使用sqlbulkcopy类将本地未更新到服务器的数据更新到服务器
connServer.Open();
SqlCommand myCommandRole = new SqlCommand("SELECT * FROM Role where 此处为判断是否是新数据", connServer);
SqlDataReader drRole = myCommandRole.ExecuteReader();
connBench.Open();
SqlBulkCopy bulk = new SqlBulkCopy(connBench);
bulk.DestinationTableName = "[Role]";
try
{
bulk.WriteToServer(drRole);
MessageBox.Show("角色更新成功");
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
connBench.Close();
drRole.Close();
connServer.Close();
bulk.Close();
}