Link to home
Start Free TrialLog in
Avatar of tnapolitano
tnapolitano

asked on

insert dropdownlist value into database on button click


I have a page with 3 ddl's and 3 textboxes. I want to insert the dropdownlist values and information entered into the textboxes into a database on button click.

When I launch the page I get: BC30311: Value of type 'System.Web.UI.WebControls.DropDownList' cannot be converted to 'String'

Here's my insert code:

'Insert


    Function putMaterial(ByVal role As String, ByVal level As Integer, ByVal category As String, ByVal material As String, ByVal location As String, ByVal section As String) As Integer
        Dim connectionString As String = "server='(local)'; trusted_connection=true; database='Deputization'"
        Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionString)

        Dim queryString As String = "INSERT INTO [dp_material] ([Role], [Level], [Category], [Material], [Location], ["& _
"Section]) VALUES (@Role, @Level, @Category, @Material, @Location, @Section)"
        Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand
        dbCommand.CommandText = queryString
        dbCommand.Connection = dbConnection

        Dim dbParam_role As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
        dbParam_role.ParameterName = "@Role"
        dbParam_role.Value = role
        dbParam_role.DbType = System.Data.DbType.StringFixedLength
        dbCommand.Parameters.Add(dbParam_role)
        Dim dbParam_level As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
        dbParam_level.ParameterName = "@Level"
        dbParam_level.Value = level
        dbParam_level.DbType = System.Data.DbType.Int32
        dbCommand.Parameters.Add(dbParam_level)
        Dim dbParam_category As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
        dbParam_category.ParameterName = "@Category"
        dbParam_category.Value = category
        dbParam_category.DbType = System.Data.DbType.StringFixedLength
        dbCommand.Parameters.Add(dbParam_category)
        Dim dbParam_material As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
        dbParam_material.ParameterName = "@Material"
        dbParam_material.Value = material
        dbParam_material.DbType = System.Data.DbType.StringFixedLength
        dbCommand.Parameters.Add(dbParam_material)
        Dim dbParam_location As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
        dbParam_location.ParameterName = "@Location"
        dbParam_location.Value = location
        dbParam_location.DbType = System.Data.DbType.StringFixedLength
        dbCommand.Parameters.Add(dbParam_location)
        Dim dbParam_section As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
        dbParam_section.ParameterName = "@Section"
        dbParam_section.Value = section
        dbParam_section.DbType = System.Data.DbType.StringFixedLength
        dbCommand.Parameters.Add(dbParam_section)

        Dim rowsAffected As Integer = 0
        dbConnection.Open
        Try
            rowsAffected = dbCommand.ExecuteNonQuery

        Finally
            dbConnection.Close
        End Try

        Return rowsAffected
    End Function






Sub Button1_Click(sender As Object, e As EventArgs)

putMaterial(ddlRole, ddlLevel, ddlCategory, txtboxMaterial.Text, txtboxLocation.Text, txtboxSection.Text)




End Sub
Avatar of tnapolitano
tnapolitano

ASKER

Answered it myself.

To determine the selected value in the DropDownList you would use the SelectedItem property or SelectedValue.

row.item( "edName" ) = ddlUser.SelectedValue
row.item( "edName" ) = ddlUser.SelectedItem.Value;
ASKER CERTIFIED SOLUTION
Avatar of EE_AutoDeleter
EE_AutoDeleter

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial