what is the use of untyped data set ?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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);
| Is This Answer Correct ? | 0 Yes | 2 No |
What is the difference between ldap and active directory?
hi i have a problem regarding to datagrid in aspdotnet.i have a datagrid in my application.i have to place add,edit,delete buttons or links what ever it may be. now the problem is if i click on add button then the page has to redirected to another form called "xyz.aspx" and if i click on edit button the page has to redirected to another form called "abc.aspx".i am phasing the problem that if where ever i click on the datagrid the cursor goes to gv1_SelectedIndexChanged event.please tell me the solution about the code.
Which of the following .NET framework supports Web API?
What is the difference between custom web user control and a custom web server control?
Where would you use an ihttpmodule, and what are the limitations if any?
What is an imagemap in asp.net?
When is the ViewState available during the page processing cycle ?
How to rename a table using sql queries?
What is SQL injection?
Define resource files.
What are the 3 types of web?
How can we provide the WebParts control functionality to a server control?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)