Question

怎么通过sqldatareader来显示数据空中想查询的信息(显示在Datagridview上)

我想按期查询彩票
con = new SqlConnection();
con.ConnectionString = "server=.;database=caipiao;uid=sa;pwd=123";
string sql = "select * from t_LotInfo whereType=@ype and Term=@Term";
com = new SqlCommand(sql,con);
com.Parameters.Add("@Type",SqlDbType.VarChar).Value = comboBox1.Text;
com.Parameters.Add("@Term", SqlDbType.VarChar).Value = textBox1.Text;
SqlDataReader dr = com.ExecuteReader();
接下来该怎么写了?

Answer 1

一楼的回答 不对~~~~
Using System.Data；
con = new SqlConnection();
con.ConnectionString = "server=.;database=caipiao;uid=sa;pwd=123";
string sql = "select * from t_LotInfo whereType=@ype and Term=@Term";
com = new SqlCommand(sql,con);
com.Parameters.Add("@Type",SqlDbType.VarChar).Value = comboBox1.Text;
com.Parameters.Add("@Term", SqlDbType.VarChar).Value = textBox1.Text;
SqlDataReader dr = com.ExecuteReader();
DataTable dt = new DataTable ();
dt.Load(dr);
this.datagridview.datasource=dt;
conn.Close();

Answer 2

this.datagridview.datasource="你要显示的东西";