Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Getting the selected data value from the drop down list
Message
Information générale
Forum:
ASP.NET
Catégorie:
Formulaires Web
Divers
Thread ID:
00714584
Message ID:
00714588
Vues:
22
Cathi

Thanks, I was thinking I was going to need to use the sender or e objects in the selected_IndexChanged. The value it returns in the integer value. How do I format my SQL text to address that, if I just hard code the value into the string it works, but trying to use the variable, I get no results.
            Dim objSQLString As String
            Dim cFilter As String
            cFilter = lnSelectedFunctionType.ToString
            objSQLString = "Select * from ProgramFunctions where FunctionTypeID = '" + cFilter + " '"
            Dim objSQLCommand As New System.Data.SqlClient.SqlCommand(objSQLString, Me.SqlConnection1)
            Dim objDataReader As SqlClient.SqlDataReader
            Me.SqlConnection1.Open()

            objDataReader = objSQLCommand.ExecuteReader()
            Me.DataGrid1.DataSource = objDataReader
            Me.DataGrid1.DataBind()
            Me.SqlConnection1.Close()
Thanks for your help
Kirk
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform