How to get the sql query results in tabular format on webpage without using sql datasource wizard?
Hi All,
I am using: Visual Studio 2005, SQL Server 2000, C# .net
I am using windows authentication.
I have a form which has 2 textboxes which gets start date and end date from the user. Based on start/end date my 1st query runs. Now if user does not enter any start/end date I want to run another query which takes default dates from database(which is in varchar:ex. now()/now()-180), and it puts all the results on the webpage.
I know how to write a select query for this scenario. I am able to execute the query as well and get the required results. But, the results are not in tabular format. It just dumps the results all together.
I think I can not use the SqlDataSource wizard as it only refers to one SQL (I have a dynamic sql that takes start/end dates based on user inputs -OR- default inputs).
Or I dont know how to refer to multiple SQL using SqlDataSource generated using Data Source Wizard.
I am trying to get this done for days now. Can someone please help here? Please let me know if you need the source code that I have written so far.