更新数据库中的位数据类型值

本文关键字：数据类型 数据库 更新 | 更新日期: 2023-09-27 18:13:25

try
        {
            UserMaster ObjUserMst = new UserMaster();
            ObjUserMst.GetData("UPDATE  MemberDetails SET Active = 0  WHERE Member_No = '" + txtmemberno.Text + "'");
            MessageBox.Show("Installment Close Successfully.", "Close Installment", MessageBoxButtons.OK, MessageBoxIcon.Information);
            btndebit.Visible = true;
            btndebit.Visible = false;
        }
        catch (Exception ex)
        {
            XtraMessageBox.Show(ex.Message.ToString(), "btncloseinstallment_Click", MessageBoxButtons.OK, MessageBoxIcon.Error);
        }

它的get data code

public DataTable GetData(string Query)
    {

        string cn = GlobalClass.ConnectionStringGet();
        Con = new SqlConnection(cn);
        cmd = new SqlCommand();
        cmd.Connection = Con;
        if (cmd.Connection.State == ConnectionState.Closed)
        {
            cmd.Connection.Open();
        }
        SqlTransaction ObjTrans = cmd.Connection.BeginTransaction();
        cmd.Transaction = ObjTrans;
        cmd.CommandType = CommandType.Text;
        cmd.CommandText = Query;
        cmd.CommandTimeout = 500;
        SqlDataReader dreader = cmd.ExecuteReader();
        DataTable dt = new DataTable();
        dt.Load(dreader);
        Con.Close();
        Con.Dispose();
        return dt;
    }

我有winforms.
我有memberdetails表-在这个Active字段&其数据类型为BIT .
its默认为"1"。但我需要更新到0。
1 =
0 = false
当我尝试上面的代码Active字段数据没有更新
但我得到消息"Installment Close Successfully."
https://i.stack.imgur.com/mkuhW.png
https://i.stack.imgur.com/ToXFV.png
我把我的图片上传到上面的链接

帮帮我，伙计们…对不起，如果我没有解释得很好，因为我是新来的

更新数据库中的位数据类型值

好的，我知道了。

        string constring = GlobalClass.ConnectionStringGet();
        string sqlUpdate = "UPDATE  MemberDetails SET Active = '0'  WHERE Member_No = '" + txtmemberno.Text + "'";
        SqlConnection conDatabase = new SqlConnection(constring);
        SqlCommand cmdd = new SqlCommand(sqlUpdate, conDatabase);
        conDatabase.Open();
        cmdd.ExecuteNonQuery();
        conDatabase.Close();
        MessageBox.Show("Installment Close Successfully.");


its update Active Field 1 to 0 successfully.

相关文章：