循环插入??
呵呵,其实有比较好的办法....
我给你一个小例子,只需要连接数据库一次...
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("server=localhost;uid=ztx;password=123;database=mydb");
con.Open();
SqlCommand cmd = null;
string sql = "";
for (int i = 0; i <= 10; i++)
{
sql+="insert into test values ('" + i + "')";
}
Response.Write(sql);
cmd = new SqlCommand(sql, con);
cmd.ExecuteNonQuery();
con.Close();
}
如果你有点数据库基础,那么这个东西挺好办的..