display data in a text box using the click of a Button in .aspx p

[anoop]

hello,
how can I display data from a Data source such as SQL Server in a
textbox by using the click of a Button on an .aspx page in a Visual Basic
..Net Project . If I have to use a DataSet, then how, please explain step by
step, I am new to .Net. I am using my own database in SQL Server, with all
the tables created.

Thank You

[Ken Tucker [MVP]]

Hi,

Try something like this.

Private Sub Button1_Click(B yVal sender As System.Object, ByVal e As
System.EventArg s) Handles Button1.Click

Dim cn As New SqlConnection(" server=localhos t;" & _

"Integrated Security=SSPI;I nitial Catalog=NorthWi nd")

Dim da As SqlDataAdapter

Dim ds As New DataSet

da = New SqlDataAdapter( "Select * from Customers", cn)

ds = New DataSet

da.Fill(ds)

TextBox1.Text = ds.Tables(0).Ro ws(1).Item("Cus tomerID").ToStr ing

End Sub

Ken

----------------------

"anoop" <an***@discussi ons.microsoft.c om> wrote in message
news:95******** *************** ***********@mic rosoft.com...
hello,
how can I display data from a Data source such as SQL Server in a
textbox by using the click of a Button on an .aspx page in a Visual Basic
..Net Project . If I have to use a DataSet, then how, please explain step by
step, I am new to .Net. I am using my own database in SQL Server, with all
the tables created.

Thank You