can u give the solution pls
the string d is will written as public...
string d = DateTime.Today.ToShortDateString ();
cmd1 = new OleDbCommand("select count(*) from tbllvdate where uname='" + lbluname.Text + "' and mname='" + lblmname.Text + "' and vdate='"+d+"'", con);
i= Convert.ToInt32 (cmd1.ExecuteScalar());
if (i == 0)
lvd(); // this is the procedure to insert the record
when i run this code i have the ERROR :
Data type mismatch in criteria expression.
pls give solution ...