1.用一次数据库连接,n次循环提取ds中的数据,n次数据库
myConnection.Open();
for(int i=0;i<ds.Tables[0].Rows.Count;i++)
{
string sql="insert into i_test(id,username) values(@id,@username)";
SqlCommand comm=new SqlCommand(sql,myConnection);
SqlParameter para1=new SqlParameter("@id",SqlDbType.Int);
para1.Value=ds.Tables[0].Rows[i]["id"].ToString();
comm.Parameters.Add(para1);
SqlParameter para2=new SqlParameter("@username",SqlDbType.NVarChar,30);
para2.Value=ds.Tables[0].Rows[i]["username"].ToString();
comm.Parameters.Add(para2);
comm.ExecuteNonQuery();
}
myConnection.Close();