Equivalent Function In .net Framework 2.0 Of VBA?
Jul 23, 2009
I have VBA as a namespace in the vb6 code and i would like to know if there is a way of making .net know what there is, is there a specific application namespace? I have been guessing but haven't had any luck (the beauty of the help boxes, if only i knew more of the language)
If you're not living on the edge, you're taking up too much room
View 1 Replies
ADVERTISEMENT
Mar 4, 2009
VB has a function InputBox() that will prompt the user to enter a single value, then click OK. Is there a parallel functionality in ASP.NET, that will get the browser to pop up some kind of input box to return a single value? If not, how do you recommend I achieve this effect?
View 3 Replies
Jun 22, 2010
Tell vb.net equivalent of following method:
CODE:
Which on build in visual studio 2005 gives an error.
View 2 Replies
Apr 3, 2010
In Access if a query were to compute the sum of different fields where there is a likelihood of one or more fields being NULL, you use something like NZ. Is there any equivalent Function for handling NULLs in VB .NET?
I'm use the code below to retrieve the SUM of the column "BudgetAmt" from my DB but get InvalidCast Exception was unhandled error because the BudgetAmt and/or AllocationPersonnel holds no data:
Dim strSbCode As String = cboSubSubOrg.SelectedValue.ToString
Dim budgetYr As Integer = CInt(cboBudgetYr.Text)
personBudget = CDec(transDetailsDT.Compute("SUM(BudgetAmt)", "FundSource = '02101' AND DataSource = 3" _
[Code].....
View 6 Replies
Jun 1, 2010
I'd like to know if something like this pseudo code:
myVar = "functionName"
call someObject.(myVar evaluation)
which would then be equivalent to:
call someObject.functionName
is possible in VB. I know this is done in some other languages using a GetProperty method.
View 1 Replies
Nov 17, 2009
What is the C# equivalent function of IsNumeric() in VB.. If possible include an example.
View 4 Replies
Aug 22, 2010
im trying to port a small bit of code from c to vb.i dont know if this is c# or objective c or what.anyway, a line of the source i need to port is
for x = 1 to 31
a$ = LTrim(Str$(x))
i know what to do for the first line, but the second line doesnt make sense to me. what is LTrim supposed to do to x? also, what is the equivalent function for LTrim?
View 3 Replies
May 10, 2011
What is the C# equivalent of this VB code?
Private Declare Auto Function InternetSetOption Lib "wininet.dll" (ByVal hInternet As IntPtr, ByVal dwOption As Integer, ByVal lpBuffer As IntPtr, ByVal lpdwBufferLength As Integer) As Boolean
View 1 Replies
May 24, 2011
Does VB.NET have a function to get the quotient like you can in excel.
Quotient(12, 6)
View 3 Replies
May 27, 2010
tell vb.net equivalent of following method:
C# Syntax
public class RecentPosts : Control
{
[code].....
View 3 Replies
May 9, 2009
As a non .net programmer I'm looking for the .net equivalent of the old vb function left(string, length). It was lazy in that it worked for any length string. As expected, left("foobar", 3) = "foo" while, most helpfully, left("f", 3) = "f".
In .net string.Substring(index, length) throws exceptions for everything out of range. In Java I always had the Apache-Commons lang.StringUtils handy. In Google I don't get very far searching for string functions.
Edit:@Noldorin - My first encounter, although it took me several seconds to do the same in c#:
[Code]...
Note the static class and method as well as the this keyword. Yes, they are as simple to invoke as "foobar".Left(3). See also c# extensions on msdn.
View 6 Replies
Jun 18, 2012
what is the equivalent of Access DMin and DMax function in VB.net?
View 1 Replies
Jan 23, 2010
In cell A1 of Sheet2 I have the following text [code]how to I get VB to recognize that the 4<sup>th</sup> character of the string has character code 63?
View 3 Replies
Aug 31, 2009
I have an Excel VBA function that takes a number of optional parameters, including an optional Range:
Function DazBeta(A As Range, Z As Range, _
B As Integer, _
Optional Freq As Integer = 1, _
Optional c As Double = 0, _
Optional r As Range, _
Optional Pct As Boolean = True, _
Optional Label As Integer = 1)
I am translating to VB.NET, and it's the optional Range that is giving me grief because VB.NET does allow optional Ranges. Or rather, optional parameters must provide a default value. What is the recommended way to change the VB.NET function signature so that the code is callable from an Excel cell as a UDF? (The VB.NET implements a UDF, the assembly is registered as a COM server, and the Excel spreadsheet is told of this server and type library, allowing the VB.NET code to be called from an Excel spreadsheet cell.) I have other compilation problems, so I have not been able to explore this. I am thinking that accepting an optional Object (default value Nothing) might work and then I could cast the Object to a Range. Alternatively, if there were a default value that could be specified with an optional Range, that would work, too.
View 1 Replies
May 23, 2012
This question is similar to How to emulate MySQLs utf8_general_ci collation in PHP string comparisons but I want the function for vb.net rather than PhP.Recently I make a lot of supposedly unique key.Some of the keys are equivalent under UTF8 unicode collation.For example, look at these 2 key:
byers-street-bistro_38.15-79.07
byers-street-bistro_38.15-79.07
If I paste that into front page, and look at the source code you'll see
byers-street-bistro__38.15_-79.07
byers-street-bistro__38.15_-79.07
Note: In stack overflow they still look different.I know it's not the same. I guess even in stack exchange it doesn't show. Say I have 1 million such records and I want to test whether 2 string WILL be declared the same by MySQL UTF8 collation. I want to know that before uploading. How do I do that.So vb.net think that those are different keys. When we created mysql query and upload that to database, the database complain it's the same key. Just one complain and the upload of 1 million databases will be stuck.We don't even know what the hell is ? Where can we look that up anyway?Anyway, I want a function that when given 2 strings will tell me whether they will count as the same or not.If possible we want a function that convert strings into their most "standard" form.For example, seems to encode nothing and the function would recoqnize all those nothing character and eliminate that.Is there such thing?So far this is what I do. I need something more comprehensive.
[code]...
View 2 Replies
Jun 8, 2009
I have the following function which is used by a class. It sets dates. Now the problem I have is one date comes back as dd/mm/yyyy and the other as mm/dd/yyyy
View 2 Replies
Apr 14, 2012
Easter day is determined based on astronomical events. Is there a "date" function or something similar that can be used in Visual Basic programming to project such a day?
View 4 Replies
Feb 23, 2010
I have a generic repository that I communicate with my object context with. My object context has function imports that I want to be able to call through my generic repository. Currently I call them through an "Execute" function, but this is not ideal because I have to pass in my function name and parameters as strings which can cause run-time exceptions. My function imports map to complex types.
Is there a way to do something similar to:
Dim rep As IRepository(Of ComplexType)
Dim type As ComplexType = rep.Find(where:=Function(t) t.FunctionImport(parm, parm)).First()
Here is my generic repository as is:
[Code]...
View 1 Replies
Apr 11, 2012
I have the following code:
Private Sub setDropdowns()
Using licensingModel As New licensingEntities
[code]....
My problem is that i dont know how to define the parameter type for the sub. Because they are different types of objectSets being passed each time, I thought IObjectSet(Of EntityObject) would work, but it gives me the following error:
Unable to cast object of type 'System.Data.Objects.ObjectSet1[licensingModel.tblLookup_Country]' to
type
'System.Data.Objects.IObjectSet1[System.Data.Objects.DataClasses.EntityObject]'
View 1 Replies
Sep 13, 2010
After checking an Xps file i noticed that the string within the Xps file <> is converted to <>So is there any built-in function in the .Net framework that could do this job for me?If it does not exist what characters becides <> should i escape in myOwn function?
I try to implement a search within an xps file, but searching for <> instead of <> returns nothing.
UPDATE: At least i found the list here of xml document escape characters
View 3 Replies
Jan 31, 2011
I want to execute the code that is passed as a string to my function, the code will be passed at runtime. This is an example code that may be passed as a string to my function. p is a dataset, which is declared and has some values, this code is executed in a asp.net page
p.Tables(0).Rows(0)("disp_status") = "Approved by CEO";
p.Tables(0).Rows(0)("status") = "Approved";
Session("fnc") = "generate po";
[Code]...
View 1 Replies
May 21, 2010
I am work on VB.net 2003 Framework 1.1 for last 3.5 years in windows Application.We are currently migrating to VB.net 2008 framework 3.5, but i don't know about the features which related to ADO.net and which is important to performance. I know linq to SQL but our architecture is made in .net 2003 so we should follow this.Any features which is very important to enhance the performance?
View 2 Replies
Feb 2, 2011
I have a solution that I wish to upgrade from Vb.net framework 1.1 to framework 4.0. The solution consists of a number of projects, all but one of which compile to dll's. The master project compiles to a executable which provides a menuing system which dynamically loads the dll's and connects to entry points.
The projects contain normal classes, numbers of forms and also controls, which are either usercontrols or are inherited extensions of standard windows controls.There are a number of third party components (eg reporting and grid controls from Component One, Ribbon control from DevExpress etc).
[Code]...
View 4 Replies
Apr 7, 2009
How come software created in an older framework version won't run on a newer framework version? Actually whenever i try to run some old specific software having .net 3.5 framework on my PC they show they needs .net framwork 1.1 . What a bad thing?My newer version of Photoshop ans Ms office open all lower version files.
View 6 Replies
Nov 24, 2011
I work for a small company and we are planning to build our own framework using .net . For example if a dropdown is placed in the form and set the custom property to Users, then the users list from db from has to populate. The developer will drag and drop the custom control and set the connection string in config file. Other things are to be managed by the framework.
View 4 Replies
Oct 12, 2011
I want to make an numerical integration method with takes in an analytic function and integrate it over a specific interval. For the numerical integration procedure I want to use some procedures in nr.com. The problem is that these are programmed in C++ and they uses functors to pass a function to the integration method. How can I do this in VB 2010?
I want to initialize the function (i.e. set a=1,b=0 for function y(x)=a*x+b) and then pass the function to the integration method. Then when the integration method call the function it only calls the function with one parameter (i.e. x since a,b is already set)
What is the best way to do this in VB2010?I want to make a general integration method where I can pass any single valued function and integration limits.
I have just started using VB, and from what I have found so far it seems like the tools you have is
- to us a delegate for the function
- to use a lambda expression for the function
- send a pointer/adressOf
- to create a function class/structure and submit this to the function
As for now I am most inclined to create a function-class. But I am not really sure how.F.ex. I make different classes for each "uniqe function" I want to integrate, but how can I pass them to the integration function when I need to specify the argument type in the integration-function-call?This seems like a basic problem which applies to many Math operations, so I think it would be very useful to clarify this.
View 2 Replies
May 13, 2010
c# - Are Microsoft Entity Framework and ADO.NET Entity Framework (.edmx) the same?
View 7 Replies
Apr 1, 2010
I'm trying to undersatnd the syntax of calling a funciton and it seem confusing when I'm using a web service in ASP.net. Maybe this question should be in an ASP forum, but it is a VB question. This simple web service allows you to type in your name and it response with an alert box with you name.
My question is, How can you call a function with 2 arguments when the function is only defined for one. I understand that the second argument is actually a method that handling the respons, but how can you interchange function arguments for methods and how do you know that there are methods for
Here's my call:
<script type="text/javascript">
function HelloWorld()
{
var yourName = $get('txtYourName').value;
[CODE]...
View 7 Replies
May 25, 2012
I am trying to convert a DLL function call which has the Callback function routine called within the DLL function call.The DLL function call signature is like this:
typedef void *HANDLE;
typedef HANDLE HACQDESC;
DECLARE_HANDLE (HWND);
[code]....
how to convert this DLL call to VB.NET and also how to create the callback function and send it as parameter to this function
call.
View 15 Replies
Aug 1, 2009
i wanted to ask how to make picturebox1 ,to which functions are already assigned, perform the same function as picturebox2 ,to which no functions are assigned.For example:I have already made picturebox1 and have assigned it alot of function like when play button is pressed then picturebox1.visible = true and when we press pause button picturebox1.visible = false. So now i decided to make a theme and have to remove the picturebox1 and want to allow the picturebox2 to havefunction of picturebox1.But when i disable the theme the function of picturebox1 should go back to picturebox1.
View 6 Replies