Format Function Not Working?
Jun 8, 2010[code].....
View 5 Replies[code].....
View 5 RepliesWhen retrieving rows from an SQL Server table I use the following code select mydate, Customer, Details from sales where mydatetime >= '" & format (somedate, "MMM d, yyyy h:mm:ss tt") & "'"This works fine unless the clients computers windows Region setting is 'English (New Zealand)'The default time format in windows Region and Language for New Zealand is [code]On computers with this region setting I get an SQL Error 'Conversion failed when converting date and/or time from character string'..If I manually select the other option for AM symbol, PM symbol in Region and Language i.e AM PM the all works fine again..What format string can I use so that above code always works, even if the Region time format is a.m. / p.m.
View 1 RepliesI am trying to display a number, stored in a dataset as a string, as a phone number. I have a label that Binds to a value but doesn't display the format that I passed as an arg:
<asp:Label ID="lbl005108002" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "phone number", "{0:(###) ###-####}") %>'></asp:Label>
As a test I tried to pass the formated string into the dataitem but that didn't work either. Is there something else I need to do in order to use this function?
m_Row("phone number") = String.Format("{0:(###) ###-####}", value)
The value displays in both cases as: 04152543926
I have the following function in my program:
Format(Now(), "yMMdd" & "hhmm")
in 2009 it produces 912311200 for 12/31/2009 12:00
in 2010 it produces 1001011200 for 01/01/2010 12:00
It is giving me a 2 digit year. How do I get a 1 digit year?
I have Visual Studio Team System 2008 SP1 installed.In the VB editor the Pretty Listing (auto format) has stopped working. Also the Format-Document (Ctrl-K,Ctrl-D) no longer works in VB windows. Format document works in my XAML and C# windows however. I've checked the Tools-Options-Text Editor-VB setting and Pretty Listing is enabled.[URL]
View 1 RepliesThere is String.Format function that is referred to in the documentation as the analog for Format function from VB6. There's also Format function from VisualBasic namespace that is provided for compatibility and basically has same powers as String.Format.Indeed, those two format dates and numbers.But VB6's function was also able to format strings:[code]String.Format is not able to do that, as far as I'm concerned, nor is the new Format. I also couldn't find any mention in the compatibility Format documentation that certain parts of VB6 functionality is lost, seems like the feature was deprecated "silently."Is there anything in the framework that can do this type of formatting?
View 5 RepliesThe VB format() function has a bug in it that has existed for nearly 20 years! One would do this if communicating with devices that use fixed length HEX strings.
Ex: Something = Format(Hex(n), 00)
Note that the expected results occur when n = 0 to 255 EXCEPT when n=42 ... "00" is returned not "2A"! Truly an outright bug! VB up to and including .NET 2005 does this.
Testing in .NET 2010, it appears that now when a string is the passed value parameter, just the format string is echoed back.Not really fixed but functionality removed sometime between 2005 and 2010 versions.
Knowing this, I simply use my own wrapper function in all VB versions to do the formatting:
Something = PadLeftZeros( Hex(n), 2 )
Private Function PadLeftZeros(s As String, ByVal length As Integer) As String
' dumb function
To pad leading zeros to number string. Could be done many ways, this is just one primitive one.
Dim n As Integer
n = Len(s)
If n = length Then
[CODE]...
i am trying to format a numeric variable so that zeros are appended to it in VB .Net.Basically i am trying to achieve the equivalence of format(variable,"00000") in vb6, so that if variable is say 15, it can be displayed as 00015. whats the way to do it in VB .Net.
View 4 RepliesI have a SQL function that I am calling in my VB.Net code within a display function. The SQL function will format my account data to include the following results form a Table. The table data: "001000011121" (this is the type of structure the data has before formatted)
So the data table data and vb Properties would be called Myaccount, HerAccount, ThisAccount. Once the data is pulled and then formatted in the VB.net code it will result into a GridDisplay as as: "001.00.001.1121"
The way I have my Public Function in my code is:
Public Funcion GetDisplay(_
ByVal dbBass as DataProvider_
,ByVal pps AS TMGDatarequestParms_
,By filter As IFilter_
) As Ilist
Dim strobe As String = CType(parms.OptionalParameters, DataProvider).Database
Dim sql As BiGSqlBuilder(TABLE)
sql.Select = String.Format("ID, [{0}].dbo.GLForamtAcct(Myaccount) AS [Myaccount], [{0}].dbo.GLFormatAccount(HerAccount) AS [HerAccount], [{0}].dbo.GLFormatAccount(ThisAccount) AS [ThisAccount]", strobe)
I left out some of the return code since not necessary. The only thing I'm concerned is how to format the SQL within the VB.net Code above.
In my Windows Form I have a textbox for number of days to add and a textbox that has a date in it... On the button click event I need to use the "DateAdd" function to add the number of days in textbox number of days to the date entered in textxbox date? Can someone give me the correct syntax I have tried this and getting a syntax error. DateAdd(DateInterval.Day, txtNumDaysTAdd.Text, txtDate.Text)I than need to display the answer in a messagebox in the Longdate format using the formatdatetime function.
View 2 Replies<asp:GridView ID="Gridview1" runat="server" />
<Columns>
<asp:BoundField DataField="Years" HeaderText="Year" />
[code]....
I have above Gridview in my aspx page. but I need to format my Hours column from hour to (Day, hour) format for e.g. for 72 hours it should display as 9 d 0 hr.For that I have one function in my .vb page as follow,
Public Function ConvertHoursToDays(ByVal totalHours As Integer) As Object
Dim num As Integer = CInt(Math.Round(Conversion.Int(CDbl((CDbl(totalHours) / 8)))))
If (num < 0) Then
[code]....
Can I use the function to display gird data in (0 d 0 hr) format?
I am working a VB project that requires me to create an "Average" Function. What is the correct format in creating an average function? I tried different ways and gives me an error.
View 2 RepliesI'm developing a system and the system contains an update function to update the DB. I have performed all the coding but have some minor problem in my SQL Statement and I'm unable to detect the SQL Statement Error. Hope someone could rectify the problem.
[Code]...
i have a string such as {i|we|my friends} are {just|about} to go {walmart|asda|best buy} i would like to be able to randomly choose any of the words within the {} seperated by the | here is what i have so far and it only works for one {} i need it to work for sentences with multiple {}.
Function UnspinWork(ByVal SpunWords As String) As String
Dim upperBound As Integer
Dim Random As New Random()
Dim ChosenSpunString As String
[code]....
I am trying to format a Function Code so that it returns a 4 digit result no matter the entry by the user (i.e. they enter 540, stores 0540 in the database). While looking online, I've found the format function, but when I use it, it returns 540, regardless if I enter 540 or 0540. [Code]
View 2 RepliesI have wrote a function which validates a masked exit box date format. I have entered into the Mask property 00/00/0000 which on screen translates to __/__/____, great. If I get an invalid date I want to clear the content and reset the focus back giving a message box warning. [code]It all seems to work until I then try to enter a new date. The first number a press seems to push the mask characters to the right and then the rest works. So if I entered 01/01/2009 I end up with _1/01/2009.
View 29 RepliesFor years I never had trouble with this String. Format function until today when I got a value longer than 0 characters and the function returned all the characters in the string instead of just ten. Now sometimes I get less than ten characters so I can't use the substring with out getting an error. I can try the left function but I was hoping there was a solution with the Format function.
View 6 RepliesI recently moved a webservice VB.net project from VS 2005 to VS 2008 and now a conversion I use to create a unique receipt number is no longer working.
The Format() function which is supposedly a Visual basic function gives the error:
'Format' is a type and cannot be used as an expression.
The Year() Function which is also a VB function gives the error:
Name 'Year' is not declared.
The Datetime() Function which is also a VB function gives the error:
'DateTime' is a type and cannot be used as an expression.
The actual code statement remains unchanged between the two web services but VS2005 compiles and VS2008 does not.
Dim julda As Long = CLng(Format(Year(oneRowDon.Item(8)), "0000") _
+ Format(DateTime("d", CDate("01/01/" _
+ Format(Year(oneRowDon.Item(8)), "0000")), oneRowDon.Item(8)) _
+ 1, "000"))
file.Exists function not working
Dim f1 As New FileInfo(Server.MapPath("/CaseStudyImages/TemporaryImages/"))
Dim f2 As New FileInfo(Server.MapPath("/CaseStudyImages/" & success & "/"))
[code]....
I'm using fileopen() function to open the file, after doing all the works I'm using fileclose() to close the file. But when I access the file again it returns already the file is opened by another process.
Sample:
Dim intFile As Integer = FreeFile()
FileOpen(intFile, mstrFilename, OpenMode.Binary, OpenAccess.Read, OpenShare.LockWrite)
FileClose(intFile)
Loading another form increases the memory usage of the application and after closing is not combing back to normal? dispose function at formclosed event is not doing that
View 12 RepliesI have a form that displays a graph. From the appropriate toobar button click frmGraph.show is called and it works. But when I call it from the assigned F6 function key the graph hardly ever displays. Sometimes it does display properly, sometime it flickers a one time display of the graph then it's gone, but mostly the form just draws the background but no graph. In debugging this i discoverd that putting a message box just before the call to frmGraph.show the graph will display properly everytime after i click ok in the messagebox. Anyone know how to cure this or at least a workaround that doesn't involve displaying the messagebox? This is the code with the messagebox("here") just above the call.
View 8 RepliesI've been trying to get the double buffer function working in VB.NET GDI+ for a space invaders game using the following command.[code]But because I am using a separate draw routine attached to a class it doesn't seem to work:[code]The aliens draw correctly but the images are very stuttery and double buffering doesn't seem to work.
View 1 RepliesHow is it possible to add a function description in VB.NET (VS 2005)? in C# this task is resumed to tape 3 times the "/" simbol just above the function declaration. (generates the <summary> tag and others)
View 14 RepliesI have the following code which I want to run when the page first loads and then again when an update panel (asp.net) is run. Therefore I need to use function pageLoad() rather than document.ready.
function pageLoad() {
$(".zoomImage").each( function() {
$("<img src='"+$(this).attr("src").replace("-thumb.jpg",".jpg")+"' />").appendTo(".howitworksText > div");
});
};
Problem is I can only get this working with document.ready - so therefore not when the updatepanel is run.
have an xml file like this.
<?xml version ="1.0" encoding ="utf-8"?>
<menu>
<menuNode title="Register" value="true">
[Code]....
I found the following example of how to print a root directory on the net
Code:
Sub Main()
Dim Current As String
Dim Root As String
Current = Directory.getCurrentDirectory()
Root = Directory.GetDirectoryRoot(Current)
Root = Directory.GetDirectoryRoot("")
Console.WriteLine("Current directory {0}", Current)
Console.WriteLine("Root directory {0}", Root)
End Sub
However it just causes the error "name directory not declared"
[Code]...
I have an array with about 10 items in it. In order to get the desired functionality I need to append some text to each item in the array in order to sort it properly. Once it is sorted I want to remove the text I added and then just display the second half of each item in the array. The sort works great, but the split function is not worrk.
[Code]...
I wrote a simple GetCookies function but it's not working...
[Code]...
For some reason or another the WebResp.Cookies.Count always = 0 even though I know it's not true. Why is this?
I have no clue how to get ScreenToClient working. I declared the function using:
Private Declare Function ScreenToClient Lib "user32" (ByVal hwnd As Integer, ByVal lpPoint As POINTAPI) As Integer
Then:
Private Structure POINTAPI
Dim x As Integer
Dim y As Integer
End Structure
[Code] .....
What I want to do is move the cursor to 29,109 of the hwnd, not my screen (hence why I'm trying to use screentoclient).