Loading

how to get the Data Source Value in Connection string dynamically using asp.net with c#

charan sekhar

16y5.2k.NET

hi iam using sql server 2000 , with asp.net2.0 with c#

in my client machine how to read the Data Source value from client system
user id , password ,database name is same for all clients but how to get Data Source value in connection string .
can you give example which helps me

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

bala murugan16y ago
else..
used through webconfic file ..
1.open the webconfic file and select the connection string location

2.create like



3.using name space   Using System.Configuration;

4.after coding place
    string strcon = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

0
bala murugan16y ago
hi ..
first you declare the namespace

Using System.Data.sqlclient;
Using System.Data;

after you used like..

" SqlConnection con = new SqlConnection("Data Source=server2;Initial Catalog=Test;User ID=testuser;Password=User###");"

how to select datasource is( the server explorer open and create one database after the right click the database and select the properties and copy the connectionstring values from property toolbar)

thanks
balas

0