datasource - ASP.NET Database options -


apparently no 1 connects visual web dev express databases because can't find helpful on google.

  1. do need connect datasource project, login control/etc work? if not, how else?
  2. what (free!) databases can use data source in visual web dev express?
  3. how connect them?

my question little short have go, in advance.

the answer here using web.config set sql database connection string?

thats need!

update

a little example: first add reference system.configuration project imports in code (using system.configuration).

dataset ds = new dataset(); //create dataset string connectionstring = configurationmanager.connectionstrings["yourconnectionstringname"].connectionstring; //connectionstring web.config sqlconnection con = new sqlconnection(); //create new sqlconnection con.connectionstring = conectionstring; //connect using connectionstring sqldataadapter da = new sqldataadapter("your sql query goes here", con); //get data da.fill(ds); //fill dataset (in case) con.close(); //close connection 

Comments