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
Can a dll be changed to an exe?
What is the reason of occurring overflow-underflow arithmetic exception error, it shows error message when we run our program by adding control?
How to produce an assembly?
What is the difference between imperative and interrogative code?
What does jit do?
How do we access crystal reports in .net?
Explain what is the difference between constants and read-only variables?
How to load a user control dynamically in runtime?
Explain what does managed mean in the .net context?
Does .net supports destructors concept?
Example from .net. Integer & struct are value types or reference types in .net?
What is the difference between server.transfer and response.redirect? Why?
Types of evidence in .net with context to CAS
Explain .net framework overview?
What does il do?