Connect to Excel as data source

Posted Date: 16 Nov 2008	Resource Type: Code Snippets	Category: C# Syntax
Author: MASNSN	Member Level: Gold
Rating:	Points: 10

Add a button named btnConnect and a datagridview to your project, then add an ODBC dsn Start>Configuration panel>Administration tools> ODBC icon

private void btnConnect_Click(object sender, EventArgs e)

{

OdbcConnection oConn = new OdbcConnection();

//Put your DSN Name that you have already added in the ODBC sources
oConn.ConnectionString = "Dsn=DsnName";

OdbcCommand oComm = new OdbcCommand();

oComm.Connection = oConn;

oComm.CommandText = "Select * From [Feuil1$A1:C3]";

try

{

DataSet ds = new DataSet();

OdbcDataAdapter oAdapter = new OdbcDataAdapter(oComm);

oConn.Open();

oAdapter.Fill(ds);

dataGridView1.DataSource = ds;

dataGridView1.DataMember = ds.Tables[0].TableName;

label1.Text = "Connection established successfully!!!";

}

catch (IOException caught) { MessageBox.Show(caught.Message); }

catch (OdbcException caught) { MessageBox.Show(caught.Message); }

finally

{

oConn.Close();

}
}

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

Excel ODBC connection .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Get values from a database to datagrid
	Previous Resource: Encrypt decrypt data within your configuration file
	Return to Discussion Resource Index
	Post New Resource
	Category: C# Syntax

Post resources and earn money!

Related Resources