| Groups | Blog | Home |
dotnet ado.net : Refreshing a referenced dataset
made changes to the XSD file and want to propegate the changes to my typed dataset. I have tried deleting the typed dataset and then adding it back, but it still has the old structure. Can someone help me with this?
Hi David,
Did you try right click on xsd file in solution explorer and select Run Custom Tool? Also, the changes are propagated when you save xsd file. If this isn't working, check what is the Custom Tool for the selected xsd file - it should be MSDataSetGenerator. -- Miha Markic [MVP C#] - RightHand .NET consulting & software development miha at rthand com www.rthand.com [quoted text, click to view] "David D. McCrory" <dmccrory@alltell.net> wrote in message news:uuuQnmN9DHA.4044@tk2msftngp13.phx.gbl... > I have a typed dataset that was created from a referenced dataset. I have > made changes to the XSD file and want to propegate the changes to my typed > dataset. I have tried deleting the typed dataset and then adding it back, > but it still has the old structure. Can someone help me with this? > >
I tried running the Custom Tool for the XSD file, which is
MSDataSetGenerator, and did not get any results...the Build Action property is set to Content. Should it be set to something else?? [quoted text, click to view] "Miha Markic [MVP C#]" <miha at rthand com> wrote in message news:%23AcJrrS9DHA.2856@TK2MSFTNGP10.phx.gbl... > Hi David, > > Did you try right click on xsd file in solution explorer and select Run > Custom Tool? > Also, the changes are propagated when you save xsd file. > If this isn't working, check what is the Custom Tool for the selected xsd > file - it should be MSDataSetGenerator. > > -- > Miha Markic [MVP C#] - RightHand .NET consulting & software development > miha at rthand com > www.rthand.com > > "David D. McCrory" <dmccrory@alltell.net> wrote in message > news:uuuQnmN9DHA.4044@tk2msftngp13.phx.gbl... > > I have a typed dataset that was created from a referenced dataset. I have > > made changes to the XSD file and want to propegate the changes to my typed > > dataset. I have tried deleting the typed dataset and then adding it back, > > but it still has the old structure. Can someone help me with this? > > > > > >
Hi David,
Set "Show All files" in solution explorer (icon in solution explorer's toolbar) so you'll be able to see the code produced. XSD leaf in solution explorer should turn into a node. Under this node should be a file with same name and extension cs (if project is c#). Check its content. Just for test, you might delete its content (not the file itself) and run custom tool again to see if it produces anything. -- Miha Markic [MVP C#] - RightHand .NET consulting & software development miha at rthand com www.rthand.com [quoted text, click to view] "David D. McCrory" <dmccrory@alltell.net> wrote in message news:%23l9cWcb9DHA.488@TK2MSFTNGP12.phx.gbl... > I tried running the Custom Tool for the XSD file, which is > MSDataSetGenerator, and did not get any results...the Build Action property > is set to Content. Should it be set to something else?? > > > "Miha Markic [MVP C#]" <miha at rthand com> wrote in message > news:%23AcJrrS9DHA.2856@TK2MSFTNGP10.phx.gbl... > > Hi David, > > > > Did you try right click on xsd file in solution explorer and select Run > > Custom Tool? > > Also, the changes are propagated when you save xsd file. > > If this isn't working, check what is the Custom Tool for the selected xsd > > file - it should be MSDataSetGenerator. > > > > -- > > Miha Markic [MVP C#] - RightHand .NET consulting & software development > > miha at rthand com > > www.rthand.com > > > > "David D. McCrory" <dmccrory@alltell.net> wrote in message > > news:uuuQnmN9DHA.4044@tk2msftngp13.phx.gbl... > > > I have a typed dataset that was created from a referenced dataset. I > have > > > made changes to the XSD file and want to propegate the changes to my > typed > > > dataset. I have tried deleting the typed dataset and then adding it > back, > > > but it still has the old structure. Can someone help me with this? > > > > > > > > > > > >
Everything looks ok in the *.cs file....the "GetUserLogin" table that is
shown below, from the dsUserData.cs file, is the one that is not showing up in the referenced DataSet....Even if I delete the DataSet and re-create it...the table below is not a part of the DataSet....could it be cached somewhere else?? protected dsUserData(SerializationInfo info, StreamingContext context) { string strSchema = ((string)(info.GetValue("XmlSchema", typeof(string)))); if ((strSchema != null)) { DataSet ds = new DataSet(); ds.ReadXmlSchema(new XmlTextReader(new System.IO.StringReader(strSchema))); if ((ds.Tables["GetUserAddress"] != null)) { this.Tables.Add(new GetUserAddressDataTable(ds.Tables["GetUserAddress"])); } if ((ds.Tables["GetUserInfo"] != null)) { this.Tables.Add(new GetUserInfoDataTable(ds.Tables["GetUserInfo"])); } if ((ds.Tables["GetUserLogin"] != null)) { <----------------This table is not in the referenced DataSet. this.Tables.Add(new GetUserLoginDataTable(ds.Tables["GetUserLogin"])); } [quoted text, click to view] "Miha Markic [MVP C#]" <miha at rthand com> wrote in message news:OyBj$Kf9DHA.2432@TK2MSFTNGP10.phx.gbl... > Hi David, > > Set "Show All files" in solution explorer (icon in solution explorer's > toolbar) so you'll be able to see the code produced. > XSD leaf in solution explorer should turn into a node. Under this node > should be a file with same name and extension cs (if project is c#). > Check its content. > Just for test, you might delete its content (not the file itself) and run > custom tool again to see if it produces anything. > > -- > Miha Markic [MVP C#] - RightHand .NET consulting & software development > miha at rthand com > www.rthand.com > > "David D. McCrory" <dmccrory@alltell.net> wrote in message > news:%23l9cWcb9DHA.488@TK2MSFTNGP12.phx.gbl... > > I tried running the Custom Tool for the XSD file, which is > > MSDataSetGenerator, and did not get any results...the Build Action > property > > is set to Content. Should it be set to something else?? > > > > > > "Miha Markic [MVP C#]" <miha at rthand com> wrote in message > > news:%23AcJrrS9DHA.2856@TK2MSFTNGP10.phx.gbl... > > > Hi David, > > > > > > Did you try right click on xsd file in solution explorer and select Run > > > Custom Tool? > > > Also, the changes are propagated when you save xsd file. > > > If this isn't working, check what is the Custom Tool for the selected > xsd > > > file - it should be MSDataSetGenerator. > > > > > > -- > > > Miha Markic [MVP C#] - RightHand .NET consulting & software development > > > miha at rthand com > > > www.rthand.com > > > > > > "David D. McCrory" <dmccrory@alltell.net> wrote in message > > > news:uuuQnmN9DHA.4044@tk2msftngp13.phx.gbl... > > > > I have a typed dataset that was created from a referenced dataset. I > > have > > > > made changes to the XSD file and want to propegate the changes to my > > typed > > > > dataset. I have tried deleting the typed dataset and then adding it > > back, > > > > but it still has the old structure. Can someone help me with this? > > > > > > > > > > > > > > > > > > > >
Thanks for the help Miha....
I finally got this resolved. I had to delete and re-install my references to the projects that contained the XSD. I don't know if this is what should happen or if the references should update automatically. I tried rebuilding the solution several times and it never worked until I deleted and re-installed the references. Any light on this subject would be appreciated. I know how to correct the issue, but I don't understand why... [quoted text, click to view] "Miha Markic [MVP C#]" <miha at rthand com> wrote in message news:OyBj$Kf9DHA.2432@TK2MSFTNGP10.phx.gbl... > Hi David, > > Set "Show All files" in solution explorer (icon in solution explorer's > toolbar) so you'll be able to see the code produced. > XSD leaf in solution explorer should turn into a node. Under this node > should be a file with same name and extension cs (if project is c#). > Check its content. > Just for test, you might delete its content (not the file itself) and run > custom tool again to see if it produces anything. > > -- > Miha Markic [MVP C#] - RightHand .NET consulting & software development > miha at rthand com > www.rthand.com > > "David D. McCrory" <dmccrory@alltell.net> wrote in message > news:%23l9cWcb9DHA.488@TK2MSFTNGP12.phx.gbl... > > I tried running the Custom Tool for the XSD file, which is > > MSDataSetGenerator, and did not get any results...the Build Action > property > > is set to Content. Should it be set to something else?? > > > > > > "Miha Markic [MVP C#]" <miha at rthand com> wrote in message > > news:%23AcJrrS9DHA.2856@TK2MSFTNGP10.phx.gbl... > > > Hi David, > > > > > > Did you try right click on xsd file in solution explorer and select Run > > > Custom Tool? > > > Also, the changes are propagated when you save xsd file. > > > If this isn't working, check what is the Custom Tool for the selected > xsd > > > file - it should be MSDataSetGenerator. > > > > > > -- > > > Miha Markic [MVP C#] - RightHand .NET consulting & software development > > > miha at rthand com > > > www.rthand.com > > > > > > "David D. McCrory" <dmccrory@alltell.net> wrote in message > > > news:uuuQnmN9DHA.4044@tk2msftngp13.phx.gbl... > > > > I have a typed dataset that was created from a referenced dataset. I > > have > > > > made changes to the XSD file and want to propegate the changes to my > > typed > > > > dataset. I have tried deleting the typed dataset and then adding it > > back, > > > > but it still has the old structure. Can someone help me with this? > > > > > > > > > > > > > > > > > > > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008
| home · blog · groups | Questions? Comments? Contact the dn |