m using a public variable called globalquery & a global function retriveToDataGrid() it works perfectly fine under same class /form ..... but when i try to access it from a different form , it gives no error and nothing happens
Public Sub retriveDataToDataGrid()
Try
Dim connStr As String = "Database=shahopticals;" & _
"Data Source=localhost;" & _
[code]....
I want my "textbox.text" variable of my main form to be accessible by my other forms. Can somebody please guide me on making that a global variable?
View 12 RepliesI would love to implement the asp.net routing but i have a basic question.
In my Generic handler i have the following Global class
Public Class MyHandlerRouteHandler : Implements IRouteHandler
Public Function GetHttpHandler(requestContext As System.Web.Routing.RequestContext) As System.Web.IHttpHandler Implements
[Code].....
I am trying to add a new global function
I am doing it like that:
Function MessageYNC() As String
{
return "dd";
}
[Code].....
But i am getting error -> Statement is not valid in a namespace. on the first line
If there's a way to have a function, that i can call from any code-behind on my website.
for example, i want to be on any page of my website, and be able to call this function[code]...
I want to create a global function to use throughout my application. Let say it's about the connection to the database.My code that i plan to use in my global function is:
myConnection = New SqlConnection("...........")
myConnection.Open()
So that I can call it to use in every form throughout my application. This can make me easy to edit the connection later.how to define this global function and how to call this function in the form.
Can't seem to figure out how to use a function return variable in global Dims[code]...
I have also tried adding "FixPath()" under Sub On_load() but got same result. Also the reason I have to have these global is because I have around 30 Subs that refer to "Path" Variable.
I want to create a new instance of a class when I click on a button, but I need to interact with members of that class using other controls on the form, so I need the class to have a global scope. I know I could call the new class in formload, but the class creates certain variables that need to be current. If it is done on formload, the variables wouldn't be current, because if the class is created at formload, it would have different info at that time. Surely, there must be a way to create an instance of the myClass from within a sub that is accessible from other subs of the same class.
[Code]...
i have a function that i have in my data access class now i want to access it then declare and assign parameters and then insert data into database?
'1
'the function
Public Shared Function InsertNewRecord(ByVal myStoredProcedure As String) As Boolean
Dim conn As New SqlConnection
[code]....
I'm new to VB.NET and want to parameterise the SQL Connection Strings in my VB.NET App. I've added a function to my Main Form to retrieve the App.config File like:
Imports System.Configuration
Imports System.Configuration.ConfigurationSettings
Public Class MainMenu [code]....
In my other forms when i want to reference the Connection String, i get an error saying getConnStr is not declared?
Private Sub UpdDept_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Try
myconnection = New SqlConnection(getConnStr()) <=============
Dim mycommand As New SqlCommand()
why i get this when i've declared the Function as Public?
I have some existing code that looks something like this:
[tag:cb cbid="12345" cbwidth="200" cbclassname="calloutbox" cbposition="left"] Lorem ipsum dolor sit amet, consectetur adipiscing elit.
[tag:cb cbid="123" cbwidth="200" cbclass="calloutbox2" cbposition="left"] Suspendisse eleifend enim a magna pretium porttitor.
I need to write a VB .Net global function that will match these [tag:cb] and take the optional parameters and rewrite the string with Html tags.
<div id="12345" width="200" class="calloutbox" position="left">content (based on id)</div>
accessing values using ODS. i have no idea how to make this work.
im using ASP.NET VB code.
Imports Microsoft.VisualBasic.FileIO
Imports IP2V2.DataAccess
Public Class LotIDParameterDAL
[Code]....
I'm a new user of VB.Net. I do have doubt on accessing a user defined Function or Sub. In some place of program, I do see the term "Call" when using the Function/Sub. In some other place without "Call". But both works perfectly. May I know the difference between the two.
[Code]...
I am working on this project and this question seems to be stupid, but I am not really getting the point.I have the following class:
Code:
Public Class ConnectedServer
Public MYPORT As String = "8000"
[code].....
I'm still learning so this might be completely wrong. I have built a multi-user web application for internal purposes. I have split my code up to make it more manageable and have run into some problems. I suspect that I have done something very silly!
I have a class in a separate file (quoteStatus.vb) in App_Code here it is:
Imports Microsoft.VisualBasic
Imports System.Data.SqlClient
Imports System.Data
Public Class quoteStatusHelper
[Code]...
This seems really wrong, as the value seems to be held in the partial class after the first run. So if I have two users accessing the class the public shared dim is changed for both users! There must be a better way to do this. I have looked everywhere and I'm more confused now than when I started off..How can I make QuoteStatus in the partial class unique to every user and access it from my code.
Here's what I've got:
<textarea id="TextArea1" rows="6" cols="20" runat="server"></textarea>
and in the code-behind:
partial class _Default : System.Web.UI.Page
[code]....
I am calling an Oracle function PKGDummy.F_EMPDATA using vb.net.
View 1 Replies[Code]...
i have a function that i have in my data access class now i want to access it then declare and assign parameters and then insert data into database.
A brief about the foundation of the program: I have created a VB2010 Windows Form application that connects to a Microsoft Access database. A datagridview is used to show all the data of the database. Then, a filter is used to filter the dataview (the BindingSource actually) and show the filtered db's data.
Let's say this is how I filter my BindingSource:
MyBindingSource.Filter = " price > '110' "
This would cause the dataGridView to filter the data (correctly), and let's say 10 rows are now displayed. What I am trying to do now is to get the sum of the values of one column of these new data. For example each of the 10 rows have a 'price' column which contains a double value. I would need the sum of these *filtered* values.
I found on the Internet that I may be able to transform the BindingSource into a DataTable and I could, but now I don't know how to access the values inside this!
I have my app that does some complicated function and adds some values to an array, but then later I need to access the strings, I have the index number but not the string so how can I find that string again?
View 2 RepliesI need to execute a stored function in oracle or sql through vb.net. I created a command object. Depending on the database type(oracle or SQL) i am preparing the Command text as Select functionName(?,?,?,?,?,?,?,?) from dual; (For Oracle) Adding the parameter values of the function. Now performing the ExecuteScalar which is not working saying invalid parameter. This works with ODBC connection string. But ODBC doesn't with 64bit. My Requirement: Code should execute a user defined stored procedure by taking the values at runtime.
View 1 RepliesI have a new solution with 5 projects inside. a data access layer, database, 2 class libraries, and the main form. These are all components that I had worked on to get to this point of combining into 1 solution. Now what I have run into is I can not the actual functions in the class libraries. I can get to the class level, but that is it. ere is a sample line of code I need to get working. Once I get this one line, the rest will be obvious: Temperature is on the main form. get for options is "Equals, GetHashCode, GetType", etc... Before this I had bult, compiled, and referenced these classes separately, and it worked fine. I know this is going to be an easy answer, I'm just not seeing it for some reason.
View 15 RepliesIm having a problem understanding if accessing httpcontext inside a shared function, without passing in the httpcontext as a parameter is thread safe?
Are the 2 functions in the util class equally thread safe?
Class foo
Sub main()
Dim qs1 = util.getQS(HttpContext.Current)
[Code]....
I have a camera for which the complete source code with header files(.h) and all libraries files(.lib) are given in VC++. Now if I want to access the function calls in the header files and in turn the functions in the library from VB.NET, I am required to write a wrapper DLL for accessing the function calls which I never did till now.
View 1 Repliesevrytime i add new controls to a form in vb.net the designer regenerates code and asks me to make corrections, so i have to keep on changing the object declarations to global using the 'global' keyword evertime it regenarates code,especialy dataset objects.how can i prevent this?
View 1 Repliesi could use Global x as string in vb6 in a module to declare it with global privelages, how can i do this in vb2008? how to declare a global variable in vb2008? so that i could use it anywhere i want. i know global variables are not recommended in programming but i need one.
View 4 RepliesI know that if you declare a function as a data type you can return a value, but my question is, is there a way to get back other values from a function without declaring it as an arraylist? For example, if you made a GetValues function, is there a way to get a value by using something like GetValues.A or GetValuesB?
View 3 Repliesi want to get two output values in one Function is't possible ?i am just using String data type and split the values.but have any other easy way to get two output values actually i want to checking a folder how many jpg files are Horizontal and vertical [code]finally i split the values with "|" character.have any other options to get two values as separate in one functions.i have no moew idea about Dictionary,
View 2 Replies[size="5"]How can I return two values from the same function?? I need to return an arraylist and an integer...the arraylist is already returning now i need to add the integer
View 3 RepliesIs it possible to return more than one value from a function? Like two integers, or an integer and a boolean, or any other data type combination. I understand I could use a sub and set these values in a variable but I was wondering if I could avoid declaring more variables by using a function.
View 28 Replies
