View a DBF file in DataGridView using C#

[dshakya]

Hi all,

I am trying to use datagridview to view a dbf file. It is a single dbf file and is not a part of any database. How do I do this in Visual Studio 2005 using C#.

Could you help me my providing me with a code to use for this purpose?

Your help in this matter is highly appreciated.

Thanking you in advance.

Regards,
Deepak

[it577net]

using System.Data.OleDb; 
        private void ImportDBF_Load(object sender, EventArgs e) 
        { 
            if (ofdDBF.ShowDialog()==DialogResult.OK) 
            { 
                string connStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + ofdDBF.FileName.Substring(0, ofdDBF.FileName.LastIndexOf("\\")) + ";Extended Properties=dBASE IV;"; 
 
                OleDbConnection conn = new OleDbConnection(connStr); 
                conn.Open(); 
 
                string cmd_string = "select * from " + ofdDBF.SafeFileName.Substring(0, ofdDBF.SafeFileName.IndexOf(".")); 
                MessageBox.Show(cmd_string); 
                OleDbDataAdapter da = new OleDbDataAdapter(cmd_string, conn); 
                DataSet ds = new DataSet(); 
                da.Fill(ds); 
                dgvImport.DataSource = ds.Tables[0]; 
 
            } 
 
        }

I hope it's useful .

[Frinavale]

The code above retrieves the data from the DBF file and loads it into memory...then it uses this as the data source for the DataGridView's.

For more information on how to use a database in your programs please see how to use a database in your program. Also, take a look at how to use a database in your program part II for more information on how to connect to databases that are not MSSql.