XML DataSet question/problem

  • Thread starter Thread starter Jeff Petter
  • Start date Start date
J

Jeff Petter

I must admit, this is all new to me, so this may seem a bit remedial, but I'm having a tough time finding helpful documentation dealing with my problem.

I'm writing a small group calendar to display members exceptions to being in office. The first page is a login page, and following a successful login, the user name is written to an xml file followed by a redirect to an exception entry page. What I'm trying to do on the page load event is to open up two datasets; one to file containing the list of users who have logged on and another to one containing user information, so that I can populate the proper info for the logged on user. So, in essence what I'm trying to do is analogous to a .MoveLast in a recordset object (a piece of cake in visual C) to read the username of the user who just logged on. I've agonized over documentation on XmlNavigation objects, and other Xml objects, but can't find anything that explains how to navigate to a specific record, which in this case would be the last record.

If anyone can help me out or point me in the right direction, I sure would appreciate it.

Thanks,
Jeff
 
DataSets have one one more tables in them. Each table has a Rows and columns Collection. You can relate two tables even from different dataSets via the columns and the DataRelation Object. Also, you can base a DataView on a Datatable which gives you the ability to Filter and sort easily.

If your Username field is a Primary Key, then you can Select on it and if you have a datarelation, thereby pull in the parent and child information.

If you have Datasets, I'd recommend against navigating XML. Just use XML to serialize and deserialize them.

Google on "DataRelation" , "BindingContext", "BindingManagerBase" and I think you'll find all you need.

HTH,

Bill
I must admit, this is all new to me, so this may seem a bit remedial, but I'm having a tough time finding helpful documentation dealing with my problem.

I'm writing a small group calendar to display members exceptions to being in office. The first page is a login page, and following a successful login, the user name is written to an xml file followed by a redirect to an exception entry page. What I'm trying to do on the page load event is to open up two datasets; one to file containing the list of users who have logged on and another to one containing user information, so that I can populate the proper info for the logged on user. So, in essence what I'm trying to do is analogous to a .MoveLast in a recordset object (a piece of cake in visual C) to read the username of the user who just logged on. I've agonized over documentation on XmlNavigation objects, and other Xml objects, but can't find anything that explains how to navigate to a specific record, which in this case would be the last record.

If anyone can help me out or point me in the right direction, I sure would appreciate it.

Thanks,
Jeff
 
Bill,

That definitely helped.

Thanks,
Jeff
DataSets have one one more tables in them. Each table has a Rows and columns Collection. You can relate two tables even from different dataSets via the columns and the DataRelation Object. Also, you can base a DataView on a Datatable which gives you the ability to Filter and sort easily.

If your Username field is a Primary Key, then you can Select on it and if you have a datarelation, thereby pull in the parent and child information.

If you have Datasets, I'd recommend against navigating XML. Just use XML to serialize and deserialize them.

Google on "DataRelation" , "BindingContext", "BindingManagerBase" and I think you'll find all you need.

HTH,

Bill
I must admit, this is all new to me, so this may seem a bit remedial, but I'm having a tough time finding helpful documentation dealing with my problem.

I'm writing a small group calendar to display members exceptions to being in office. The first page is a login page, and following a successful login, the user name is written to an xml file followed by a redirect to an exception entry page. What I'm trying to do on the page load event is to open up two datasets; one to file containing the list of users who have logged on and another to one containing user information, so that I can populate the proper info for the logged on user. So, in essence what I'm trying to do is analogous to a .MoveLast in a recordset object (a piece of cake in visual C) to read the username of the user who just logged on. I've agonized over documentation on XmlNavigation objects, and other Xml objects, but can't find anything that explains how to navigate to a specific record, which in this case would be the last record.

If anyone can help me out or point me in the right direction, I sure would appreciate it.

Thanks,
Jeff
 
Back
Top