|
Schedule time? Is this a DateTime column in your database?
And are you doing this in VB.NET?
If so, then what you'll need to do is read this from your database via ADO.NET. Since this is an MS Access database, you should use ADO.NET's OleDB provider.
You can get the current system time via "Date.Now". Here's a quick example how to compare DateTime objects.
Dim myTime As New Date(2000, 1, 31) ' Create DateTime set to Jan 1st, 2000.
If (Date.Compare(Date.Now, myTime) > 0) Then 'Compare against current time.
' Current time is greater than "myTime".
End If
|
|
|
|
|
 Hi
there is a command used in .net to know the system time
this command is Now() function
if you compare it with the time retreived from the DB then I think you have the answer
I hope that I have provided the needed help
best wishes
Regards
Mohammad Rabay'a
|
|
|
|
|
Hi Mrabaya
Can u explain me abit more details? Cos i really dumb at programming.
Thanks and regard
Nyan Lin
|
|
|
|
|
How do input a multi-table DataSet to a Web Forms DataGrid
that can be inserted, updated, and deleted?
Visual Studio 2003, SqlServer DataBase
I am trying to create a datagrid that will have
fields from 4 separate tables.
When I drag in a SqlDataAdapter and
add all four tables to my query I get the following
Messages:
Generate insert statement
The original query has a select list that has
columns from multiple tables. The statement
cannot be generated automatically
for this type of query.
Generate Update statement
The original query has a select list that has
columns from multiple tables. The statement
cannot be generated automatically
for this type of query.
Generate Delete statement
The original query has a select list that has
columns from multiple tables. The statement
cannot be generated automatically
for this type of query.
|
|
|
|
|
Hi, how to copy an entire row from a dataGrid to a lisBox
a tuturial whould do fine. Thank you Andy38
|
|
|
|
|
Could someone help and redirect me or tell me what's the name of the methed that used with the screen server actions....
the examples i found sucks... i can't found the perfect exampl to help me out.
most of the examples solve the problem in one side and in a weak way and not understandable....
i and i've low resources>>>>!
 
Militiaware
Faris Madi
|
|
|
|
|
militiaware wrote: Could someone help and redirect me or tell me what's the name of the methed that used with the screen server actions....
What actions?
militiaware wrote: most of the examples solve the problem in one side and in a weak way and not understandable
What problem?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Anyone can give a link of the advantages using VB.net compare to classic VB ?
Thanks before...
|
|
|
|
|
|
Hi! I'm not a VB programmer and I wonder if there is any way of having a map, like map<...> in STL or CMap, or something like that.
Thank you in advance.
Sorry I forgot to say I'm working with VBA.
|
|
|
|
|
I found it.
Microsoft Scripting Runtime Library --> Dictionary
|
|
|
|
|
how to flip the screen/forms using c# or vb
lok
|
|
|
|
|
Define "flip"? What are you talking about?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I want to open my computer , control panel and other computer options through voice command. Urgently Required.
|
|
|
|
|
So what portion of this app are you having problems with?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I have an application that fills a combobox with the contents of an xml file.
The xml file represents superscript 4 with ⁴ which shows as: ⁴
I can change the font of the combobox so that the superscript 4 is shown but it doesn't work on all fonts and to be honest the ones where it does work look hideous.
I'm just looking for a way of displaying the superscript 4, does anyone have any ideas?
An optimist's glass is half full.
A pesimist's glass is half empty.
An engineer goes and gets the right size glass.
-- modified at 8:52 Friday 13th January, 2006
|
|
|
|
|
The html code for superscript is <sup>. I don't know how well that works in a combobox, though.
---
b { font-weight: normal; }
|
|
|
|
|
The problem I'm having is that I'm reading an xml file and have simple nodes with text so I can cast the node value to a string. If I use the <sup> tag I can't cast to a string and I would have to format the text in the combobox.
It seems that utf-8 encoded characters is the simplest method if I can just get the font issue right.
On the next message is a copy of the code I'm using to populate a collection of objects that is used as the datasource for the combobox.
The display member of the combobox can be either the Name or Abbreviation nodes.
An optimist's glass is half full.
A pesimist's glass is half empty.
An engineer goes and gets the right size glass.
-- modified at 8:51 Friday 13th January, 2006
|
|
|
|
|
<br />
Public Sub PopulateFromXML(ByVal fileName As String)<br />
<br />
'Collect the path for the dll<br />
Dim path As String<br />
path = System.Environment.GetFolderPath( _<br />
Environment.SpecialFolder.CommonApplicationData)<br />
<br />
'Read the xml file into a dataset<br />
Dim xmlFile As New System.Data.DataSet<br />
xmlFile.ReadXml(path & _<br />
System.IO.Path.DirectorySeparatorChar & _<br />
"Flowguard Limited " & _<br />
System.IO.Path.DirectorySeparatorChar & _<br />
"Engineering Dimensions" & _<br />
System.IO.Path.DirectorySeparatorChar & _<br />
fileName)<br />
<br />
'Collect the unit type<br />
Dim unitType As String<br />
unitType = Convert.ToString(xmlFile.Tables("DimensionUnits").Rows(0).Item("Type"))<br />
<br />
'Collect the units table<br />
Dim unitsTable As New System.Data.DataTable<br />
unitsTable = xmlFile.Tables("Unit")<br />
<br />
'Loop through each row of the units table, adding a new unit each time<br />
Dim rowEnum As IEnumerator<br />
rowEnum = unitsTable.Rows.GetEnumerator<br />
<br />
While rowEnum.MoveNext<br />
'Cast the enumerated object to a data row<br />
Dim currRow As DataRow<br />
currRow = CType(rowEnum.Current, System.Data.DataRow)<br />
'Create a new unit object<br />
Try<br />
Dim newUnit As New Unit(Convert.ToString(currRow("Name")), _<br />
Convert.ToString(currRow("Abbreviation")), _<br />
Convert.ToDouble(currRow("Factor")), _<br />
Convert.ToBoolean(currRow("IsMetric")), _<br />
Convert.ToBoolean(currRow("IsSIUnit")), _<br />
"Length")<br />
<br />
'Add the unit to the collection<br />
Me.Add(newUnit)<br />
Catch formatEx As System.FormatException<br />
'Provide a message string<br />
Dim origString As String = "There is a problem in the xml file "<br />
Dim msgString As String = ""<br />
<br />
'Identify which value has the problem<br />
If Not (TypeOf (currRow("Name")) Is String) Then<br />
If msgString.Length = 0 Then<br />
msgString = origString & " with the Name Field"<br />
Else<br />
msgString += ", the Name Field"<br />
End If<br />
End If<br />
<br />
If Not (TypeOf (currRow("Abbreviation")) Is String) Then<br />
If msgString.Length = 0 Then<br />
msgString = origString & " with the Abbreviation Field"<br />
Else<br />
msgString += ", the Abbreviation Field"<br />
End If<br />
End If<br />
<br />
If Not (TypeOf (currRow("Factor")) Is Double) Then<br />
If msgString.Length = 0 Then<br />
msgString = origString & " with the Factor Field"<br />
Else<br />
msgString += ", the Factor Field"<br />
End If<br />
End If<br />
<br />
If Not (TypeOf (currRow("IsMetric")) Is Boolean) Then<br />
If msgString.Length = 0 Then<br />
msgString = origString & " with the IsMetric Field"<br />
Else<br />
msgString += ", the IsMetric Field"<br />
End If<br />
End If<br />
<br />
If Not (TypeOf (currRow("IsSIUnit")) Is Boolean) Then<br />
If msgString.Length = 0 Then<br />
msgString = origString & " with the IsSIUnit Field"<br />
Else<br />
msgString += ", the IsSIUnit Field"<br />
End If<br />
End If<br />
<br />
'Inform the user<br />
System.Windows.Forms.MessageBox.Show( _<br />
msgString, "XML File Error!", _<br />
MessageBoxButtons.OK, MessageBoxIcon.Exclamation)<br />
Catch ex As System.Exception<br />
'Throw the exception<br />
Throw ex<br />
End Try<br />
<br />
End While<br />
<br />
'Raise the list changed event<br />
RaiseEvent ListChanged(Me, _<br />
New System.ComponentModel.ListChangedEventArgs( _<br />
System.ComponentModel.ListChangedType.Reset, 0))<br />
<br />
End Sub 'PopulateFromXML<br />
An optimist's glass is half full.
A pesimist's glass is half empty.
An engineer goes and gets the right size glass.
|
|
|
|
|
I don't see the problem with storing the tags in a string. Properly encoded in the xml file, it would look like this, as example:
<node>A value with <sup>superscript</sup> text.</node>
If you can't store the tags in the xml file, can't you replace the unicode character after you have gotten the data:
str = str.Replace("\x1234", "<sup>4</sup>")
---
b { font-weight: normal; }
|
|
|
|
|
The problem is that the text doesn't show in the combobox.
I presume (and I haven't tried it yet) that if I changed the text to "<sup>4</sup>" then this is what would show in the combobox and not the superscript character. The combobox isn't in a web browser its on a windows form.
What I've doen is set the default font to lucida sans unicode and everything is fine, I'm almost sure it is a font issue.
If i'm getting the wrong end of the stick poke me with the right end
An optimist's glass is half full.
A pesimist's glass is half empty.
An engineer goes and gets the right size glass.
|
|
|
|
|
Hi,
Anyone out there come across a dxf/dwg viewer component(activex) or dll that is free and compliant with the different cad versions, please let me know.
I've been searching till my fingers have been worn to the bone 
|
|
|
|
|
Autodesk used to do a viewer called voloview that was free. Autodesk include VBA in their CAD products so you may be able to use the voloview application as a com object.
Worth a look.
An optimist's glass is half full.
A pesimist's glass is half empty.
An engineer goes and gets the right size glass.
|
|
|
|
|
about 5 years ago i found one. It was free and worked really well for what we wanted. I am sorry but i really cant remember the name of it and i havent worked forthat company for a long time. Not really much help i know but all i can say is there is at least one out there. Keep searching.
Jon
|
|
|
|
|
hi,
I have 2 application. one is opening a port let say 2600 and listening to that port.
my 2nd program will tell me that port 2600 is open or not
what will be the code for that VB.
bye
Paritosh
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
