How to get the sql query results in tabular format on webpage without using sql datasource wizard?

Question

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.