dataset and datatable in vb.net
can someone clarify the difference between Dataset and DataTable?
thanks
thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Because I have seen some codes like this one, I hope I am correct.
sqldataAdpater.fill(datase
I have also seen :
SqldataAdapter.fill(datase
if you notice 2 different ways.
sqldataAdpater.fill(datase
I have also seen :
SqldataAdapter.fill(datase
if you notice 2 different ways.
>>SqldataAdapter.fill(data
Adds or refreshes rows in the DataSet to match those in the data source using the DataSet name, and creates a DataTable named "Table".
>>sqldataAdpater.fill(data
Adds or refreshes rows in a DataTable to match those in the data source using the DataTable name.
Adds or refreshes rows in the DataSet to match those in the data source using the DataSet name, and creates a DataTable named "Table".
>>sqldataAdpater.fill(data
Adds or refreshes rows in a DataTable to match those in the data source using the DataTable name.
ASKER
I am raising the points to 400 pts
emoreau : Can you please rephrase your statement into an example please?
emoreau : Can you please rephrase your statement into an example please?
>>SqldataAdapter.fill(data
The dataset named dataset1 is filled with a datatable named "Table" containing the result of the query SqlDataAdapter.
this is the regulare syntax.
>>sqldataAdpater.fill(data
a specific datatable is filled in the dataset.
The dataset named dataset1 is filled with a datatable named "Table" containing the result of the query SqlDataAdapter.
this is the regulare syntax.
>>sqldataAdpater.fill(data
a specific datatable is filled in the dataset.
have you read the help file on these 2 syntax? do you have any particular problem?
ASKER
Let me see if I understood the difference
<<<sqldataAdpater.fill(dat
You use this statement above to fill dataset1 with a specific datatable named datatable1. Correct?
SqldataAdapter.fill(datase
You use this statement above to fill dataset1 with a any datatable used in the SqlDataAdapter(s) it could be one or more . Correct?
<<<sqldataAdpater.fill(dat
You use this statement above to fill dataset1 with a specific datatable named datatable1. Correct?
SqldataAdapter.fill(datase
You use this statement above to fill dataset1 with a any datatable used in the SqlDataAdapter(s) it could be one or more . Correct?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
A DataSet is an in-memory representation of one or multiple DataTables, relations, and constraints. (Applied ADO.NET)
a DataTable contains the result of a SELECT query.
A DataSet contains DataTables, DataRelations.
Cheers!