Wednesday, March 21, 2012

DataSet .xsd use / Re-use concepts?

Hi all,

I've asked this question on another forum on the 2nd October 2006 and has gone unanswered to date.

I'd like to discuss SQL Express DataSet controls use / re-use concepts.

As I have been so busy sorting out the ins-n-outs and the dos-n-dont's of database connections n usage I haven't had a chance to focus on this issue.

Let me exagerate to make my point.

Lets say I have 10 forms.
Each has the standard DataSet, BindingSource, TableAdapter, and BindingNavigator.
Each form has the exact same general (broad scope: select * from myTable, myTable2 etc) query.

My solutions explorer has 1 Dataset .xsd for each forms query:
myDataset01.xsd
myDataset02.xsd
myDataset03.xsd
....
myDataset10.xsd

Is this how I should handle the datasets?
Keeping all dataset/querys seperate. One for each form. And possible multiples for each form?
(In case I want to adjust the number of returned fields on a specific form.)

Or is there a better way (not thru code) to have each form point to the same dataset controls?
i.e. have form2 thru form10 point to the datacontrols on form1? (doesn't sound right now that I've written it.)

Or is there a better way (not thru code) to have each form point to the same Dataset .xsd?
And should I?
i.e. reuse the one Dataset .xsd.

At the moment I'm thinking its all just text any way.
And each dataset has to be reconnected and data retrieved from the database anyway.

So does it really matter?

As I recall, I was having so many crashes when setting up the dataset .xsd that I found it was safer to have just one dataset per query.

I've ordered VS 2005 Pro and hope its more stable.

--


I've also found that if I update the SQL Express Table thru Management Studio
(and I believe thru the database explorer in the vb.net IDE) that the .xsd file gets lost.

i.e. I have to go thru and duplicate the changes.

Is there an easier way?

Thanks,
Barry G. Sumpter

Currently working with:
Visual Basic 2005 Express
SQL Server 2005 Express

Developing Windows Forms with
101 Samples for Visual Basic 2005
using the DataGridView thru code
and every development wizard I can find within vb.net
unless otherwise individually stated within a thread.

hmmm, I'm wondering if its the way I've written this query.

Or could it be I'm so off the mark that it would take too long to answer?

Can anyone out there please confirm that they:

1) Understand this query
2) Don't know the answer
3) Would also like to know the answer

|||

I've just had a quick look at another developers DataSet.

There is only one dataset.

It contains all the Tables in the database.

In the dataset designer there are additional queries at the bottom of each table.

I wonder how you access these additional queries thru code?

|||

Jeez! LOL! Now I'm rolling...

Thru the dataset designer you can right click on the table and select "Add new querie"
The wizard will step you thru then ask you to name your query and give you a starting value of "Fillby"
You need to add text to FillBy like FillByCity
Dim cityValue As String = "Seattle"

CustomersTableAdapter.FillByCity(NorthwindDataSet.Customers, cityValue)

http://msdn2.microsoft.com/en-us/library/kda44dwy(VS.80).aspx