Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.
Under html tags I am using dropdownlist control to display all the branch names.
<%@ language="VBScript"%> <% Dim sUsername sUsername = Session("Username") If sUsername = "" Then Response.Redirect("itformslogin.asp") end if Dim rs, rs1, rs2,rs3,rs4,rs5,rs6, data_source, no, sName, sSQL, sSQL1, sSQL2, sSQL3, sSQL4,sSQL5,sSQL6 data_source = "Provider=OraOLEDB.Oracle;User ID=username;Password=password;Data Source=orcllive; Persist Security Info=False " sSQL3 = "select * from owf_mgr.branch order by 2” -- Table Branch with two columns Branch_Code and E_Branch_Name 'For Branch Set rs3 = Server.CreateObject("ADODB.Recordset") rs3.Open sSQL3 , data_source %> <html>
<td>Branch</td> <td > <% response.write "<select name='lstBranch' id='lstBranch' style='width:201px'>" response.write "<option value='Please select branch'>Please select branch</option>" while not rs3.eof response.write "<option value='" & rs3("e_branch_name")& "'>" & rs3("e_branch_name") & "</option>" rs3.movenext wend response.write "</select>" %> </html>
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|User has constant problems with Outlook and Quickbooks||8||37|
|drag and drop (but keep all) lines||11||47|
what does http://website.whatever/ro
|Changing TableLayoutPanel Locations to Specific XY Locations||7||25|
Join the community of 500,000 technology professionals and ask your questions.