Problem with dropdownlist and stored procecedure

I managed to pass values to the stored procedure by entering the values into the parameters collection successfully using a webform generated code below:<br><br>Me.OleDbCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("PARAM_SCHOOL_CODE", System.Data.OleDb.OleDbType.VarChar, 4000, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, "testing"))<br><br>May I know how to pass the value selected from a databound dropdownlist to the stored procedure?<br>I tried to change the web form generated code "testing" to str(a selected value from the dropdownlist but it doesn't work)<br><br>changed webform generated code:<br>Me.OleDbCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("PARAM_SCHOOL_CODE", System.Data.OleDb.OleDbType.VarChar, 4000, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, str))<br><br>VB code:<br><br>Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load<br> OleDbDataAdapter1.Fill(DataSet11)<br> DropDownList1.DataBind()<br><br> End Sub<br><br> Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click<br> Dim objReturnValue As Object<br><br> OleDbConnection1.Open()<br><br> Dim str As String<br><br> str = DropDownList1.SelectedItem.Text<br> <br> objReturnValue = OleDbCommand1.ExecuteScalar()<br> TextBox1.Text = OleDbCommand1.Parameters(0).Value.ToString()//<br> TextBox2.Text = OleDbCommand1.Parameters(1).Value.ToString()//This is my PARAM_SCHOOL_CODE <br> TextBox3.Text = OleDbCommand1.Parameters(2).Value.ToString()<br> '.Value.ToString()<br><br> OleDbCommand1 = Nothing<br> OleDbConnection1.Close()<br> OleDbConnection1 = Nothing<br> End Sub<br><br> Private Sub DropDownList1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DropDownList1.SelectedIndexChanged<br> <br><br> End Sub<br>End Class<br><br><br><br>I appreciate any help or assistance. Thank you!