Answer / rahul

Dataset are two types 1.Typed dataset
2. Untyped dataset.

In typed dataset we've autocompletion and intelisense of vs.
and also data's from datset are cached in xml format.

But in untyped dataset, it just connect with the database
and it doesn't support any other features of Vs.

Answer / m_dasharatham

An "untyped" dataset is an instance of the DataSet class
from the System.Data namespace. It’s called “untyped”
because all columns are provided as the base System.Object
type (“object” in C# and “Object” in VB.NET) and must be
coerced to the appropriate type, e.g.

void Form1_Load(object sender, EventArgs e) {
DataSet ds = new DataSet();
sqlDataAdapter1.Fill(ds);
foreach( DataRow row in ds.Tables[0].Rows ) {
string fname = (string)row["au_fname"];
bool contract = (bool)row["contract"];
string item =
string.Format("{0} has a contract: {1}", fname,
contract);
listBox1.Items.Add(item);
}
}

Answer / rahul bhatnagar

Sorry for the above answer---
This is correct one...

Type Dataset
You will get type mismatch and other errors at compile time.


UnType Dataset
You will get type mismatch and other errors at runtime.

Example :

string custid;
custid=dsetcust.customer(0).customerid;


untyped dataset
string custid;
custid=Convert.toString(dsetcust.customer(0).customerid);

Answer / nidhi garg

in untyped dataset, it just connect with the database
and it doesn't support any intellisence features of Vs.

Answer / rahul bhatnagar

UnType Dataset
You will get type mismatch and other errors at compile time.


Type Dataset
You will get type mismatch and other errors at runtime.

Example :

string custid;
custid=dsetcust.customer(0).customerid;


untyped dataset
string custid;
custid=Convert.toString(dsetcust.customer(0).customerid);

if i have 1000 records and i want to access 20 ata time from SQL server, what will be the query?

9 Answers   Mind Tree,

How to sign out from forms authentication?

0 Answers  

When would you set this property to false?

2 Answers  

What is the lifespan for items stored in ViewState?

4 Answers   Siebel Systems,

What is ispostback method in asp.net? Why do we use that?

0 Answers  

Explain authorization levels in .net ?

0 Answers  

Is overloading possible in web services?

3 Answers   Microsoft,

Explain what is an abstract class?

0 Answers  

ASP.NET 2.0's new membership API used for creating and managing user account is exposed through which 2 clause?

0 Answers  

What is the importence of the INTERFACE? but not the inheritence concept?and why we r declaring the empty methods in that? we can directly implements with in the class know? Tell me the importence?

2 Answers  

what is the difference between response.write() and response.output.write()?

0 Answers  

Why is global asax is used?

0 Answers