public void BindUsers() { try { user_dll = new UsersDLL(); DataTable dt = user_dll.GetUsers(); ddlUsers.DataSource = dt; ddlUsers.DataTextField = "UserName"; ddlUsers.DataValueField = "UserID"; ddlUsers.DataBind(); ddlUsers.Items.Insert(0, new ListItem("--Select--", "0")); } catch (Exception ex) { ErrorMessage("Users dropdown binding error:1 " + ex.Message); } }
public void BindGrid() { try { user_dll = new UsersDLL(); DataTable dt = user_dll.GetUsers(); if (dt.Rows.Count > 0) { ViewState["UserData"] = dt; grvUser.DataSource = dt; grvUser.DataBind(); } else { ShowEmptyGrid(); } } catch (Exception ex) { ErrorMessage("Grid binding error:1 " + ex.Message); } }