Answer Posted / vasudha.g.n

DataReader
Datareader is like a forward only recordset. It fetches one
row at a time so very less Network Cost compare to DataSet
(Fetches all the rows at a time). DataReader is readonly so
we cannot do any transaction on them. DataReader will be
the best choice where we need to show the data to the user
which requires no transaction ie reports. Due to DataReader
is forward only we cannot fetch the data randomly. .NET
Dataproviders optimizes the datareaders to handle the huge
amount of data.

DataSet
DataSet is always a bulky object that requires lot of
memory space compare to DataReader. We can say the dataset
as a small database coz it stores the schema and data in
the application memory area. DataSet fetches all data from
the datasource at a time to its memory area. So we can
traverse through the object to get required data like
qureying database.

What is the difference between vb 6 and vb.net?

1163

---

What do you mean by serialization and deserialization?

972

---

What are the advantages of VB.NET?

1073

---

Explain what observations between vb.net and vc#.net?

1016

---

What are the different types of applications supported in .net (or) .net framework?

988

---

Explain managed code?

988

---

what is intermediate language?

1088

---

Explain jit?

1182

---

thak you Mr Govind for replying to my question. My next question is that how to retrieve image stored in an SQL server table and assign it to any image control or picture control using VB.net

2158

---

What are jagged arrays ?

1119

---

What is the source code for display the picture in button click event?

1195

---

Explain nested classes?

1023

---

Define naming convention?

1058

---

i am attending to US consulate i kept my projects on vb.net ,please help me what questions will be ask on vb.net in us consulate

2391

---

What is strong name in .net assembly?

1029

---