protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { StudentsDataSetTableAdapters.TBLStudentsTableAdapter studentsTableAdapter = new StudentsDataSetTableAdapters.TBLStudentsTableAdapter(); StudentsDataSet.TBLStudentsDataTable tBLStudents = new StudentsDataSet.TBLStudentsDataTable(); studentsTableAdapter.Fill(tBLStudents); Session["DATASET"] = tBLStudents; GridView1.DataSource = from Student in tBLStudents select new { Student.ID, Student.Name, Student.Gender, Student.TotalMarks }; GridView1.DataBind(); } }
protected void Button1_Click(object sender, EventArgs e) { StudentsDataSet.TBLStudentsDataTable tBLStudents = new StudentsDataSet.TBLStudentsDataTable(); tBLStudents = (StudentsDataSet.TBLStudentsDataTable)Session["DATASET"]; if (string.IsNullOrEmpty(TextBox1.Text)) { GridView1.DataSource = from Student in tBLStudents select new { Student.ID, Student.Name, Student.Gender, Student.TotalMarks }; GridView1.DataBind(); } else { GridView1.DataSource = from Student in tBLStudents where Student.Name.ToUpper().StartsWith(TextBox1.ToString()) select new { Student.ID, Student.Name, Student.Gender, Student.TotalMarks }; GridView1.DataBind(); } }