how to get sorted data wihin the region date from and dateto

try like this


in your code


Regards,
Iftikar

hi you can use like this:

1st add the reference of

using System.Configuration;


public DataTable GET_PRE_SALES_REPORT(string From, string To)
    {
  string  cn= ConfigurationManager.ConnectionStrings["MagnaDBConnection"].ConnectionString;
        adap = new SqlDataAdapter("sp_PaymentRegisterGrid", cn);
        adap.SelectCommand.CommandType = CommandType.StoredProcedure;
        adap.SelectCommand.Parameters.AddWithValue("@from", From);
        adap.SelectCommand.Parameters.AddWithValue("@to", To);
        dt = new DataTable();
        adap.Fill(dt);
        return dt;

    }

hi,

cn is your connection string. if you store your connection string in different variable pass it their.

Use below code in application...

Please share your code.

Regards,
Iftikar

try 


SELECT * from table where

convert(DATETIME,CreatedDate,101)>=convert(DATETIME,@From,101)
AND
convert(DATETIME,CreatedDate,101) <= convert(DATETIME,@To,101)

dRPDate	datetime
deDRAmount	decimal(18, 2)
deCRAmount	decimal(18, 2)
cVType	char(1)
vNarration	varchar(1000)
vSeries	nvarchar(20)
iRPNo	int
vAcName	varchar(50)

can you give coding?

Hi ,

if your sql column is in varchar format .please first convert into proper datetime format...
try below query...


SELECT * from table where

convert(DATETIME,CreatedDate,101)>=convert(DATETIME,@From,101)
AND
convert(DATETIME,CreatedDate,101) <= convert(DATETIME,@To,101)


Mark it as answer if it helped .

Please share you table schema...

In which format your column is in sql table.

you can use SqlDbType.DateTime 

Regards,
Iftikar

your SP is correct. I hope you will pass correct parameter (2) from your code to sql.

Regards,
Iftikar

ALTER PROCEDURE [dbo].[sp_PaymentRegisterGrid]
(
  @DTFROM datetime, 
  @DTTO datetime
)
AS
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;


        }
IS THIS CORRECT OR NOT?I THINK STRING STRWHERECONDITION IS WRONG?

Hi,
        You need to pass from and to date to your stored procedure. And write the query like this

@StartDate and @EndDate are input parametrs of datetime for your SP

SELECT 
        col1,col2...
FROM
        table1
WHERE
        CreatedOn>=@StartDate and CreatedOn<=@EndDate

Regards,
Iftikar