how to connect database connectivity in dotNET? if suppose
SQL server?and also MS access?
Answer Posted / 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 |
Post New Answer View All Answers
How can I get at the win32 api from a .net program?
What is a serviced component?
How to view a .NET assembly?
Is it true that objects don't always get destroyed immediately when the last reference goes away?
What is the use com component in .net?
What is SOAP? How you will do windows and forms authentication?
Dynamic Fonts
Please explain what are an object and a class?
Why inheritance is important?
What is meant by globalization?
What is the advantage of .net?
What are data types in .NET?
What is typical about a windows process in regards to memory allocation in dot net?
Explain garbage collection?
What does .net stand for?