你可以在一个stringbuilder里面写多行stringbuilder b=new stringbuilder();
b.appendline("insert aa select value");
b.appendline("insert aa select value");
b.appendline("insert aa select value");
b.appendline("insert aa select value");
b.appendline("insert aa select value");
runsql(b.tostring());
b.appendline("insert aa select value");
b.appendline("insert aa select value");
b.appendline("insert aa select value");
b.appendline("insert aa select value");
b.appendline("insert aa select value");
runsql(b.tostring());
如果可以的话告诉我吧,给我发个邮件[email protected]
只要你明白上面这句话的意思就成了
msdn官方代码如下:
public DataSet CreateCmdsAndUpdate(DataSet dataSet, string connectionString,
string queryString)
{
using (OleDbConnection connection = new OleDbConnection(connectionString))
{
OleDbDataAdapter adapter = new OleDbDataAdapter();
adapter.SelectCommand = new OleDbCommand(queryString, connection);
OleDbCommandBuilder builder = new OleDbCommandBuilder(adapter); connection.Open(); DataSet customers = new DataSet();
adapter.Fill(customers); //code to modify data in dataset here //Insert new records from DataSet
DataRow[] rows = customers.Tables[0].Select(
null, null, DataViewRowState.Added);
adapter.Update(rows); return customers;
}
}
dataTable.Rows.add()这样的操作应该都是基本性操作,剩下的问题是如何在页面取值,这个必须根据你本身的asp.net页面来考虑,我不多说了,具体页面具体对待,界面逻辑还是交给界面逻辑处理好了
然后定义这个类的数组或基于泛型的arraylist,
把这个arraylist做为参数,传给哪个Save函数,让它foreach{save...}