المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : Crystal report binding



C# Programming
05-06-2009, 06:01 PM
Hi.....
I have combobox which gives table list.After selecting table from same then crystal report view must show table data.
I got problem with crystal report binding.I am using C#.net and in my code i m using "dataset1 Ds" which retrieve all values but cant show that data into crystalreport viewer.
kindly find my code below......

private void cmb_type_SelectedIndexChanged(object sender, EventArgs e)
{


if (Convert.ToInt32(cmb_type.SelectedIndex) == -1 && (Convert.ToString(cmb_type.SelectedValue) == "System.Data.DataRowView"))
{
return;
}
CrystalReport1 objRpt;
objRpt = new CrystalReport1();


String ConnStr = "Data Source=SHREE\\SQLEXPRESS;Initial Catalog=NandKumar;Integrated Security=True";

SqlConnection myConnection = new SqlConnection(ConnStr);

string Query1 = "Select * from " + cmb_type.Text ;

SqlDataAdapter adapter = new SqlDataAdapter(Query1, ConnStr);
DataSet1 Ds = new DataSet1();
adapter.Fill(Ds,"C"); // " + cmb_type.Text + "

if (Ds.Tables[0].Rows.Count == 0)
{
MessageBox.Show("No data Found", "Project Tracker Suite");
return;
}
// Upto this my code run- ok,i got problem from here...



objRpt.SetDataSource(Ds.Tables["C"].DefaultView);
CrystalDecisions.CrystalReports.Engine.TextObject root;
root = (CrystalDecisions.CrystalReports.Engine.TextObject)objRpt.ReportDefinition.ReportObjects["txtHeader"];
root.Text = "Sample Report With Parameter!!";
crystalReportViewer1.Visible = true;
crystalReportViewer1.ReportSource = objRpt;

}
}