问题描述:两个表mps_material_cal和itemdata,要求显示mps_material_cal表中的itemno和quantity字段,条件是mps_material_cal.itemno=itemdata.itemno并且表itemdata中的mp_code字段为zz,这个通过sql语句能够实现,在sql查询分析器中已经运行过了是可以的。现在关键是这段程序的最后两句该怎么写,就是tableadapter的问题,究竟该使用哪个adapter填到哪个dataset中。
这个问题卡了我好几天了,还是不知道怎么处理,特求救,以下是程序代码:最后两句不知道怎么改?SqlDataAdapter wahahaDataSet1TableAdapters = new SqlDataAdapter();
//连接数据库
string myConnectionString = "Data Source=IBM-715A590BD4E;Initial Catalog=wahaha;Persist Security Info=True;User ID=sa;Password=sa;";
//设置数据库连接
SqlConnection myConnection = new SqlConnection(myConnectionString);
//设置数据库操作命令
string myInsertQuery = "select mps_material_cal.itemno,mps_material_cal.quantity from mps_material_cal join itemdata on(mps_material_cal.itemno=itemdata.itemno) where itemdata.mp_code='zz'";
SqlCommand myCommand = new SqlCommand(myInsertQuery);
myCommand.Connection = myConnection; //设置 SqlCommand实例使用的连接
myConnection.Open(); //打开数据库
myCommand.ExecuteNonQuery();
this.resource_shebeiTableAdapter.Fill(this.wahahaDataSet.resource_shebei);
//this.wahahaDataSet1TableAdapters.Fill(this.wahahaDataSet1.mps_material_cal);
这个问题卡了我好几天了,还是不知道怎么处理,特求救,以下是程序代码:最后两句不知道怎么改?SqlDataAdapter wahahaDataSet1TableAdapters = new SqlDataAdapter();
//连接数据库
string myConnectionString = "Data Source=IBM-715A590BD4E;Initial Catalog=wahaha;Persist Security Info=True;User ID=sa;Password=sa;";
//设置数据库连接
SqlConnection myConnection = new SqlConnection(myConnectionString);
//设置数据库操作命令
string myInsertQuery = "select mps_material_cal.itemno,mps_material_cal.quantity from mps_material_cal join itemdata on(mps_material_cal.itemno=itemdata.itemno) where itemdata.mp_code='zz'";
SqlCommand myCommand = new SqlCommand(myInsertQuery);
myCommand.Connection = myConnection; //设置 SqlCommand实例使用的连接
myConnection.Open(); //打开数据库
myCommand.ExecuteNonQuery();
this.resource_shebeiTableAdapter.Fill(this.wahahaDataSet.resource_shebei);
//this.wahahaDataSet1TableAdapters.Fill(this.wahahaDataSet1.mps_material_cal);
解决方案 »
- C#如何从combox中获取选择项的值?
- 关于上传图片创建文件夹的问题,着急,在线等~~~
- xml数据绑定在treeview里怎么弄?
- 包哥开源CMS系统预览版
- 技术问题:DataGrid 自动滚动
- C# 怎么使用fnthex32.dll 获取指令打印汉字二维码
- (查无结果,比较难)C#。NET中数据按月份来分页
- 求救 --如何把 vs2005 中使用 sql2000 中的事务 ?
- 怎么用DataGridTableStyle 格式化添加了关系的DataSet中的子表的表头 -_-!
- 【急!】关于MSDN的问题?
- 不明白~C#的一个小类型~~~~~~
- toolStripComboBox 的默认值
//连接数据库
string myConnectionString = "Data Source=IBM-715A590BD4E;Initial Catalog=wahaha;Persist Security Info=True;User ID=sa;Password=sa;";
//设置数据库连接
SqlConnection myConnection = new SqlConnection(myConnectionString);
//设置数据库操作命令
string myInsertQuery = "select mps_material_cal.itemno,mps_material_cal.quantity from mps_material_cal join itemdata on(mps_material_cal.itemno=itemdata.itemno) where itemdata.mp_code='zz'";
SqlCommand myCommand = new SqlCommand(myInsertQuery);
myCommand.Connection = myConnection; //设置 SqlCommand实例使用的连接
myConnection.Open(); //打开数据库
SqlDataAdapter wahahaDataSet1TableAdapters = new SqlDataAdapter(myCommand,myConnection);
wahahaDataSet1TableAdapters.Fill(ds);
myConnection.Close()
return ds
//连接数据库
string myConnectionString = "Data Source=IBM-715A590BD4E;Initial Catalog=wahaha;Persist Security Info=True;User ID=sa;Password=sa;";
//设置数据库连接
SqlConnection myConnection = new SqlConnection(myConnectionString);
myConnection.Open(); //设置数据库操作命令
string myInsertQuery = "select mps_material_cal.itemno,mps_material_cal.quantity from mps_material_cal join itemdata on(mps_material_cal.itemno=itemdata.itemno) where itemdata.mp_code='zz'";
SqlDataAdapter wahahaDataSet1TableAdapters = new SqlDataAdapter(myInsertQuery,myConnection);
DataSet ds = new DataSet();
wahahaDataSet1TableAdapters.Fill(ds,"Table1");
DataTable dt = ds.Tables["Table1"];//获取的表
//连接数据库
string myConnectionString = "Data Source=IBM-715A590BD4E;Initial Catalog=wahaha;Persist Security Info=True;User ID=sa;Password=sa;";
//设置数据库连接
SqlConnection myConnection = new SqlConnection(myConnectionString);
//设置数据库操作命令
string myInsertQuery = "select mps_material_cal.itemno,mps_material_cal.quantity from mps_material_cal join itemdata on(mps_material_cal.itemno=itemdata.itemno) where itemdata.mp_code='zz'";
SqlCommand myCommand = new SqlCommand(myInsertQuery);
myCommand.Connection = myConnection; //设置 SqlCommand实例使用的连接
myConnection.Open(); //打开数据库
SqlDataAdapter wahahaDataSet1TableAdapters = new SqlDataAdapter(myCommand,myConnection);
wahahaDataSet1TableAdapters.Fill(ds);
myConnection.Close()
return ds
输进这段代码有报错:
在SqlDataAdapter wahahaDataSet1TableAdapters = new SqlDataAdapter(myCommand,myConnection);
这一句中,等号的后半部分,报错如下:
Error 2 Argument '1': cannot convert from 'System.Data.SqlClient.SqlCommand' to 'string' C:\Documents and Settings\Admin\My Documents\Visual Studio 2005\Projects\new_wahaha\new_wahaha\粗能力平衡运算.cs 31 77 new_wahahaError 3 Argument '2': cannot convert from 'System.Data.SqlClient.SqlConnection' to 'string' C:\Documents and Settings\Admin\My Documents\Visual Studio 2005\Projects\new_wahaha\new_wahaha\粗能力平衡运算.cs 31 87 new_wahaha还有就是return语句报错:
Error 4 Since 'new_wahaha.粗能力平衡运算.粗能力平衡运算_Load(object, System.EventArgs)' returns void, a return keyword must not be followed by an object expression C:\Documents and Settings\Admin\My Documents\Visual Studio 2005\Projects\new_wahaha\new_wahaha\粗能力平衡运算.cs 34 13 new_wahaha