so here's my code
int rowNo = 0; selected = listBox1.SelectedItem.ToString(); sqlSelectCommand2.Parameters["@title"].Value = selected; sqlDataAdapter1.Fill(dataSet1); byte tempByteArray = (byte)dataSet1.photos.Rows[rowNo]["photo"]; MemoryStream pic = new MemoryStream(tempByteArray); Image photo1 = Image.FromStream(pic); utils.load(photo1, pictureBox2); dataSet1.Clear();
I am looking to get the chosen item from the listbox (that is associated with a dataset) to visit another listbox together with the image thats saved with this title within the database.
Im obtaining the error message "no row at possition " but ive done the query
Choose photo, title, photoid FROM photos WHERE (title = @title) around the dataAdapter
Help im heading out of my thoughts!!!