|
public static void BulkToDB(DataTable dt,string table) { SqlConnection sqlConn = new SqlConnection(sqlstr); SqlBulkCopy bulkCopy = new SqlBulkCopy(sqlConn); bulkCopy.DestinationTableName = table; bulkCopy.BatchSize = dt.Rows.Count; // dt.Rows.Count try { sqlConn.Open(); if (dt != null && dt.Rows.Count != 0) bulkCopy.WriteToServer(dt); } catch (Exception ex) { throw ex; } finally { sqlConn.Close(); if (bulkCopy != null) bulkCopy.Close(); } } public static DataTable GetTable() { DataTable dt = new DataTable(); dt.Columns.AddRange(new DataColumn[]{ new DataColumn("QID",typeof(int)), new DataColumn("cid",typeof(int)), new DataColumn("[QTitle]",typeof(string)), new DataColumn("[QContext]",typeof(string)), new DataColumn("[qDesc]",typeof(string)), new DataColumn("[url]",typeof(string)), new DataColumn("[imgUrl]",typeof(string)) }); return dt; } |
|
|
