Ejemplo n.º 1
0
 protected void btnVeiw_OnClick(object sender, EventArgs e)
 {
     try
     {
         string qry = "";
         dtinfo.ShortDatePattern = "dd/MM/yyyy";
         dtinfo.DateSeparator    = "/";
         if (rbtnICE.Checked == true)
         {
             lblGridTitle.Text = "Date: " + txtDateFrom.Text + " To: " + txtDateto.Text.ToString();
             qry = "select IMID,DiaryNo,Session,SubDate as Date,AmtFor,DDDate,DDNO,Bank,Narration,Amt as Amount from FeeAC where SubDate Between '" + Convert.ToDateTime(txtDateFrom.Text, dtinfo) + "' and '" + Convert.ToDateTime(txtDateto.Text, dtinfo) + "' order by SubDate Desc";
         }
         else if (rbtnIM.Checked == true)
         {
             lblGridTitle.Text = "IMID: " + txtIMID.Text.ToString() + " and Session: " + lblSessionHidden.Text.ToString();
             qry = "select IMID,DiaryNo,Session,SubDate as Date,AmtFor,DDDate,DDNO,Bank,Narration,Amt as Amount from FeeAC where Session='" + lblSessionHidden.Text.ToString() + "' and IMID='" + txtIMID.Text.ToString() + "' order by SubDate Desc";
         }
         else if (rbtnDiary.Checked == true)
         {
             lblGridTitle.Text = "Diary No. " + txtDiary.Text.ToString();
             qry = "select IMID,DiaryNo,Session,SubDate as Date,AmtFor,DDDate,DDNO,Bank,Narration,Amt as Amount from FeeAC where DiaryNo='" + txtDiary.Text.ToString() + "'  order by SubDate Desc";
         }
         else if (rbtnDDNO.Checked == true)
         {
             lblGridTitle.Text = "DD No. " + txtDiary.Text.ToString();
             qry = "select IMID,DiaryNo,Session,SubDate as Date,AmtFor,DDDate,DDNO,Bank,Narration,Amt as Amount from FeeAC where DDNO='" + txtDiary.Text.ToString() + "' and Session='" + lblSessionHidden.Text.ToString() + "'  order by SubDate Desc";
         }
         SqlDataAdapter ad = new SqlDataAdapter(qry, con);
         DataTable      dt = new DataTable();
         ad.Fill(dt);
         GridAC.DataSource = dt;
         GridAC.DataBind();
         if (GridAC.Rows.Count > 0)
         {
             GridAC.Focus();
         }
         else
         {
             btnView.Focus();
         }
     }
     catch (FormatException ex)
     {
         GridAC.DataBind();
         if (GridAC.Rows.Count > 0)
         {
             GridAC.Focus();
         }
         else
         {
             btnView.Focus();
         }
     }
     finally
     {
         con.Close();
         con.Dispose();
     }
 }
Ejemplo n.º 2
0
 protected void btnVeiw_OnClick(object sender, EventArgs e)
 {
     try
     {
         SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["Conn"]);
         string        qry = "";
         dtinfo.ShortDatePattern = "dd/MM/yyyy";
         dtinfo.DateSeparator    = "/";
         con.Close(); con.Open();
         if (rbtnICE.Checked == true)
         {
             lblGridTitle.Text = "Date: " + txtDateFrom.Text + " To: " + txtDateto.Text.ToString();
             qry = "select IMID,DiaryNo,Session,Date,Amount,Type,Balance,Details from Account where Date Between '" + Convert.ToDateTime(txtDateFrom.Text, dtinfo) + "' and '" + Convert.ToDateTime(txtDateto.Text, dtinfo) + "' ORDER BY SN DESC";
         }
         else if (rbtnIM.Checked == true)
         {
             lblGridTitle.Text = "IMID: " + txtIMID.Text.ToString() + " and Session: " + lblSessionHidden.Text.ToString();
             qry = "select IMID,DiaryNo,Session,Date,Amount,Type,Balance,Details from Account where Session='" + lblSessionHidden.Text.ToString() + "' and IMID='" + txtIMID.Text.ToString() + "' ORDER BY SN DESC";
         }
         else if (rbtnDiary.Checked == true)
         {
             lblGridTitle.Text = "Diary No. " + txtDiary.Text.ToString();
             qry = "select IMID,DiaryNo,Session,Date,Amount,Type,Balance,Details from Account where DiaryNo='" + txtDiary.Text.ToString() + "' ORDER BY SN DESC";
         }
         SqlDataAdapter ad = new SqlDataAdapter(qry, con);
         DataTable      dt = new DataTable();
         ad.Fill(dt);
         GridAC.DataSource = dt;
         GridAC.DataBind();
         GridAC.Focus();
     }
     catch (SqlException ex)
     {
     }
     catch (FormatException ex)
     {
     }
 }