hellp help..... .net(vb) urgent :(

ad.hasareli

Well-known member
  • Mar 27, 2010
    5,264
    580
    113
    දකුනේ කොල්ලෙක්
    machanla sql query aken check karana value aka null nam aka empty textbox akak widihata display karanne kohomada ??????? .net(vb)



    Sqlsstr1 As String = "sql query"

    sqlAD = New SqlDataAdapter(Sqlsstr1, sqlConn)

    sqlAD.Fill(sqlDS, "det5")

    TextBox1.Text = sqlDS.Tables("det5").Rows(0).Item(0)



     

    san**

    Well-known member
  • Feb 21, 2012
    5,418
    8,368
    113
    kandy
    try catch akak athulata dala balanna..sql query aka null nam catch eka execute wenawane..athakota textbox aka ""; karala balanna..
    try{}
    catch(Exception )
    {
    //setTextbox to null
    }
     

    penguinruwan

    Well-known member
  • Aug 10, 2008
    967
    267
    83
    machanla sql query aken check karana value aka null nam aka empty textbox akak widihata display karanne kohomada ??????? .net(vb)



    Sqlsstr1 As String = "sql query"

    sqlAD = New SqlDataAdapter(Sqlsstr1, sqlConn)

    sqlAD.Fill(sqlDS, "det5")

    TextBox1.Text = sqlDS.Tables("det5").Rows(0).Item(0)




    Machan VB.net wala hariyat sintax eka mathaka ne eet mehemai yanne

    if isdbNull(sqlDS.Tables("det5").Rows(0).Item(0))= true then TextBox1.Text = "" else TextBox1.Text = sqlDS.Tables("det5").Rows(0).Item(0)
     

    penguinruwan

    Well-known member
  • Aug 10, 2008
    967
    267
    83
    ane machan mata aka amataka unane ban.... oya java ne
    Catch ex As Exception
    TextBox1.Text = ""
    End Try
    ;)

    Meeka use karanawa Exeption eka dbnull eka capture karanna nattan hama error ekatama textbox eka null wenawane ethkota error msg eka catch karaganna ba ne machan...
     

    penguinruwan

    Well-known member
  • Aug 10, 2008
    967
    267
    83
    mehemath weda karanne nehe ban :(
    ADOH mama uba kiwat me vb.net wala check kara
    If IsDBNull(objdataSet.Tables("tbl_Cirt_PlantReg").Rows(0).Item(4)) = True Then txtPlntSerial.Text = "HISTHAN" Else txtPlntSerial.Text = objdataSet.Tables("tbl_Cirt_PlantReg").Rows(0).Item(4)

    Weda ban ube mokakda ena error eka ehemanattan quarry ekat null ena field ekat podi wadak danna

    { fn IFNULL(yourfield, "") } mehema quary eka danna etkot null value eka output krnne histhank widiyat quary ekekn "" wenuwat 0 dammot null value 0 wenawa terunada oya dekenma man use karanawa ban null value ekka cal karanna project waladi 100% sure weda ube ena error eka kiypan balanda...