get the data from database

[nagarajuch]

in windows form i created four textboxes and picturebox .how can i get the data from the database.

i wrote the code in this manner [ error Cannot find column 3.]

cmd.Parameters.Clear();
            cmd.CommandText = "Student_select";
            cmd.Parameters.AddWithValue("@sno", textBox1.Text);            
            da = new SqlDataAdapter(cmd);
            ds = new DataSet();
            da.Fill(ds, "Sutdent");
            if (ds.Tables[0].Rows.Count > 0)
            {
                //textBox1.Text = ds.Tables[0].Rows[0][0].ToString();
                textBox2.Text = ds.Tables[0].Rows[0][0].ToString();
                textBox3.Text = ds.Tables[0].Rows[0][1].ToString();
                textBox4.Text = ds.Tables[0].Rows[0][2].ToString();
 
                if (ds.Tables[0].Rows [0][3]!= System.DBNull.Value)  // ]there is error ocured
 
                    byte[] data = (byte[])ds.Tables[0].Rows[0][3];
                    ms = new MemoryStream(data);
                    pictureBox1.Image = Image.FromStream(ms);
                }
                else
                    pictureBox1.Image = null;
            }
            else
                MessageBox.Show("not available data");     
 
        }

[Monomachus]

[ error Cannot find column 3.]

There is no column 3 apparently in your dataset

[tlhintoq]

TIP: When you first created your question you were asked to wrap your code with [code] tags.

It really does help a bunch. Look how much easier it is to read now that someone has done it for you. Its the button with a '#' on it. More on tags. They're cool. Check'em out.

[tlhintoq]

Database tutorial Part 1
Database tutorial Part 2