如何用数据集填充gridview? [英] how can i fill the gridview with dataset?

问题描述

这是我的代码:

    string aaa;
    aaa = Request.Params["aaa"];
    string strSel;
    if (aaa != "" && aaa != null)
    {
       // Response.Write("<script>alert('" + aaa + "');</script>");
        strSel = "Select * from inout where FName like '%" + aaa + "%'";

    }
    else
    {
        strSel = "Select * from inout";
    }
    Response.Write(strSel);
    string strProvider = "Server=(local);DataBase=AIS20060712101417;UID=sa;PWD=";
    Data0 ds= new Data0();
    SqlConnection MyConn = new SqlConnection(strProvider);
    MyConn.Open();
    SqlDataAdapter MyAdapter = new SqlDataAdapter(strSel, MyConn);
    MyAdapter.Fill(ds,"inout");  
    GridView1.DataSource = ds;
    GridView1.DataBind();  

然后gridview为空.

then the gridview is empty.

推荐答案

AutoGenerateColumns 是否设置为true?

Is AutoGenerateColumns set to true ?

尝试将 ds.Tables [0] 添加为 DataSource .

这篇关于如何用数据集填充gridview?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！