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

<%
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 .

Heres an example using adodb

<%
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.