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(); }