Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Adding column to dataset .xsd file
Message
 
 
À
05/12/2013 20:25:53
Information générale
Forum:
ASP.NET
Catégorie:
ADO.NET
Versions des environnements
Environment:
VB 9.0
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01589385
Message ID:
01589403
Vues:
26
>>>>>>>>This is a newbie question. In my project I have a dataset file (MyDataSet.xsd, MyDataSet.Designer.cs, MyDataSet.cs). I need to add a couple of columns to this dataset. I double click on MyDataSet.xsd file in the VS Solution Explorer. I see the MYDATASET image with all the columns. I can right-mouse click and add a column. But how do I specify the type of the new column? In fact, I can't even figure out how to see the type of any of the existing columns.
>>>>>>>>TIA.
>>>>>>>
>>>>>>>I've never used the GUI method to alter the .xsd file.
>>>>>>>I wrote a program that creates the datatables , adds them to the dataset ds and then uses
>>>>>>>
ds.WriteXmlSchema(filename);
>>>>>>>to create the .xsd.
>>>>>>
>>>>>>Thank you. But since I already have this dataset in .xsd file there may be a way to modify it in GUI. Hopefully someone know how.
>>>>>
>>>>>Can you right click and hit properties?
>>>>
>>>>I tried but it showed me the Property for the entire dataset but not individual columns. Unless I am missing something simple.
>>>
>>>Is the dataset related to a table to which you have added the column?
>>
>>No. The dataset is related to an XML file from which the dataset is filled.
>
>OK
>I'm sorry I can't help you.
>I think you'll find that most developers who use datasets day to day don't use the GUI.

Thank you for trying to help. I suppose if I never get any suggestions on how use GUI I will have to learn to do it in code. But I see that in GUI I can easily add a column; it is just that I can't see how to specify the type. And it is maybe that the GUI-created dataset is not strongly typed. If so, I will have to live with a not strongly typed dataset.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform