Populate a datagridview with sql query results

Question

I m trying to present query results  but I keep getting a blank data grid   It s like the data itself is not visible  Here is my code    private void Employee Report Load object sender  EventArgs e          string select    SELECT   FROM tblEmployee        Connection c   new Connection         SqlDataAdapter dataAdapter   new SqlDataAdapter select  c con     c con is the connection string      SqlCommandBuilder commandBuilder   new SqlCommandBuilder dataAdapter         DataTable table   new DataTable         table Locale   System Globalization CultureInfo InvariantCulture       dataAdapter Fill table        bindingSource1 DataSource   table        dataGridView1 ReadOnly   true               dataGridView1 DataSource   bindingSource1      What s wrong with this code

User · Answer

This is suppose to be the safest and error pron query        public void Load Data                         using  SqlConnection connection   new SqlConnection DatabaseServices connectionString     use your connection string here                               var bindingSource   new BindingSource                    string fetachSlidesRecentSQL    select top  50    from dbo slides order by created date desc                   using  SqlDataAdapter dataAdapter   new SqlDataAdapter fetachSlidesRecentSQL  connection                                         try                                              SqlCommandBuilder commandBuilder   new SqlCommandBuilder dataAdapter                            DataTable table   new DataTable                            dataAdapter Fill table                           bindingSource DataSource   table                          recent slides grd view ReadOnly   true                          recent slides grd view DataSource   bindingSource                                            catch  SqlException ex                                               MessageBox Show ex Message ToString     ERROR Loading                                              finally                                               connection Close

User · Answer

String strConnection   Properties Settings Default BooksConnectionString  SqlConnection con   new SqlConnection strConnection    SqlCommand sqlCmd   new SqlCommand    sqlCmd Connection   con  sqlCmd CommandType   CommandType Text  sqlCmd CommandText    Select   from titles   SqlDataAdapter sqlDataAdap   new SqlDataAdapter sqlCmd    DataTable dtRecord   new DataTable    sqlDataAdap Fill dtRecord   dataGridView1 DataSource   dtRecord

User · Answer

You may try this sample  and always check your Connection String  you can use this example with or with out bindingsource you can load the data to datagridview   private void Employee Report Load object sender  EventArgs e            var table   new DataTable             var connection    ConnectionString            using  var con   new SqlConnection   ConnectionString   connection                          using  var command   new SqlCommand   Connection   con                                   if  con State    ConnectionState Open                                        con Close                                       con Open                     try                                       command CommandText     SELECT   FROM tblEmployee                       table Load command ExecuteReader                          bindingSource1 DataSource   table                       dataGridView1 ReadOnly   true                      dataGridView1 DataSource   bindingSource1                                     catch SqlException ex                                        MessageBox Show ex Message     sql query error

User · Answer

you have to add the property Tables to the DataGridView Data Source   dataGridView1 DataSource   table Tables 0

User · Answer

Years late but here s the simplest for others in case  String connectionString     quot Data Source LOCALHOST Initial Catalog DB Integrated Security true quot    SqlConnection cnn   new SqlConnection connectionString   SqlDataAdapter sda   new SqlDataAdapter  quot SELECT   FROM tblEmployee  quot   cnn    DataTable data   new DataTable    sda Fill data    DataGridView1 DataSource   data   Using DataSet is not necessary and DataTable should be good enough  SQLCommandBuilder is unnecessary either

User · Answer

You don t need bindingSource1  Just set dataGridView1 DataSource   table

User · Answer

You may get a blank data grid if you set the data Source to a Dataset that you added to the  form but is not being used  Set this to None if you are programatically setting your dataSource based on the above codes

User · Answer

Try binding your DataGridView to the DefaultView of the DataTable   dataGridView1 DataSource   table DefaultView

User · Answer

if you are using mysql this code you can use   string con    SERVER localhost  user id root  password   database databasename       private void loaddata     MySqlConnection connect   new MySqlConnection con   connect Open    try   MySqlCommand cmd   connect CreateCommand    cmd CommandText    SELECT   FROM DATA1   MySqlDataAdapter da   new MySqlDataAdapter cmd   DataTable dt   new DataTable    da Fill dt   datagrid DataSource   dt    catch Exception ex    MessageBox Show ex Message

User · Answer

Here s your code fixed up  Next forget bindingsource   var select    SELECT   FROM tblEmployee    var c   new SqlConnection yourConnectionString      Your Connection String here  var dataAdapter   new SqlDataAdapter select  c      var commandBuilder   new SqlCommandBuilder dataAdapter    var ds   new DataSet     dataAdapter Fill ds    dataGridView1 ReadOnly   true    dataGridView1 DataSource   ds Tables 0

[c#] Populate a datagridview with sql query results

Examples related to c#

Examples related to winforms

Examples related to datagridview