Answer / umesh shrivastava

if we are using web application
1-open web.config file
<ConnectionString>
<add name="connect" connectionstring="Data Source=
,IntialCatalog= " Username= ,Password=
;providerName="System.Data.SqlClient"
</ConnectionString>
2-write namespace at the top in .cs file System.Data.SqlClient;
2-now write this code to button click event
String
ss=ConfigurationManager.ConnectionString["connect"].ConnectionString;
Sqlconnection con=new SqlConnection(ss);
con.open();
SqlCommand cmd=new SqlCommand("select * from emp",con);
SqlDataReader r=cmd.ExecuteReader();
con.close();

Answer / gaurav

by writing the connection string on the click event of the
button. by connection string i mean it's the ado.net
structure.firstly you have to include the namespace- using
system.data.sqlclient;
now on the click event of the button( eg u have taken a
sumbit button ) you will be writting- sqlconnenection con=
new sqlconnection........then u'll use
datacommand,dataset,string,databind,gridview.
u can also use read for getting the errors in a specified
manner.for this u will be using try and the catch then your
connection string code and then u'll use the finally
function and then close().

what is the need of using interface in program ex:if we have a program like this interface1() { void method1(); void method(); } class a1 : interface1 { a1 b = new b(); b.method1(); b.method2(); } so without using interface also we can achieve this then wat is the need to use the interface? plz give me the answer

1 Answers  

---

How can we set class to be inherited, but prevent the method from being over-ridden?

0 Answers  

---

What is expression tree with example?

0 Answers  

---

What do you mean by a windows process in regards to memory allocation?

0 Answers  

---

Which compiler switch creates an xml file from xml comments in the files in an assembly?

0 Answers   Siebel,

---

code for arranging given number in possible permutation ways ex:123,321,312,132,231,213.

0 Answers  

---

How to parse a date time string?

0 Answers  

---

What is base class in c#?

0 Answers  

---

Can you inherit multiple interfaces?

3 Answers  

---

In object oriented programming, how would you describe encapsulation in c#?

0 Answers  

---

Can namespace contain the private class?

0 Answers  

---

Explain the use of SN.exe

0 Answers   Accenture,

---