private void BindUserData() { try { GridView_users.DataSource = con.SelecthostProc(Com_username, "User_Select", null, null); GridView_users.DataBind(); } catch (Exception ex) { con.ExcutehostProc(Com_username, "Log_Issues", new string[] { "msg", "details" }, ex.Message, "Err-Setting-BindUserData"); } }
protected void GridView_users_PageIndexChanging(object sender, GridViewPageEventArgs e) { try { BindUserData(); GridView_users.PageIndex = e.NewPageIndex; GridView_users.DataBind(); } catch (Exception ex) { con.ExcutehostProc(Com_username, "Log_Issues", new string[] { "msg", "details" }, ex.Message, "Err-Setting-GridView_users_PageIndexChanging"); } }
public void viewgrid() //course grid function { SqlConnection con = new SqlConnection("Data Source=.\\sqlexpress;Initial Catalog=college_management;User ID=sa;Password=admin123"); con.Open(); SqlCommand cmd = new SqlCommand("select user_type from tbl_user ", con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); cmd.ExecuteNonQuery(); GridView_users.DataSource = dt; GridView_users.DataBind(); }