One last hope

[Pete Newman]

VS2005 (vb) and SQL2005 :sigh: ok im nearly beaten here... think its lack of sleep I need a very very kind person to help me out as im totally losing the will to live Ok i have an Default.aspx page with a textbox ( ID TXT1 ) and a Button. what i want to do, what ive been trying to do is when the button is clicked, it basicly does a a "Select count(*) from Table1.dbo.users where name = '" & TXT1.text & "'" and display the return value ok to some its simple stuff but i have to start somewhere :^), so please can you explain it in laymans terms thank you

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

[nlarson11]

Pete, let's start slow... 1) are you able to establish a database connection from your webpage?

[Pete Newman]

Hi, Thanks for the reply. this is all new to me and im struggling like mad. Just for background, Im trying to create an Intra-net project... as a tester. I have my web.config file which has the connection string to the SQL server, and im presuming that if the connection string was incorrect there would be an error. as below The only conponents i have added are the textbox and Button section of web.config thanks :)

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

[Pete Newman]

grrr sorry this is what was meant to be added I really do need help..... all this computer stuff is way over my head !!

[Pete Newman]

nlarson11 I got an email from the site, but no message on the forum :^) . From the email tho yes i know the connection string is correct. If its easier you can mail me direct ?

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

[nlarson11]

look at your webpage. double click on the button that will add code for the click event of your button inside the click event-connect to the database. run your select statement returning a dataset(ds) using either a helper or an adapter textbox1.text = ds.tables(0).rows(0)(0) -- modified at 10:58 Tuesday 24th October, 2006