title: Adding sql data to a grid view based on the input value?
body: <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>