conn.ConnectionString = "server=server;uid=sa;Password=;database=ytdb"; conn.Open(); SqlCommand com = new SqlCommand(); com.Connection = conn; com.CommandText = "select dwm as no,dwm+'-'+dwmc as name from ylgsuser.tbl_codecorp order by name"; System.Data.SqlClient.SqlDataAdapter dat = new SqlDataAdapter(); dat.SelectCommand = com; dat.Fill(this.ds_bargain,"tbl_codecorp"); com.CommandText = "select ylh as no,ylmc as name from ylgsuser.tbl_codestock"; dat.Fill(this.ds_bargain,"tbl_codestock"); com.CommandText = "select dbo.fun_bal_code('01',dwm) as dwmc,dbo.fun_bal_code('02',ylh) as ylmc,dbo.fun_bal_code('02',sfcph) as sfcpmc,hth,jcj,jcj2,jgf,htlr_date,htl_1,htl_2,htl_3,htl_4,htl_5,htl_6,htl_7,htl_8,htl_9,htl_10,htl_11,htl_12,htl_1+htl_2+htl_3+htl_4+htl_5+htl_6+htl_7+htl_8+htl_9+htl_10+htl_11+htl_12 as allyear from ylgsuser.tbl_htdata"; dat.Fill(this.ds_bargain,"tbl_htdata"); dat.Dispose(); com.Dispose(); conn.Close(); conn.Dispose();DataSet就象一个小型的数据库一样可存放多张表还可建视图不同控件可绑定到相同或不同的表上用: dataset.tables["name"]来区分同一Dataset中不同的表。
conn.Open();
SqlCommand com = new SqlCommand();
com.Connection = conn;
com.CommandText = "select dwm as no,dwm+'-'+dwmc as name from ylgsuser.tbl_codecorp order by name";
System.Data.SqlClient.SqlDataAdapter dat = new SqlDataAdapter();
dat.SelectCommand = com;
dat.Fill(this.ds_bargain,"tbl_codecorp");
com.CommandText = "select ylh as no,ylmc as name from ylgsuser.tbl_codestock";
dat.Fill(this.ds_bargain,"tbl_codestock");
com.CommandText = "select dbo.fun_bal_code('01',dwm) as dwmc,dbo.fun_bal_code('02',ylh) as ylmc,dbo.fun_bal_code('02',sfcph) as sfcpmc,hth,jcj,jcj2,jgf,htlr_date,htl_1,htl_2,htl_3,htl_4,htl_5,htl_6,htl_7,htl_8,htl_9,htl_10,htl_11,htl_12,htl_1+htl_2+htl_3+htl_4+htl_5+htl_6+htl_7+htl_8+htl_9+htl_10+htl_11+htl_12 as allyear from ylgsuser.tbl_htdata";
dat.Fill(this.ds_bargain,"tbl_htdata");
dat.Dispose();
com.Dispose();
conn.Close();
conn.Dispose();DataSet就象一个小型的数据库一样可存放多张表还可建视图不同控件可绑定到相同或不同的表上用:
dataset.tables["name"]来区分同一Dataset中不同的表。