XML Data File

matt.fields · January 27th, 2004, 02:33 PM

I am using XML to store a username and password information for users. The file looks something like this.

<?xml version="1.0" encoding="utf-8" ?>
<UserData xmlns="http://tempuri.org/cqUser.xsd">
    <User ID="1">
        <branchID>1</branchID>
        <FirstName>Matt</FirstName>
        <LastName>Fields</LastName>
        <LoginID>mattf</LoginID>
        <Password>1234</Password>
    </User>
    <User ID="2">
        <branchID>1</branchID>
        <FirstName>Jeff</FirstName>
        <LastName>Reynolds</LastName>
        <LoginID>jeffr</LoginID>
        <Password>55678</Password>
    </User>
</UserData>

From a windows form, I want to log into an application and authenticate using a valid user(one of the ones above). I have tried using the dataset and can not seem to evaluate a username and password for a table. I am new to XML so it may be simplier that I imagine.

Can anyone help. Thanks

bmains · January 28th, 2004, 01:35 PM

How are you validating a user (form-based) or WindowsIdentity? What code are you using to get the information from the XML?

matt.fields · January 29th, 2004, 10:53 AM

I am using a windows form with a username and password box and login button. The code to get the data from the XML document and compare it to the username and password text box is what I am having issues with.

bmains · January 29th, 2004, 11:01 AM

Try:

Code:

dim objDataSet as new DataSet
objDataSet.ReadXML(Server.MapPath("cgUser.XML"))
'This allows you to use the find method to retrieve the user ID
objDataSet.Tables(0).PrimaryKey = new DataColumn() {objDataSet.Tables(0).Columns("LoginID")}

'try to find the row of data with the user ID
dim objRow as DataRow = objDataSet.Tables(0).Rows.Find(strUserID)
'If the XML row with the user ID exists
if (not isNothing(objRow)) then
    'If password matches
    if ( objRow("Password") = strPassWord ) then
        'Validation successful
    end if
end if

Let me know if it works.

Thanks,

Brian Mains