thelner
Last Activity: Feb 4 '08, 07:13 AM
Joined: Oct 18 '07
Location:
-
Can anybody help me please... -
Still wont work. Has the same error. I think the error is generated because .net cant display on a datagridview tables that has a diiferent format date field. Is there a way so that .net will interpret mysql date tables as strings?
[CODE=vb] Public Sub refreshinvoices ()
Dim source As New BindingSource
richdb.connectR ichDB() 'opens mysql connection
source.DataSour ce = richdb.getTable Data("Select...Leave a comment:
-
binding a mysql table on vb05 datagridview error
Im trying to bind a table in mysql containing a mysql date field in a datagridview in vb.net 05. When i only select fields containing non-dates it works, but once i add a date field it generates this error:
Unable to convert MySQL date/time value to System.DateTime
Any work around for this?
Thanks in advance. ;) -
Thanks but a complete noob here. :)
Where should i place the bindingsource.f ilter?
Will it allow me to display mysql dates on the datagridview w/o the error?Leave a comment:
-
error on datagridview date field using mysql and vb2005
Well, the app im working on makes an error when trying to populate a datagridview when the source contains date field. Any solution to my problem?
dgvInvoices.Dat aSource = richdb.getTable Data("Select invoiceno,dueda te as string from invoice Where IsCleared = '0' and duedate <= '" & convert.tomysql datenow & "'")
Error: Unable to convert MySQL date/time value to System.DateTim... -
reading list view items
Hi, sorry but i cant find a tutorial on reading list view items online, only adding subitems. Im using vb 2005 btw.
my questions:
1. How to read the entire row of a selected item in list view?
2. How to delete the said row?
Thanks. -
Figured it out. :)
DirectCast(ctl, RadioButton).Ch ecked
Thanks all.Leave a comment:
-
Thanks for the reply but it still doesnt work. Value and checked doesnt show after ctl.Leave a comment:
-
Next question, what if i want to check if those radio buttons (see last post) is checked?
ctl.checked = True doesnt work.Leave a comment:
-
Hey nev,
I just started learning vb.net and mysql today and this site is really helping me a lot. They have an artice on vb.net and mysql.Leave a comment:
-
Woot!!! Thanks qveen72! Everything works now.
[CODE=vbnet]
Dim x As Integer
For x = 1 To 15
For Each grp As GroupBox In Me.Controls
If grp.Name = "grp" & x Then
For Each ctl As Control In grp.Controls
If TypeOf ctl Is TextBox Then
ctl.Text = x
...Last edited by Killer42; Oct 18 '07, 10:19 PM. Reason: Added [CODE=vbnet] tag. And giggled at the size of the indenting :)Leave a comment:
-
Thanks nev ive edited t a bit and it works :D
[CODE=vbnet]Dim x As Integer
For x = 1 To 15
For Each ctl As Control In Me.Controls
If TypeOf ctl Is TextBox Then
If ctl.Name = "txt" & x Then
ctl.Text = x
End If
End If
Next[/CODE]
Now the problem is it doesnt work on textboxes inside a groupbox....Last edited by Killer42; Oct 18 '07, 10:17 PM.Leave a comment:
-
VB.NET: filling a sequence named textboxes using for next.
Hi, quick question.
I have numbered labels and i want to fill the text using for next.
txt1
txt2
.
.
.
.
.
txt15
i tried using
dim x as integer
for x=i to 15
txt(x).text = x and txt[x].text = x
next
Unfortunately it doesnt work.
Can somebody please tell me how to do it right. Thanks...
No activity results to display
Leave a comment: