protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
// In this example a strongly typed DataSet is used.
// In a strongly typed DataSet the table columns becomes properties and type (class) associated with each of the table columns is known at design time
// A seperate defination of the class for the DataSet table is not needed, also do not have to map the class properties to the DataSet table columns, Which is required for not strongly typed DataSet.
// This makes development much easier and reduces errors in coding.
StudentDataSetTableAdapters.StudentsTableAdapter StudentsTableAdapater = new StudentDataSetTableAdapters.StudentsTableAdapter();
StudentDataSet.StudentsDataTable StudentDataTable = new StudentDataSet.StudentsDataTable();
StudentDataSetTableAdapters.EmailsTableAdapter EmailsTableAdapter = new StudentDataSetTableAdapters.EmailsTableAdapter();
StudentDataSet.EmailsDataTable EmailDataTable = new StudentDataSet.EmailsDataTable();
Session["STUDENTDATATABLE"] = StudentDataTable;
Session["EMAILDATATABLE"] = EmailDataTable;
StudentsTableAdapater.Fill(StudentDataTable);
EmailsTableAdapter.Fill(EmailDataTable);
GrdvStudents.DataSource = from student in StudentDataTable
// As it is a strongly typed DataSet, the type (Class) of table is known at design time and,
// all table columns are properties.
select new
{
student.Id,
student.FirstName,
student.LastName,
studentEmail = GetStudentEmails(student.Id), // New property can be defined if additional information needs to be added as one more column programatically.
};
GrdvStudents.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
StudentDataSetTableAdapters.StudentsTableAdapter studentsTableAdapter = new StudentDataSetTableAdapters.StudentsTableAdapter();
StudentDataSet.StudentsDataTable studentsDataTable = new StudentDataSet.StudentsDataTable();
studentsTableAdapter.Fill(studentsDataTable);
Session["DATATABLE"] = studentsDataTable;
GridView1.DataSource = from student in studentsDataTable
select new { student.ID, student.Name, student.Gender, student.TotalMarks };
GridView1.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
StudentDataSetTableAdapters.StudentsTableAdapter sta = new StudentDataSetTableAdapters.StudentsTableAdapter();
StudentDataSet.StudentsDataTable sdt = new StudentDataSet.StudentsDataTable();
sta.Fill(sdt);
Session["DATATABLE"] = sdt;
Gvw_Display.DataSource = from student in sdt
select new
{
student.Id,
student.Name,
student.Gender,
student.TotalMarks
};
Gvw_Display.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
StudentDataSetTableAdapters.StudentsTableAdapter studentsTableAdapter = new StudentDataSetTableAdapters.StudentsTableAdapter();
StudentDataSet.StudentsDataTable studentsDataTable = new StudentDataSet.StudentsDataTable();
studentsTableAdapter.Fill(studentsDataTable);
Session["DATATABLE"] = studentsDataTable;
// Using LINQ to select each row entry from student datatable, and mapping the filtered result to new object as defined by student datatable columns
// This is strongly typed datatable
gvStudents.DataSource = from student in studentsDataTable
select new
{
student.ID,
student.Name,
student.Gender,
student.TotalMarks
};
gvStudents.DataBind();
}
}
