关于提高循环的效率问题

Question

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怎么写啊?????
}
}谢谢了不知道有什么好办法提高效率呀

Answer 1

foreach比for多操作,,,你是要实现什么功能?

Answer 2

foreach       (datarow  dr in dt.rows) 
sb.Append（"INSERT       INTO       User(ID,UserName)       VALUES(dr["ID"].ToSting()',dr["UserName"].ToSting()')       ";）