C# Tutorials and offshore development in India

Prizes & Awards

My Profile

AdSense Revenue

Active Members
Today

Last 7 Days

more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !

Getting schema of database

Posted Date: 18 May 2008	Resource Type: Code Snippets	Category: C# Syntax
Author: shakti singh tanwar	Member Level: Diamond
Rating:	Points: 10

Place a datagridview control on your form with name = "dataGridView1".

Write this code.

OleDbConnection Conn = new OleDbConnection("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Northwind;Data Source=.");
Conn.Open();
DataTable schemaTable = nwindConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,
new object[] { null, null, null, "TABLE" });
Conn.Close();
dataGridView1.DataSource = schemaTable;//This will populate the gridview with all table names from database

Responses

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

Feedbacks

Popular Tags

What are tags ?

Search Tags

(No tags found.)

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: Creating web browser in .Net that can't be closed by Virus
	Previous Resource: Merging Different Array lists into a Single Array list
	Return to Discussion Resource Index
	Post New Resource
	Category: C# Syntax

Post resources and earn money!

Related Resources

dotNet Slackers BizTalk Adaptors Web Design