Hi, please help me with this annoying error "Input string was not in a correct format"
here is my code:
Private Sub SaveData()
Dim cnn As New Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings("smfConnectionString").ConnectionString)
Dim sda As New SqlDataAdapter("Compete_Query", cnn)
Dim cmd As SqlCommand
sda.SelectCommand.CommandType = CommandType.StoredProcedure
sda.SelectCommand.Parameters.Add(New SqlParameter("@CLID", SqlDbType.Int))
sda.SelectCommand.Parameters("@CLID").Value = Trim(Request.QueryString("CLID").ToString)
Dim strSQL As String
Dim CollegePoints As Object = (txtCandidateGPA.Text / txtUnivGPA.Text) * 4
Dim AdvancedPoints As Object = ddlAdvanced.SelectedValue.ToString
Dim BasicPoints As Object = ddlBasic.SelectedValue.ToString
strSQL = ...
Go to the complete details ...