|
Check out the intrinsic DateDiff function.
|
|
|
|
|
how to show the time only not the full date with time. I use TODAY.NOW.
Adrian De Battista
|
|
|
|
|
Check out the overloads of the .ToString() method. You can specify a format string that just has the parts of the date and time that you want to show.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
can i use the microsoft.vb.left(Today.now,11) with this way! or it is not good?? because right now i am using this method and i don't think so that it is 100% good.
|
|
|
|
|
I wouldn't. Then again, I wouldn't be using the code that came out of the conversion tool either. It's best to start from scratch and rewrite the project instead of trying to wrestle VB.NET into doing something "the old fashioned way".
Now() returns a DateTime object, not a string. The brief statement you posted wouldn't even compile. The Left method takes a string parameter, not a DateTime.
Dim currentTime As String = DateTime.Now().ToString("hh:mm:ss:")
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
|
Why do I get this error: Public WithEvents cmdFileOp As Microsoft.VisualBasic.Compatibility.VB6.ButtonArray
type " error " is not defined.
It was converted to vb.net, with no problems.
Why is it saying that i need to defined it?
Can someone help me?
|
|
|
|
|
It's not a good idea to use the code that is generated by the conversion tool. I've always recommended that a VB6 project be scrapped and rewritten from scratch instead of trying to get VB.NET to do things "the old fashioned way".
But, in regards to your code, without seeing the lines that generated the error, it's pretty impossible to tell you what's wrong. Complicating things is the fact that the code is using a bunch of "adapter" classes in the Compatibility namespace that just, in my experience, complicate solving the problem.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hello.
I'm wondering if anyone can help me to be able to save an xml string to a dataset.
I have a remoting vb.net application. On the host side I have an xml file that I want to return to the client. I have saved the xml file to a string variable by doing: sXMLData = ds.ReadXml(XML_FILENAME).ToString(). It was specified to me to bring the xml data over to the client as a string rather than the whole file because it would be more efficient.
I currently have the sXMLData variable returning to the client.
My problem is that I don't quite know how to get the string data back into a dataset on the client side. Can anyone help me with this?
Thanks in advance for any help offered.
Peter
|
|
|
|
|
I think this would work
Dim myDS As DataSet = New DataSet
Dim xmlData As String = "<xmlds><table1><col1>Value1<table1><col1>Value2"
Dim xmlSR As System.IO.StringReader = New System.IO.StringReader(xmlData)
myDS.ReadXml(xmlSR)
|
|
|
|
|
Thanks!
I appreciate the help.
I ended up finding an answer to the problem before you responded.
It worked and I did the following:
ds.ReadXml(XML_FILENAME) 'Load the XML file
Return ds.GetXml() 'Returns the Xml file as a string
Thanks again for your efforts to help me!
Peter
|
|
|
|
|
You can use the ds.writexml(sxmldata) to get it back as a dataset I've been using it this way and it's working for me so try it out.
Love to code, and love to help others
|
|
|
|
|
In Crystal report how can export file in to text format.
anybody help me.
Continue...
|
|
|
|
|
The guy's that write the reporting exper tools call CRYSTAL REPORT are just good guy's. The icon is their at the top of the report view tools, just click and folow the instruction.
Love to code, and love to help others
|
|
|
|
|
I have a database with two columns, "department_name" and "color". My goal is to display a list of all of the values but formatted so as to display a rectangular swatch of the color and have the name follow it. I have absolutely no idea how to do this (new to VB.NET programming, ASP/ASP.net background), and would really appreciate some feedback. Can I draw a rectangle in each column as the listview is populated and specify the color of each one? OR could I possibly use like a transparent icon and specify the background color of the place holder? If anyone has used Adobe InDesign, they've seen something similar to what I am looking for when invoking a pantone color. You simply get a scrollable list with a rectangular swatch of the color followed by the color name. Any help or direction would be greatly appreciated--this has REALLY been bothering me!
|
|
|
|
|
Does anyone know how to convert a date to a string but keeping its date format i.e. 08/10/2005.
macca
|
|
|
|
|
If you are using a Date object you can do the following:
'format today's date<br />
Messagebox.Show(Now.ToString("M/DD/YYYY"))
|
|
|
|
|
Does anyone know how to convert a date to a string but keeping its date format i.e. 08/10/2005.
macca
|
|
|
|
|
A DateTime object doesn't have a format. The format only applies to the string representation of the object. You can give it any format you want if you just supply the .ToString() method with the appropriate format code(s).
DateTime.ToString()[^] method and overloads documentation
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hello,
I get an access denied error when I execute
processes = Process.GetProcesses()
1. Is this because the logged in user doesnt have access to the process information on the computer.(What access wd i have to give the user. I cannot give them administrative rights)
2. I know the process class is dependant on performance counters. Could this be because performance counters have been disabled
These are the error details :
Error Message : Access is denied
Target Site : IntPtr OpenProcess(Int32, Int32, Boolean)
Stack Trace : at System.Diagnostics.ProcessManager.OpenProcess(Int32 processId, Int32 access, Boolean throwIfExited)
at System.Diagnostics.NtProcessManager.GetModuleInfos(Int32 processId)
at System.Diagnostics.Process.get_Modules()
at System.Diagnostics.Process.get_MainModule()
at System.Diagnostics.Process.get_ProcessName()
at TRASAutomation.Common.IsRunning(String ProgramName)
at TRASAutomation.frmStartAppln.RunReport()
at TRASAutomation.frmStartAppln.btnStartAppln_Click(Object sender, EventArgs e)
Any help is appreciated!!
|
|
|
|
|
Hi all,
I'm trying to open a Excel spreadsheet from a VB Application, but it seems that VB cannot handle spaces, the code is as follow:
System.Diagnostics.Process.Start("excel.exe", _
"C:\Documents and Settings\HHarrar\My Documents\XDAStatus.xls")
I get the Error:
"C:\Document.xls" could not be found. check the spelling of the file name, and verify that the file location is correct.
just to make sure I moved the file and ran it as:
System.Diagnostics.Process.Start("excel.exe", _
"C:\XDAStatus.xls")
it worked perfectly shich leads me to believe that the problem is the space between the words in the pathname.
does anyone know how to get a round this.
Thanks.
Ignorance is darkness.
Knowledge is light.
|
|
|
|
|
Try putting quotes around the full path.
Where:
System.Diagnostics.Process.Start("excel.exe", _<br />
"C:\Documents and Settings\HHarrar\My Documents\XDAStatus.xls")
Becomes:
System.Diagnostics.Process.Start("excel.exe", _<br />
"""C:\Documents and Settings\HHarrar\My Documents\XDAStatus.xls""")
|
|
|
|
|
Thanks for the suggestion unfortunately it didn't resolve the problem, I still get the same error coming up
any other suggestions??
Thanks
|
|
|
|
|
Perhaps it doesn't like the command line argument. Try putting the information into a Process.StartInfo
Dim p as New Process<br />
<br />
With p.StartInfo<br />
'name of process to start<br />
.Filename = "excel.exe"<br />
<br />
'specify the arguments - in your case the filename<br />
.Arguments = ControlChars.Quote & "C:\Documents and Settings\HHarrar\My Documents\XDAStatus.xls" & ControlChars.Quote<br />
End With<br />
<br />
'start the process<br />
p.Start()
A few extra lines of code, but it should work. 
|
|
|
|
|
Hello
Is there any way that one can reffer to a new page with an URL and at the same time define how the window should look (eks: no toolbars, size etc).
SomeFunction.TargetURL = "../PersonInfo.aspx (and define the window here?)"
Spaz
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
