Interested to Buy Any Domain ? << Click Here >> for more details...
how to connect database connectivity in dotNET? if suppose
SQL server?and also MS access?
- 8 Answers
- 18127 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 |
Is .NET a runtime service or a development platform?
Is do-it (chennai) a good institute to learn dot-net???? are the trainers well experienced??
What is assemblies in .net?
Explain the difference between vb and vb.net?
What is the difference between boxing and unboxing?
What is operator overloading in .net?
Explain what does managed mean in the .net context?
What is reflection and what is it for?
What is the use of edititem template ingridview?
1 Answers C Squared Systems, Microsoft,
What is dot net architecture?
Please explain the difference between constants and read-only variables?
What are three common acronyms used in .net, and what do they stand for?
Dot Net Framework 
