Doesnt search the right data from Database

Israel

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();
}

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Kumar7y ago
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);
}
}
Israel7y ago
Please I cant sleep well. I need to resolv this problem.
Laxmidhar Sahoo7y ago
it id is number field no need of single code
Israel7y ago
@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 Kumar7y ago
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 Kumar7y ago
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.
Israel7y ago
I try to do it but I have this message:
Incorrect syntax near '.'.
Amit Kumar7y ago
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.