Dataset Question

[jcb1269]

When I put this line in my code:

dsUser.Tables(0).TableName = "Users"
====================================

Dim da As New SqlDataAdapter("SELECT * FROM Users WHERE UserName = '" & CurrentUser & "'", conn)

dsUser = New DataSet
dsUser.Tables(0).TableName = "Users" 'Errors here..!!
da.Fill(dsUser)

conn.Close()

This errors out. It says "Can't find table".

Any Ideas?

[pclement]

I think you want something like the following:

dsUser = New DataSet
daFill(dsUser, "Users")