Displaying database query data in the form of a table

Question

I am a little new to C #. I am working on a database application and I need to execute a query, say SELECT, and load it into some kind of table. Then I want to double-click on the result and load it into my original data entry form. Can someone tell me how I should follow? Do not waste time adding coding, etc. Just steps will be enough. A link to a good resource will also be OK :)

Answer 1

See SqlCommand , SqlDataAdapter, and DataTable for retrieving data from a database. Assuming an SQL server, otherwise other database providers are also available and implement the same API.

For Window Forms, look at a DataGridView , you can bind a DataTable to it and display the data in a DataTable

Here you can find an example.

Answer 2

Loot in some samples:

• Database Viewer (in sources) http://www.codeproject.com/KB/database/MyDbViewerSite.aspx
• Also see this http-support.microsoft.com/kb/308247

Future readings:

• @MSDN data access application block
• (LinqToSQL, Entity Framework, NHibernate ..)

Answer 3

http://www.java2s.com/Code/CSharp/Database-ADO.net/FillDatafromdatabasetabletoListView.htm

Answer 4

ADO.NET

: ADO.NET - , , , . .NET. Framework . API ADO.NET , .NET. Framework, Visual Basic, #, J # Visual ++.