/// <summary> /// this method using for get the student data and return table /// </summary> public void DisplayStudent_Grid() { try { StudentClassObject = new StudentClass(); ds = new DataSet(); ds = StudentClassObject.GetStudentData(Convert.ToInt32(Session["ID"].ToString()), ""); GridView1.DataSource = null; if (ds.Tables.Count != 0) { GridView1.DataSource = ds.Tables[0]; } //GridView1.DataBind(); } catch (Exception) { GridView1.DataSource = null; } finally { GridView1.DataBind(); } }
public void GetStudentDetails_Json(string Session_Key, string Student_No) { int LoginID = 0; rows = new List<Dictionary<string, object>>(); serializer = new System.Web.Script.Serialization.JavaScriptSerializer(); if (HttpContext.Current.Session["ID"] == null) { Context.Response.Write("[{Status: Login is experied}]"); } else if (Convert.ToString(HttpContext.Current.Session.SessionID) == Session_Key) { DataTable dt = new DataTable(); StudentClsObject = new StudentClass(); ds = new DataSet(); try { LoginID = Convert.ToInt32(HttpContext.Current.Session["ID"].ToString()); ds = StudentClsObject.GetStudentData(LoginID, Student_No); dt = ds.Tables[0]; Dictionary<string, object> row; foreach (DataRow dr in dt.Rows) { row = new Dictionary<string, object>(); foreach (DataColumn col in dt.Columns) { row.Add(col.ColumnName, dr[col]); } rows.Add(row); } } catch (Exception) { } if (rows.Count > 0) { Context.Response.Write(serializer.Serialize(rows)); } } else { // Context.Response.Clear(); // Context.Response.ContentType = "application/json; charset=utf-8"; Context.Response.Write("[{Status: Session key is not Matched}]"); } }
public void GetStudentDetails_Json(string Session_Key, string Student_No) { int LoginID = 0; rows = new List <Dictionary <string, object> >(); serializer = new System.Web.Script.Serialization.JavaScriptSerializer(); if (HttpContext.Current.Session["ID"] == null) { Context.Response.Write("[{Status: Login is experied}]"); } else if (Convert.ToString(HttpContext.Current.Session.SessionID) == Session_Key) { DataTable dt = new DataTable(); StudentClsObject = new StudentClass(); ds = new DataSet(); try { LoginID = Convert.ToInt32(HttpContext.Current.Session["ID"].ToString()); ds = StudentClsObject.GetStudentData(LoginID, Student_No); dt = ds.Tables[0]; Dictionary <string, object> row; foreach (DataRow dr in dt.Rows) { row = new Dictionary <string, object>(); foreach (DataColumn col in dt.Columns) { row.Add(col.ColumnName, dr[col]); } rows.Add(row); } } catch (Exception) { } if (rows.Count > 0) { Context.Response.Write(serializer.Serialize(rows)); } } else { // Context.Response.Clear(); // Context.Response.ContentType = "application/json; charset=utf-8"; Context.Response.Write("[{Status: Session key is not Matched}]"); } }
/// <summary> /// this method using for get the student data and return table /// </summary> public void DisplayStudent_Grid() { try { StudentClassObject = new StudentClass(); ds = new DataSet(); ds = StudentClassObject.GetStudentData(Convert.ToInt32(Session["ID"].ToString()), ""); GridView1.DataSource = null; if (ds.Tables.Count != 0) { GridView1.DataSource = ds.Tables[0]; } //GridView1.DataBind(); } catch (Exception) { GridView1.DataSource = null; } finally { GridView1.DataBind(); } }
public DataTable GetStudentDetails_Xml(int UserID, string StudentId) { StudentClsObject = new StudentClass(); ds = StudentClsObject.GetStudentData(UserID, StudentId); return(ds.Tables[0]); }
public DataTable GetStudentDetails_Xml(int UserID, string StudentId) { StudentClsObject = new StudentClass(); ds = StudentClsObject.GetStudentData(UserID, StudentId); return ds.Tables[0]; }