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 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 want to dedicate a number with format method i can access to integer number with this code Dim s As Decimal = 123.326321 MsgBox(String.Format("{0:0}", s)) but now i want the floating how can i do that?
View 7 RepliesWhen I run my program, I want my AverageInventoryTextBox to be formatted like $0.00 and my TurnOverTextBox to be 0.00 (2 decimal places)But when I do the strings for the textboxes and run the program, no matter what numbers I put in it just gives me $0.00 and 0.00, it SHOULD be like $13.84 or 7.44 something like that, but it will only give me zero for an answer.
Public Class Form1
Private BeginInventoryInteger, EndInventoryInteger, CostInteger As Decimal
Private Sub CalculateButton_Click(ByVal sender As System.Object, ByVal e As
[code].....
When I am trying to use DataTable.Select to get column values.. Actually it is working file in C# which I have converted using Converters.[code]...
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]...
[code].....
View 5 RepliesI have a data structure (which is a class) called user_class and I want to load all the users data from a database.Currently I have
While SQLreader.Read()
Hold_user.username = SQLreader(0)
Hold_user.BlahBlahBlah = SQLreader(1)
[code]....
Where return_value is a List of user_class and hold_user is an instance of the same class.
Dim return_value As New List(Of user_class)
Dim Hold_user As New user_class
As the while statement loops through the read data, SQLreader(0),(1) and (2) are updated with new data, however they also appear to be updating the stored values held in return_value....
Need some help to develop a method/function. No problem if there is no code but I would like to start discussing the best way of doing this even in high level language. First of all would like to provide you with some information. The set that I use here is very small, but the data is on a table in mysql and there will be over a million rows. Its important because if I make a complex loop code, maybe there will be a lot of selects in there.[code]
View 9 RepliesI was wondering if there was a way to get the name of the property my statement is in, like I can get the name of a function in PHP with the magic constant __FUNCTION__. Is there a way to get that property name, and more in general, also for functions and methods?
View 1 RepliesI got following error when trying to login my web application.
method not found: System.String Microsoft.visual compatibility.vb6.support.format
what is that ?
Microsoft.visual basic.compatibility.dll is already present @ my machine
I 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.
I'm trying to create an extension method that returns an IEqualityComparer based on a lambda function. Heres the extension method:
<Extension()>
Public Function Comparer(Of T)(Func As Func(Of T, T, Boolean)) As IEqualityComparer(Of T)
Return New GenericComparer(Of T)(Func)
End Function
[Code]...
I have a Direction Enum:
Public Enum Direction
Left
Right
Top
Bottom
End Enum
And Sometimes I need to get the inverse, so it seems nice to write:
SomeDirection.Inverse()
But I can't put a method on an enum! However, I can add an Extension Method (VS2008+) to it.
In VB, Extension Methods must be inside Modules. I really don't like modules that much, and I'm trying to write a (moderately) simple class that I can share in a single file to be plugged into other projects.
Modules can only reside in the file/namespace level so I have one in the bottom of the file now:
Public Class MyClass
'...'
End Class
[Code]....
It works, and "if it ain't broke, don't fix it", but I'd love to know if I'm doing it wrong and there's a better way with less boilerplate. Maybe in .NET 4?
Finally, I know I could write a structure that behaves like an enum, but that seems even more backwards.
I am using Resharper 4.5 in Visual Studio 2008. Whenever I try to extract a block of code into a method, it tries to create a subroutine and not a function. The return type option is disabled. Does anyone have any advice as to how I can get it to create a function and not a subroutine?
View 1 RepliesIn 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 need to know what is the funcion of the below GetTooltiptooltippopup eventstoptimer methodAlso i need to know how can i let the tooltip works after remove all i mean how can i restore the tooltip work after the below code ToolTip1.RemoveAll()
View 2 Repliesi 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"))
I'm using VB6 and trying to get an instance of a Type Library object.After i retrieved the object and i'm trying to invoke a method. I'm getting this exception. However, i've checked with the parameters and its type. it is correct.I found something fishy, that method doesnt have return value. But it is throwing a compiler error whenever i'm trying to call the function and the compiler error went off when i get a return value from that method.I don't know,
View 1 RepliesI am not able to use Format function in a converted VB2008 project in VS 2010.
MSDN Documentation about Format function in not available for VS 2010.
Has that function been deprecated? If so, what is the alternative?
Let say I have a function inside a class which require 4 parameter (table name,field name,field value, return field) When I use this function my form, such as
myclass.Search("customers", <-- after pressing the "," a popup list will be displayed that contain all the fields in "customers" table.
It is really too bad that Microsoft (who once had the best documentation in the business) has slipped so badly. Good documentation does not really require analysis, though, admittedly, it is a lot of work. To wit: for each and every single method, function, event and operator provide the following: a brief topical functional description including any parameters, a detailed description of how the object works, a workable example of the code needed to make this object do something useful and links to all possible associated objects (See Also).
I see pages upon pages of useless text and links to other pages full of links. This rapidly descends into a crevace of unbelievable complexity for the developer trying to find out something truly simple like filtering a DataGridView without changing the data connection. (As it turns out this is very simple to do but I could not find a single example of how to do it in the Visual Studio documentation.)
with a system of regional date configuration as dd/MM/yy
isdate("13/08/10 10:00") ' returns true, but with a system of regional date configuration as MM/dd/yy
isdate("13/08/10 10:00") ' returns false
how to handle this situation, all i need is i want to check a string for convert able to valid date format & then convert the same.