Comments by Meisam Parsa (Top 16 by date)

ok

error :
'timeDr' is a 'variable' but is used like a 'method'

error : The string was not recognized as a valid DateTime. There is an unknown word starting at index 0.

save code :

instoReceiveTbl.Parameters.AddWithValue("@enterTime", DateTime.Now);
instoReceiveTbl.ExecuteNonQuery();

Retrieval code :

SqlCommand cmTime = new SqlCommand("select enterTime from receiveTable where cardNo = " + enterCardNo_txtBox.Text, cnn);
SqlDataReader timeDr = cmTime.ExecuteReader();
timeDr.Read();
DateTime enterTime = Convert.ToDateTime(timeDr.ToString());

whats the my problem ?

thanks buddy ;)

Error : Invalid attempt to read when no data is present.


save code :

SqlCommand instoReceiveTbl = new SqlCommand("insert into receiveTable (carNo,enterTime,cardNo,faceImage) values (@carNo,@enterTime,@cardNo,@faceImage)", cnn);
instoReceiveTbl.Parameters.AddWithValue("@cardNo",enterCardNo_txtBox.Text);
instoReceiveTbl.Parameters.AddWithValue("@carNo", "ثبت نشده");
instoReceiveTbl.Parameters.AddWithValue("@enterTime", DateTime.Now);
instoReceiveTbl.Parameters.AddWithValue("@faceImage", imageByte);
instoReceiveTbl.ExecuteNonQuery();


Retrieval code :

SqlCommand callFaceImage = new SqlCommand("select faceImage from receiveTable where cardNo = "+ enterCardNo_txtBox.Text,cnn);
SqlDataReader dr = callFaceImage.ExecuteReader();
byte[] Img =(byte[]) dr["faceImage"];
MemoryStream ms = new MemoryStream(Img);
pictureBox3.Image = Image.FromStream(ms);

this solution not working

yes in binary

What exactly should I write the code?

Thanks buddy

I do not know how to start a photo from my ip camera and how save this in database