private void Form1_Load(object sender, EventArgs e)
{ StringBuilder sqlCmdStr = new StringBuilder("Select ");
sqlCmdStr.Append("ConporationNum as 公司代码,Name as 公司名称, type as 公司类型,");
sqlCmdStr.Append("CorDomain as 公司所在行业,Quality as 公司注册性质,Commissary as 法定代表人,");
sqlCmdStr.Append("Status as 公司经营状况,Bound as 公司经营范围,OganNum as 企业机构代码,");
sqlCmdStr.Append("TaxNum as 企业纳税登记号码,CustomsNum as 企业海关代码,Re as 备注 From tb_CorporationData");
//string sqlCmdStr = "Select CorporationID as 序列号, ConporationNum as 公司代码,Name as 公司名称, type as 公司类型,CorDomain as 公司所在行业,Quality as 公司注册性质,Commissary as 法定代表人," +
// "Status as 公司经营状况,Bound as 公司经营范围,OganNum as 企业机构代码,TaxNum as 企业纳税登记号码,CustomsNum as 企业海关代码,Re as 备注 From tb_CorporationData";
string sqlConStr = "Server =LocalHost;uid = sa;pwd=;DataBase=ClientSys";
//string sqlCmdStr = "Select * From tb_CorporationData";
SqlConnection sqlConn = new SqlConnection(sqlConStr);
try
{
sqlConn.Open();
SqlDataAdapter sda = new SqlDataAdapter(sqlCmdStr.ToString(), sqlConStr);
string tmpds = "TempleDataSet";
sda.Fill(ds, tmpds);
dataGridView1.DataSource = ds.Tables[tmpds].DefaultView;
sqlConn.Close();
} catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
} private void Form1_FormClosing(object sender, FormClosingEventArgs e)
{
string sqlConStr = "Server =LocalHost;DataBase=ClientSys;Uid=sa;PWD=;";
string sqlCMDStr = "Select * From tb_CorporationData"; try
{
SqlConnection sqlCon = new SqlConnection(sqlConStr);
sqlCon.Open();
SqlDataAdapter sda = new SqlDataAdapter(sqlCMDStr,sqlConStr);
SqlCommandBuilder sqlCMDBuider = new SqlCommandBuilder(sda);
sda.Update(ds.Tables[0]);
sqlCon.Close();
} catch(SqlException ex)
{
MessageBox.Show("数据库更新失败,原因是" + ex.Message);
}
这段代码是用来学习怎么样在关闭的时候用内存里面的数据更新数据库的,但是现在问题是关闭的时候老是说我有一个列没有好,请问各位大哥看看是出现了什么样的问题可以吗?
{ StringBuilder sqlCmdStr = new StringBuilder("Select ");
sqlCmdStr.Append("ConporationNum as 公司代码,Name as 公司名称, type as 公司类型,");
sqlCmdStr.Append("CorDomain as 公司所在行业,Quality as 公司注册性质,Commissary as 法定代表人,");
sqlCmdStr.Append("Status as 公司经营状况,Bound as 公司经营范围,OganNum as 企业机构代码,");
sqlCmdStr.Append("TaxNum as 企业纳税登记号码,CustomsNum as 企业海关代码,Re as 备注 From tb_CorporationData");
//string sqlCmdStr = "Select CorporationID as 序列号, ConporationNum as 公司代码,Name as 公司名称, type as 公司类型,CorDomain as 公司所在行业,Quality as 公司注册性质,Commissary as 法定代表人," +
// "Status as 公司经营状况,Bound as 公司经营范围,OganNum as 企业机构代码,TaxNum as 企业纳税登记号码,CustomsNum as 企业海关代码,Re as 备注 From tb_CorporationData";
string sqlConStr = "Server =LocalHost;uid = sa;pwd=;DataBase=ClientSys";
//string sqlCmdStr = "Select * From tb_CorporationData";
SqlConnection sqlConn = new SqlConnection(sqlConStr);
try
{
sqlConn.Open();
SqlDataAdapter sda = new SqlDataAdapter(sqlCmdStr.ToString(), sqlConStr);
string tmpds = "TempleDataSet";
sda.Fill(ds, tmpds);
dataGridView1.DataSource = ds.Tables[tmpds].DefaultView;
sqlConn.Close();
} catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
} private void Form1_FormClosing(object sender, FormClosingEventArgs e)
{
string sqlConStr = "Server =LocalHost;DataBase=ClientSys;Uid=sa;PWD=;";
string sqlCMDStr = "Select * From tb_CorporationData"; try
{
SqlConnection sqlCon = new SqlConnection(sqlConStr);
sqlCon.Open();
SqlDataAdapter sda = new SqlDataAdapter(sqlCMDStr,sqlConStr);
SqlCommandBuilder sqlCMDBuider = new SqlCommandBuilder(sda);
sda.Update(ds.Tables[0]);
sqlCon.Close();
} catch(SqlException ex)
{
MessageBox.Show("数据库更新失败,原因是" + ex.Message);
}
这段代码是用来学习怎么样在关闭的时候用内存里面的数据更新数据库的,但是现在问题是关闭的时候老是说我有一个列没有好,请问各位大哥看看是出现了什么样的问题可以吗?
解决方案 »
- C#水晶报表怎样绑定一个数据集DataSet里的两个dataTable?
- C#中 所有的东西都是类,int i; 可以这样写int myInt = new int(); 请问int()函数在哪个命名空间中?
- C# 怎么把string[] 转换成 FileInfo
- regasm注册的问题,请大家帮忙下
- 请问C#中如何实现两个类之间的通信
- 小问题
- long 在vb,vc, c#,java里边类型的定义
- 一个可能要遇到的问题 .NET
- 怎么导出Excel,有代码更好!
- 为什么当我调用了Socket.Close 后,客户端还是能够发信息给服务端?
- 判断目录是否存在Directory.Exists(C:\Program Files\XXXX)的奇怪问题
- c# 如何在 PC端 控制 手机设备的 键盘
DataTable“TempleDataSet”中缺少 SourceColumn“ConporationNum”的 DataColumn“ConporationNum”。