17-03-18, 09:59 PM
ع
السلام عليكم
عندي مشكلة في كود يعرض تقرير
يظهر رسالة
الكود
ReportViewer1.Visible = true;
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Report4.rdlc");
web_ScholarshipDataSet dsscholarship = GetData("select [Name],[Gender],[Position],[Duration_of_Scholarship],[University] from TBL_ScholarshipData ");
ReportDataSource datasource = new ReportDataSource("Sholarship", dsscholarship.Tables["TBL_ScholarshipData"]);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(datasource);
///ReportDataSource rds = new ReportDataSource("Product_Detail", ds.Tables[0]);
}
public web_ScholarshipDataSet GetData(string query)
{
//SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString);
string conString = ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString;
SqlCommand cmd = new SqlCommand(query);
using (SqlConnection con = new SqlConnection(conString))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.Connection = con;
sda.SelectCommand = cmd;
using (web_ScholarshipDataSet dsscholarship = new web_ScholarshipDataSet())
{
sda.Fill(dsscholarship, "DataTable1");
return dsscholarship;
}
}
}
}
ارجو المساعدة
شكرااا
السلام عليكم
عندي مشكلة في كود يعرض تقرير
يظهر رسالة
الكود
ReportViewer1.Visible = true;
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Report4.rdlc");
web_ScholarshipDataSet dsscholarship = GetData("select [Name],[Gender],[Position],[Duration_of_Scholarship],[University] from TBL_ScholarshipData ");
ReportDataSource datasource = new ReportDataSource("Sholarship", dsscholarship.Tables["TBL_ScholarshipData"]);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(datasource);
///ReportDataSource rds = new ReportDataSource("Product_Detail", ds.Tables[0]);
}
public web_ScholarshipDataSet GetData(string query)
{
//SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString);
string conString = ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString;
SqlCommand cmd = new SqlCommand(query);
using (SqlConnection con = new SqlConnection(conString))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.Connection = con;
sda.SelectCommand = cmd;
using (web_ScholarshipDataSet dsscholarship = new web_ScholarshipDataSet())
{
sda.Fill(dsscholarship, "DataTable1");
return dsscholarship;
}
}
}
}
ارجو المساعدة
شكرااا