Can't Find Column

[André Almeida Maldonado]

When I use this code:

Dim dtsDataSet As DataSet = New DataSet("Dados")
Dim dttUsuarios As DataTable = dtsDataSet.Tables.Add("Usuarios")
Dim dtvUsuarios As DataView = New DataView(dtsDataSet.Tables("Usuarios"),
"", "UsuaNome", DataViewRowState.CurrentRows)

The compiler say that the column "UsuaNome" cannot be find, but it exists in
the database... Why it happens?????


Thank's...

 

[Nicole Calinoiu]

André,

You haven't actually populated the dataset or datatable in this code, so
it's no surprise that the column is not found. Have you left out some code
in your example? If so, you might want to consider using debug
functionality to get a list of the tables and columns in the dataset at the
point where the exception is raised. You will probably find that a lack of
table mappings has caused your dataset to be populated in an unexpected
manner.

HTH,
Nicole

 

[André Almeida Maldonado]

Sorry, but I never made it.... What is the error in the code? How can I
populate the dataset / datatable???

Thank's......

 

[Nicole Calinoiu]

André,

The usual manner for populating a DataSet or DataTable from a database is to
use the Fill method of a DataAdapter object. If you're not familiar with
this method, you can find documentation at the following URL:
http://msdn.microsoft.com/library/e...stemdatacommondbdataadapterclassfilltopic.asp.

HTH,
Nicole