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" <de***@bol.com.br> wrote in message
news:uv**************@TK2MSFTNGP12.phx.gbl...

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...

[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" <ni*****@somewhere.net> escreveu na mensagem
news:O%****************@TK2MSFTNGP12.phx.gbl...

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" <de***@bol.com.br> wrote in message
news:uv**************@TK2MSFTNGP12.phx.gbl...

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é,

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/en...sfilltopic.asp.

HTH,
Nicole
"André Almeida Maldonado" <de***@bol.com.br> wrote in message
news:Ow**************@tk2msftngp13.phx.gbl...

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

Thank's......
"Nicole Calinoiu" <ni*****@somewhere.net> escreveu na mensagem
news:O%****************@TK2MSFTNGP12.phx.gbl...

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" <de***@bol.com.br> wrote in message
news:uv**************@TK2MSFTNGP12.phx.gbl...

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...