//添加行
int num = Convert.ToInt32( DropDownList1.SelectedValue );
for (int i = 0; i < num; i++)
{
DataRow dr = dt.NewRow();
dr["name"] = "";
dr["shuliang"]=Convert.ToInt32("0");
dr["price"]=Convert.ToDouble("0");
dt.Rows.Add(dr);
}
GridView1.DataSource = dt;
GridView1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
dt = getDataTable();
SqlConnection con = new SqlConnection("server=.;database=test;uid=sa;pwd=");
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
for (int i = 0; i < dt.Rows.Count; i++)
{
string strsql="insert into testdatatable values('"+dt.Rows[i]["name"]+"',"+dt.Rows[i]["shuliang"]+","+dt.Rows[i]["price"]+")";
cmd.CommandType = CommandType.Text;
cmd.CommandText = strsql;
cmd.ExecuteNonQuery();
}