friends i am using reportviewer in asp in which i show the record through stored procedure and the prooblem is that i used a textbox and a search button in textbox i insert date. i want that after the given date all record shown in report viewer here i paste my code in this code only one record shown in report but same result after every search plz help meeee...
protected void Button1_Click(object sender, EventArgs e)
{
string a=TextBox1.Text;
ReportViewer1.Visible=true;
SqlConnection thisConnection=new SqlConnection(ConfigurationManager.ConnectionStrings["base93ConnectionString"].ToString());
SqlCommand cmd=new SqlCommand("Executepasswath"), thisConnection);
cmd.Parameters.Add("@lookdate",a);
cmd.CommandType=CommandType.StoredProcedure;
DataTable dt=new DataTable();
SqlDataAdapter adp=new SqlDataAdapter(cmd);
adp.Fill(dt);
System.Data.DataSet thisDataSet=new System.Data.DataSet();
ReportDataSource datasource=new ReportDataSource("ReportDataSet1_Exctepasswatch", thisDataSet.Tables["Executepasswath"]);
ReportViewer1.LocalReport.Refresh();
ReportViewer1.DataBind();
}