Doesnt search the right data from Database

Question

Hi, I have data into my DB (five records). When I search for example the number "3" its sturk and give the error message: the parameter it's not valide. Curiosly all number out of numbers inside of my DB (1,2,3,4,5) its says "Data not find". private void button2_Click( object sender, EventArgs e) { conn.Open(); string sqlQuery = "select * from test where id ='" + textID.Text + "'" ; cmd = new SqlCommand(sqlQuery, conn); SqlDataReader DataRead = cmd.ExecuteReader(); DataRead.Read(); if (DataRead.HasRows) { textName.Text = DataRead[1].ToString(); byte [] img = (( byte [])DataRead[2]); if (img == null ) { pictureBox1.Image = null ; } else { MemoryStream mstream = new MemoryStream(img); pictureBox1.Image = Image.FromStream(mstream); // Its sturk here on this line } } else { MessageBox.Show( "Data not find" ); } conn.Close(); }

Amit Kumar · Answer

Hi, use the below code. It work properly. if (DataRead.HasRows) { textName.Text = DataRead[1].ToString(); Byte[] bindata= new byte [Convert.ToInt32(DataRead[2])]; if (img == null ) { pictureBox1.Image = null ; } else { MemoryStream stream = new MemoryStream(bindata); //load picture stream.Position = 0; pictureBox1.Image = Image.FromStream(stream); } }

Israel · Answer

Please I cant sleep well. I need to resolv this problem.

Laxmidhar Sahoo · Answer

it id is number field no need of single code

Israel · Answer

@Jignesh Kumar For these codes its stucks on that line colored in red and says: the parameter is not valid if (DataRead.HasRows) { textName.Text = DataRead[1].ToString(); MemoryStream ms = new MemoryStream(( byte [])DataRead[2]); pictureBox1.Image = new Bitmap(ms); //Here } @Amit Kumar I do step by step as you told me but its stucks and says: Incorrect syntax near '.'

Jignesh Kumar · Answer

Hi Israel, Plese try to correct here, if (DataRead.HasRows) { textName.Text = DataRead[1].ToString(); MemoryStream ms = new MemoryStream(( byte [])DataRead[2]); pictureBox1.Image = new Bitmap(ms); }

Amit Kumar · Answer

Dear, This line will not show an error. Do onething start debugging step by step and then tell me what is error and show it.

Israel · Answer

I try to do it but I have this message: Incorrect syntax near '.'.

Amit Kumar · Answer

Hi, I think in your database table id column is integer datatype but your pass string value . Because textID.text alwyas return string datatype. In your query you pass string value inside integer datatype. Correct it like that. string sqlQuery = "select * from test where id = Convert.ToInt32('" + textID.Text + "')" ; I hope it will help you.