存储过程
CREATE PROCEDURE [fxxsxhzdsc] AS
select min(xh) from jw_xsb
where xh not in (select xh from fx_xsb)
GO
方法:
public DataSet fxxsxhzdsc()
{
sqlcon = new SqlConnection(net_2008);
sqlcon.Open();
string sqlstr = "exec fxxsxhzdsc";
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(sqlstr, sqlcon); da.Fill(ds, "fxxsxhzdsc1");
sqlcon.Close();
return ds;
}
引用方法:
DataSet ds212 = obj1.fxxsxhzdsc();
comboBoxEx1.DataSource = ds212.Tables[0];
comboBoxEx1.DisplayMember = "xh";
调试后 combox 出现:System.Data.DataRowView
请 高手们看下
CREATE PROCEDURE [fxxsxhzdsc] AS
select min(xh) from jw_xsb
where xh not in (select xh from fx_xsb)
GO
方法:
public DataSet fxxsxhzdsc()
{
sqlcon = new SqlConnection(net_2008);
sqlcon.Open();
string sqlstr = "exec fxxsxhzdsc";
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(sqlstr, sqlcon); da.Fill(ds, "fxxsxhzdsc1");
sqlcon.Close();
return ds;
}
引用方法:
DataSet ds212 = obj1.fxxsxhzdsc();
comboBoxEx1.DataSource = ds212.Tables[0];
comboBoxEx1.DisplayMember = "xh";
调试后 combox 出现:System.Data.DataRowView
请 高手们看下
select min(xh) AS xh from jw_xsb
where xh not in (select xh from fx_xsb)
GO