Display SQL query results in Windows Form

[hobbsieoz]

Hi im executing a sql command from my C# windows form. Its a count command : SELECT [COLUMN NAME], COUNT(*) FROM [DATABASE] GROUP BY [COLUMN]. 2 Columns load from the results, the column name, and the number of records (count). How can i display these results in a C# windows form? Datagrid, large textbox? Please help me on this.

[Vasudevan Deepak Kumar]

hobbsieoz wrote:

Datagrid

Did you check out http://www.albahari.com/queryexpress.html[^]? This is a free open-source Windows Forms SQL Query Tool and it can help out a lot in Windows forms and SQL plays.

Vasudevan Deepak Kumar Personal Homepage Tech Gossips

[hobbsieoz]

This seems very long winded, is there another way.

[Abhijit Jana]

You can easily displyed it with in DataGrid. Just connect with database Create DataAdapter (SqlDataAdapter da=new SqlDataAdapter(Command,Connection)) Create a Dataset (e.g Dataset Ds=new DataSet()) Fill DataSet With DataAdpter (e.g Da.Fill(ds)) And DataGrid1.DataSource=Ds Hope This will help :cool:

Happy Programming ----------------- Abhijit Jana Noida, India

[hobbsieoz]

I have tried this method, but did not display my count number results

[Abhijit Jana]

why not ?:doh: What error r u getting :confused:

Best Regards ----------------- Abhijit Jana View My CodeProject Articles "Success is Journey it's not a destination"

[J4amieC]

You may need to Alias the count column to make it easier to identify in the resulting dataset... something like SELECT foo, **COUNT(*) AS countOfFoos** FROM fooTable GROUP BY foo

--- How to get answers to your questions[^]