TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
vinayak kulkarni
NA
20
92.8k
programatically pass the connection string to the ssrs reports
Oct 20 2010 4:08 AM
hi... to all
i've created ssrs reports local following is my code..
public void source(string tbname,string Rptname)
{
ReportViewer1.Visible = true;
string myQuery = "select * from " + tbname;
SqlConnection myConnection = new SqlConnection(ConnectionString);
SqlCommand myCommand = new SqlCommand(myQuery, myConnection);
myCommand.Connection.Open();
SqlDataAdapter da = new SqlDataAdapter(myCommand);
DataSet dt = new DataSet();
da.Fill(dt);
//ReportParameter[] p = new ReportParameter[1];
//p[1] = new ReportParameter("@p_dno", "5");
//this.ReportViewer1.LocalReport.SetParameters(p);
//DataSet dt = new DataSet();
//dt = p;
ReportViewer1.LocalReport.ReportPath = Rptname + ".rdlc" ;
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
ReportDataSource datasource = new ReportDataSource("employeeDataSet_" + tbname , dt.Tables[0]);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(datasource);
}
now it works good..
as i expected...
but i want to pass the datasource connection string from here is there any
way to pass the datasource programatically....
Reply
Answers (
1
)
Generate dynamic image based on If Condtion
differences between ssrs reports and crystal reports