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
- 18384 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 are Sessions?
What is 3 tier architecture?
What are Generics? Where do we use them.
When developing a Windows service for .NET, which namespace do you typically look in for required classes?
Explain soap and xml?
Readonly vs. const?
Is there any attempt system for microsoft technology papers?
Why is .net used?
How would ASP and ASP.NET apps run at the same time on the same server?
How to implement datagrid in.net? How would you make a combo-box appear in one column of a datagrid? What are the ways to show data grid inside a data grid for a master details type of tables? If we write any code for datagrid methods. What is the access specifier used for that methods in the code behind file and why?
What are the contents of assembly?
Is .net front end or backend?
Dot Net Framework 
