各位高手帮忙看下这段代码哪里有错。。绑定的GRIDVIEW没有显视出来。没有提示代码有错

Question

  改为:  GridView1.DataSource = ds.Table[0]; 

Answer 1

寫錯了你
GridView1.DataSource = ds.Tables[0];

Answer 2

把“SetBind()；”放入PAGE_LOAD中了么 ？

Answer 3

 string conntext =ConfigurationManager.ConnectionStrings["SQLConnString1"].ConnectionString

Answer 4

GridView1.DataSource = ds.Tables[0];这个tables[0]...是什么意思....

Answer 5

<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
                        AutoGenerateColumns="False" BackColor="White" BorderColor="#999999" BorderStyle="Solid"
                        BorderWidth="1px" CellPadding="3" ForeColor="Black"
                        GridLines="Vertical" Height="1px" Width="679px">
                        <FooterStyle BackColor="#CCCCCC" />
                        <SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
                        <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
                        <HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" />
                        <AlternatingRowStyle BackColor="#CCCCCC" />
                    </asp:GridView>   protected void Page_Load(object sender, EventArgs e)
    {
      
            SetBind();
       
    }
    protected void btn_delete_Click(object sender, EventArgs e)
    {
        string conntext = (ConfigurationManager.ConnectionStrings["ConnectionString"]).ToString();
        SqlConnection conn = new SqlConnection(conntext);
        conn.Open();
        string sql = "DELETE FROM Positioning WHERE FlightNO='" + txt_FNO.Text + "' and BillNO='" + txt_BNO.Text + "'";
        SqlCommand cmd = new SqlCommand(sql, conn);
        cmd.ExecuteNonQuery();
        conn.Close();
        SetBind();
    }
    private void SetBind()
    {
        string conntext = (ConfigurationManager.ConnectionStrings["ConnectionString"]).ToString(); 
        SqlConnection conn = new SqlConnection(conntext); 
        conn.Open(); 
        string sql="SELECT FlightNO,BillNO,ReceiveTicket FROM Positioning"; 
        SqlDataAdapter da = new SqlDataAdapter(sql,conn); 
        DataSet ds = new DataSet(); 
        da.Fill(ds); 
        GridView1.DataSource = ds; 
        GridView1.DataBind(); 
           }

Answer 6

AutoGenerateColumns="False"
你不给绑定数据怎么显示呢,改成true

Answer 7

private void SetBind() 
    { 
      string conntext = (ConfigurationManager.ConnectionStrings["ConnectionString"]).ToString(); 
        SqlConnection conn = new SqlConnection(conntext); 
        conn.Open(); 
        string sql="SELECT FlightNO,BillNO,ReceiveTicket FROM Positioning"; 
        SqlCommand cmd = new SqlCommand(sql);
        SqlDataAdapter da = new SqlDataAdapter();
        sda.SelectCommand = cmd; 
        DataSet ds = new DataSet(); 
        da.Fill(ds); 
        GridView1.DataSource = ds; 
        GridView1.DataBind(); 
      
    }
放进PAGE_LOAD就行了