SQLServer数据导出Access

        private void WriteJson(string status1, string msg1, object data1 = null)
        {
            Response.ContentType = "application/json";
            var obj = new { status = status1, msg = msg1, data = data1 };
            string json = new JavaScriptSerializer().Serialize(obj);
            Response.Write(json);
        }

        private ADOX.Column[] CreateAdoXColumn<T>()
        {
            var properties = typeof(T).GetProperties();
            List<ADOX.Column> columns = new List<ADOX.Column>();
            DataTypeEnum typeEnum = DataTypeEnum.adSingle;

            properties.ToList().ForEach(p =>
            {
                if (p.PropertyType == typeof(String)) typeEnum = DataTypeEnum.adLongVarWChar;
                else if (p.PropertyType == typeof(Int32)) typeEnum = DataTypeEnum.adInteger;
                else if (p.PropertyType == typeof(DateTime)) typeEnum = DataTypeEnum.adDate;
                else if (p.PropertyType == typeof(Boolean)) typeEnum = DataTypeEnum.adBoolean;
                else if (p.PropertyType == typeof(Double)) typeEnum = DataTypeEnum.adNumeric;
                columns.Add(new ADOX.Column() { Name = p.Name, Type = typeEnum });
            });
            return columns.ToArray();
        }
        private void InsertToMdb<T>(string fileNameWithPath, ADOX.Column[] columns, IList<T> list)
        {
            var con = new OleDbConnection("Provider = Microsoft.Jet.OLEDB.4.0; Data Source = " + fileNameWithPath);            
            try
            {
                con.Open();
                var cmd = new OleDbCommand();
                cmd.Connection = con;
                string columnString = "";
                string fmtColumnString = "";
                foreach (var col in columns)
                {
                    columnString += "[" + col.Name + "],";
                    fmtColumnString += "@" + col.Name + ",";
                }
                columnString = columnString.Substring(0, columnString.Length - 1);
                fmtColumnString = fmtColumnString.Substring(0, fmtColumnString.Length - 1);

                string tableName = typeof(T).Name;
                string formatStr = "insert into {0}({1}) values({2});";

                foreach (var item in list)
                {
                    cmd.CommandText = string.Format(formatStr, tableName, columnString, fmtColumnString);
                    var properties = item.GetType().GetProperties();
                    foreach (var p in properties)
                    {
                        var column = columns.FirstOrDefault(c => c.Name.ToLower() == p.Name.ToLower());
                        cmd.Parameters.AddWithValue("@" + p.Name, p.GetValue(item, null));
                    }
                    cmd.ExecuteNonQuery();
                }
                //cmd.Parameters.AddWithValue("@ID", 1);
                //cmd.Parameters.AddWithValue("@Info", "toster.ru");
                //cmd.Parameters.AddWithValue("@text", "blabla");           
            }
            catch (Exception ex)
            {

            }
            finally
            {
                con.Close();
            }
        }

        /// 在access数据库中创建表  
        /// </summary>  
        /// <param name="filePath">数据库表文件全路径如D:\\NewDb.mdb 没有则创建 </param>   
        /// <param name="tableName">表名</param>  
        /// <param name="colums">ADOX.Column对象数组</param>  
        private void CreateAccessTable(string filePath, string tableName, params ADOX.Column[] colums)  
        {  
            ADOX.Catalog catalog = new Catalog();  
            //数据库文件不存在则创建  
            if (!System.IO.File.Exists(filePath))  
            {  
                try  
                {  
                    catalog.Create("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Jet OLEDB:Engine Type=5");  
                }  
                catch (System.Exception ex)  
                {

                }  
            }  
            ADODB.Connection cn = new ADODB.Connection();  
            cn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath, null, null, -1);  
            catalog.ActiveConnection = cn;  
            ADOX.Table table = new ADOX.Table();  
            table.Name = tableName;  
            foreach (var column in colums)  
            {  
                table.Columns.Append(column);  
            }  
           // column.ParentCatalog = catalog;   
            //column.Properties["AutoIncrement"].Value = true; //设置自动增长  
            //table.Keys.Append("FirstTablePrimaryKey", KeyTypeEnum.adKeyPrimary, column, null, null); //定义主键  
            catalog.Tables.Append(table);  
            cn.Close();  
        }  

    
        [HttpPost]
        public void ExportMdb()
        {
            string folder = "~/Exports/";
            string filename = DateTime.Now.ToString("yyyyMMddHHmmssffff") + ".mdb";
            var path = Path.Combine(Server.MapPath(folder), filename);

            try
            {
                ISession aSession = SessionHelper.GetSession();
                //电缆井
                ADOX.Column[] columnsPit = CreateAdoXColumn<mycablepit>();
                CreateAccessTable(path, "mycablepit", columnsPit);
                ImycablepitService caServicePit = new mycablepitService(aSession);
                var allCablesPit = caServicePit.getAll();
                InsertToMdb<mycablepit>(path, columnsPit, allCablesPit);

                WriteJson("true", folder.Replace("~/","") + filename);
            }
            catch (Exception ex)
            {
                WriteJson("false", "");
            }
        }

function exportDatabase(_type) {
    $("#btnExportMdb").button('loading');
    switch (_type) {
        case "mdb":
            var url = "/ExportDb/ExportMdb";
            $.post(url, "", function (data) {
                if (data.status == "true") {
                    $("#btnExportMdb").button('reset');

                    alert("导出成功");
                    //var $eleForm = $("<form method='get'></form>");
                    //$eleForm.attr("action", data.msg);
                    //$(document.body).append($eleForm);
                    //$eleForm.submit();
                }
            });
            break;
    }
}