how to connect database connectivity in dotNET? if suppose
SQL server?and also MS access?
- 8 Answers
- 16227 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / aravind
in code behind give namespace
using System.data.sqlclient;
and write connections string in web.config to which
database to connect
| Is This Answer Correct ? | 40 Yes | 6 No |
Answer / guest
in web.config file
<configuration>
<appSettings>
<add key="SqlCon" value="Data
Source=winserver;initial
Catalog=cieflnew;uid=cieflnew;pwd=cieflnew; Connection
Lifetime=0;Max Pool Size=10000;Min Pool Size=0;Connection
Reset=false;Pooling=true;Persist Security Info=False"/>
</appSettings>
<system.web>
and in code behind
Sql cmd= new Sql command(Query here,con);
cmd.executenonquery();
| Is This Answer Correct ? | 23 Yes | 7 No |
Answer / rajesh chekuri
MySQLConnection myConn;
myConn = new MySQLConnection(new
MySQLConnectionString("localhost", "databse", "User",
"password").AsString);
For More Info Visit www.funnydotnet.co.cc
| Is This Answer Correct ? | 15 Yes | 2 No |
Answer / raju
SQl Server
namespace->Using System .data.Sqlclient;
SqlConnectin con=new SqlConnection
("Servername="";uid="";pwd="";database="")
Ms-Access:
Namespace->using system.data.oledb;
oledbconnection con=new oledb connection
("Servername="";uid="";pwd="";database="")
| Is This Answer Correct ? | 12 Yes | 4 No |
Answer / manish
in the sql server
using system.data.sqlclient
sqlconnection con=new
sqlconnection("server=;uid=;pwd=;database=;");
con.open();
| Is This Answer Correct ? | 5 Yes | 3 No |
Answer / konda
USe system.data.oledb for connect int both sql and Ms
access and Oracle also
| Is This Answer Correct ? | 5 Yes | 4 No |
Answer / varun
in the sql server
using system.data.sqlclient
sqlconnection con=new
sqlconnection("server=;uid=;pwd=;database=;");
con.open();
Ms-Access:
Namespace->using system.data.oledb;
oledbconnection con=new oledb connection
("Servername="";uid="";pwd="";database="")
| Is This Answer Correct ? | 3 Yes | 2 No |
What is multiThreading in .NET?
What is Assembly?
What is MSIL code ?
What is Complex Class in .NET?
What are the important components of .net?
What is a formatter?
Elements of CAS
What is the difference between Dataset and DataReader? Can u breif me ADO.net classes and architecture
Tell us the differences between an interface and an abstract class in .net?
What is portable executable (PE)?
When we use windows api in .net is it managed or unmanaged code?
What are the features of dot net?
Dot Net Framework 
