String sql = "select PatientId, FirstName, LastName, Sex, Age, CNIC, Phone, GaurdianName from Patients WHERE 1=1";
if (PatientId.Text != "")
{
sql += " AND PatientId LIKE '%" + PatientId.Text + "%'";
}
i couldn't uderstand where is wrong!! i want to retrieve exact patient id but not getting like if i query for 1 it is showing 1,10,11 records!! i couldn't fighure out where is the problem.