private void LoadDataFromCacheForTeacher()
{
DataSet ds = (DataSet)Cache["DATASETTEACHER"];
GridViewTeachers.DataSource = ds.Tables["UserTeacher"];
GridViewTeachers.DataBind();
}
public void LoadGridViewTeachers()
{
string query = @"SELECT [ID]
,[Name]
,[Designation]
,[Gender]
,[Date_of_Join]
,[Phone]
,[Email]
,[Address]
FROM [dbo].[Teachers]";
GridViewTeachers.DataSource = dm.GetDataTable(query);
GridViewTeachers.DataBind();
}
private void LoadFromDatabaseForTeacher()
{
string connStr = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
string sql = "select u.ID, u.Password, t.Name, t.Email from UserInfo u, Teacher t where u.ID = t.TeacherID";
SqlDataAdapter AdapterUserTeacher = new SqlDataAdapter(sql, conn);
SqlCommandBuilder builder = new SqlCommandBuilder(AdapterUserTeacher);
DataSet ds = new DataSet();
AdapterUserTeacher.Fill(ds, "UserTeacher");
sql = "select * from UserInfo";
SqlDataAdapter AdapterUserInfo = new SqlDataAdapter(sql, conn);
builder = new SqlCommandBuilder(AdapterUserInfo);
AdapterUserInfo.Fill(ds, "UserInfo");
sql = "select * from Teacher";
SqlDataAdapter AdapterTeacher = new SqlDataAdapter(sql, conn);
builder = new SqlCommandBuilder(AdapterTeacher);
AdapterTeacher.Fill(ds, "Teacher");
ds.Tables["UserTeacher"].PrimaryKey = new DataColumn[] { ds.Tables["UserTeacher"].Columns["ID"] };
ds.Tables["UserInfo"].PrimaryKey = new DataColumn[] { ds.Tables["UserInfo"].Columns["ID"] };
ds.Tables["Teacher"].PrimaryKey = new DataColumn[] { ds.Tables["Teacher"].Columns["TeacherID"] };
GridViewTeachers.DataSource = ds.Tables["UserTeacher"];
GridViewTeachers.DataBind();
Cache["DATASETTEACHER"] = ds;
Cache["AdapterUserTeacher"] = AdapterUserTeacher;
Cache["AdapterUserInfo"] = AdapterUserInfo;
Cache["AdapterTeacher"] = AdapterTeacher;
}
