Question

如何让查询的数据gridview中显示

protected void Button1_Click(object sender, EventArgs e)
{
string strConnection = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
OleDbConnection objConnection = new OleDbConnection(strConnection);
objConnection.Open();
if (RadioButton1.Checked)
{
string sql = " select * from six where accountingnum = '" + TextBox1.Text + "' or name = '" + TextBox2.Text + "' or idcard = '" + TextBox3.Text + "'";
/*OleDbCommand com = new OleDbCommand(sql );
OleDbDataReader ord = com.ExecuteReader();
DataSet ds = new DataSet();
ord.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
//*/
OleDbCommand com = new OleDbCommand(sql,objConnection );
OleDbDataReader ord = com.ExecuteReader();
GridView1.DataSource = ord;
GridView1.DataBind();
}

Answer 1

public void GridViewBind()//gridvie数据绑定方法
{
//实例化SqlConnection对象
SqlConnection sqlCon = new SqlConnection();
//实例化SqlConnection对象连接数据库的字符串
sqlCon.ConnectionString = "server=.;uid=sa;pwd=;database=SearchDB";
//定义SQL语句
string SqlStr = "select * from Discussion";
//实例化SqlDataAdapter对象
SqlDataAdapter da = new SqlDataAdapter(SqlStr, sqlCon);
//实例化数据集DataSet
DataSet ds = new DataSet();
da.Fill(ds, "Discussion");
//绑定DataList控件
GridView1.DataSource = ds;//设置数据源，用于填充控件中的项的值列表
GridView1.DataBind();//将控件及其所有子控件绑定到指定的数据源
}
获取你查询的值！使用select 字段 from 表查询表中的数据，然后重新填充 GridView。

Answer 2

不是用OleDbDataReader的，这只能查1行数据
用OleDbDataAdapter 来Fill Dataset

Answer 3

把分拿来