C# Web-App: how to retreive data form SQL tables?

[waterfall]

code for populating drop down:

DataAccess data = null;
	
            data = new DataAccess();
           
            SqlConnection oConnection = null;
           


            oConnection = new SqlConnection("server=ABC-F78782C30;uid=sa;pwd=sasa;database=Emp");

            data.openConnection();
            data.ProcName = "DisplayEmployeeName";
            data.CreateCommand();

            data.Parameters("@name", SqlDbType.VarChar, 50, name_combo.SelectedValue);

            SqlDataReader dr = data.ExecuteDataReader();
            name_combo.DataSource = dr;

            name_combo.DataTextField = "name";
            name_combo.DataValueField = "name";
            name_combo.DataBind();


            data.openConnection();
            data.DisposeConnection();

code for getting values in textbox from Worker table:

SqlConnection con = null;
            con = new SqlConnection("server=ABC-F78782C30;uid=sa;pwd=sasa;database=Emp");
            DataAccess dataA = null;
                      dataA = new DataAccess();
            dataA.openConnection();
                      
                        dataA.ProcName = "ShiftDetails";
                        dataA.CreateCommand();
                        dataA.Parameters("@shift_detail", SqlDbType.VarChar, 50, shift_box.Text);

                       SqlDataReader drA = dataA.ExecuteDataReader();
                        drA.Read();
                        name_combo.SelectedValue = drA.GetValue(0).ToString();
                        while (drA.Read())
                        {
                            shift_box.Text = drA["shift_detail"].ToString();
                            shift_box.Text = drA.GetValue(0).ToString();
                        }
                        
        }

my code shows no error but doesnt display any record in textbox.

[waterfall]

sorry i sent the same code again..
the code using SqlData Reader is below:

 connection.Open();      
   SqlCommand command = new SqlCommand();
   command.Connection = connection;
   command.CommandText = "ShiftDetails";
   command.CommandType = CommandType.StoredProcedure;
      
   // Add the input parameter and set its properties.
   SqlParameter parameter = new SqlParameter();
   parameter.ParameterName = "@shift_detail";
   parameter.SqlDbType = SqlDbType.VarChar;
   parameter.Direction = ParameterDirection.Input;
 
   parameter.Value = name_combo.SelectedValue.ToString();


   command.Parameters.Add(parameter);

   SqlDataReader reader = command.ExecuteReader();
   
   if(reader.HasRows)
   {
      while (reader.Read())
      {
         txtshift.Text = reader["shift_detail"].ToString();
      }

[alijannaty52]

You can verily do it using "Databound DropDown Lists".Below link will explain you the same, hope it will be helpful indeed.


http://aspspider.info/magicalspell4u/?Quest=Databoun dDropDownLists

-Thanks
52

[waterfall]

Thanks alot..My problem is solved.But i've another..
here it is:
i get the data from database in textbox but for each employee i get the same data.I think there's problem with my Query..