Symbianize Forum

Most of our features and services are available only to members, so we encourage you to login or register a new account. Registration is free, fast and simple. You only need to provide a valid email. Being a member you'll gain access to all member forums and features, post a message to ask question or provide answer, and share or find resources related to mobile phones, tablets, computers, game consoles, and multimedia.

All that and more, so what are you waiting for, click the register button and join us now! Ito ang website na ginawa ng pinoy para sa pinoy!

101 Visual Basic and C# Code Samples for Visual Studio .Net

Status
Not open for further replies.
Sir pa update naman mo ng link di na siya ma download. Newbie lang po gustong matuto :d
 
tnx po s author.. sakto open ko..tnx din s nagbigay ng link..god bless s inyo
 
thanks bro sa pag share, sorry hindi ko ma download yung share files mo. pede maka hingi ng bagong link ulit?
 
sir newbie here , bali ano po ang gamit na visual studio? d ko kasi maopen yung mga projects o sample, salamat po.
 
Pre mga sample lang ba yan?o meron ding tutorial PDF? Thanks
 
Good Day po mga bosx, cnu po pwede magshare ng sample malufet na code about C# Report using SAP Crystal report? mrming salmuch po sa mkkpgbgay :praise::salute::thumbsup:
 
helo po patulong ako panoo masolve ung error na "Unable to convert MySQL date/time value to System.DateTime"




Public Class frmlistbarrowedbooks

Sub loadbarrowed()
Me.lvlist3.Items.Clear()
connect()
cmd.Connection = conn
cmd.CommandText = "select * from brwbooks"
reader = cmd.ExecuteReader
While reader.Read
iITem = New ListViewItem(reader(0).ToString)
iITem.SubItems.Add(reader(1).ToString)
iITem.SubItems.Add(reader(2).ToString)
iITem.SubItems.Add(reader(3).ToString)
iITem.SubItems.Add(reader(4).ToString)
iITem.SubItems.Add(reader(5).ToString)
iITem.SubItems.Add(reader(6).ToString)
iITem.SubItems.Add(reader(7).ToString)
iITem.SubItems.Add(reader(8).ToString)
iITem.SubItems.Add(reader(9).ToString)
iITem.SubItems.Add(reader(10).ToString) -----> dto po un tinuturo nia
lvlist3.Items.Add(iITem)
End While
disconnect()
End Sub

Private Sub frmlistbarrowedbooks_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
loadbarrowed()
End Sub
End Class
 
helo po patulong ako panoo masolve ung error na "Unable to convert MySQL date/time value to System.DateTime"




Public Class frmlistbarrowedbooks

Sub loadbarrowed()
Me.lvlist3.Items.Clear()
connect()
cmd.Connection = conn
cmd.CommandText = "select * from brwbooks"
reader = cmd.ExecuteReader
While reader.Read
iITem = New ListViewItem(reader(0).ToString)
iITem.SubItems.Add(reader(1).ToString)
iITem.SubItems.Add(reader(2).ToString)
iITem.SubItems.Add(reader(3).ToString)
iITem.SubItems.Add(reader(4).ToString)
iITem.SubItems.Add(reader(5).ToString)
iITem.SubItems.Add(reader(6).ToString)
iITem.SubItems.Add(reader(7).ToString)
iITem.SubItems.Add(reader(8).ToString)
iITem.SubItems.Add(reader(9).ToString)
iITem.SubItems.Add(reader(10).ToString) -----> dto po un tinuturo nia
lvlist3.Items.Add(iITem)
End While
disconnect()
End Sub

Private Sub frmlistbarrowedbooks_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
loadbarrowed()
End Sub
End Class


sir, kailangan mo malaman kung ano yung value nung
Code:
"reader(10)"
. possible kasi na NULL yung value nyan kya sumasabit yung code.

Code:
then mas safe gamitin yung Convert.ToString(reader(10)) to safely handle null values.
 
Last edited:
sir, kailangan mo malaman kung ano yung value nung
Code:
"reader(10)"
. possible kasi na NULL yung value nyan kya sumasabit yung code.

Code:
then mas safe gamitin yung Convert.ToString(reader(10)) to safely handle null values.

iITem.SubItems.Add(reader(10).ToString) -----> dto po un tinuturo nia
replace
iITem.SubItems.Add(reader.getMysqlDatetime(10).tostring()) -----> replace reader(10) to reader.getMysqlDatetime(10)<- datetime kasi yung datatype neto getmysqldatetime first before converting it to string.
 
Last edited:
Status
Not open for further replies.
Back
Top Bottom