what is the use of untyped data set ?

Categories >> Software >> Microsoft Related >> ASP.NET
Suggest New Category

Question Posted / darisi.nag

5 Answers
13105 Views
TCS, Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the use of untyped data set ?..

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.

Is This Answer Correct ?

3 Yes

2 No

what is the use of untyped data set ?..

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);
}
}

Is This Answer Correct ?

3 Yes

3 No

what is the use of untyped data set ?..

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);

Is This Answer Correct ?

1 Yes

1 No

what is the use of untyped data set ?..

Answer / nidhi garg

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

Is This Answer Correct ?

0 Yes

1 No

what is the use of untyped data set ?..

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);