ASP .NET Tutorial: Fetching the names of the tables from Microsoft Access Database

jawahar
11/13/2005 5:20:49 PM, Views: 1630

The following code can be used to get the names of the tables from MS Access Database.

DataTable dt = con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
string tableName = dt.Rows[0][dt.Columns[2].ColumnName].ToString();
com = new OleDbCommand("Select * from [" + tableName + "]", con );

the above code gets the tables names and perform select on the first table

Next Steps:

Add this Tutorial to:
	Blink	Del.icio.us	Digg
	Fark	Furl	Google
	Reddit	Simpy	Spurl
	Technorati	Win Live	Yahoo

Rate Me!

Avg Visitor Rating: Average Visitor Rating is 2.5 out of 5

Number of Ratings : 3 Votes

Send Message

Signup / Login To View the Solution or Provide Comments

Post Comment/Solution

Comment:*
	(Link Rules)
	Use : [bold] for <b>; [/bold] for </b>; [italic] for <i>; [/italic] for </i>; [code] & [/code] for code