I have to run a simple query (say select name from table where id = 4) and get those results and make it into a report. I am not sure I have crystal reports (do I have to install some thing for this?). So what is the easiest way to create this? May in in a spread sheet or some thing like this? I am so new to SQL Server
Thanks
Possible way:
Retrieve data in DataSet|||
Hi dotnet001,
Of course you can use Crystal reports to generate that report. But since you have mentioned that you want the "easiest" way and "may in a spead sheet", I think maybe you can try the DataGrid control. You can fist connect to the database and execute the sql query string,then call the databind method of the DataGrid control to retrieve data from the query result set. After that you will have a detailed list which show all the items you get from that database.
I would like to suggest you to read something on ADO.NET and databinding. See:http://www.w3schools.com/aspnet/aspnet_databinding.asp (tutorial)
http://www.codeproject.com/aspnet/Mastering_DataBinding.asp (code example)
Hope my suggestion can help
This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.
No comments:
Post a Comment