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

[ad.hasareli]

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)



​

 

[Pink panther]

Bump

 

[ad.hasareli]

Bump

tnx machan

 

[ad.hasareli]

ane kauruwath danne nedda ? netnam help akak denne nedda ?

 

[ad.hasareli]

bmp

 

[NUWAN BUWA]

B
U
M
P

 

[ad.hasareli]

bmp

 

[ad.hasareli]

bmp

 

[san**]

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
}

 

[ad.hasareli]

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
}

ane machan mata aka amataka unane ban.... oya java ne
Catch ex As Exception
TextBox1.Text = ""
End Try

 

[මම කට්ටා]

dump

 

[penguinruwan]

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]

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...

 

[ad.hasareli]

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)

mehemath weda karanne nehe ban

 

[azarox]

bump macha!!!!

 

[ad.hasareli]

bmpyoooooooooooooo

 

[penguinruwan]

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...

 

[penguinruwan]

weda karada?