I have an input box that allows users to enter a date that when the user clicks "Ok" that it does two things, marks a field called "code" in my Exceptions SQL table as H and passes whatever date they have entered to that table as well.
View 1 RepliesI am a total beginner to Visual Basic and have a project to conduct a survey for my company. The Answers of the users need to be populated to the database. So far, all I've managed to do is to define a string which will have the answer to be updated into the access table. How am I supposed to pass the value?
View 2 RepliesTrying to make a vb.net program that is able to read values from an access database and pass them into some data sets. Here is the code I have so far, with the error line between the two dotted lines:
[Code]...
How do i get data from a database and put it in to multiple text boxes?Basically i have abilling form with; name, address, etc.But i have a 'retrieve' function underneath which allows a name and post code to be entered and then the information above is automatically filled in if the name and post code exists. At the moment i just setup a connection with the variables. not sure how to do the rest
objCommand.Connection = objConnect
objCommand.CommandType = Data.CommandType.Text
objCommand.CommandText = "SELECT CustomerName FROM Customer WHERE CustomerName = @CustomerName AND PostCode = @PostCode"
[code]....
I have a winform with richtextbox. I want to get the user input values in any window like chat programs(msn,yahoo,gtalk), Ms Word,...etc, and set the values into richtextbox?
View 3 RepliesInput a range of numbers and sort them into 6 equal amounts and then having the program tell you which amount the number was put into?
I.e
Input:
1200, 2400, 600, 600, 300, 300, 1200, 1200
Sorted into:
Group A: 2400 = 2400
Group B: 1200 + 1200 = 2400
Group C: 600 + 600 + 300 + 300 + 1200 = 2400
I have a stored procedure with two input and one output parameters. I need to execute the stored procedure from VB 2008 code passing it two parameters and returning the output parameter. How might I go about doing this? I don't have how to do this. Newbie here.
View 1 RepliesIm trying to pass a value of a date control from form1 to form2.on form 1.aspx.vb:
Public ReadOnly Property Property1() As Date
Get
Return StartDate.SelectedDate[code].....
Tried to assign the property to a string, it did not work either.
I have a form with 2 dropdownlists and a submit button. I want to pass the values of the lists in a URL when the list is submitted but for some reason the initial value of the ddl is getting passed. Here's my code:
[Code]...
I think I'm getting hung up on syntax here. I've got 2 forms and am trying to pass a textbox value from the 1st form to the 2nd. The textbox value is an unique ID #, so it's an integer value in the database. The ID displays in the textbox just fine on the 1st form. When I try to access the value of this ID textbox in code in the 2nd form, I see that the value is empty, or equal to "". But I see a valid ID # on the 1st form. Here's the code that shows me that the textbox equals "".
[Code]...
solid rundown of how this process works using custom events &EventArgs, Im really having trouble wrapping my head around it
View 14 Repliesi have a listview control on form1. I want to send the selected value to form2.
I tried couple of ways but nothing seems to work correctly.
I'm pulling up a a webpage in a control and the page is full of Java functions. I'm able to use execute a function using invokescript. That works out really well. But here's the thing. There's a function that takes the value of a rendered textbox and uses that data to perform the function.The textbox is usually hidden until another function activates it to enter data.What I want to do is to bypass having the textbox come up and execute the function with predefined data. Basically the function refers to the data it gets as txtWrapupComment.value whereas txtWrapupComment is the textbox it's getting its data from.
So, the bottom line, is there a way I can declare txtWrapupComment.value and pass it before I execute the funtion?
basically, i get "Object reference not set to an instance of an object" on the line:
example Dim x As Integer = objPlayer.Hand.Count
this line is in the object Dealer, but as far as i can tell i've declared everything correctly ...
i was told that i had to pass the values to the object or something, but not how to do it
I have a simple query but I am just not able to get it right. Have a look at my sample code below:
Sub Function1
My Code Here
Function2(Year,Month)
End Sub
Sub Function2(Year,Month)
Dim Str as String()
for 1 to 30
Dim MyDate As New Date(Year, Month, i)
Str = MyDate.DayOfWeek.ToString()
Next
Return Str
End Sub
My problem is that I have two forms, Form1 and Form2 ...on Form1 there is a TextBox called txtTotal (this contains the calculation of Ticket Prices, thus it's a numeric value) and on Form2 there is a TextBox called txtTotal2. All I want to do is get the same number that appears in txtTotal on Form1 to appear in txtTotal2 on Form2 .However whenever I try some of the help tips online such as using a declaring txtTotal as global or friend it dosn't work, and any other code iv tried attempts pass the textbox value as String which brings an error.
View 2 RepliesCan anyone give me the best method of passing back a value from a Thread?I have some procedures that I have set up as threads that I'm starting at the same time.My main function then waits until the threads are done and I'm needing to get back some values that the threads have created.Is there a better way to get these values back rather than just having them set a global variable with the returned value? Also, what is the proper way to wait for a thread to to be completed?I've just got a loop waiting for the Thread. Thread State property to not be in the Running state.So if there is a more proper way to wait for the thread to end I would be interested in knowing it.
View 7 RepliesIm having a hard time trying to pass the values from a list inside of a class. Im trying to display multiple lines of values from a list inside of a class. My "client" class stores multiple lines of values into a list(of class transaction), with the number value(num) counting each transaction that it adds to the list.
Code:
Public Class Client
Private m_tranlist As New List(Of transaction)[code]....
im trying to display each line that is stored in the list in a label, and im having major trouble. I know all of the results are added into the lists, but how do i call the list in my main form in order to display each line of all of the values? Would I have to look up an index or something?
This may not be the place to ask this, if not, you can move this post to the SQL forum but I have an application that I'm building which pulls dates from a database. The start value is stored as payPeriodStart date and I add 7 days to get the end date. What I need to know is, is it possible to store those values and pass them to a Stored Procedure? Currently my stored procedures have "static" dates in them ie:
where dateadd (n, Timestamp, '12/31/1899') - ([LoggedIn]/1000)/60/1440+1 Between '10/3/2010' and '10/10/2010'
and I'd like those values to be
Between payPeriodStartDate and payPeriodEndDate.
How do you pass values using a basic event handler:
'...
dropDownItem= New ToolStripMenuItem("item1", Nothing, New EventHandler(AddressOf clickHandler(1)))
'...
Public Sub clickHandler(ByVal sender As Object, ByVal e As System.EventArgs)
'dim i as integer = e
end sub
I have an application that I'm building which pulls dates from a database. The start value is stored as payPeriodStart date and I add 7 days to get the end date. What I need to know is, is it possible to store those values and pass them to a Stored Procedure? Currently my stored procedures have "static" dates in them ie:
[Code]...
I am struggling with trying to pass values to a stored procedure, I am creating new records on my table by the values are not passing to the table.Here is my persistance class.
Public Function createDMRIssue(ByVal ItemNumber As String, ByVal IssueStatus As String, _
ByVal ProblemDescription As String, ByVal p_AuditResults As String, _
ByVal DMRDate As String, ByVal p_IssueCategory As String, _
ByVal p_DMRInitiator As String, ByVal p_QtyUnacceptable As Integer, _
ByVal p_ProductType As String, ByVal p_OrderNumberm_dmrissue As String)
Me.Connection()
[Code]...
I am trying to pass values within a repeater binding them to a button and pass them from this form to another form. When I compile this it gives me an error indicating.
System.FormatException: Input string was not in a correct format.
Button within Repeater Code in form1.aspx:
<asp:Button ID="Button1" runat="server" Text="" CommandName= "TEST" CommandArgument = '<%# Eval("Parking_ID") + "," + Eval("Parking_Name") %>' />
In form1.aspx.vb Repeater_ItemCommand Function:
Protected Sub repeater1_ItemCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.RepeaterCommandEventArgs) Handles repeater1.ItemCommand
If (e.CommandName = "TEST") Then
Dim commandArgsAccept As String() = e.CommandArgument.ToString().Split(New Char() {","c})
[Code] .....
how to use a String Array for passing Values
View 3 RepliesI am trying to get into vb.net but having an issue getting a variable value from a class library in a different thread.
What I am trying to do is create my own Winsock type control for my own use. Once data arrives I try and pass it back to the main application so that I can read it and process it.
So far I cant get it working at all. I have tried the following
Raiseevent
I try passing the value as a variable in the raiseevent property. This triggers an error about the value being in a different thread, I always thought that it would create a new variable in the thread of the application it was raising an event in and copy the value.
Function
I have tried writing a function into the class that I call (much like how the winsock control works) so that the class can return the value to the main application.
aka
strData = Myclass.GetData
in the class it returns the value and clears it from its own local variable. This however means the value returns to the main application as nothing even if I step through and see it assigning a value.
I have a very simple windows forms setup. Form1 has a progress bar and a button on it, when clicked the button opens Form2 which also has a button on it that launches Form3. On Form3 is a button which I want to use to raise an event back to Form1.To achieve this can I add an event handler on form1 that will listen for an event of the type raised in form3? Or do I have to pass references to form1 to form2 and then from form2 to form3?
View 1 RepliesI am building VB.NET application that takes data from text files that are exported from a legacy DOS program. These are written to a datatable and displayed in a datagridview. Right now my code simply loops through the datagridview and inserts the data into the database (SQL Server). There is a requirement now that the client number must be checked before the insert to see if it exists in the database. If it does, then the value of one field (tax rate) is checked against the value of the field in the datagridview. If there is a difference, then the rate is to be updated in the database and the data that was in the database is to be written to a history table for audit purposes. If the client number is not there, then we are to do the insert (which is already written). I want to know what is the most elegant and efficient solution for this problem.
I need to compare what is in the database table with what is in the datagridview, update the history table for records that exist, and then insert new records.
I have the following code to validate two text box entries to make sure that they are valid dates. My problem is that I cannot figure out how to pass the text box value as an argument so I can use the method to handle the text validation of two different text boxes. Here is what I have so far:
Private Sub txtBirthdate_Validating(sender As System.Object, e As System.ComponentModel.CancelEventArgs) Handles txtBirthdate.Validating, txtSpouseBirthday.Validating
Try[code].....
I am trying to work with classes and variables and don't seem to understand some behavior that is going on.
first off the class
Public Class csSession
Public ID As Integer
Public Name As String
End Class
Usage and behavior (example code)
Dim S1 as new csSession
Dim S2 as new csSession
S1.ID = 1
S1.Name = "1st Session"
S2 = S1
S2.ID = 99
When I assign S2 = S1 all the values of S1 passes to S2 but also there is a "link" or bond between the two variables now. If I change the values of S2 this automatically changes the values of S1!! Why does this happen and how can I prevent it? I just want to pass the variables values contained S1 to S2.
I have to ask a stupid question:How to pass values from my form into the controls of other form?I made textbox and button in my form1 and Label into the form2 When I click the button, I want to pass the values of the my textbox in the form1 into the labels of my form2
I am a student and totally new to vb.net