MANEESH AN

MANEESH AN

  • NA
  • 110
  • 46.9k

HOW TO GET DATE

Jul 20 2013 6:28 AM
Declaration

  DateTime DTFROM;
  DateTime DTTO;
  string vSeries;

button view

frmView view = new frmView();
            view.vSeries = txtSeries.Text;
           
            view.Show();
            view.Location = new Point(0, 50);


            DataTable dt = new DataTable();
            dt = objPaymentBL.fnGetPayReg(DTFROM, DTTO);

 view.DTFROM.Text = DtpDateFrom.Value.Date.ToString() + "TO" + DtpDateTo.Value.Date.ToString();


BL
DateTime dRPDate;
        DateTime FROM;
        DateTime TO;

public DateTime DTFROM
        {
            get { return FROM; }
            set { FROM = value; }
        }
        public DateTime DTTO
        {
            get { return TO; }
            set { TO = value; }
        }
  public DataTable fnGetPayReg(string vSeries,DateTime FROM, DateTime TO)
        {
            DataTable dt = new DataTable();
            dt = objPaymentMasterDL.fnGetPayReg(vSeries,DTFROM, DTTO);
            return dt;
        }

DL

  public DataTable fnGetPayReg(string vSeries,DateTime FROM, DateTime TO)
        {
            DataTable dt = new DataTable();
            dt = objPaymentMasterDL.fnGetPayReg(vSeries,DTFROM, DTTO);
            return dt;
        }
GRID

DECLARATION
 DateTime DATEFROM;
        DateTime DTTO;

  public DateTime FROM
        {
            get { return DATEFROM; }
            set { DATEFROM = value; }
        }
        public DateTime TO
        {
            get { return DTTO; }
            set { DTTO = value; }
        }
GRID LOAD

DateTime @dRPDate;
            DataTable DT = new DataTable();
            DT = objViewBL.fnGetPayReg(FROM, TO);

ONLY ON FIELD 'drpdate' is inserted in one table,series is inserted in another table,when form come up,we will select series,date from.datet to and click view button,that time grid will come up within the region of date and time...how can i go?Error found:SQL DATETIME OVERFLOW.....I DONT KNOW THE FORMAT OF DATE HOW TO GIVE?I HAD SENT ALREADY OUTPUT OF SP(THERE YOU CAN SEE DATE VALUE OF DATETIME)...

Answers (1)