需要帮助找出 gridview 我做错了什么？

Question

我怎样才能让数据显示在网格视图上，有人看到我做错了什么吗？

<asp:GridView ID="xTimeGridView"
 runat="server" AllowSorting="True" 
          AutoGenerateColumns="False">
            <Columns>
                <asp:BoundField DataField="CLOCK_IN_TIME"
 HeaderText="CLOCK_IN_TIME" 
                    SortExpression="CLOCK_IN_TIME" />
                <asp:BoundField DataField="CLOCK_OUT_TIME"
 HeaderText="CLOCK_OUT_TIME" 
                    SortExpression="CLOCK_OUT_TIME" />
            </Columns>

    string cmdquery = "SELECT * FROM EMPLOYEES WHERE BADGE ='" + Badge + "'";



            OracleCommand cmd = new OracleCommand(cmdquery);
            cmd.Connection = conn;
            cmd.CommandType = CommandType.Text;
            conn.Open();
            using (OracleDataReader reader = cmd.ExecuteReader())
            {

                while (reader.Read())
                {
                    this.xUserNameLabel.Text += reader["EMPLOYEE_NAME"];
                    this.xDepartmentLabel.Text += reader["REPORT_DEPARTMENT"];


                }




            }
            conn.Close();

            string hrquery = "SELECT CLOCK_IN_TIME, CLOCK_OUT_TIME FROM CLOCK_HISTORY WHERE BADGE='" + Badge + "'";

            OracleCommand time = new OracleCommand(hrquery);
            time.Connection = conn;
            time.CommandType = CommandType.Text;
            conn.Open();

            using (OracleDataReader readers = time.ExecuteReader())
            {
                while (readers.Read())
                {

                    xTimeGridView.DataSource = readers;
                    xTimeGridView.DataBind();

                }


            }
            conn.Close();

Answer 1

哦，你这里有问题。

为了让您了解代码中发生的情况，您尝试打开获得的数据，并循环遍历所有数据；我不确定，但我认为您有效地将 GridView 单独重新绑定到每行数据。

您不想迭代所有数据并“读取”它，您想要做的是将查询结果存储在可绑定对象（如 DataSet）中，以便您可以将 gridview 粘合到它。

尝试这样的事情，一定要稍后添加你的 try/catch ：

        OracleCommand time = new OracleCommand(hrquery);
        time.Connection = conn;
        time.CommandType = CommandType.Text;
        conn.Open();
        // new code starts below
        DataSet data = new DataSet("my data");
        OracleDataAdapter adapter = new OracleDataAdapter(time);
        adapter.Fill(data);
        conn.Close();

        xTimeGridView.DataSource = data;
        xTimeGridView.DataBind();