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
- 18696 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 |
explain the states of a window service application?
Different between .net & j2ee ?
Do you know what is lambda expressions in c#?
How will you load dynamic assembly? How will create assemblies at run time?
0 Answers InfoAxon Technologies,
Why DLL files are needed. & how They are Created in DOTNET?
Name for built-in permission sets in .Net
How to Exchange data between Webservices
What is 'Common Type System' (CTS) in .NET?
As you know read-only variables and constants have many similarities, but what is at least one way that they differ?
If you are executing these statements in commandobject. Select * from table1; select * from table2? How you will deal result set? 42. How do you sort a dataset.
Explain what is the difference between encrypting a password and applying a hashing?
What are the Project related questions generaly asked in the interview. Mail to: ana_net1@yahoo.com
Dot Net Framework 
