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
What data providers available in .net to connect to database?
What is .net3.0 and .net3.5?
How to customize the trace output?
Describe the compilation process for .net code?
Tell us what do the following acronyms in .net stand for: il, cil, msil, cli and jit?
What is the use of immutability?
How do you turn off cookies for one page in your site? Give an example.
Is there any attempt system for microsoft technology papers?
What is .net technology?
What is your observations between vb.net and vc#.net?
What is the purpose of IClonable interface in .NET?
Can you create instance of a class which has private constructor?
What operating systems does the .net framework run on?
How do I use the thread pool?
Name the classes that are introduced in the system.numerics namespace.