DataTable dt = new DataTable(); con = new SqlConnection(strcon); SqlDataAdapter adapt = new SqlDataAdapter("select * from customer where id=@a,password=@b,confirm=@c", con); adapt.SelectCommand.Parameters.AddWithValue("@a",id); adapt.SelectCommand.Parameters.AddWithValue("@b",password); adapt.SelectCommand.Parameters.AddWithValue("@c",confirm); adapt.Fill(dt);
AND
your query will be like follwoing.you are missing <code>and</code> SqlDataAdapter adapt = new SqlDataAdapter("select * from customer where id=@a and password=@b and confirm=@c", con);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)