How do I make a simple database connection to sql server 2005 express and how do I find out/set the database name
Simple Database connection
Hot Topic
- C# TAPI ITAddressTranslation
- Code to detect speed performance of operations.
- Preview problem
- how to change color in a text cut
- No-parameter struct constructors & hiding virtual methods
- WDS3 and Outlook2007 Beta2 German Problem
- Generics: Explicit Interface Declaration
- When does P/Invoke free a DLL from memory again ?
- Windowsform : hideframe with transparency
- datagrid view real NOOB
Visual C#
- How to connect to catelog SQL-Server Full text search
- Transferring a resource into another namespace
- updating the UI with progress bar while Business Layer in process
- delete datagridviewrow
- How to stop MDI parent background image being tile
- Programmatically select a Listview item
- Search string?
- OWC10 Pivotchart Save and retrive using C# windows forms
- FileStream and writing out in chunks
- what does this mean for the exception message?
Simple Database connection
larsbg
In the System.Data.SqlClient namespace you will find the SqlConnection class. Use the Database property to get the connected database name, here is a example:
SqlConnection dbConn = new SqlConnection("Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;");
MessageBox.Show( dbConn.Database );
Here is a good list with example: