I have read many post and none of them worked for me. This is what im trying to do. I made a login box in form 3 and when the user types in his login or pass word both gets saved to different Variables and I want to send to form 2.
[Code]...
Also I was wondering If I made a variable in form 2 and I access it from form3 and what ever value is in form 3 gets sent to form 2?
I'm attempting to pass in a collection of dates to a T-SQL 'IN' clause via a date array (see below for how data is collated).
'Workout weeks difference between start and enddate
Dim wksDifference As Integer = CType(DateDiff(DateInterval.WeekOfYear, bookingStartDate, bookingEndDate), Integer)
[code].....
I need to pass a double from form1 to form2 and have form2 return this value back. My problem is while i can receive the proper value in form2 i can not seem to get the corrected value back in form1 (using byRef in form1). Here is the code snip
Dim AmountPaid As Double = 8
Dim newInvoiceRow As InvoiceDataSet.InvoiceRow
If (MakeAPayment.ShowDialog(AmountPaid) = Windows.Forms.DialogResult.OK) Then
Form1 is a Datagridview which is non editable. I want a user to be able to double click and open Form2, which will allow editing BUTForm2 is a list view and also had a binding navigator so I guess I cannot use dialogue? I do not want to simply just edit in a dialogue and save.Is there an easy way to get the record from Form1 and pass it to the controls in Form2 so that the correct record is displayed?
View 5 RepliesI am trying to pass data between forms on a double click operation. On Form1, I have a simple database with three fields (ProfileID(PK), Profile First, Profile Surname). The database has 10 records at present which displays all records in a datagrid view which is set to read only. I have the Selection Mode set to FullRowSelect to highlight the full row.Form2, is a form to Display one record at a time. This form allows editing and saving of changes.How would I go about coding in vb.net to firstly get the ProfileID from the relevant row and send this into Form2 to display that record for editing?
View 10 RepliesImagine a project with couple of forms and a module. Now as per my knowledge if i want to send some data from one form to another then :
- If I declare variable friend/public in a module then it can be accessed in the entire project (thus also between forms).
- If I just have to send data from one form to another, then I can call the other form's sub/function and pass value.
- If the pass value by reference then I can get new value only if its changed in that function.
Now what the issue is, I need to pass a variable to a form and in that form when user types contents in a textbox or makes other selection and presses OK button then it should return some values back to the calling form. Now how can I achieve this (without declaring global variables which will be accessible everywhere) ?
To start things up, I have a DLL called clsEmployeeModule, containing forms frmEmpInfo and frmAddEmpName. frmEmpInfo contains a textbox that when clicked displays the frmAddEmpName. Now the latter contains three textboxes (firstname, middlename and lastname) and a Save button. Once the user clicks Save, the values from the three textboxes will be concatenated and displayed as a full name back in the frmEmpInfo form.Below is the code snippet calling the frmAddEmpName:
vb
Private Sub empname_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles empname.Click If genInfo_edit = True Then call_addempname.Text = "Edit Employee Name" End If call_addempname.Show() End Sub
And here's the code snippet from the frmAddEmpName:
vb
Imports clsEmployeeModule Public Class frmAddEmpName Dim callempinfo As New clsEmployeeModule.frmEmpInfo Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click mnFname = firstname.Text
[code]....
When I debugged the program, it showed that employee_fullname was successfully populated with the concatenated values -- however, that wasn't the case for the empname textbox.
Im looking to pass information from a number of textboxes in one form to a number of textboxes in another form using Visual Basic 2008.
View 2 RepliesPassing data between forms without any public methods or properties on the forms. everything but the "Controller" class, which I would like you furnish. I just changed the title from "Intermediate" to "Beginner" This solution is an example of the Observer Pattern. The "Controller" class is the "observed" class, which in this case means it publishes events.
' File Definitions.vb
Public Delegate Sub MessageDelegate(ByVal sender As Object, ByVal e As MessageEventArgs)
Public Class MessageEventArgs : Inherits EventArgs
Public Message As String
[CODE]...
The program should initially display Form1, and Form2. Clicking of the button on either form will modify the Title Text of both forms. I think that you will find the final end result to be pretty neat, as it works with any number of open forms not just two. I think asking for the Controller class is easier than asking for the code in the forms. My solution for Controller class has 7 lines of content, 9 lines if you include Class, EndClass. A minimal solution could achieved with only 4 lines of content, but it would a textbook example of bad programming.
I'm upgrading a project from VB6 to VB2008.I have a routine that clears a combo box, named 'cmbDataTable' which could be on any form. I pass the form and the combo box is cleared.
[code]...
I assumed it would be the same in VB2008 but I get the error.'cmbDataTable' is not a menber of 'System.Windows.Forms.Form'I am working my way through the project, first updating the global procedures - this is one - I haven't written the calls so cmbDataTable doesn't yet exist.
I use the code
Dim Selvk As New Selvkost2
Selvk.PassedText = TextBox29.Text
Selvk.Show()
[code]....
in my second form and the text passes. but I need to pass values from 20 textboxes. do I have to copy the code in my second form 20 times an declare passedtext2 and so on or is there an easier way to do this?
This is my first Windows app to create since VB6. I've been in the world of ASP and ASP.NET for many years. However, now I have been asked to create a simple app that needs to be windows based.
[Code]...
I m using VB.net 2005 and MS Sql 2000.In my database date is in format of 2007-07-09 11:02:47.000. date&time.
When i m using the filter condition to get the record by passing date.it gives me zero record.
Can tell me what is the format of date to retrieve value in VB.net 2005.
I am getting error when debugging a project. The error is as below,
"FormatException was unhandled
String was not recognized as a valid DateTime."
Highlighting the following line
[code]...
Form2 will need to get a transaction date from the Form1. The date will be saved into Form2a can passing text from Form1 to Form 2, but has a problem to save the date at form 2
<Form 1>
Public Event ItemSelected(ByVal Item As String)
Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As
[code].....
I want to pass a date as parameter in vb to query the data from the table.If I hardcore the value in the query it works fine for me, but if I pass it as parameter to query, like I am getting the data from edit text and trying to send that as a parameter, this does not work.
SELECT *
FROM VehicleAnalogParamDownload2
WHERE Vapd2_Date between 'From_date.Text' And 'To_Date.Text'
I have a form that collects user parameters to print a report. There are two DateTimePickers to let the user select a date range for the report. The selection of a date range is optional so I set the From picker to a date before any data could be present. If the user wants to select a date range, the from field is set to a very old date so it takes a long time to get to any current dates. Whe I'd like to do is when the user drops down the picker, reset the date to today and let the user scroll from there.I tried the dropdown even in the picker, but the new date doesn't get set until the user has already selected a date. Any suggestions on how to get this type of UI behavior? Also any better suggestions to streamline the process?The main objective it to collect from and to dates from the user is they want to select them and collect wide ranging dates if the user doesn't enter any.
View 2 RepliesExample Form1 with data bound controls and a Public Variable Form1Var.Form2 with data bound controls and a Public Variable Form2Var DataTables are related Form2 Data is related to Form1 Data in a one-to-many.What I am trying to accomplish.When editing Form1 data there is a button to open Form2 if new data needs to be added. on closing Form2 I would like Form1 to remain at the state it was in before opening Form2. If I Change Visibility of Form1 when Form2 is opened upon Retun to Form1 Data is reloaded, if I minimise Form1 when Form2 is opened upon return to Form1 Public variables are reset to defaults.I have many Forms with many controls and buttons to do Lookups or additional add to related tables.
View 2 RepliesI have a gridview on a form pulling user data. I have also created a basic login system where users login and their username/password is checked against a table in SQL Server 2005.The gridview is on Form 2 but i am having great difficulty in returning the records in the gridview for the user that is currently logged in.
View 3 RepliesI'm getting a little fustrated, ive been trying to figure out how to allow my main from access to a sub form. what I'm initially aiming for is control of text and font color via a dialog on the main form and the results to appear on the second form, if that makes sense. Most of my knowlege resides around using VB.net for creating games and not progams. ill post the code so you guys might be able to get a better understanding of what im looking for as a result.
[Code]...
My scenerio is a form with a button, when clicked opens a form dialog. The dialog allows the user to enter a text box. I want to read the value of the text box from the main form into a variable to be used with an SQL statement. The following code is used to create a new instance of the form dialog if one does not exist:-
[Code]...
I seem to be running into an issue. This may seem like a noob question (which it really is, I only have experience in vb6 from years ago) but what Im trying to do is pass a variable from one form to another. Ive tried telling the first form to set the value of the variable on the second form like so frmsecond.variable = "value" but that does not work. Ive tried placing a public variable in a module to do it, but again, no luck. The only way seem to be able to get it to work is the second form setting the variable by reading the value from the first form like so [code]The problem I have with that code is what if for some reason the selected line gets changed as the form is loading or something to that nature. It doesnt seem very secure.
View 5 RepliesI need to pass date range parameters to a crystal report from a vb.net application, but I don't know how to. I have a crystal report that pulls data from an oracle database. In the database, I have a table of students, and each record has a birth date, name and surname. I need to display on the report only records where the birth date is between date X and date Y inclusive of both. Date X and Date Y are dates passed on the vb.net application when opening the report. I am using crystal reports 9, visual studio 2008 and oracle 9i.
View 1 RepliesThe date time picker control does not seem to be passing on its default value (which appears to be 'Now'), when bound to a datatable and then saved. I have to select 'today' or pick another time from the popup calendar for that date to be saved.
View 1 RepliesJst recently i came across the select() method of data table and felli n love with it instantaneously.
Basically I want query the data table on a date field, unfortunately the format of the date string returned from y database in to data-table and the date string i'm passing as inputs are different.
How can i make sure that the data is compared irrespective of the formats ? Can I use something like SqlParameters whoes data type is date for comparison ??
this is what i'm tying :
dim dat as date = "#1/3/2009#"
dt.select("StzDate ='" & dat "'")
entry in datateable dt : StzDate : 3/1/2009 12:00:000
Am I do'in something wrong ??
Also, can anyone redirect me to some site where I can learn a bit more about passing parameters to the select statement,etc...
i'm not 100% sure about sql server but i think it doesn't accept null value for date type columns but in oracle, a date column can accept a null value. and since i'm using oracle, this is causing some problems because in my form, a textbox item bound to a date column will not accept a null value. reading thru some threads, it would seem that it is not possible to pass a null value to a date type in .Net.
[Code]...
I am trying to do a really simple function (atleast it was simple in 6.0)... what I want to do is have two forms. One with a textbox, and one with a button and a textbox (we'll call this one form2). When I add a value to form2 and click the button I want the text to appear in form1's textbox.
My code in form2 is...
' on event button1_click...
form1.textbox1.text = me.textbox1.text
("me" being form2)
Anyways, how to pass a value from one form to another.
Im 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 2 forms. Using Visual Basic.On Form 1 there is a populated combo box. This was done so by running a query through it and populating it with PUZ_ID values from a data set.On form two there is a tool strip and below is a search query.I need to be able to select the value i want in the combo box on form 1, and launch a button that opens form 2, which has loaded the data that i binded onto the form.Anyone have any ideas/code or need me to clear this up a bit more?So i need to run something through a query, or make something public or what?
View 2 RepliesI have 2 forms. Using Visual Studio.
On Form 1 there is a populated combo box. This was done so by running a query through it and populating it with PUZ_ID values from a data set.
On form two there is a tool strip and below is a search query.
I need to be able to select the value i want in the combo box on form 1, and launch a button that opens form 2, which has loaded the data that i binded onto the form.
So i need to run something through a query, or make something public or what?