SqlConnection con = new SqlConnection(“Conneection String”);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText=”Procedure Name”;
cmd.Parameters.AddWithValue(“@param1″, value);
cmd.Parameters.AddWithValue(“@param2″,value);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds, “tab1″);
ds.Tables[0].TableName = “specialreport1″; //This will be Dataset[.Xsd] name
ReportDocument crystalReport = new ReportDocument();
crystalReport.Load(Server.MapPath(“~“) + “\\reports\\rptSpecialReport.rpt”);
crystalReport.SetDatabaseLogon(“USERNAME”,”PASSWORD”,
@”SERIP”,“DBASE”);
crystalReport.SetDataSource(ds);
CrystalReportViewer1.ReportSource = crystalReport;
Posted by kamalraaja