-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: BalajiKrishnan
Message 5 in Discussion
Hi Pooran Prasad.. I have done the changes but still I am not getting the data in the
report But when i bind the dataset to a datagrid i am getting the values.. I think
there is some problem in the code.(while binding to the crystal reports) Can you check
it out
SqlDataAdapter adapter = new SqlDataAdapter();
DataSet test = new DataSet("EFTTable");
SqlConnection conn = new SqlConnection("server=server;User
ID=sa;Password=sa;database=McoDev;Connection Reset=FALSE");
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandText = "GetChecksByCheckNumber";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@CHECKNUMBER", SqlDbType.Char);
command.Parameters["@CHECKNUMBER"].Value = "00007020";
adapter.SelectCommand = command;
adapter.Fill(test,"EFTTable");
string filename="C:\\MySchema.xsd";
test.WriteXmlSchema(filename);
FCRV cr= new FCRV(); // FCRV is the name of the report file...
cr.SetDataSource(test.Tables["EFTTable"]);
CrystalReportViewer1.ReportSource = cr; // CrystalReportViewer1 is the Crystal
Report Viewer - ID Also is this process correct when designing the
report............. Field Explorer - Database Fields - Right Click and choose
Add/Remove Database - More Data Sources - ADO.NET XML and Choose the MySchema.XML
file. And then i drag and drop the fields in the report. Thanks Balaji
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
