
26/11/2004, 15:45
|
| | Fecha de Ingreso: septiembre-2004
Mensajes: 141
Antigüedad: 20 años, 4 meses Puntos: 0 | |
Como capturo la variable ,AYUDAPORFAA como capturo la variables de estos 4 dropdown
necesito hacer un redirect o algo para que en la siguiente pagina sean capturadas las 4 variables, ayudenme porfa me falta poko de este codigo esta funcioando pero me falta hacer que pase las variables a la otra pagina
codigo:
<%@ Page Language="VB" Debug="true" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SqlClient" %>
<script runat="server">
Sub Page_Load(sender as Object, e as EventArgs)
dim fechai as String = Request.QueryString("fechai")
dim fechaf as String = Request.QueryString("fechaf")
If Not Page.IsPostBack Then
Dim myConnection As SqlConnection
Dim myConnection2 As SqlConnection
Dim myConnection3 As SqlConnection
Dim myConnection4 As SqlConnection
Dim myCommand As SqlCommand
Dim myCommand2 As SqlCommand
Dim myCommand3 As SqlCommand
Dim myCommand4 As SqlCommand
Dim myDataReader As SqlDataReader
Dim myDataReader2 As SqlDataReader
Dim myDataReader3 As SqlDataReader
Dim myDataReader4 As SqlDataReader
Dim strSQLQuery As String
Dim strSQLQuery2 As String
Dim strSQLQuery3 As String
Dim strSQLQuery4 As String
myConnection = New SqlConnection("Persist Security Info=False;User ID=docsadm;pwd=docsadm;Initial Catalog=callcenter;Data Source=TESTEDMS;Packet Size=4096;Workstation ID=ISRV_EDMS")
myConnection2 = New SqlConnection("Persist Security Info=False;User ID=docsadm;pwd=docsadm;Initial Catalog=callcenter;Data Source=TESTEDMS;Packet Size=4096;Workstation ID=ISRV_EDMS")
myConnection3 = New SqlConnection("Persist Security Info=False;User ID=docsadm;pwd=docsadm;Initial Catalog=callcenter;Data Source=TESTEDMS;Packet Size=4096;Workstation ID=ISRV_EDMS")
myConnection4 = New SqlConnection("Persist Security Info=False;User ID=docsadm;pwd=docsadm;Initial Catalog=callcenter;Data Source=TESTEDMS;Packet Size=4096;Workstation ID=ISRV_EDMS")
strSQLQuery = "SELECT system_id,docname from profile"
strSQLQuery2 = "SELECT system_id,full_name from people"
strSQLQuery3 = "SELECT system_id,type_id from documenttypes"
strSQLQuery4 = "SELECT system_id,cod_descr from estado"
myCommand = New SqlCommand(strSQLQuery, myConnection)
myConnection.Open()
myDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConne ction)
myCommand2 = New SqlCommand(strSQLQuery2, myConnection2)
myConnection2.Open()
myDataReader2 = myCommand2.ExecuteReader(CommandBehavior.CloseConn ection)
myCommand3 = New SqlCommand(strSQLQuery3, myConnection3)
myConnection3.Open()
myDataReader3 = myCommand3.ExecuteReader(CommandBehavior.CloseConn ection)
myCommand4 = New SqlCommand(strSQLQuery4, myConnection4)
myConnection4.Open()
myDataReader4 = myCommand4.ExecuteReader(CommandBehavior.CloseConn ection)
ddlNamesList.DataSource = myDataReader
ddlNamesList.DataValueField = "system_id"
ddlNamesList.DataTextField = "docname"
ddlNamesList.DataBind()
ddlNamesList2.DataSource = myDataReader2
ddlNamesList2.DataValueField = "system_id"
ddlNamesList2.DataTextField = "full_name"
ddlNamesList2.DataBind()
ddlNamesList3.DataSource = myDataReader3
ddlNamesList3.DataValueField = "system_id"
ddlNamesList3.DataTextField = "type_id"
ddlNamesList3.DataBind()
ddlNamesList4.DataSource = myDataReader4
ddlNamesList4.DataValueField = "system_id"
ddlNamesList4.DataTextField = "cod_descr"
ddlNamesList4.DataBind()
' We've got our data... now connect it to our list:
End If
End Sub
</script>
<html>
<head>
<style type="text/css">.Estilo1 {
FONT-WEIGHT: bold
}
.Estilo2 {
COLOR: #ffffff
}
.Estilo3 {
COLOR: #2a3f00
}
.Estilo4 {
COLOR: #fffbf0
}
.Estilo5 {
COLOR: #2a0000
}
.Estilo6 {
FONT-WEIGHT: bold; FONT-SIZE: 18px
}
</style>
</head>
<body>
<form runat="server">
<table width="200" border="1">
<tbody>
<tr>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
Proveedor</td>
<td>
<strong>
<asp:DropDownList id="ddlNamesList2" runat="server"></asp:DropDownList>
</strong></td>
</tr>
<tr>
<td>
Tipo</td>
<td>
<strong>
<asp:DropDownList id="ddlNamesList4" runat="server"></asp:DropDownList>
</strong></td>
</tr>
<tr>
<td>
Estado</td>
<td>
<strong>
<asp:DropDownList id="ddlNamesList" runat="server"></asp:DropDownList>
</strong></td>
</tr>
<tr>
<td>
Receptor</td>
<td>
<asp:DropDownList id="ddlNamesList3" runat="server"></asp:DropDownList>
</td>
</tr>
<tr>
<td>
</td>
<td>
</td>
</tr>
</tbody>
</table>
<p>
</p>
</form>
<p>
</p>
<p>
</p>
</body>
</html> |