我的写法是这样的, SqlConnection objConn = new SqlConnection(sConnectionString); objConn.Open(); SqlDataAdapter da = new SqlDataAdapter(); SqlCommandBuilder cb = new SqlCommandBuilder(da) da.Update(dataSet,"TEST1");但执行时报异常错误:“Update无法找到TableMapping['TEST1']或DataTable"TEST1"”请问是怎么回事啊????
SqlConnection objConn = new SqlConnection(sConnectionString);
objConn.Open();
SqlDataAdapter da = new SqlDataAdapter();
SqlCommandBuilder cb = new SqlCommandBuilder(da)
da.Update(dataSet,"TEST1");但执行时报异常错误:“Update无法找到TableMapping['TEST1']或DataTable"TEST1"”请问是怎么回事啊????
SqlDataAdapter.Fill(dataSet,"TEST1");
objConn.Open();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand("select * from TableName");
SqlCommandBuilder cb = new SqlCommandBuilder(da)
da.Update(dataSet,"TEST1");
建议用SqlBulkCopy:
SqlConnection sqlConnect = new SqlConnection;
sqlConnect.Open();
SqlBulkCopy bcp = new SqlBulkCopy(sqlConnect);
bcp.DestinationTableName = tableName; //tableName 数据库表名
bcp.WriteToServer(dt); //dt 包含数据的DataTable
SqlBulkCopy要USING哪个空间呢?我是用.NET2003
但在数据库里查询发现数据根本没入库,是什么原因啊?
我也很想知道,对于数据表中已经存在的数据,用SqlBulkCopy能进行更新操作吗?