我如何填充gridview与数据集？

Question

这是我的代码：

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是空的。

Answer 1

AutoGenerateColumns设置为true？ 尝试将ds.Tables [0]添加为DataSource。

Answer 2

这很容易亲爱的......试试这个它很适合我

using (DataSet ds = new DataSet()) 
    { 
     DataTable dt = new DataTable(); 
     ds.Tables.Add(dt); 
     string str = "User ID=username;Password=password;Data Source=Test"; 
     OracleConnection conn = new OracleConnection(str); 
     conn.Open(); 
     OracleCommand cmd = new OracleCommand(); 
     cmd.Connection = conn; 
     cmd.CommandText = "select * from table_name"; 
     cmd.CommandType = CommandType.Text; 
     OracleDataAdapter da = new OracleDataAdapter(cmd); 
     da.Fill(dt); 
     GridView2.DataSource = dt; 
     GridView2.DataBind(); 
    } 

而且它Done.Happy用C＃

Answer 3

编码我有同样的问题。我的解决方案是删除“*”并手动包含列名。