crystal report in c#.net
-
I am developing one window application. In which I am using crystal report. I want to pass sql query to crystal report programatically from C#.net. For example: "select * foms staffmaster where id=78" So how can I create report. Thanks in advance!
-
I am developing one window application. In which I am using crystal report. I want to pass sql query to crystal report programatically from C#.net. For example: "select * foms staffmaster where id=78" So how can I create report. Thanks in advance!
retrive data in datatable and then simply pass datatable to your report paramater as myReport.SetDataSource(mydataTable);
Abdul Rahaman Hamidy Database Developer Kabul, Afghanistan
-
I am developing one window application. In which I am using crystal report. I want to pass sql query to crystal report programatically from C#.net. For example: "select * foms staffmaster where id=78" So how can I create report. Thanks in advance!
is that really what you want to do? i create the database and all the required store procedures in sql server, only then i begin to build c# application i don´t do any sql in c#, i just trigger a sql SP i want by triggering an event like button click so, i have a DataGridView to show datatable and i trigger refresh, add, delete, edit row SP procedures for exemple to make changes i have also crystal reports viewer, but here you will have to built a scheme that is a 100% match your datatable scheme in order to work, DGV doesn´t need that, it "loads" anything regardless the datadable scheme
nelsonpaixao@yahoo.com.br trying to help & get help