[Resolved] Add DataRow to DataTable...

[Redth]

Hello, i'm trying to pass back a DataTable through a function..

i've created my datatable no problems, setup all my columns, but now i'm trying to add a row to the datatable.. it's not going so smooth...

here's the code i'm attempting...

'Create our datatable column structure
            dtblAccount.Columns.Add("ID", GetType(Integer))
            dtblAccount.Columns.Add("UserName", GetType(String))
            dtblAccount.Columns.Add("UserPass", GetType(String))
            dtblAccount.Columns.Add("Email", GetType(String))
            dtblAccount.Columns.Add("FirstName", GetType(String))
            dtblAccount.Columns.Add("LastName", GetType(String))
            dtblAccount.Columns.Add("BusinessName", GetType(String))
            dtblAccount.Columns.Add("BusinessDesc", GetType(String))
            dtblAccount.Columns.Add("Phone", GetType(String))
            dtblAccount.Columns.Add("Fax", GetType(String))
            dtblAccount.Columns.Add("Address", GetType(String))
            dtblAccount.Columns.Add("City", GetType(String))
            dtblAccount.Columns.Add("State", GetType(String))
            dtblAccount.Columns.Add("ZipCode", GetType(String))
            dtblAccount.Columns.Add("Country", GetType(String))
            dtblAccount.Columns.Add("ValidationCode", GetType(String))
            dtblAccount.Columns.Add("Validated", GetType(Integer))
            dtblAccount.Columns.Add("WebsiteURL", GetType(String))
            dtblAccount.Columns.Add("DateRegistered", GetType(DateTime))
 
            'Create a DataRow, filled with the proper column contents
        
    dRow("ID") = objDS("ID") & ""
            dRow("UserName") = objDS("UserName") & ""
            dRow("UserPass") = objDS("UserPass") & ""
            dRow("Email") = objDS("Email") & ""
            dRow("FirstName") = objDS("FirstName") & ""
            dRow("LastName") = objDS("LastName") & ""
            dRow("BusinessName") = objDS("BusinessName") & ""
            dRow("BusinessDesc") = objDS("BusinessDesc") & ""
            dRow("Phone") = objDS("Phone") & ""
            dRow("Fax") = objDS("Fax") & ""
            dRow("Address") = objDS("Address") & ""
            dRow("City") = objDS("City") & ""
            dRow("State") = objDS("State") & ""
            dRow("ZipCode") = objDS("ZipCode") & ""
            dRow("Country") = objDS("Country") & ""
            dRow("ValidationCode") = objDS("ValidationCode") & ""
            dRow("Validated") = objDS("Validated") & ""
            dRow("WebsiteURL") = objDS("WebsiteURL") & ""
            dRow("DateRegistered") = objDS("DateRegistered") & ""
 
            'Add drow, the row we just created, to the datatable
            dtblAccount.Rows.Add(dRow)

Now, obviously that doesn't work...

why? because how does dRow (which is declared as a DataRow) know what column structure to follow? it doesn't...

dtblAccount is declared as a DataTable btw...

how can i go about this? thanks for the help!

[Edneeis]

After you add the columns you need to use the NewRow method to get a new row with the tables structure.

dim dtRow as datarow=dtblAccount.NewRow

[Redth]

heh, thanks again...

so simple