sql语句,插入多条记录
一个按钮需要响应8条sql插入语句,如果每次执行一条,需要设8个变量,执行8次,效率太低,怎么做比较好
"insert into takecard (name,time,mianzhi,shuliang) values ('"+TextBox9.Text+"',getdate(),'20','"+TextBox1.Text+"')";
"insert into takecard (name,time,mianzhi,shuliang) values ('" + TextBox9.Text + "',getdate(),'30','" + TextBox2.Text + "')
"insert into takecard (name,time,mianzhi,shuliang) values ('" + TextBox9.Text + "',getdate(),'50','" + TextBox3.Text + "')";
"insert into takecard (name,time,mianzhi,shuliang) values ('" + TextBox9.Text + "',getdate(),'100','" + TextBox4.Text + "')";
"insert into takecard (name,time,mianzhi,shuliang) values ('" + TextBox9.Text + "',getdate(),'200','" + TextBox5.Text + "')";
"insert into takecard (name,time,mianzhi,shuliang) values ('" + TextBox9.Text + "',getdate(),'500','" + TextBox6.Text + "')";
"insert into takecard (name,time,mianzhi,shuliang) values ('" + TextBox9.Text + "',getdate(),'1000','" + TextBox7.Text + "')";
"insert into takecard (name,time,mianzhi,shuliang) values ('" + TextBox9.Text + "',getdate(),'10000','" + TextBox8.Text + "')";