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().

Is c# a keyword?

0 Answers  

---

Can arraylist store different data types in c#?

0 Answers  

---

Is string a class in c#?

0 Answers  

---

Which .gang of four. Design pattern is shown below?

0 Answers  

---

What is transparent caching with aop ?

0 Answers  

---

What is arraylist class in c#?

0 Answers  

---

How many bytes is an int c#?

0 Answers  

---

What is ienumerator c#?

0 Answers  

---

Classes and structs can be declared as static, is this statement true or false?

0 Answers  

---

Which types of inheritances does c# support?

0 Answers  

---

When should we use sealed class in c#?

0 Answers  

---

How does the XmlSerializer work ?

1 Answers  

---