Passing form value from a select thats being pulled from MYSQL.

See more:

ASP.NET

ADO.NET

Thanks for the help

I am trying to pass a value into SQL using ADO. My problem is im not sure what variable is being used in the select table.

Here is the form.

<form action="test.aspx" name="PF" onsubmit="javascript:return Valid2();" style="margin-left: auto; margin-right: auto;">
<div style="text-align: center;">
<select name="ID" size="12" style="margin-left: auto; margin-right: auto;">
<%
Dim objConn As New SqlConnection(Application("CS"))
Dim objCmd As New SqlCommand("SELECT DISTINCT V.ID, V.Vendor FROM Vendors V INNER JOIN ServiceEntries E ON E.VID = V.ID WHERE (V.Active = 1) AND (E.Site = '" & strSite & "') ORDER BY V.Vendor", objConn)
objConn.Open()
Dim objR As SQLDataReader=objCmd.ExecuteReader()
While objR.Read()
    Response.Write("<option value=""" & objR(0).ToString() & """>" & objR(1).ToString() & "</option>")
End While
objR.Close() : objCmd.Dispose() : objConn.Close() : objConn.Dispose()
%>
</select><br />
<input type="submit" value="Send Login Info" /></div>
</form>

And here is the way im attempting to pass it

<%
Dim strSQL = "Insert into Vendorpasswordrecovery(Vendor, IP) Values ('" & Request.Form("selectedIndex") & "', '" & Request.ServerVariables("REMOTE_ADDR") & "')"
Dim objConn As New SqlConnection(Application("CS"))
Dim objCmd As New SqlCommand(strSQL, objConn)
response.write(strSQL)
objConn.Open()
%>

Im not sure of what I need to use to pull the selection from the form to the ado string.