Need some help with asp.net and fill labels from a database.

[Morten]

Hi.

I have just began to use vb.net/ asp.net.
Now I am trying to undertand ado.net and use of it.

The datagrid it seems I got right but how do I "fill" e.g. a label.
Previous I dis label.caption= rs!something.

Now I have
Dim custNmAdapter As New OleDb.OleDbDataAdapter("SELECT Nm from myTable
where id=1")
Dim dsCustNm As DataSet = New DataSet()
custNmAdapter.Fill(dsCustNm, "Intelle_CustNm")
So if anyone please could show me how I can get data into my label I would
be fextreamly happy.
label.text=???

Thanks
Morten

[Anuradha]

Hi,

You just have to access with the the rows in the dataset.
Have a look at the Dataset class
dsCustNm.Tables["Intelle_CustNm"].Rows[0].Columns
["columnName"]

-----Original Message-----
Hi.

I have just began to use vb.net/ asp.net.
Now I am trying to undertand ado.net and use of it.

The datagrid it seems I got right but how do I "fill" e.g. a label.Previous I dis label.caption= rs!something.

Now I have
Dim custNmAdapter As New OleDb.OleDbDataAdapter("SELECT Nm from myTablewhere id=1")
Dim dsCustNm As DataSet = New DataSet()
custNmAdapter.Fill(dsCustNm, "Intelle_CustNm")
So if anyone please could show me how I can get data into my label I wouldbe fextreamly happy.
label.text=???

Thanks
Morten
.

[Morten]

Thanks.

U got me on track again.

:) Morten

"Anuradha" <an****@hotmail.com> skrev i melding
news:0b****************************@phx.gbl...

Hi,

You just have to access with the the rows in the dataset.
Have a look at the Dataset class
dsCustNm.Tables["Intelle_CustNm"].Rows[0].Columns
["columnName"]

-----Original Message-----
Hi.

I have just began to use vb.net/ asp.net.
Now I am trying to undertand ado.net and use of it.

The datagrid it seems I got right but how do I "fill"

e.g. a label.

Previous I dis label.caption= rs!something.

Now I have
Dim custNmAdapter As New OleDb.OleDbDataAdapter("SELECT

Nm from myTable

where id=1")
Dim dsCustNm As DataSet = New DataSet()
custNmAdapter.Fill(dsCustNm, "Intelle_CustNm")
So if anyone please could show me how I can get data into

my label I would

be fextreamly happy.
label.text=???

Thanks
Morten
.