But in my application i need to pass the ID of my Client (company) to fecth it's businessName. So first i've written a storedprocedure to return it's ClientID searched by BusinessName, then i pass the ClientID to fetch all the other details of the client such has his contatcs...etc....
Therefore currently i use two stored procedures to one i pass the businessName then i will return it;s ClientID then to the other i pass the ClientID then it will return everything about the client (beucase client was indexed on clientID)
Is it possible to write only one stored procedure to perform the two operations..
Table2 should be updates from table based on the results... If all results is PASS then the table2 should be updated as pass... if any result is FAIL then the entire case_no should be updates a s fail..
This code was working consistently, but now...This code works on the first pass.Then second pass it just hangs on Code:Dim tcpClient As TcpClient = tcpListener.AcceptTcpClient() for about 2 minutesThen the code will fork for another pass, then fail.....
Just started VB programming this week and have found a wealth of information about what I'm trying to do. Problem is, some of it is more complete than others.Here's what I'm trying to do:In Form1 (my main form), I want to instantiate a class that contains a couple of properties (speed setpoint and position setpoint). When I click a button, I want to pass this data to Form2 and populate two textboxes on Form2 with the properties of this object. I want to manipulate the property values on Form2 and click an OK button which closes the dialog and returns the manipulated data, updating the property values of the object. Here's the algorithm I'm following:1) On Form1, instantiate the class2) On Form1's "Pass Data" button click event handler, instantiate a Form2 object and invoke the ShowDialog method, passing the object as a parameter.
3) On Form2, overload the ShowDialog method to accept the object as a parameter and modify the method so that it returns the manipulated class data.4) On Form2, in the ShowDialog method, populate the textboxes with the class data that was passed in.Here's where I get stuck. If I press the OK button on Form2 (DialogResult.OK), it returns me to Form1, but what hook do I have in Form1 to receive the manipulated class data that the ShowDialog method is returning?Here's an example of what I'm thinking about:
Code: Public Class Form1 Dim clsController1 As New MotionController
[code].....
I'm sure it's probably a very elementary question, but every explanation I've found seems to be incomplete.
I am looking for some input. I am helping with a web application that is fairly large. We have some logic factored out into classes, not a true business logic layer (yet ). The classes are setup to pull values directly from the QueryString or Session variables and I'm not sure that that mehtod is proper or even a
The reason I would like some input is, there may be a chance to rewrite or at least refactor the code.
Im a student doing an assignment, how do i pass the value from a sub procedure to a function procedure....i want to pass the value from decSubtotal to a function procedure named CalculateDiscount; check out my code--
This code copose from Class including tow sub first sub to insert data in DB Ms access- second code: to check if there is same number of Tel if there is not same number will excute the first code insert, if there is same number of Tel it will show messagebox the problem that I faced is by how to pass object(InsertData) from CheckN sub. It showed me error : Expression is not a method
If I want to use a FolderItem verb like 'Copy to folder', then I have to somehow supply the name of the folder to which I want the object copied. How is this done. I dont understand how msdn can be so minimal on examples.
Suppose I save a file as *.tar (this extension is my own making) using a vb6 program.Now when the user clicks this file, the window asks 'with what program to open this file' and he/she selects the exe of my program. Now I want to pass the name of file clicked to my program. Like when we click *.xls file, the exe of Excel program knows which file has been opened or clicked. Is there a way?
Can any one please tell me why the following code is not giving me the expected result Application type as Class library Form with 1 text box and 2 button
form1.vb Public Class Form1 Private Sub button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim cl As New WindowApp.Class1
ok to start i know very little about VB6 but i am very good in true basic lol (stupid school teaching the wrong language -_-) anyway im just asking you to make the answer as clear as possible because i don't know very much. heres the problem . ok in the above example i have a button that (for my example) can be used to build a house (lol) i then have a variable in the button sub called money which will have 150 subtracted from it when the button is clicked my problem is it say variable not defined when using this button ... i have declared the variable in a module and in form load along with my other 50 or so variables. my question is how do i pass the variable into this sub and then send the new value back into form load so it can be sent into another sub for more calculations.
Public Sub GetUserAmount(ByVal ConnectionString As String) Dim command1Text As String = "SELECT Wager FROM Donations1 WHERE DonationId = (SELECTCOUNT (BidCountHistory) FROM BidCountHistory)"
I have the following sub which works for the type "Button". I would like to make it general by having a parameter that is assigned a type rather than "Button" being hard wired. Can this be done? How do you pass a type? I tried the parameter "ByVal t as Type" but the compiler complained when I used t as a type and I also tried inserting (Of T)but the compiler complained about CType(control,T).
how add type as an input to this sub?
Public Shared Sub Example(ctrl As Control, items As ToolStripItemCollection) For Each control As Control In ctrl.Controls If TypeOf control Is Button Then Dim butt As Button = CType(control, Button)
Assuming that I have a datagridview or a listview populated by value (form 1), then here I have a command button to edit (form 2, details in text boxes) a selected record from the grid or listview, now, the edit process is done, how can I then, pass these values to datagridview from the other form (form 1) and update or refresh the grid then close the form 2 as if it is not been opened?
Passing a value through radio buttons that are in group boxes, this is a project that is upgrading an old program so I already have formulas for figuring out all the rest of the program I am just stuck with how to pass these values to the formulas.[code]...
I am currently trying to teach myself how to program VB.Net in Visual Basic 2010 Express.I've been working on a little project for a while and have hit a wall. Normally I can find what I need online but I am now at a complete loss. Essentially I am trying to pass a pair of variables from Visual Basic (file names actually) to VBA so that I can copy/paste data from them using VBA. What I need is to find out how I can pass variables (in string form) back and forth between VB and VBA
I need to pass data between a vb6 app and a .net app. This data will either be written or read every second. It is about 30 fields. Both apps reside on the same machine. I am currently passing this data via the registry and it works great but it makes me a little nervous. I would do it with a text file but I am worried about data loss.
Is there any way to pass in an operator in VB.NET? I'm looking to reduce my lines of code and for two functions there is literally only an operator that is different.For example, I have two functions, Darken and Lighten. I'd like to get to a single function with as little code as possible. The only difference are Greater Than and Less Than operators.
Function Darken(ByVal clr1 As Color, ByVal clr2 As Color) As Color Dim newR = If(clr2.R < clr1.R, clr2.R, clr1.R) Dim newG = If(clr2.G < clr1.G, clr2.G, clr1.G)
I have created an application which consists of 3 Layers: GUI-BLL-DLL. When I am loading a flat file I am doing this in the DLL but I want to show to the user the process through a progress bar in the GUI. So I want to pass the variable LineCounts from the DLL to GUI. I know that I have to use EVENTS
