i am new to vb.net and dont have any idea about using datareader.i am right now doing a project on vb.net and am facing an issue.i have a form, where in i have to select the matching records from the database and show it in various textfields. as far as the query execution is concerned, i have successfully completed it, but i am facing an issue now. Suppose, i have an Id of a student, and he has registered for 3 courses, when i give the query something like select students.studentid,courseid,midtermmarks,finalterm marks from marks,students where students.studentid=course.studentid;it gives me multiple records.my doubt is, when i get multiple records, and which is true(in the case a student has registered for multiple courses), how can i traverse through the resultset and fetch the values in the respective textfields.
I 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.
Public Sub CreateXml() Dim db As New MDataContext Dim Customers = <gallery columns="3" rows="3">
[code]....
Could i mix local values with the ones returned from the LINQ query...Something like the following?
Public Sub CreateXml(ByVal **Col** As String, ByVal **Row** As String) Dim db As New MDataContext Dim Customers = <gallery columns="& **Col** &" rows="& **Row** &">
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:-
Ive created one database Sql Server Compact Edition 2005, with one table ("Cliente") I know that I can created my database good, but i have a problem saving information since three textbox, in my table(With columns "Nombre" "Apellido" "Cliente". In my form there is a button save ("Guardar"). When I do click in my button appear the next message : "The column cannot contain null values. [ Column name = Nombre,Table name = Cliente ] " and happen the same with apellido and Id_Cliente. And this happen becouse my code cant save the information....
This is the code
Option Explicit On Option Strict On
Imports System Imports System.IO Imports System.Data
[CODE]...
And the code for my button is:
Private Sub cmdguardar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdguardar.Click
Dim myconnection As SqlCeConnection Dim mycommand As SqlCeCommand
I created a dataset and i am using OleDbDataAdapter to insert new values to access database. But when i close the program and after open it, values are not in the database. How can i solve this problem? Also, i have another problem. When i write codes that
I'm working on a tool that allows the user to connect to his SQL database and edit some of the database values.First here's a screenshot of the GUI (you can see my problem as well):
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 "".
How do you guys take control of a listbox in a form from another form? I could have sworn I've done this before but can't remember how or find any of my programs that did this. In form load i populate a listbox with a routine. I wish to call that routine again to refresh it from another form.
i have a question on how to add two values of placeholder on different forms. in the forms i put a placeholder for "correct answer" and "wrong answer" so one of this placeholder will have a value of integer. how can i add a value on the first form to the other placeholder of the other form.
I have a form set up that allows the user to do many things to manipulate items. One of the things they can do is replace an item with another. To do so, what I have them do is click the Replace button on the main form. This calls the show of a choose replacement form where there is a grid view containing the replacement options and a Replace and Cancel button. When the user selects a product from the grid, and clicks the replace button, I want the item's ID to be sent back to the main form to be used in the replacement sub.This is what I have:
I'm basically putting some validation logic around an undo button on my form and i'd like to check whether any fields on the form have had their values changed so i can ask the question "abandon changes?". This seems like something pretty standard to me but I can not see how to check whether a value has had its contents changed (without recording a before value and comparing it to the after value which for large forms would be quite horrendous to code).
In the language i used to use we used to walk the object tree (so we dont have to specify each object individually like text box, combo box etc) and check any object that have value-changed = yes to indicate the validation was required.
Throughout our program, forms are opened like this[code]...
The problem is that when forms are closed, they seem to not really be closed, only hidden - if I add some text to a textbox and close/reopen the form, the text is still there, rather than the textbox being cleared like normal. This is presumably because the form always uses the same instance.
Is there any easy way to fix this other than going through the entire program and creating a new form instance for every ShowDialog() call (there are hundreds)?
I am currently building a mortgage application and currently have two forms, the way the system works so far is the user selects an option from a series of radio buttons whilst a score is kept based on the options chosen, this is then displayed in a text box to the user, on the second form there are more choices, and a textbox to display the final score, what I can't figure out is how to get the value from form one to the textbox on form two when the user clicks next on form1 to get to form 2.
I am trying to create a quiz application in Visual Basic 2008. I need to be able to store a score value when the player gets a correct answer. When the value is stored a new question set appears. Once the score is calculated I want to be able to show this is in a new form so the value needs to be passed from one form to the other. I'm not entirely sure how to do this but I believe it will incorporate a module.
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.
My application sends information from Form1 to Form2 by means of a global variable on Form1 whose value is read by Form2.
This variable is basically used to tell Form2 what it has to do because it's value will change depending on different conditions.
All form2 is meant to do is load data from a database into DataSets which will "ported" to Form1 (the main form) for consumption. I use a Form for this rather than a class because there's a lot of data that will be loaded each time it's visible and I wanted[code]...
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?
I m working on an school management application, i design the database in access2003 and forms in vb.net2005. but i dont have any idea about the database conectivity. with the help of a book to connect with the db but i cannot save the data in the mdb file. in my application 1 add the followin buttons add new record modify record delete search using id or enrolment no.
I have a groupbox with a number of textboxes. I want to loop through all the textboxes, get their value( text) and add them all together and show it in a final totaltextbox outside the groupbox. This is what i have done but it does not work. The totaltextbox values do not change. Here is my code :
Private Sub AGroupBox_VisibleChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles AGroupBox.VisibleChanged Dim xxx As Integer
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 have about 10 boxes on my form1 that the user will populate, I am looking for a "Best Practice solution to pass the values across to form2 and form3. Would like the user to be able to edit the value on either form and have the chnage carry over to the other forms.
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.
I'm trying to make a string inputted on a separate form's text box adjust the value of a string on another form. Is there a way to do this rather than exporting the data to a file and retrieving it on the other form?