How to fill a datagrid with data in c#.net?

[Bob Thompson]

I've tried everything and nothing works.

I'm connecting to a Microsoft Access database using the following code:

OleDbConnection conn = new OleDbConnection(
@"Provider=Microsoft.Jet.OLEDB.4.0; " + 
@"Data Source=C:\Bob\Status\Timekeeping Status Sheets\Timekeeping.mdb");
 
conn.Open();
System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter(
"select charge, description from timesheet", conn);
 
DataTable t = new DataTable();
dataGridView1.DataSource = t;

When I do this, absolutely nothing happens. I get a gray grid with no rows and no columns and NOTHING.

I've tried creating a binding source and setting its DataSource to "t", and setting the dataGridView's data source to the binding source, to no avail. Still nothing happens.

I've verified that the data table has data in it by manually populating a ListBox with the data read from the database. That part works. Getting the data in the datagrid does not work. Any clues, help or pointers would be appreciated. Thanks.

[Per Eriksson]

I'm doing the same thing right now so I might have a tip for you.
You should probably try to use a DataSet as an "intermediate" storage facility of your table data.
- Insert a new DataSet (xsd) into your project.
- You will then get a "page" where it says that you can either drag in objects from the Server Explorer or add them by hand.
- This means that you should add a table onto the page that has the same format as the one in your DB.
-Do it by hand from the toolBox or by connecting to the Db via server explorer and dragging the table into it.(The latter option creates quite a lot of system generated code but could be easier since in this code is included all the SQL-queries you might want to use.
- It is then a matter of adding a dataset into your form that contains the datagrid and let it "use" the datasetfile you've just created.
-Then binding your binding source to the dataset and the datgridview to the binding source.
- To populate the grid is then done by calling the method Fill() from the (or a) tableadapter that is associated with the DataSet table.
This reply became very long so I'm stopping here.
But I hope this can guide you in the right direction to make it work.
If you want more info make another reply and I'll try to follow up with further descriptions.
/Per

[bish1]

Include the following namespace in your code window

using System.Data.SqlClient;

Write the following code in formload event or button click event

SqlConnection con=new SqlConnection();
con.connectionString="Data Source=SqlserverName;initial catalog=databasename;user id=sqlusername;password=sqlpassword;integrated security=false";
con.open();
try
{
  SqlCommand cmd=new SqlCommand();
  cmd.connection=con;
  cmd.commandText="Select field1,field2,...field n from tablename";
SqlDataAdapter adp=new SqlDataAdapter();
adp.selectCommand=cmd;
DataSet Ds=new DataSet();
adp.fill(ds,"tempTablename");
adp.dispose();
if(ds.tables["tempTablename"].rows.count>0)
{
  GridView1.Datasource=ds.tables["tempTablename"];
}
else
{
GridView1.Datasource=ds.tables["tempTablename"];
}
}
catch(systemException ex)
{
  Messagebox.show(ex.message);
}

[Frinavale]

I am failing to see where you are calling one of the OleDbDataAdapter's Fill methods in the code you posted.

If you do not call the fill method to fill a DataSet (or table), how do you expect to get the data?

The fill method retrieves data from the database and populates an in memory DataTable.

The Fill(DataTable) method would work well in your code since you're not using a DataSet.

-Frinny

[bish1]

//object of dataadapter
SqlDataAdapter adp=new SqlDataAdapter(); 
 
// assign sqlquery to extract from database. refer previous //code for selecting data from db.
adp.selectCommand=cmd;
 
//object of dataset
DataSet Ds=new DataSet();
 
//filling dataset with records that exist in adapter
adp.fill(ds,"tempTablename");
 
//realeasing data adapter
adp.dispose();
 
//check whether inline table contain data or not
if(ds.tables["tempTablename"].rows.count>0)
{
 
// Fills data grid with records
  GridView1.Datasource=ds.tables["tempTablename"];
}