public void DataSearch(string SearchKey)
{
string query = @"SELECT * FROM Students WHERE Name LIKE '%" + SearchKey + "%' OR Fathers_name LIKE '%" + SearchKey + "%' OR Mothers_name LIKE '%" + SearchKey + "%' OR Date_of_Admission LIKE '%" + SearchKey + "%' OR Gender LIKE '%" + SearchKey + "%' OR Class LIKE '%" + SearchKey + "%' OR Class_Roll LIKE '%" + SearchKey + "%' OR Address LIKE '%" + SearchKey + "%'";
GridViewAddStudents.DataSource = dm.GetDataTable(query);
GridViewAddStudents.DataBind();
if (dm.count == 0)
{
lblSearchResult.Text = "Sorry! no data found";
}
else
{
lblSearchResult.Text = "";
}
}
public void LoadGridAddStudents()
{
string query = @"SELECT [ID]
,[Name]
,[Fathers_name]
,[Mothers_name]
,[Date_of_Birth]
,[Date_of_Admission]
,[Gender]
,[Class]
,[Class_Roll]
,[Phone]
,[Email]
,[Address]
FROM [dbo].[Students]";
GridViewAddStudents.DataSource = dm.GetDataTable(query);
GridViewAddStudents.DataBind();
}
