Saving Database In Two Forms?
Jun 6, 2012
i was working a program that has two forms. first form1 has a datagridview for viewing. with a button ADD and SAVE and disregardchanges.then when i click add another form2 with textboxes to input data. with buttons ADDTODATA, ADDANOTHER and CLOSE when i click ADDTODATA the data will add to datagridview in form 1 and when i click ADDANOTHER i also input another add ADD to datagridview to view.and when i get back to form 1 i have a choice if i will SAVE ot DISREGARDCHANGES. if i click save all data will save.
I used this code in adding data to table.
Dim dsNewRow As DataRow
dsNewRow = ds2.Tables("NewEmpChildren").NewRow()
dsNewRow.Item("dbIDNo") = txtIDNo.Text
[code]....
but nothing changes. it seems that my connection is close when i close form2. how can i make my connection still open when i close form two or any code that will substitute with my code. im a student and this is for my project.
View 3 Replies
ADVERTISEMENT
Aug 14, 2011
Private Sub Table1BindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Table1BindingNavigatorSaveItem.Click
Dim dg As DialogResult = MessageBox.Show("Would you like to continue saving your changes?", "Save Changes?", MessageBoxButtons.YesNo)
[Code]....
View 5 Replies
Mar 11, 2012
I have been trying for a good while to save the forms icon(the one shown in the taskbar & such to a file...using such code as Me.Icon.Save(stream) & writing the stream to disk for example but every time I do there is a loss of color information it seems, maybe due to not using 32-bit color or lossless color or something...by what I see online it only uses 24-bit color or something.?Not sure what the problem is specifically but the point is there is a loss of color information.if I use Me.Icon.ToBitmap.Save() it works & saves right but it saves as type .png by default, regardless of the extension & not an actual icon file(.ico) which would be usable in the editor itself as an icon how do I convert it or save it correctly to begin with but without the loss of color information.This is basically a test project to see what I can do & what I still need to work on...and this is apparently one spot but I can't figure out the problem after searching bing, google and a few other search sites and reviewing the top 100 links of each to see if any contain any useful information on how to get this working....
View 9 Replies
Jun 25, 2009
I have many child forms, If I open them many tÃmes it makes higgdly-piggedly.
i want to save names of them to a tool and open them for later.
View 3 Replies
Nov 6, 2009
I was wondering why my code doesn't work - I want to save a picture from a picture box showing a webcam preview.[code]
View 4 Replies
Mar 17, 2009
I'm totally new to the programming area. I'm using VB 2008 and I'm trying to save three textboxes in a text format. I have tried some code but my problem is that I don't want to save always at the same name (test.txt). How can I do it.
Here is the code that I'm using (and probably has lot of mistakes :'( )
Public Class Form1
Const mForm1Name As String = "c:est.txt"
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim Form1 As System.IO.StreamWriter
[Code] .....
I understand that the problem is on the top where I've placed Const mForm1Name As String = "c:est.txt", but when I'm taking it out gives back a mistake. Also my form doesn't close when I save.
View 4 Replies
Feb 5, 2011
So I'm a beginner and I'm guessing this has been asked before, but can anyone tell me how to save multiple inputs from textboxes and radio buttons etc. as one whole umm... thing in a STANDALONE form. I don't want any extra CFG or INI files etc. Kind of like how a new profile in a game would work. I'm a beginner so please try to keep it simple (or if you already know of a thread with the exact same question please link that as a reply instead).
View 2 Replies
Aug 24, 2010
I'm a newbee with VBnet , I use vbnet2005 I have a major form called FORM1, and when I click the bottons in it it shows another form for example-I have these some forms (printscreen):
FORM1 - major form
FORM2 - calculation form ( there are few forms like this)
FORM3 - result form
What I need is:When I open FORM2 and get results I push the botton SEND and then it should send the values into FORM3 I don't know if the public variable will be good here because they are not constant , I can get different results in FORM2 ,and these results should be writen in textboxes only after I push send bottom.
I hope it is clear , I don't know how to do it,if you can give me a code for this or detailed answer , I would be very glad.
View 3 Replies
Nov 27, 2011
Am new here and also a beginner in VB. I have created a form with a TabControl and when I click the tab page it creates another TabControl Dynamically. This works fine.I would like to save the form with the newly created TabControl and when I close the form and reload it the new TabControl should still be there.
Public Class Form1
Inherits System.Windows.Forms.Form
Private Sub Form1_Load(ByVal sender As System.Object,
[code]....
View 4 Replies
Apr 12, 2011
I am making a program to organize grainbins in seperate yards.In this program, the grainbins need to be moved around and thier position to be saved when the program is closed. I also need to save information such as backcolour and text.I am specifically referring to GroupBoxes, OvalShapes, Textboxes, Labels, and ComboBoxes.
View 2 Replies
Feb 23, 2012
I am trying to get my project to be able to save the data been input from a user. I have uploaded a screen shot of the dialog I am currently trying to use. You will see that I have got a combobox for member at the top. What I want is when the "new" button gets clicked then I can add the desired information then click "Ok buttton which will then save the information.
I want to be able to select members from the combobox after multiple have been recorded to be able to delete or edit them. I have got as far as "changing" the combobox to a textbox for input purposes. I have tried a few attempts to get it. I am getting "ConfigurationErrorsException was unhandled"
View 2 Replies
Nov 22, 2010
I have two labels in my form with two integer values I need to save these labels in an array and when I load the form again I need the saved data appear in two textboxes.
View 4 Replies
Dec 4, 2011
I am trying to make a program that allows me to operate a program while I am not around (kind of like a bot) because I need to move alot of things and do the same motion over and over.
So in my program's settings I have made a form that is transparent that I want to set my working area with (i wont be resizing the form, it's size is "975, 575") and save the forms Top, Left, Bottom, Right positions so I can create a macro for my mouse to click.
how to save a forms position on the screen? So I can use it to set a working area?
I just want to save its current location to 4 variables
View 2 Replies
Apr 16, 2009
I have been working on a project which is used by a company's sale team, to combine all the wanted input data in one place allowing the sales team to show customers, where switching to them could save them money.
Basically what i want is a program which can save single records, which can hold data added in other text boxes, or indeed take the data from the list view boxes which is the intended output. I want to be able to save that data, then be able to Open it up again at a later date, and even modify it.
enabled me to save the three ways to identify a single record, the index number, company name and the date it was added. However I now need a way to save the data entered in my other forms to these single records.
View 1 Replies
Aug 30, 2011
I have an application that has a treeview in the MDI parent form, there is a button1 that adds a child node to the treeview and a mdichild form for that specific treeview child node. i would like to know if it is possible to save the trevview and the MDi child forms to a single txt file or csv file no matter how many mdi children and treeview child nodes are poduced.
View 11 Replies
Feb 29, 2012
I have managed to create a connection to the database and am able to save information to it from my form, the form contains 22 textboxes, a save and another exit button. I have set the form to retrieve data in the form_load. I have used the "UPDATE" SQL command on the save button and it does save the data on all 22 textboxes (all textboxes are linked to their separate columns). But only one record will be needed that is why I did not use the "INSERT" command.
The problem arises when I click the save button, all (19) textboxes are saved but when I retrieve the text (by reloading the form), each of the 20, 21, 22 textboxes (only) the text of the 20th textbox keeps on moving tho the next textbox e.g. 20>21>22>20>21>22 is interchanged amongst themselves.
[Code]...
View 1 Replies
May 2, 2011
can u see what is the error in this code because it not saving in the data base the error is Data type mismatch in criteria expression.
[code]...
View 1 Replies
Jan 10, 2009
I have a datagridview that's bound to an access database, and it loads fine, and runs without errors, but it doesn't save. Here's my code:
Imports System.Data.OleDb
Public Class Form1
Private Sub Form1_FormClosing(ByVal sender As Object, ByVal e As System.Windows.Forms.FormClosingEventArgs) Handles Me.FormClosing
Dim myDA As OleDbDataAdapter
[code].....
View 7 Replies
Nov 6, 2011
I'm working on a project which are generating some data from my VB.NET software and I wish to save those data into sql server. But my concerns is the speed of saving and the large amount of data. For every 0.5s, one set of data will be generated and the process will keep running for about 8 hours, so at the end of 8 hours, roughly there will be 60,000 set of data generated.May i know what is the best option/method of saving the data into the sql server in not hanging up my software and also keeping the pace with the speed of 0.5s data being generated?
- Speed of 0.5s. I have to maintained for every 0.5s, one data must be generated. Cannot delay too much.
- I can afford delay in the sql database, meant the data might not be necessary close to real time.
View 5 Replies
Jun 3, 2010
What is the best way on saving changes in datagridview into database? Whatever the user made changes in the datagridview will reflect right away in the database? The fastest and accurate way.
View 3 Replies
Jun 7, 2011
i need to save an image that will be displayed on a vb.net form. how do i get round this:
1. how do i get the image before saving it in the database?
2. how do i save the image in the database?
3. how do i fetch and display the image from the database on a form?
View 3 Replies
Apr 11, 2010
I created a database in access 2007, linked it to my project in visual studio 2008 (vb). When I enter some data using the UI, it does not save it in the database, and it's gone as soon as I run the program again. I dragged the textboxes from the datasource panel, onto the UI..
this is the code that was automatically generated by vs for the save button:
[code]Private Sub StaffBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles StaffBindingNavigatorSaveItem.Click
[Code].....
View 2 Replies
Mar 11, 2010
I am developing a software for a restaurant which is owned by my sister. I would like a functionality that will make her send all purchased items into a listbox,and afterwards which will calculate for the total plus VAT. Whereby, there will be another button which will print out a items and the total from the listbox to a POS printer, and at the same time save into the sales database.
View 2 Replies
Feb 23, 2009
I'm saving data to a database, data from a listbox and checkboxes.In the listbox, on the form, there are 20 records and then there are 20 corresponding checkboxes.I need to save all 20 records to the database so really I need 20 new rows. What I have managed to get working so far is that it will save the last record only.Here is the code that works:
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
'setup the relationship
objDataSet.Relations.Clear()
[code]...
but that's not right.How can I get to save 20 new rows to the database table?
View 2 Replies
Sep 2, 2010
im having problems saving and and updating my database. created in the database explorer.Run thorugh what ive done, created tables saved the job, imported the database dragged items on to screen.
Ive looked at my xsd file and Update and delete comands havent been set, how do i set them and is there a default to preset them when ive i create new databases. its really great you helped out..
View 3 Replies
May 25, 2010
I save my database in my application like this:
Public Sub save_mandant(Optional ByVal SName As String = "")
Dim set_temp As New DataSet
Dim set_tables As New DataSet
Dim ada_temp As New SqlDataAdapter("Select name from Sys.tables", SQLcon)
ada_temp.Fill(set_tables, "T")
[Code]...
View 8 Replies
May 2, 2010
In my project the "teacher" must enter grades in the Grades database then save it and click the Semester Average button(btnSA)to display the grades in the database. Well I can't the the data to save. After I completely fill in the grades and click the save button in my tool strip I get the following error "OleDbException was unhandled: Command text was not set for the command object"
Public Class Form1
Dim connStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=GRADEBOOK.MDB"
[code]......
View 1 Replies
Feb 18, 2010
I have read all the posts on this and tried a million different suggestions from the posts and I still can't get this and I don't know what I am doing wrong. I am new to working with DataGrids, Table Adapters, and Binding Sources so please bear with me.I have a form with a datagrid that loads when someone makes a selection in a combobox. I want the ability to make changes in the grid when they hit the save button. This is my data connection and variables, etc.
Dim con As OleDbConnection = New OleDbConnection("Provider=Microsoft.jet.oledb.4.0;data source=C:Documents and SettingsTodd LerewMy DocumentsVisual Studio 2008ProjectsPracticeAppPracticeAppTFPOperationsDatabase.mdb")
Dim myAdapter As New OleDbDataAdapter
[Code]...
View 1 Replies
Feb 23, 2010
I am making a simple program in Visual Studio 2010.My program connects to a MySQL 5.5.8 database running on my computer through XXAMP. I have used the Connector/Net 6.3.7 for MySQL to allow me to do this.
This is the local information for the MySQL server:
Server: 127.0.0.1
Port: 3306 (default)
Username: root
Password: admin
I have successfully created a Data Source for this server. The DataSet is called 'testdbDataSet'.
This is what my program looks like:I do not want to use the navigation bar that Visual Studio gives me at the top. Instead, I want to use the buttons shown below the input fields. The btnAdd button I believe should clear the two fields. It is currently working fine. I want the btnSave button to save the stored values of the two input fields to the database. I do not know how to do this.
View 5 Replies
Nov 21, 2011
this is roughly the add form where i have created... i am suppose to send this information into the database that i am using which is mysql.It is suppose to grab the incident date and the Type and also a count that increases by 1 if the date is the same or else it will be back to one.
This is the code
Dim count As Integer
Dim hotelcode As Integer
[code].....
View 1 Replies
