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();
}
