C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Communities   Interview   Jobs   Projects   Offshore Development    
Silverlight Tutorials | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Revenue Sharing |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...

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




How to Show all Datbases


Posted Date: 15 May 2008    Resource Type: Code Snippets    Category: C# Syntax
Author: Abhishek AryaMember Level: Diamond    
Rating: Points: 10



The following code shows how to Show all Datbases

using System.Data;
using System.Data.SqlClient;
private stringCreateConnection(string strConn)
{
String strConn = "";
String strDatabaseName ="";
using (SqlConnection sqlConn = new SqlConnection(strConn))
{
sqlConn.Open();
DataTable tblDatabases = sqlConn.GetSchema("Databases");
sqlConn.Close();

foreach (DataRow row in tblDatabases.Rows)
{
strDatabaseName = row["database_name"].ToString();
}
}
return strDatabaseName ;
}


This function will show all the databases. You need to create the connection string and pass in the function




Responses


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

Feedbacks      
Popular Tags   What are tags ?   Search Tags  
Show all Databases  .  

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: How to Read a file
Previous Resource: Change Disktop background using PInvoke
Return to Discussion Resource Index
Post New Resource
Category: C# Syntax


Post resources and earn money!
 
Related Resources



dotNet Slackers   BizTalk Adaptors    Web Design


Contact Us    Privacy Policy    Terms Of Use