Adding sql data to a grid view based on the input value?
<p>Had no hits on the asp side so I thought id try here.I finally got one query working that inserts the employees name and department but now I want to add their hours worked for the week in a table or a grid view like a typical time sheet report. any Ideas on how to accomplish this I'm new to programming "still a student"</p>

<pre><code> string cmdquery = "SELECT * from Employees WHERE Badge ='" + Badge + "'";
                string HrQuery = "SELECT CLOCK_IN_TIME, CLOCK_OUT_TIME FROM CLOCK_HISTORY 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"];

                    }

                    //OracleCommand HrQuery = new OracleCommand(HrQuery);




                }

                conn.Close();
</code></pre>

<p>here's an example of the old time sheets format that I'm trying to replicate and improve. </p>

<pre><code>Clock In Time    Clock Out Time     Subtotal    " Actual Time" // user can input data

Sunday
6/20/10 6/20/10 

0

Monday
6/21/10 6/21/10 

0

Tuesday
6/22/10 6/22/10 

0

Wednesday
6/23/10 6/23/10 

0

Thursday
6/24/10 6/24/10 

0

Friday
6/25/10 6/25/10 

0

Saturday
6/26/10 6/26/10 

0
</code></pre>
