conn.Open(); string CommandText = "SELECT * FROM entry where userid ='"+ userid.Text + "'"; OleDbCommand cmd = new OleDbCommand(CommandText); cmd.Connection = conn; OleDbDataReader dr; dr = cmd.ExecuteReader(); while (dr.Read()) { panel1.Visible = true; label13.Text = dr["userid"].ToString(); label13.Text = dr["Name"].ToString(); label13.Text = dr["NIC"].ToString(); label13.Text = dr["Father_Name"].ToString(); }
Data type mismatch in criteria expression please help me out this error.
conn.Open(); string CommandText = "SELECT * FROM entry where userid ="+ userid.Text ; OleDbCommand cmd = new OleDbCommand(CommandText); cmd.Connection = conn; OleDbDataReader dr; dr = cmd.ExecuteReader(); while (dr.Read()) { panel1.Visible = true; label13.Text = Convert.ToString(dr["userid"]); label13.Text = Convert.ToString(dr["Name"]); label13.Text = Convert.ToString(dr["NIC"]); label13.Text = Convert.ToString(dr["Father_Name"]); }
string CommandText = "SELECT * FROM entry where userid ="+ Convert.TOInt32(userid.Text) + "";
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)