display data from data base when onchange in drow down

i have html page and two drop down when i change value in service drop down the value changed in anothed drop down

Expand|Select|Wrap|Line Numbers

 <!DOCTYPE HTML>
 
<html>

<head>
 
    <title>Gestion Des Non-Conformité</title>

    <link rel="stylesheet" href="css/style.css"/>

   <!-- <script type="text/javascript" src="chemindiv.js">

</script>-->

     <script type="text/javascript" src="JScript_1.11.js"></script>    

     <script type="text/javascript" src="Copie (2) de jvc.js"></script>
 
<style type="text/css">

   h3{font-family: Calibri; font-size: 22pt; font-style: normal; font-weight: bold; color:SlateBlue;

text-align: center; text-decoration: underline }
 
table{font-family: Calibri; color:white; font-size: 11pt; font-style: normal;

 background-color: #4c8f97; border: 5px solid #1c2137}
 
table.inner{border: 0px}

</style>
 
<script type="text/javascript" src="jquery-1.7.2.min.js"></script>
 
<script>

    function Submitt(){

        document.getElementById("allserivce").submit();

    }

</script>
 
<!-- <script type="text/javascript">
 
     $.get('Copie de selectemployee_par_service.asp', function (data) {

         $('#allserivce').html(data);

     });
 
</script>-->
 
</head>
 
<body >

    <div id="body">
 
                 <h3>identification de non-conformite</h3>
 
<form action="Employee.asp" method="POST">
 
<table align="center" cellpadding = "10" >
 
<!----- N dossie ---------------------------------------------------------->

<tr>

<td>N Dossier</td>

<td><input type="text" name="First_Name" maxlength="30" id="autree" onclick="check();" />

</td>

</tr>
 
 <!----- test ---------------------------------------------------------->

 <tr>
 
<td>Service </td>

<td><select  onchange="this.form.submit();Loaddd('Employee.asp','nservicee');" name="comboser" id="allserivce">
 
</select></td>

</tr>
 
<!----- choix service ---------------------------------------------------------->
 
<tr>

  <td>Choix</td> 

  <td><select id="nservicee">
 
  </select></td>   

</tr>
 
<!----- nature ---------------------------------------------------------->

<tr>

<td>Nature</td>

<td><input type="text" name="Last_Name" maxlength="30"/>

</td>

</tr>

 <!-----delai---------------------------------------------------------->

<tr>

<td>Delai</td>

<td><input type="text" name="Email_Id" maxlength="100" /></td>

</tr>

<!----- Processus-------------------------------------------------------->

<tr>

<td>Processus</td>

<td>

<select name="Birthday_day" id="Birthday_Day">

<option value="1">Processus 1</option>

<option value="2">Processus 2</option>

<option value="3">Processus 3</option>

<option value="4">Processus 4</option>

</select>

 </td>

 </tr>

 <!----- Activite-------------------------------------------------------->

 <tr>

 <td>Activite</td>
 
 <td>

<select id="Birthday_Month" name="Birthday_Month">

<option value="October">Activite 1</option>

<option value="November">Activite 2</option>

<option value="December">Activite 3</option>

</select>

 </td>

 </tr>

 <!----- AC et AP-------------------------------------------------------->

 <tr>

 <td>AC et AP</td>
 
 <td>

<select name="Birthday_Year" id="Birthday_Year">

<option value="oui">Oui</option>

<option value="non">non</option>

</select>

</td>

</tr>
 
 <tr>

<td colspan="2" align="center">

<input type="button" value="Submit"/>

<input type="reset" value="Reset"/>

</td>

</tr>
 
</table>
 
</form>

    </div>
 
</body>

</html>
 
asp page 
 
 <%@ LANGUAGE="VBSCRIPT" %>

<!-- #include file="Connect.inc" -->
 
 <%
 
                strconnexion = connectionstr

                Dim Connection

                Dim Recordse

                Dim Recordse1

                Dim Recordse2

                Dim sql

                Dim sql1

                Dim sql2

                Dim serrr

                serrr="CT"
 
                sql1= "SELECT * FROM Servicee where Libelle_service='"& Request.Form("comboser") &"'"

                Set Connection = Server.CreateObject("ADODB.Connection")

                Set Recordse1 = Server.CreateObject("ADODB.Recordset")
 
                Connection.Open strconnexion

                Recordse1.Open sql1,Connection
 
                if Recordse1("ID_service") = 2 then 
 
                       sql="select * from Employee where Employee.ID_service="& Recordse1("ID_service") &" and ID_profile=2 "               

                       Set Recordse = Server.CreateObject("ADODB.Recordset")

                       Recordse.Open sql,Connection

                       Response.Write("<select>")

                           If Recordse1.EOF Then

                                Response.Write("<option>Aucune Employee</option>")

                          else

                                  Do While NOT Recordse.Eof 

                                  Response.Write("<option>"& Recordse("Nom_emp")+" "+ Recordse("Prenom_emp") &"</option>")

                                  Recordse.MoveNext

                                  loop

                         end If

                         Response.Write("</select>")

             '   else
 
              '      sql2 = "select * from Employee where ID_service ="& Recordse1("ID_service") &""

               '     Recordse2.Open sql2,Connection

                '         If Recordse2.EOF Then

                 '              Response.Write("<option>Aucune Employee</option>")

                  '       else

                   '            Do While NOT Recordse2.Eof 
 
                    '           Response.Write("<option>"& Recordse2("Nom_emp")& "</option>")
 
                     '          Recordse2.MoveNext

                      '         loop

                       ' end If

                 end If
 
                Recordse.Close

                Set Recordse=nothing

                Recordse1.Close

                Set Recordse1=nothing

                Connection.Close

                Set Connection=nothing
 
              %>

Apr 22 '14 #1

Subscribe Post Reply

1251

by: serge calderara | last post by:

Dear all, I need to display in my application incoming data from an external source which is pooled every 2 seconds. Thos data actually are displaye in a listbox control, but the problem I...

.NET Framework

Cannot display Chinese data from database

by: Jason Chan | last post by:

Some chinese characters data (in Big5 encoding) is stored in database. I tried to display the data in an aspx but the characters cannot display correctly. I tried anything I think is related: -...

ASP.NET

Display XML Data From SQL Database Column

by: teknowledgy | last post by:

My SQL database has four tables. A couple of the columns in these tables use the xml data type which receive data from custom asp.net 2.0 user controls. Now I am trying to display the data from my...

XML

Display XML data from a RS dataset

by: mviz | last post by:

I have a RS dataset that contains XML data, but when this data is displayed on the browser it shows as a string. I need help to display this data as a formatted XML document in browser. I have...

.NET Framework

How to find control value binding control (Drow down list) ?

by: umeshdchaudhari | last post by:

fist I filled value of drow down and GridView control. Now we find the databound of grid view control as per drow down value at time binding. ? How we find the value of control time of binding in...

.NET Framework

Display form details based on populated drop down menu

by: giandeo | last post by:

Hello all, It's almost a couple of weeks since i am struggling to get this code work. Unfortunately, i am stuck. There seems to be no hope... Please Help....... I am working with an asp page...

ASP / Active Server Pages

What control would you use to display unbound data?

by: Mel | last post by:

I want to display custom data in some sort of control on a web page. By custom data I mean it's not in a database yet it just resides in a List Box on a different tab . I just want to display the...

ASP.NET

How to display the table values when select drop down list?

by: matamala Naresh | last post by:

in the table 3 fields are available (id,name,dept) iam creating drop down list with names.when user selects name in the drop down we need to auto pop up the department(dept) of that selected name in...

Perl

display the data in rich-text box in tree format

by: hrushikeshd | last post by:

I want to display my data in rich-text box in the tree like structure,i fetch the data from the data base MSACCESS & i want to print it on my rich-textbox, what can i do ? exampale is :-A ...

C# / C Sharp

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

display data from data base when onchange in drow down

Similar topics