Problem with bind data in textbox

[Ahmed R El Bohoty]

hi, i note that when i retrieve data and bind it to textbox that when i want to bind to each textbox i do the same thing , so i think to make method where i pass array of the name of textbox and it will bind automatic for each textbox and here is what i try to do

//Step 1 :
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "student_SelectAll";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = cn;
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = cmd;

        //Step 2 :
        TextBox \[\] txtb={textBox1,textBox2,textBox3,textBox4,textBox5,textBox6,textBox7,textBox8};

        //Step 3:
        IDataParameter\[\] param = adapter.GetFillParameters();
        for (int i = 0; i <param.length;>            {
            cmd.Parameters.Add(param\[i\].ParameterName,param\[i\].DbType).Value = txtb\[i\].Text;
        }

Discover Other .... http://www.islamHouse.com

[Vimalsoft Pty Ltd]

What is your Problem?

Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za

[Ahmed R El Bohoty]

It does not work or how i can do something like this ?

Discover Other .... http://www.islamHouse.com

[Vimalsoft Pty Ltd]

There ways that you can do that, if i understand you Correctly , you want to Bind the Results from the DB to the indivisual Textbox. You can Create a Class that has a Function to get you Data , or you can create your Function in your Form (thats not professional) and call your Function like this

public class Class1
{

  
   public DataTable GetData() 
   {
      int Code;

      String strCon = "blablablablablablabla";

      SqlConnection con = new SqlConnection(strCon);

      SqlCommand cmdselect = new SqlCommand();

      cmdselect.CommandType = CommandType.StoredProcedure;  
      
      cmdselect.CommandText = "student\_SelectAll";

      cmdselect.Connection = con;

      DataTable DT = new DataTable();


      try
      {
          con.Open();

          DT = cmdselect.ExecuteNonQuery();

      }
       catch(SqlException)
      {
           throw; 
      }
       finally
      {
          con.Close();
      }

      return DT;
       
   } 

  }

This is a Class that has a Function Getdata that returns a Datatable and in your Form you access the Function and Bind the Textbox like this

Class1 obj = new Class1();

       DataTable DT = new DataTable();
       
        DT =  obj.GetData();

        txtname.Text = DT.Columns\[0\];

        txtlastname.Text = DT.Columns\[1\];
        //and bla bla blabla 

Am Sorry for the untidy code, am just in a Hurry for a meeting. Hope this Helps :)

Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za