Click here to Skip to main content
15,895,192 members
Search within:


connection string for visual studio inner database?
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
C#
Visual-Studio
connection string for visual studio inner database?
Posted
Add a Solution
Comments
Shafeequl 29-Jun-13 2:37am    
inner db???
OriginalGriff 29-Jun-13 2:37am    
This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind.
Use the "Improve question" widget to edit your question and provide better information.
jaideepsinh 29-Jun-13 3:19am    
Inner database means local server data base or you use in bult sql in visual studio.

4 solutions

You can add connection string in app.config file of your project
C#
<add name="WindowsFormsApplication1.Properties.Settings.INSPEConnectionString">
            connectionString="Data Source=ServerName;Initial Catalog=DataBaseName;User ID=;Password=" providerName="System.Data.SqlClient" /></add>
..
 
Share this answer
 
Posted
XML
<add name="ConnString" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=DataBaseName;Integrated Security=True" providerName="System.Data.SqlClient"/>


hope it will help...
 
Share this answer
 
Posted
Updated 30-Jun-13 19:58pm
v2
XML
<add name="ConnectionStringName" connectionstring="Data Source=.\sqlexpress;Initial Catalog=DBName;Integrated Security=True">


ConnectionStringName= This is the Name of Connectionstring
connectionString = Here you have to give the SQLServer Path. (.\ represents local server)
Initial Catalog: You have to specify the DB name to be connected here
 
Share this answer
 
Posted
Updated 30-Jun-13 20:43pm
v2
If you want to give connectionstring from inner database..It is very simple.
You can only drag and drop any table from your database into your webform.Connectionstring automatically added into web.comfig file. After that you can change name of connectionstring from web.config if you want....

hope it will be help you..............
 
Share this answer
 
Posted
Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
Connecting to a Oracle database using Visual studio
Connecting to database using visual studio
Visual studio connect to mysql database error
Write connection string for access database without designating a folder
Sql connection with authentication and visual studio 2019
Adding users from visual studio 2017 windows forms to SQL server management studio
Unable to find mysql for visual studio
INNER JOIN implementation
Upgrading a VB.net Windows application from Visual Studio 2003 to VS 2005
web application query for connection to database in Visual studio 2010

Advertise
Privacy
Cookies
Terms of Use
Last Updated 1 Jul 2013
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web01 2.8:2024-04-02:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900