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
vishvesh kasi
NA
5
0
Hi ,How to get data from object source to report viewer..
Jun 22 2010 5:12 AM
Hi,i am developing one application .In that for value in list box i m getting using object source.I need to compare these object source data to data and get the result into reportviewer ..I doing mistake some where .i m placing the code below ..pleas uggest some solution.
i have a list box and a button .i placing the button click event code here...to get data into list box i m using object source..
string thisConnectionString =
ConfigurationManager.ConnectionStrings[
"DatabaseConnectionString"].ConnectionString;
string strddl = ObjectDataSource1.ToString();
SqlConnection Con = new SqlConnection(thisConnectionString);
SqlCommand Cmd = new SqlCommand("select * from table3 where [col1] ='" + strddl + "'", Con);
SqlDataAdapter da = new SqlDataAdapter(Cmd);
System.Data.DataSet ds = new System.Data.DataSet();
da.Fill(ds);
ReportDataSource datasource = new ReportDataSource("DatabaseDataSet_table3", ds.Tables[0]);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(datasource);
if (ds.Tables[0].Rows.Count == 0)
{
// lblMessage.Text = "Sorry, no data under this category!";
}
ReportViewer1.LocalReport.Refresh();
Reply
Answers (
0
)
Socket Bind Error Win7
delays in csharp code execution