Need help undestandinf the concept

[Pete Newman]

Running Vista ( business ) , SQl 2005 and VS 2005 (VB.net) I apoliguise if this is posted in the wrong forum Ok im trying to create an asp.net page that has a 'text' box on it ( no data grid ). in the vb code ( i believe its called code behind ) i have connected to a data source and created a data table - dt .. ( code below ). Ive been looking at lots of different articles and all i manage is to go in circles. Is it possible to write all the 'code behind' and just bind the data to a text box and if so using the code below how can i bind the field Licence to the text box StrLicence Alternatly would it be more productive to look at just the asp code, and if so how can i do the same with out using the Form View Any help would be most appriciated Vb code Dim Conn As SqlConnection = New SqlConnection(connectionString) Try Conn.Open() Response.Write("SQL Connection = " & Conn.State.ToString) Dim Adapter As SqlDataAdapter = New SqlDataAdapter(SelectCommand, Conn) Try Adapter.Fill(dt) Response.Write("Filled Data Table") Catch ex1 As Exception Response.Write(ex1.Message) End Try Catch ex As Exception Response.Write(ex.Message) End Try dt = Nothing Conn.Close() Conn = Nothing

I really do need help..... all this computer stuff is way over my head !!

[Paddy Boyd]

If all you need is to bind one field from the data base, then filling a datatable may be a bit too much overhead. But, with your above code, you should be able to bind your text box something like: strLicense.text = dt.Rows(0).Items(indexOfYourColumn) I think that's the syntax, don't have anything handy to check it on.

[Pete Newman]

Hi Paddy Thanks for the reply, Thats a way forward for me, tho i must admit i havent made it fully clear on what im trying to do. I onlu used one text box as an example, there will be about 20 in total with some 300 records in the table, which i need to navigate through, hence i was trying to bind to the text box to the table Thanks again, i can now see a way forwards :-D

I really do need help..... all this computer stuff is way over my head !!

[Paddy Boyd]

Buy a book, or read some articles. In all honesty, stumbling along blindly is just going to cause you all manner of problems... Doing a wee bit of proper learning and then coding what you need will probably take you about the same time as bumbling along writing buggy code.