关于提高性能的问题,请大虾指导(在线等)
StringBuilder sb = new StringBuilder();
DataTable dt = SQLData.GetTable(sql); //获取DataTable
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
sb.Append("INSERT INTO User(ID,UserName) VALUES('dt.rows[i]["ID"].ToSting()','dt.rows[i]["UserName"].ToSting()') ";)
//我在这想把SQL语句拼接起来
//我用的是for循环
//想问下用foreach怎么写啊?????
}
}
谢谢了