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
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.SqlC
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.SqlC
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection
Dim dbParam_role As System.Data.IDataParameter
dbParam_role.ParameterName
dbParam_role.Value = role
dbParam_role.DbType = System.Data.DbType.StringF
dbCommand.Parameters.Add(d
Dim dbParam_level As System.Data.IDataParameter
dbParam_level.ParameterNam
dbParam_level.Value = level
dbParam_level.DbType = System.Data.DbType.Int32
dbCommand.Parameters.Add(d
Dim dbParam_category As System.Data.IDataParameter
dbParam_category.Parameter
dbParam_category.Value = category
dbParam_category.DbType = System.Data.DbType.StringF
dbCommand.Parameters.Add(d
Dim dbParam_material As System.Data.IDataParameter
dbParam_material.Parameter
dbParam_material.Value = material
dbParam_material.DbType = System.Data.DbType.StringF
dbCommand.Parameters.Add(d
Dim dbParam_location As System.Data.IDataParameter
dbParam_location.Parameter
dbParam_location.Value = location
dbParam_location.DbType = System.Data.DbType.StringF
dbCommand.Parameters.Add(d
Dim dbParam_section As System.Data.IDataParameter
dbParam_section.ParameterN
dbParam_section.Value = section
dbParam_section.DbType = System.Data.DbType.StringF
dbCommand.Parameters.Add(d
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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