none
checkbox vaule in sql quary

    Question

  • Can you look at this quary :

    DB.GetDataSet("select '' as Item, sum((bolordqty * bolordweight) + bolordunitwt) as Weight, sum(bolordpk) as Package, sum(convert(int,bolordqty)) as Qty,  convert(bit,0) as bolordhz, '' as bolorduom, bolordtype, sum(bolordunit) as bolordunit, '' as bolordunittype, '' as bolordaddinfo, bolordpackgroup from bolorderinfo where bolorddocid = '" & TxtDocNo.Text.Trim & "' and bolordpackgroup <> 0 group by bolordtype, bolordpackgroup union all "

    Here "bolordhz" is checkbox. Problem is even i check the check box ..i am getting the value from that quary is false.i hope because of convert(bit,0) ...is wrong

    if i change   convert(bit,1)..then it is alwayes showing true value even i did not check checkbox.

    How to  i figure out based on my checkbox value.



    kavitha

    mardi 13 mars 2012 17:00

Réponses

  • hi kavitha

    well, your query is hard to follow, but are you simply trying to get whether a CheckBox is checked or not? you can get it with the Checked property

    try this in an app with a button and a checkbox. Each time you click the button, it changes the checked state and displays whether it is Checked (True) or not Checked (False)

    Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
            CheckBox1.Checked = Not CheckBox1.Checked
            MessageBox.Show("Checked is " & CheckBox1.Checked)
        End Sub

    mardi 13 mars 2012 20:14

Toutes les réponses

  • hi kavitha

    well, your query is hard to follow, but are you simply trying to get whether a CheckBox is checked or not? you can get it with the Checked property

    try this in an app with a button and a checkbox. Each time you click the button, it changes the checked state and displays whether it is Checked (True) or not Checked (False)

    Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
            CheckBox1.Checked = Not CheckBox1.Checked
            MessageBox.Show("Checked is " & CheckBox1.Checked)
        End Sub

    mardi 13 mars 2012 20:14
  • I can only guess that somewhere in your DB.GetDataSet you need to use SqlDbType.Bit to tell it to convert from an SQL bit datatype to a .NET Boolean.

    --
    Andrew

    mardi 13 mars 2012 21:56