sofia_khan 0 Newbie Poster

hi,
i have a stored procedure named as'usp_rp_era_rejected_claims_detail'.

ALTER PROCEDURE [dbo].[usp_rp_era_rejected_claims_detail] 
( 
@S_Nos varchar (max)=null, 
@Practice_Code varchar(500)=null, 
@Date_From varchar(10)=null, 
@Date_To varchar(10)=null, 
@Date_Type char(1)=null, --'E' for Entry Date , 'C' Check Date 
@Report_Type char(1)=null --'U' unresolved, 'R' resolved 
) 
AS 
BEGIN 

DECLARE @SQL Nvarchar(4000);

I have an form in asp.net.The form has a dropdown for Practice_Code,2 txtboxes for Date_From,Date_To respectively and radio buttons for Date_Type and Report_Type.When i click the Refresh button,the data should b shown in a grid.
i m using 3 layered architecture.In bussiness layer i have used the following code:

public void GetClaims(string strSno,string strPracticecode,string strDatefrom,string strDateto,string strDatetype,string strReporttype)
{
DbAccess helper = new DbAccess();
using (var db = helper.getDBContext())
{
var GetClaims = (from Claims in db.usp_rp_era_rejected_claims_detail(strSno,strPracticecode,strDatefrom,strDateto,Convert.ToChar(strDatetype),Convert.ToChar(strReporttype)) select Claims);


}
}

and in event handler,i have used the following coding:

protected void btnRefresh_Click(object sender, EventArgs e)
{

var Claims = objRejectedandResolvedClaims.GetClaims(null,ddlPractice.SelectedValue.ToString(),txtFrom.Text,txtTo.Text,rdoCheckdate.Text.ToString(),rdoResolved.Text.ToString()).ToList();


if (Claims.ToString().Length > 0)
{

gvDetail.DataSource = null;
gvDetail.DataSource = Claims;
gvDetail.DataBind();
}
}

But errors are there.Plz help me.Its urgent....
Regards....