110,536
社区成员
发帖
与我相关
我的任务
分享
static void DataTableSave()
{
DataTable dt = new DataTable();
StringBuilder tmp = new StringBuilder();
tmp.Append("INSERT INTO ");
tmp.Append("TableName (");
List<string> list = new List<string>();
foreach (DataColumn col in dt.Columns)
{
list.Add(col.ColumnName);
}
tmp.Append(string.Join(",", list));
tmp.Append(") VALUES (");
tmp.Append(string.Join(",", list.Select(x => string.Format("@{0}", x))));
tmp.Append(")");
string insertSql = tmp.ToString();
SqlParameter[] parameter;
SqlConnection conn = new SqlConnection("");//设定连接字符串
conn.Open();
SqlCommand cmd = new SqlCommand(insertSql, conn);
foreach(DataRow row in dt.Rows)
{
cmd.Parameters.Clear();
parameter = list.Select(x => new SqlParameter(string.Format("@{0}", x), row[x])).ToArray();
cmd.Parameters.Add(parameter);
cmd.ExecuteNonQuery();
}
}
我就应该学sp1234的样子