HOW TO GET DATA WITHIN THE FROM DATE AND TO DATE?

MANEESH AN

13y1.5kVisual Basic .NET

ALTER PROCEDURE [dbo].[sp_PaymentRegisterGrid]

(

@DTFROM datetime,

@DTTO datetime

)

BEGIN

SELECT

ACC.dRPDate DATE,

ACC.cVType TYPE,

TS.vSeries SERIES,

ACC.iRPNo VOUCHERNO,

ACM.vAcName HEAD,

ACC.vNarration NARRATION,

ACC.deDRAmount DEBIT,

ACC.deCRAmount CREDIT

FROM tbl_Acc_Voucher AS ACC INNER JOIN

tblSerialNumbers AS TS ON ACC.iSeriesId = TS.iSeriesId INNER JOIN

tbl_Acc_AccountMaster AS ACM ON ACM.iAcID = ACC.iAcID

where dRPDate >=@DTFROM and dRPDate<=@DTTO

END

DLL

public DataTable fnPayRegDateView(string strWhereCondition)

{

Connection objCon = new Connection();

SqlParameter[] parmsDetails = new SqlParameter[1];

parmsDetails[0] = new SqlParameter();

parmsDetails[0].SqlDbType = SqlDbType.VarChar;

parmsDetails[0].Value = strWhereCondition;

parmsDetails[0].ParameterName = "@WhereCondition";

DataTable dt = new DataTable();

dt = objCon.fnSelectData("sp_PaymentRegisterGridView", parmsDetails);

return dt;

}

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

MANEESH AN13y ago
BLL

public DataTable fnPayRegDateView(DateTime dRPDate)
{
DataTable dt = new DataTable();
dt = objPaymentMasterDL.fnPayRegDateView(dRPDate);
return dt;
}
DLL

public DataTable fnPayRegDateView(DateTime dRPDate)
{
Connection objCon = new Connection();
//SqlParameter[] parmsDetails = new SqlParameter[1];

//parmsDetails[0] = new SqlParameter();
//parmsDetails[0].SqlDbType = SqlDbType.VarChar;
//parmsDetails[0].Value = strWhereCondition;
//parmsDetails[0].ParameterName = "@WhereCondition";
//DataTable dt = new DataTable();
//dt = objCon.fnSelectData("sp_PaymentRegisterGridView", parmsDetails);
//return dt;

//SqlConnection objCon = new SqlConnection();
SqlParameter[] parmsDetails = new SqlParameter[2];

parmsDetails[0] = new SqlParameter();
parmsDetails[0].SqlDbType = SqlDbType.DateTime;
parmsDetails[0].Value = dRPDate;
parmsDetails[0].ParameterName = "@DTFROM";

parmsDetails[0] = new SqlParameter();
parmsDetails[0].SqlDbType = SqlDbType.DateTime;
parmsDetails[0].Value = dRPDate;
parmsDetails[0].ParameterName = "@DTTO";

DataTable dt = new DataTable();
dt = objCon.fnSelectData("sp_PaymentRegisterGrid", parmsDetails);
return dt;

}
PLEASE GIVE FURTHER?
0
Iftikar Hussain13y ago
can you share your complete code to call stored procedure?

Regards,
Iftikar
0
MANEESH AN13y ago
i got an error:Object reference not set to an instance of an object.whats it?
0
Iftikar Hussain13y ago
Hi,
Try like this

SqlConnection objCon = new SqlConnection();
SqlParameter[] parmsDetails = new SqlParameter[2];

parmsDetails[0] = new SqlParameter();
parmsDetails[0].SqlDbType = SqlDbType.DateTime;
parmsDetails[0].Value = fromDate;
parmsDetails[0].ParameterName = "@DTFROM";

parmsDetails[0] = new SqlParameter();
parmsDetails[0].SqlDbType = SqlDbType.DateTime;
parmsDetails[0].Value = toDate;
parmsDetails[0].ParameterName = "@DTTO";

Regards,
Iftikar
0
Pankaj Pandey13y ago
ALTER PROCEDURE [dbo].[sp_PaymentRegisterGrid]
(
@DTFROM datetime,
@DTTO datetime
)
AS
BEGIN

SELECT
ACC.dRPDate as 'DATE',
ACC.cVType as 'TYPE',
TS.vSeries as 'SERIES',

ACC.iRPNo as 'VOUCHERNO',
ACM.vAcName as 'HEAD',
ACC.vNarration as 'NARRATION',
ACC.deDRAmount as 'DEBIT',
ACC.deCRAmount as 'CREDIT'

FROM tbl_Acc_Voucher AS ACC INNER JOIN
tblSerialNumbers AS TS ON ACC.iSeriesId = TS.iSeriesId INNER JOIN
tbl_Acc_AccountMaster AS ACM ON ACM.iAcID = ACC.iAcID

where ACC.dRPDate between @DTFROM and @DTTO

END
0