Click here to Skip to main content
15,920,111 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: how t send usper 100 request to a crystal report for tesing report performance Pin
V.11-May-14 20:42
professionalV.11-May-14 20:42 
Questionhow to bind data from database to option in classic ASP Pin
Ye Htut7-May-14 18:06
Ye Htut7-May-14 18:06 
Show me sample code to bind data to option value in Classic ASP.
Now, I use manual method to add items in select-option.



<title>



Boook ID

Book Name

Author Name

Ye Htut
Thaw Tar Swe
Shwe U Daung
Tar Yar Min Wai




<%
Dim conn
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=SQLOLEDB; Data Source = (local); Initial Catalog = Test; User Id = sa; Password=as"


Dim MyRs 'As ADODB.Recordset
Set MyRs = Server.CreateObject("ADODB.Recordset")
MyRs.CursorLocation = 3 'adUseClient

Dim Id, name,sql
Id = request.QueryString("id")
name = request.QueryString("name")
authorname = request.QueryString("author")

if name<>"" Then
sql="Insert into book(bid,bname,aid) VALUES ('"& Id &"','" & name &"', ' " & authorname & "')"
conn.Execute(sql)
conn.close
set sql = Nothing
else
response.write("Enter Name")
End if
%>



Thz
AnswerRe: how to bind data from database to option in classic ASP Pin
Peter Leow7-May-14 18:42
professionalPeter Leow7-May-14 18:42 
Questionhow to make dropdownlist select manually inserted value Pin
Nico Haegens7-May-14 0:55
professionalNico Haegens7-May-14 0:55 
AnswerRe: how to make dropdownlist select manually inserted value Pin
Shameel7-May-14 1:23
professionalShameel7-May-14 1:23 
AnswerRe: how to make dropdownlist select manually inserted value Pin
Nico Haegens7-May-14 1:38
professionalNico Haegens7-May-14 1:38 
QuestionControl to be focused on postback Pin
Kandepu Rajesh5-May-14 22:47
Kandepu Rajesh5-May-14 22:47 
AnswerRe: Control to be focused on postback Pin
Tom Marvolo Riddle6-May-14 0:04
professionalTom Marvolo Riddle6-May-14 0:04 
GeneralRe: Control to be focused on postback Pin
Kandepu Rajesh6-May-14 0:12
Kandepu Rajesh6-May-14 0:12 
GeneralRe: Control to be focused on postback Pin
Tom Marvolo Riddle6-May-14 0:54
professionalTom Marvolo Riddle6-May-14 0:54 
AnswerRe: Control to be focused on postback Pin
jkirkerx8-May-14 12:09
professionaljkirkerx8-May-14 12:09 
QuestionSwitching from PHP to ASP.NET Pin
Daniel Lieberwirth (BrainInBlack)4-May-14 22:38
professionalDaniel Lieberwirth (BrainInBlack)4-May-14 22:38 
AnswerRe: Switching from PHP to ASP.NET Pin
Peter Leow4-May-14 23:16
professionalPeter Leow4-May-14 23:16 
GeneralRe: Switching from PHP to ASP.NET Pin
Daniel Lieberwirth (BrainInBlack)4-May-14 23:25
professionalDaniel Lieberwirth (BrainInBlack)4-May-14 23:25 
AnswerRe: Switching from PHP to ASP.NET Pin
thatraja4-May-14 23:19
professionalthatraja4-May-14 23:19 
GeneralRe: Switching from PHP to ASP.NET Pin
Daniel Lieberwirth (BrainInBlack)4-May-14 23:29
professionalDaniel Lieberwirth (BrainInBlack)4-May-14 23:29 
GeneralRe: Switching from PHP to ASP.NET Pin
thatraja4-May-14 23:31
professionalthatraja4-May-14 23:31 
GeneralRe: Switching from PHP to ASP.NET Pin
Daniel Lieberwirth (BrainInBlack)4-May-14 23:36
professionalDaniel Lieberwirth (BrainInBlack)4-May-14 23:36 
GeneralRe: Switching from PHP to ASP.NET Pin
jkirkerx8-May-14 12:21
professionaljkirkerx8-May-14 12:21 
Generalinsert data to DB with MS SQL using Classic ASP Pin
Ye Htut4-May-14 19:15
Ye Htut4-May-14 19:15 
GeneralRe: insert data to DB with MS SQL using Classic ASP Pin
Schatak4-May-14 20:27
professionalSchatak4-May-14 20:27 
GeneralRe: insert data to DB with MS SQL using Classic ASP Pin
Ye Htut4-May-14 20:51
Ye Htut4-May-14 20:51 
GeneralRe: insert data to DB with MS SQL using Classic ASP Pin
Schatak4-May-14 20:58
professionalSchatak4-May-14 20:58 
GeneralRe: insert data to DB with MS SQL using Classic ASP Pin
Ye Htut5-May-14 3:11
Ye Htut5-May-14 3:11 
GeneralRe: insert data to DB with MS SQL using Classic ASP Pin
thatraja5-May-14 4:29
professionalthatraja5-May-14 4:29 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.