|
First make sure you have a table, then check the rows
If not me.dataset11.tables.contains("tblMyTable") Then
'blow up no table -- or however you want to handle it
Exit Sub
ElseIf me.dataset11.tables("tblMyTable").rows.count = 0 Then
'blow up no rows -- or however you want to handle it
Exit Sub
End If
'Process Records
'Never argue with an idiot; they'll drag you down to their level and beat you with experience.' ~ anonymous
'Life's real failure is when you do not realize how close you were to success when you gave up.' ~ anonymous
|
|
|
|
|
Also check the value of Item(0) against DBNull.Value and the target type.
|
|
|
|
|
After going back and trying this again this trap is working. Thanks.
many hours later...
meh
Statistics are like bikini's...
What they reveal is astonishing ...
But what they hide is vital ...
|
|
|
|
|
|
Perhaps you should ask the author of that article.
|
|
|
|
|
There is a message board at the bottom of the article. Post there and maybe the author will reply.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Hi Friends,
I want to send email from VB6. It should open the default mail client.
And I want to format the body with tab and want to add image also.
How to achieve this ?
Thanks,
Sun Rays
To get something you must have to try once.
My Articles
|
|
|
|
|
|
Hi,
thanks buddy.
But i want in VB 6.
not in .Net..
Any other help ?
Thanks..
Thanks,
Sun Rays
To get something you must have to try once.
My Articles
|
|
|
|
|
It's the exact same thing. Instead of using .Net's Process class, use the ShellExecute API, or the Shell function.
|
|
|
|
|
Thanks,
but in that cant put image or cant have html mail body.
Thanks,
Sun Rays
To get something you must have to try once.
My Articles
|
|
|
|
|
Hi group,
we have a userdefined control (called e.g. LabelAndMore) which contains a Label and other controls. When I apply this userdefined ctrl LabelAndMore in eg. a form I need to set the properties of the label.
Of course, we could add properties like Label_Text and Label_AutoSize in LabelAndMore. For a label this would be ok. However, if a more complex control with more relevant properties is needed instead of a label, all its properties would have to be added in LabelAndMore just to mirror the already existing properties of the complex control to LabelAndMore.
Thus we had the idea to add the property
Public Property Label() As Label
Get
Return Me.Label1
End Get
Set(ByVal value As Label)
Me.Label1 = value
End Set
End Property
in LabelAndMore. At the first glance this approach looks quite fine. When I add a LabelAndMore to e.g. a form and look at the property list of the inserted instance of LabelAndMore, the new property Label shows. It has a plus symbol in front of it. Expanding it one gets all the properties of the label. But unfortunately the designer does not create code in Form1.Designer.vb for the changed properties of the Label within LabelAndMore.
What do we have to do so that changes of the properties of Label in LabelAndMore are added to the code created by the designer?
I guess it is possible because a split container does it. It consists two panels called Panel1 and Panel2 and the changes of their properties are added in the code created by the designer.
Me.SplitContainer1.Panel2.Enabled = False
Kind regards and thanks in advance.
Michael
(VB .net 3.5)
|
|
|
|
|
Finilly I have found a solution which seems to work. I've had a look into the source code of the .net framework for the SplitContainer mentioned above. It shows
[
SRCategory(SR.CatAppearance),
SRDescription(SR.SplitContainerPanel1Descr),
Localizable(false),
DesignerSerializationVisibility(DesignerSerializationVisibility.Content)
]
public SplitterPanel Panel1 {
get {
return this.panel1;
}
}
If I use this in my case the problem is solved:
< _
System.ComponentModel.Localizable(False), _
System.ComponentModel.DesignerSerializationVisibility( _
System.ComponentModel.DesignerSerializationVisibility.Content) _
> _
Public ReadOnly Property Label() As Label
Get
Return Me.Label1
End Get
End Property
Michael
Some infos from the VS 2008 docu:
' HINT from VS docu for "SRCategory"
' (no entry available)
' HINT from VS2008 docu for "SRDescriptionAttribute Class"
' Provides an attribute for use in upgrading Visual Basic 6.0 applications to Visual Basic 2008.
' HINT from VS2008 docu for "DesignerSerializationVisibilityAttribute Class"
' When a serializer persists the persistable state of a design mode document, it often adds
' code to the initialization method of components to persist values of properties that have
' been set at design time. This happens by default for most basic types, if no attribute has
' been set to direct other behavior.
' With the DesignerSerializationVisibilityAttribute, you can indicate whether the value for a
' property is Visible, and should be persisted in initialization code, Hidden, and should not
' be persisted in initialization code, or consists of Content, which should have initialization
' code generated for each public, not hidden property of the object assigned to the property.
' HINT from VS2008 docu for "LocalizableAttribute class":
' When code is generated for a component, members that are marked with the LocalizableAttribute
' set to true have their property values saved in resource files. You can localize these resource
' files without modifying the code.
' By default, members that have no localizable attribute or are marked with the LocalizableAttribute
' set to false will have their property values persisted to code, if the data type allows.
|
|
|
|
|
hi all,
am working on vb.net2.0 , a facing noe regler issue in filtering the names
for eample in my Database , Location name is CANADA, when i click CANADA location i want to dispaly the values depends on Location.
in databse 10 diffent names are there, need to dispaly only 3 namesPls help me
Regards
Vidhish
|
|
|
|
|
A SQL query like select * from databasetable where country <> 'Canada' ?
|
|
|
|
|
i am having a client server application where user will input some data from their office and i suppose to save their data into a sql server 2005 express, where located in a different place using internet .
can any one suggest how to achice this goal, please.
urgent!
thank you
|
|
|
|
|
Just connect the application to the database. It isn't hard.
|
|
|
|
|
Does anyone maybe now how to capture netflow v5 packets and to write the packet data to a text file.
Thanks in advance.
|
|
|
|
|
|
|
Iam Usingwindows project and it is startup windows project
I registered in registry key of the program and set the value to set the program to come in start up..
..Iam using code to kill the project but it is coming again in task manager..
Thro task manager also i killed ,it is coming again
how to kill the process.
|
|
|
|
|
..well not be reposting the question. If you didn't get an answer the first time what makes you think you will now?
Bob
Ashfield Consultants Ltd
|
|
|
|
|
|
Hii
I want to develop a Face Recognizer application so i need the face recognizer SDK. Can any one provide me a link for Download Face Recognizer SDK at Free of Cost Trial version or Full Version.
Thanx
~Khatri Mitesh
|
|
|
|
|
I didn't occur to you to simply use Google, hmm?
"I love deadlines. I like the whooshing sound they make as they fly by." (DNA)
|
|
|
|