HOW TO FILTER DATAS USED BY FROMDATE AND TODATE?

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)...

SP

pass the value in  mm/dd/yyyy and check

Regards,
Iftikar

SP OUTPUT

are you passing the date in this format MM/DD/YYYY to the SP?

Regards,
Iftikar

01-JUL-2013
19-JUL-2013

I am asking what is the value you have selected for datetime

Regards,
Iftikar

what is the input datetime value you have provided?

Regards,
Iftikar

Hi,
        What the issue you are getting now?

Regards,
Iftikar