Como capturo la variable ,AYUDAPORFAA

carlostapia · #1 (**permalink**) 26/11/2004, 15:45

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>

splinter · #2 (**permalink**) 26/11/2004, 16:04

Seria algo como este ejemplo para obtener las variables del url:

'En el load del formulario
dim var1 as string
var1 = request.params("varList1")

carlostapia · #3 (**permalink**) 28/11/2004, 08:49

cumpa porfa mira de esta forma se capturan las variables
mira te peudo pedir un ultmo favor mira este ejemplo y dime si las variables de estos dropdown se capturan igual porfa

http://www.aspnet101.com/aspnet101/a...day-Month-year

mira de este en el que yo uso ame la funciona para que hubieran 2 ossea fecha DESe y fecha HASTA

con esta tecnica de

REQUEST.PaRAMS("variable")

se podran recuperar porfasss

SPLINTER DAME ESA ULIMA AYUDITA YA ESTOY TERMINANDO EL PROYECTO PORFA, ME QUEDA ESO NOMAS Y YA NO MOLESTOMAS, CREEME QUE BUSCO SOLUCIONES PR TODOS LADOS LEO CALETA PERO ME FALTA ARTO
ME PEUDES AYUDAR CON ESTO PORFA
YA QUE SI SE CAPTURAN IGUAL SERIA FENOMENAL Y TENDRIA CASI TERMINADO EL PROBLEMA YO CREO QUE ESTO ADEMAS LE SERVIRIA A VARIAS PERSONAS MAS PORFAS AYUDENME

carlostapia · #4 (**permalink**) 29/11/2004, 07:10

funko compadreee bakan

Sub doSubmit(Source as Object, E as EventArgs)

dim fechai as String = Request.QueryString("fechai")
dim fechaf as String = Request.QueryString("fechaf")

dim var1 as string
var1 = request.params("ddlNamesList")
dim var2 as string
var2 = request.params("ddlNamesList2")
dim var3 as string
var3 = request.params("ddlNamesList3")
dim var4 as string
var4 = request.params("ddlNamesList4")

fechaiaux.text=fechai
fechafaux.text=fechaf

Response.Redirect("detalle_all.aspx?estado=" & var1 & "&tipo=" & var2 & "&proveedor=" & var3 & "&receptor=" & var4 & "&fechai=" & fechai & "&fechaf=" & fechaf &" ")

End Sub