How to retrieve data from sql server db to form controls?

Rasha Farouk

Peace upon u all
I wanna know how to retrieve data from db and pass it to form controls.

iam_clint

Heres an example using adodb

Expand|Select|Wrap|Line Numbers

 
<%

Dim strCon

Dim strSQL

Dim rs

Dim dbHost, dbName, dbUsername, dbPassword

dbHost="Localhost"

dbName="Test"

dbUsername="Test"

dbPassword="Test"

strCon="Provider=SQLOLEDB;SERVER=" &  dbHost & ";DATABASE=" & dbName & ";UID=" & dbUsername & ";PWD=" & dbPassword

set cn = server.CreateObject("adodb.connection")

set rs = server.CreateObject("adodb.recordset")

cn.Open strCon
 
strSQL="select * from whatever"

rs.open strSQL, cn, 1, 1

if not rs.eof then

%>

<input type="text" name="whatever" value="<%=rs("whatever")%>">

<%

end if

rs.close

cn.close

set rs = nothing

set cn = nothing

%>

Rasha Farouk

Thanks for help but I work with asp.net .

Quote:

Originally Posted by iam_clint

Heres an example using adodb

Expand|Select|Wrap|Line Numbers

 
<%

Dim strCon

Dim strSQL

Dim rs

Dim dbHost, dbName, dbUsername, dbPassword

dbHost="Localhost"

dbName="Test"

dbUsername="Test"

dbPassword="Test"

strCon="Provider=SQLOLEDB;SERVER=" &  dbHost & ";DATABASE=" & dbName & ";UID=" & dbUsername & ";PWD=" & dbPassword

set cn = server.CreateObject("adodb.connection")

set rs = server.CreateObject("adodb.recordset")

cn.Open strCon
 
strSQL="select * from whatever"

rs.open strSQL, cn, 1, 1

if not rs.eof then

%>

<input type="text" name="whatever" value="<%=rs("whatever")%>">

<%

end if

rs.close

cn.close

set rs = nothing

set cn = nothing

%>

iam_clint

Moved your thread to the .net section

Frinavale

Hey!

Please take a look at your other thread. I gave a whole bunch of links pointing you in the right direction there and was waiting for you to tell me more about what you've tried and what problems you're facing.

Please do Not double post your questions in the future.

How to retrieve data from sql server db to form controls?

re: How to retrieve data from sql server db to form controls?

re: How to retrieve data from sql server db to form controls?

re: How to retrieve data from sql server db to form controls?

re: How to retrieve data from sql server db to form controls?

Similar .NET Framework bytes

/bytes/development

/bytes/it

/bytes/about