c# display table from sql server on winform

Question

I am connecting to sql server using c#. How do I display the results of the below query on a winform? I would like to display this data set in a control. I believe it should be a datachart, but it does not matter to me.

// Initialize a connection string    
string myConnectionString = "Provider=SQLOLEDB;Data Source=hermes;" +
   "Initial Catalog=qcvaluestest;Integrated Security=SSPI;";

// Define the database query    
string mySelectQuery = "select top 500 name, finalconc " + 
   "from qvalues where rowid between 0 and 25000";

What is the best way to display the results of this query on a winform?

BFree · Accepted Answer · 2010-11-03 15:49:45Z

6

Drop a DataGridView on your form, and use this code to populate it

using(var connection = new SqlConnection(myConnectionString))
using(var adapter = new SqlDataAdapter(mySelectQuery, connection))
{
   var table = new DataTable();
   adapter.Fill(table);
   this.dataGridView.DataSource = table;
}

answered Nov 3, 2010 at 15:49

BFree

104k21 gold badges164 silver badges205 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Alex Gordon Over a year ago

which namespace should i be importing in order to u sqldataadpter

Kogitsune Over a year ago

SqlClient is the namespace you would want to import.

Collectives™ on Stack Overflow

c# display table from sql server on winform

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related