/// <summary> /// Fill clients drop down for searching /// </summary> protected void fillclient() { objuser.clientname = ""; objuser.action = "select1"; objuser.companyid = Session["companyid"].ToString(); objuser.id = ""; ds = objuser.client(); if (ds.Tables[0].Rows.Count > 0) { dropclient.DataSource = ds; dropclient.DataTextField = "clientname"; dropclient.DataValueField = "nid"; dropclient.DataBind(); //ListItem li = new ListItem("--All Clients--", ""); //dropclient.Items.Insert(0, li); } }
/// <summary> /// Fill clients /// </summary> protected void fillclient() { objuser.clientname = ""; objuser.action = "select"; objuser.companyid = Session["companyid"].ToString(); objuser.id = ""; ds = objuser.client(); if (ds.Tables[0].Rows.Count > 0) { ddlclient.DataSource = ds; ddlclient.DataTextField = "clientcodewithname"; ddlclient.DataValueField = "nid"; ddlclient.DataBind(); ListItem li = new ListItem("--Select Client--", ""); ddlclient.Items.Insert(0, li); ddlclient.SelectedIndex = 0; } }
protected void fillclients() { ClsUser objuser = new ClsUser(); objuser.action = "select"; objuser.name = ""; objuser.id = ""; objuser.companyid = Session["companyId"].ToString(); DataSet ds = objuser.client(); if (ds.Tables[0].Rows.Count > 0) { dropclient.DataSource = ds; // dropclient.DataTextField = "clientcodewithname"; // dropclient.DataValueField = "nid"; dropclient.DataBind(); } }
/// <summary> /// Fill list of existing clients /// </summary> public void fillgrid() { objuser.clientname = txtsearch.Text; objuser.action = "select"; objuser.companyid = Session["companyid"].ToString(); objuser.id = ""; objuser.activestatus = drostatus.Text; ds = objuser.client(); DataTable dt = new DataTable(); dt = ds.Tables[0]; //int start = dgnews.PageSize * dgnews.PageIndex; //int end = start + dgnews.PageSize; //start = start + 1; //if (end >= ds.Tables[0].Rows.Count) // end = ds.Tables[0].Rows.Count; //lblstart.Text = start.ToString(); //lblend.Text = end.ToString(); //lbltotalrecord.Text = ds.Tables[0].Rows.Count.ToString(); if (ds.Tables[0].Rows.Count > 0) { //if (ViewState["SortDirection"] != null && ViewState["SortExpression"] != null) //{ // dt.DefaultView.Sort = ViewState["SortExpression"].ToString() + " " + ViewState["SortDirection"].ToString(); //} Session["TaskTable"] = dt; dgnews.DataSource = dt; dgnews.DataBind(); btnexportcsv.Enabled = true; nodata.Visible = false; dgnews.Visible = true; lnkprevious.Enabled = true; lnknext.Enabled = true; if (lbltotalrecord.Text == lblend.Text) { lnknext.Enabled = false; } if (lblstart.Text == "1") { lnkprevious.Enabled = false; } } else { lblstart.Text = "0"; lnkprevious.Enabled = false; lnknext.Enabled = false; // btnexportcsv.Enabled = false; if (IsPostBack) { nodata.Visible = true; } dgnews.Visible = false; Session["TaskTable"] = null; } updateData.Update(); ScriptManager.RegisterStartupScript(updateData, updateData.GetType(), "key", "<script type='text/javascript'>fixheader();</script>", false); }