将数据从下拉列表插入数据库 [英] Insert Data from Dropdownlist into Database

问题描述

大家好。



请帮帮我。我有一个页面包含一个下拉列表和一个html文本编辑器。我需要将两个字段中的数据插入到我的数据库。但是，只有html编辑成功。下拉列表中的值还没有工作。



这是我的代码;

Hi All.

Please help me.I have one page contain one dropdownlist and one html text editor.I need to insert the data from both field into my database.But,only html editor success.The value from dropdownlist not working yet.

This is my code;

Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click


        Dim sqlConnection1 As New SqlConnection(ConfigurationManager.ConnectionStrings("EnforcementConnectionString").ToString())
        Dim cmd As New System.Data.SqlClient.SqlCommand

        cmd.CommandType = System.Data.CommandType.Text
        cmd.CommandText = "INSERT INTO LetterContentCollection (Module, ConfiguredFor,  DataCollection, Cid, Cdt, Mid, Mdt ) VALUES " & _
        "('Aduan',('" & DropDownList1.DataTextField & "'), ('" & TextBox1.Text & "'), ('" & User.Identity.Name & "'), GetDate(), ('" & User.Identity.Name & "'), GetDate())"

        cmd.Connection = sqlConnection1
        sqlConnection1.Open()
        cmd.Parameters.AddWithValue("@", DropDownList1.SelectedValue)
        cmd.ExecuteNonQuery()
        sqlConnection1.Close()

        lblMessage.Text = "Successfully Saved!"


       


    End Sub

推荐答案

cmd.CommandText = "INSERT INTO LetterContentCollection (Module, ConfiguredFor,  DataCollection, Cid, Cdt, Mid, Mdt ) VALUES " & _
        "('Aduan',('" & DropDownList1.SelectedValue  or DropDownList1.Selecteditem.text & "'), ('" & TextBox1.Text & "'), ('" & User.Identity.Name & "'), GetDate(), ('" & User.Identity.Name & "'), GetDate())"

[edit]固定格式&标记，江户[/ edit]

这篇关于将数据从下拉列表插入数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！