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);
}
这段代码是用来学习怎么样在关闭的时候用内存里面的数据更新数据库的,但是现在问题是关闭的时候老是说我有一个列没有好,请问各位大哥看看是出现了什么样的问题可以吗?
解决方案 »
- ByteToHex(System.Text.Encoding.UTF8.GetBytes("aaa"))
- 在form里放一个定时器,当到了10(倒计时)秒时关闭Form,怎么显视这个时间
- 怎样在WEB设计中弹出一个对话框?
- 很奇怪的问题,是关于ConfigurationManager,我怎么不能够使用它?
- RDLC报表有选择性的加序号问题
- 新手求助: 常量中有换行符是什么意思?
- C#运行时的一个错误,新手不懂哇
- 获取另一窗口上控件的句柄并向它发送Click事件的代码应该怎么写?
- 那位有inside c#啊,帮忙啊
- WINFORM picturebox 控件问题
- 判断目录是否存在Directory.Exists(C:\Program Files\XXXX)的奇怪问题
- c# 如何在 PC端 控制 手机设备的 键盘
DataTable“TempleDataSet”中缺少 SourceColumn“ConporationNum”的 DataColumn“ConporationNum”。