I STORED MULTIPLE IMAGES IN MY SQL SERVER 2005. NOW I WANT TO RETRIEVE PARTICULAR CATEGORY OF IMAGES INTO MULTIPLE PICTUREBOX AT RUNTIME IN C# WINDOWS APPLICATION. i used the following code in my final result form at form_Load using c# windows apps.. But it displays only one picture at run time pls help to me...



  2.  
  3.  
  4. SqlConnection con = new SqlConnection(@"Data Source=ttt-PC;Initial Catalog=Query_Image;Integrated Security=True");
  5.             SqlCommand cmdnew = new SqlCommand("select pic from Image_Category where IMG_Cat='" + searchvalue.ToString() + "'", con);
  6.             con.Open();
  7.           //  SqlDataReader dr = cmdnew.ExecuteReader();
  8.             SqlDataAdapter da = new SqlDataAdapter(cmdnew);
  9.             DataSet ds = new DataSet("Image_Category");
  10.             byte[] mydata = new byte[0];
  11.             da.Fill(ds, "Image_Category");
  12.             DataRow myrow;
  13.             //if (dr.HasRows)
  14.             //{
  15.             //    while (dr.Read())
  16.             //    {
  17.  
  18.             for (int i = 0; i < 2; i++)
  19.  
  20.             // while (i <= dt.Rows.Count)
  21.  
  22.             {
  23.  
  24.                 myrow= ds.Tables["Image_Category"].Rows[i];
  25.                 mydata = (byte[])ds.Tables[0].Rows[i]["pic"];
  26.                 str[i]=new MemoryStream(mydata);
  27.  
  28.                 pbx[i]=new PictureBox();
  29.                  pbx[i].Size = new Size(150, 150);
  30.                  pbx[i].SizeMode = PictureBoxSizeMode.StretchImage;
  31.                 pbx[i].BackgroundImage = Image.FromStream(str[i]);
  32.                  pbx[i].Visible = true;
  33.                  //this.Controls.Add(pbx[i]);
  34.                 }
  35.  


PLEASE TELL IS IT ANY WRONG WITH THIS CODE?
OR SUGGEST NEW CODE TO ME PLEASE..

its very urgent