datatable 导入mysql 解决_将DATATABLE中的数据导入到数据库中

上次在

小小的改动即可。

///

/// 将DataTable中数据写入数据库中

///

///

///

public static bool WriteDataToDB(DataTable dt)

{

if (dt==null || dt.Rows.Count == 0)

{

return true;

}

string tname = dt.TableName;

string colNames = "";

for (int i = 0; i < dt.Columns.Count; i++)

{

colNames += dt.Columns[i].ColumnName + ",";

}

colNames = colNames.TrimEnd(',');

string cmd = "";

string colValues;

string cmdmode = string.Format("insert into {0}({1}) values({ {0}});", tname, colNames);

for (int i = 0; i < dt.Rows.Count; i++)

{

colValues = "";

for (int j = 0; j < dt.Columns.Count;