protected void Grid_OnselectedIndexChanged(object sender, EventArgs e) { if (GridCounselling.Rows.Count > 0) { pnlCounselling.Visible = true; pnlhome.Visible = false; fillProfile(Convert.ToInt32(GridCounselling.SelectedRow.Cells[1].Text.ToString())); rbtnFollowupDate.Checked = true; SqlDataAdapter ad = new SqlDataAdapter("select * from Followup where CID='" + Convert.ToInt32(GridCounselling.SelectedRow.Cells[1].Text.ToString()) + "'", con); DataSet ds = new DataSet(); ad.Fill(ds); GridCounselling.DataSource = ds; GridCounselling.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { try { if (Convert.ToString(Server.HtmlEncode(Request.Cookies["MyLogin"]["PWD"])) == "") { Response.Redirect("../Login.aspx"); } else { if (!IsPostBack) { dtinfo.ShortDatePattern = "dd/MM/yyyy"; dtinfo.DateSeparator = "/"; pnlCounselling.Visible = false; rbtndate.Checked = true; maikal mk = new maikal(); int lvl = mk.returnlevel(Server.HtmlEncode(Request.Cookies["MyLogin"]["UID"]).ToString(), Server.HtmlEncode(Request.Cookies["MyLogin"]["PWD"]).ToString()); txtDate.Text = DateTime.Now.ToString("dd/MM/yyyy"); txtCurrentDate.Text = DateTime.Now.ToString("dd/MM/yyyy"); SqlDataAdapter ad = new SqlDataAdapter("select * from Counselling where Date Between '" + Convert.ToDateTime(txtDate.Text, dtinfo).AddMonths(-1) + "' and '" + Convert.ToDateTime(txtDate.Text, dtinfo) + "'", con); DataSet ds = new DataSet(); ad.Fill(ds); GridCounselling.DataSource = ds; GridCounselling.DataBind(); GridCounselling.Focus(); } if (rbtnFollowupDate.Checked == true) { if (lblCID.Text.ToString() == null) { SqlDataAdapter ad = new SqlDataAdapter("select * from Followup where CID='" + Convert.ToInt32(lblCID.Text) + "'", con); DataSet ds = new DataSet(); ad.Fill(ds); GridCounselling.DataSource = ds; GridCounselling.DataBind(); } } btnView.Focus(); } } catch (NullReferenceException ex) { Response.Redirect("../Login.aspx"); } }
private void fillgrid(string type, DateTime dt) { string qry = ""; if (type == "date") { qry = "select * from Counselling where Date='" + dt + "'"; } else if (type == "nextdate") { qry = "select * from Followup where FollowUpDate='" + dt + "'"; } SqlDataAdapter ad = new SqlDataAdapter(qry, con); DataSet ds = new DataSet(); ad.Fill(ds); GridCounselling.DataSource = ds; GridCounselling.DataBind(); }