SqlConnection sqlConnection = new SqlConnection(connectionstr);
sqlConnection.Open();
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandText = "insert into Fit_Area (code,name ) values (@code,@name) ";
sqlCommand.CommandType = CommandType.Text;
SqlParameter sqlParameter1 = new SqlParameter("@code", SqlDbType.VarChar);
sqlParameter1.SourceColumn = @"area_code";
SqlParameter sqlParameter2 = new SqlParameter("@name", SqlDbType.VarChar);
sqlParameter2.SourceColumn = @"area_name";
//SqlParameter sqlParameter3 = new SqlParameter("@gid", SqlDbType.VarChar);
//sqlParameter3.SourceColumn = @"gid";
//SqlParameter sqlParameter4 = new SqlParameter("@SalePrice1", SqlDbType.VarChar);
//sqlParameter4.SourceColumn = @"SalePrice2";
sqlCommand.Parameters.AddRange(new[] { sqlParameter1, sqlParameter2 });
// sqlCommand.UpdatedRowSource = UpdateRowSource.None;
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter();
sqlDataAdapter.InsertCommand = sqlCommand;
// var para = new SqlParameter("@OrdersCollection", SqlDbType.Structured, -1);
// para.Value = dataTable;
// sqlDataAdapter.FillSchema(dataTable.DataSet, SchemaType.Mapped, "TBarCode");
sqlDataAdapter.Update(dataTablebase);
。net 批量数据插入方法2
于 2021-11-18 09:37:30 首次发布