How put a Dataset in a Datagridview

  • Thread starter Thread starter Freddy Coal
  • Start date Start date
F

Freddy Coal

Hi, I'm newbye in that theme. I would like put the data of a dBase in a
DataGridView, why make that?.

I'm open my database with this instructions:
'----------------
Dim Tabla As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=" _
& Folder & ";Extended Properties=dBASE IV")
Tabla.Open()
Folder = Path.GetFileNameWithoutExtension(ruta) 'Name of the file

Dim Comando As New OleDbCommand("Select * From " & Folder, Tabla) 'Select
all values in the dBase
Dim da1 As New OleDbDataAdapter(Comando)
Dim DataSet As New Data.DataSet

da1.Fill(DataSet) 'I put all the info in the dataset.

Tabla.Close()
'----------------

Now I need put all that data in a Datagridview, and I don´t find an example
about how make that; My datagridview is clear, don't have any columns, I
would like add diferent dBase and make columns and rows for each database.

Thanks in advance for any help.

Freddy Coal
 
Hi, I'm newbye in that theme. I would like put the data of a dBase in a
DataGridView, why make that?.

I'm open my database with this instructions:
'----------------
Dim Tabla As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=" _
& Folder & ";Extended Properties=dBASE IV")
Tabla.Open()
Folder = Path.GetFileNameWithoutExtension(ruta) 'Name of the file

Dim Comando As New OleDbCommand("Select * From " & Folder, Tabla) 'Select
all values in the dBase
Dim da1 As New OleDbDataAdapter(Comando)
Dim DataSet As New Data.DataSet

da1.Fill(DataSet) 'I put all the info in the dataset.

Tabla.Close()
'----------------

Now I need put all that data in a Datagridview, and I don´t find an example
about how make that; My datagridview is clear, don't have any columns, I
would like add diferent dBase and make columns and rows for each database.

Thanks in advance for any help.

Freddy Coal
Click to expand...

MyDataGridView.DataSource = DataSet.Tables("TheTableToDisplay")
 
Thanks Tom, that is the instruction, now I have another problem, how I can
open files with others characters like ñíó, space...etc?

I try to open a database in the next path:

C:\Documents and Settings\fcorredor.Company\My Documents\Visual Studio
2005\@Reservorio\Carto\Estaciones_font_point.dbf

And in the line: da1.Fill(Dataset)

I get the next error:

'-------
System.Data.OleDb.OleDbException: '' is not a valid name. Make sure that it
does not include invalid characters or punctuation and that it is not too
long.
at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS
dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior,
Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior
behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
at
System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior
behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
'-------

Or when I try open dBase with special characters I get:

'-------
"System.Data.OleDb.OleDbException: Syntax error in FROM clause.
at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS
dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior,
Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior
behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
at
System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior
behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
'-------

I'm using this command for open the dBase file:

Dim Tabla As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=" _
& Folder & ";Extended Properties=dBASE IV")

Thanks in advance for your help.

Freddy Coal


Hi, I'm newbye in that theme. I would like put the data of a dBase in a
DataGridView, why make that?.

I'm open my database with this instructions:
'----------------
Dim Tabla As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=" _
& Folder & ";Extended Properties=dBASE IV")
Tabla.Open()
Folder = Path.GetFileNameWithoutExtension(ruta) 'Name of the file

Dim Comando As New OleDbCommand("Select * From " & Folder, Tabla) 'Select
all values in the dBase
Dim da1 As New OleDbDataAdapter(Comando)
Dim DataSet As New Data.DataSet

da1.Fill(DataSet) 'I put all the info in the dataset.

Tabla.Close()
'----------------

Now I need put all that data in a Datagridview, and I don´t find an
example
about how make that; My datagridview is clear, don't have any columns, I
would like add diferent dBase and make columns and rows for each database.

Thanks in advance for any help.

Freddy Coal
Click to expand...

MyDataGridView.DataSource = DataSet.Tables("TheTableToDisplay")
 
Freddy Coal said:
Thanks Tom, that is the instruction, now I have another problem, how I can
open files with others characters like ñíó, space...etc?

I try to open a database in the next path:

C:\Documents and Settings\fcorredor.Company\My Documents\Visual Studio
2005\@Reservorio\Carto\Estaciones_font_point.dbf

And in the line: da1.Fill(Dataset)

I get the next error:

'-------
System.Data.OleDb.OleDbException: '' is not a valid name. Make sure that
it does not include invalid characters or punctuation and that it is not
too long.
Click to expand...

"." is a punctuation character.

"@" is a special character and may be invalid.

Move the file to a folder with a name that is less complicated.
 
Back
Top