如何通过c＃将复选框值保存到sql server 2005 [英] How to save checkbox values into sql server 2005 via c#

问题描述

有


我想知道如何将复选框值保存到sql server 2005中？ 复选框位于我的Windows窗体应用程序中...
$


谢谢

Hi there

I want to know how I can save a checkbox value into sql server 2005?  The check box is in my windows forms application...

Thanks

推荐答案

尝试以下代码

    Dim query As String = "INSERT INTO TABLENAME (CheckBoxColumn) VALUES (@CheckBoxColumn)"
    Dim conn As New SqlClient.SqlConnection("Connection String")
    Dim cmd As New SqlClient.SqlCommand(query, conn)
    If CheckBox1.Checked = True Then
      cmd.Parameters.Add("@CheckBoxColumn", SqlDbType.Bit).Value = 1
    Else
      cmd.Parameters.Add("@CheckBoxColumn", SqlDbType.Bit).Value = 0
    End If

    conn.Open()
    cmd.ExecuteNonQuery()
    conn.Close()

这篇关于如何通过c＃将复选框值保存到sql server 2005的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！