VB .NET With ADO .NET

[rooshan2008]

pinwathek meka solve karala dennako :'(

Dim con As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Users\Roosh\documents\visual studio 2012\Projects\WindowsApplication2\WindowsApplication2\roosh.mdb")

    Private Sub Button3_Click(sender As Object, e As EventArgs) Handles Button3.Click
        con.Open()
        Dim com As New OleDb.OleDbCommand("SELECT * FROM contacts WHERE id='" + TextBox1.Text + "'", con)
        Dim rd As OleDb.OleDbDataReader
        rd = com.ExecuteReader
        While rd.Read
            TextBox2.Text = rd.
        End While
    End Sub

DB eke thiyenne Coloumn 2i, ID, NAME only ;(

mecharai, SELECT statement eken read karanda ona name eka and populate karanda ona name field eka ID ekata hariyana

 

[RePost බුවා]

ade bump thama kollo...

 

[rooshan2008]

thanks bump ekata

 

[RePost බුවා]

ela ela....

 

[rcccc]

bump

 

[Xxo0oxX]

Dim con As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Users\Roosh\documents\visual studio 2012\Projects\WindowsApplication2\WindowsApplication2\roosh.mdb")

Private Sub Button3_Click(sender As Object, e As EventArgs) Handles Button3.Click
con.Open()
Dim com As New OleDb.OleDbCommand("SELECT `name` FROM contacts WHERE id='" + cInt(TextBox1.Text) + "'", con)
Dim rd As OleDb.OleDbDataReader
rd = com.ExecuteReader
While rd.Read
TextBox2.Text = rd.item(0).ToString()
End While
End Sub

meka yanthan shape habayi leda godayi ubata mokakda wenna one pahadili madi

 

[chucks]

 

[rooshan2008]

meka yanthan shape habayi leda godayi ubata mokakda wenna one pahadili madi

ID eka deela select dunnahama name text field eka populate wenda ona

 

[rooshan2008]

cInt demmahama wede kachal wenawa ban

 

[rooshan2008]

Thanks Macho mama solve kara thank you kolla

 

[Xxo0oxX]

cInt demmahama wede kachal wenawa ban

Thanks Macho mama solve kara thank you kolla

man cInt danna kiwe ube DB eke field eka mokakda danne nathi nisa
normally man nam danne Interger, uba decimal hari varchar hari dammoth wenas karanna wenawa cDec or cVar, aye trim karannath wenawa mokada Spaces thibboth wade kachal.
habayi man nam sqlreader walata wada dataset ekakin ganne mokada eka lesi nisa...

kohomada wada kare monada damme

 

[rooshan2008]

man cInt danna kiwe ube DB eke field eka mokakda danne nathi nisa
normally man nam danne Interger, uba decimal hari varchar hari dammoth wenas karanna wenawa cDec or cVar, aye trim karannath wenawa mokada Spaces thibboth wade kachal.
habayi man nam sqlreader walata wada dataset ekakin ganne mokada eka lesi nisa...

kohomada wada kare monada damme

DB eke thibbe AI field ekak Int wenda ethi, cInt demma gam an Double walata convert karanda be kiyala wede awul giya mage weredda thibbe Double quotation ekak thibba ID ekata, eka String wela giya nisa thama awula man double quotation eka neti kara wede goda....

me Database eke Basic eka pennanda hadapu ekak

 

[Xxo0oxX]

DB eke thibbe AI field ekak Int wenda ethi, cInt demma gam an Double walata convert karanda be kiyala wede awul giya mage weredda thibbe Double quotation ekak thibba ID ekata, eka String wela giya nisa thama awula man double quotation eka neti kara wede goda....

me Database eke Basic eka pennanda hadapu ekak

ithin ban int ekak kiyanne dashamasthana thiyenna ba double walata conv karanna nam CDbl - decimal danna wenawa
ena error eke thiyenawane ban

kohomahari ' ' athule dammama string wenawa thama huta