110,534
社区成员
发帖
与我相关
我的任务
分享
using (SqlConnection mycon = new SqlConnection(appCon))
{
mycon.Open();
string cmd = "SELECT * from [Salary]";
SqlDataAdapter sda = new SqlDataAdapter(cmd, mycon);
SqlCommandBuilder thisBulider = new SqlCommandBuilder(sda);
thisDataSet = new DataSet();
sda.MissingSchemaAction = MissingSchemaAction.AddWithKey;//显式加载数据库主键
sda.Fill(thisDataSet, "salary");
////------------------Merge---------
thisDataSet.Tables["salary"].Merge(excelDataSet.Tables[sheetName], false, MissingSchemaAction.Ignore);
//
dataGridView1.DataMember = null;
dataGridView1.DataSource = null;
dataGridView1.DataSource = thisDataSet;
dataGridView1.DataMember = "salary";
///--------------------------------------------
///sqlcommand
sda.Update(thisDataSet, "salary");//这个步骤没有起作用................
class Program
{
static void Main(string[] args)
{
/* sql脚本
create database test
go
use test
go
create table tab1
(
id int identity primary key,
a varchar(10)
)
create table tab2
(
id int identity primary key,
a varchar(10)
)
insert into tab1 values('1')
insert into tab2 values('2')
select * from tab1
*/
DataSet ds = new DataSet();
SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=test;Integrated Security=True");
SqlDataAdapter da1 = new SqlDataAdapter("select * from tab1", con);
da1.Fill(ds, "Tab1");
SqlDataAdapter da2 = new SqlDataAdapter("select * from tab2", con);
da2.Fill(ds, "Tab2");
foreach (DataRow row in ds.Tables["Tab2"].Rows)
row.SetAdded();
ds.Tables["Tab1"].Merge(ds.Tables["Tab2"]);
SqlCommandBuilder cb = new SqlCommandBuilder(da1);
da1.Update(ds.Tables["Tab1"]);
}
}