Answer Posted / d0tnetf0x

In web.config,we have to give connection to database by add
key which is given in application setting tags.as

<appsettings>
<add key="constr" value="Data Source=SQL-PC;Initial
Catalog=sampledb;User ID=sa;password=password "/>

</appsettings>

//under value we have given the database which is connected.
here under ----data source=servername
intial catalog=database name
user id=username of the database(if give)
password= password(optional)

to use this connection we use configsetting or we caneven
directly give it in sqlconnection

sqlconnection conn=new sqlconnection
(configurationsetting.appsettings("constr"))
here constr is the key we added in application settings to
identify it in web.config
[this connection we used by declearing in web.config]

with out declearation:-
sqlconnection conn=new sqlconnection("Data Source=SQL-
PC;Initial Catalog=sampledb;User ID=sa;password=password ")

better process is useing connection by declearing in
web.config

What you mean by filtering of data?

1017

---

Explain how can we load multiple tables in to dataset?

982

---

Which object needs to be closed?

2309

---

Describe connection object in ado.net

1100

---

What are datareaders?

1028

---

What are the major challenges in accessing data from a database?

1068

---

What do you mean by ‘batch updates’?

1091

---

How can you identify whether or not any changes are made to the DataSet object since it was last loaded?

1109

---

Which database is the ado.net sql connection object designed for?

1092

---

Do we use stored procedure in ADO.Net?

1059

---

What is dataset object? Explain the various objects in dataset.

1085

---

What are the steps you will take to improve performance? Will you use dataset or datareader?

1053

---

What is a datareader object?

1145

---

Explain the basic use of "dataview" and explain its methods.

1063

---

What is sqldatareader in ado.net?

971

---