I am trying to save added data through my form into MySQL. Here is my
VB.net
Public Sub savenotes()
notesConn.Open()
Dim savecmd As MySqlCommand = New MySqlCommand("UPDATE Events (Date_Time, Regarding, User, Details, Control_Number) VALUES (@Date, @Regarding, @User, @Details, @CtrlNmb)", notesConn)
[Code]...
i am creating a system where when a command button is pressed, it adds the data corresponding to that command button to a Table of the screen. And basically im at my wits end at how to do this, i have tried using SQL and databases but all i seem to be able to do is type data into the table and this is not what i want.Basically the table has 3 columns at the moment, which are filled in column at a time, and this need to be done by pressing command buttons. To explain this basically there are 8 buttons, which can be pressed to enter into the first column, once one of these buttons is pressed and second set of buttons appear which correspond to the second column and after one of these buttons is pressed the 3rd set of buttons appears to enter into the third column.Once the last button is pressed that is the first row filled in and the user can again press a button from the first set. Its basically a system for rapidly entering data into this table through the corresponding buttons.I have the buttons appearing and all that working fine, but thats basically just the layout. I need to know how to enter the data into the table.i have to use a SQL database, i only added that as at the end of the session, the entire table of data needs to be added to a master database but i can attempt this at a later date.
View 12 RepliesCurrently I am saving data from my applications by saving a text file via a stream reader as a string. I have come to a problem. In my current application, I have an array of the following structure:
[Code]...
rewriting a class I use for saving Treeview data to a XML file for use of saving ListView data I can't really figure out the rewrite, I'm stucked, unfortunately Listviews seems to be a big problem for me in general.
Option Strict On
''' <summary>
''' The TreeViewDataAccess class allows the nodes within a TreeView to be
''' persisted to xml for later retrevial.
''' </summary>
[Code]....
I created a form with 4 textboxes, one date picker, time and combobox. Now the problem I have is that I want to save all the values in these boxes in a folder which depends on what is selected in the combobox.
Source:
vb.net
Private Sub ListBox1_SelectedIndexChanged_1(ByVal sender As System.Object, ByVal e As System.EventArgs)
End Sub
[Code]....
The idea is that if I select 3 in the combobox, the files has to be saved in the folder 3. This folder is located on a server located in the LAN.
I am using visual studio 2012 to generate data. I am not using ASP.NET. My programs are on a CDROM disk. How can I use a button to save data into an excel file on the CDROM.
View 8 RepliesI am creating a software to carve data from an image file( removing data which can be deleted and undeleted) I am using the header and footer method. The problem is that am not able to save the data in between the header and footer. The data i want to save is raw data , in hexadecimal.So after getting the data, i would be able to get it back to its normal form.
View 1 Repliesno beating around the bush, here's the code.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim myXMLFile As String = Application.StartupPath & "creditors.xml"
[code].....
I have an Access DB that lists customer details in a datagrid and in textboxes, when I use the edit button I can edit in the textboxes and when I click save the record is saved and shows in the datagrid. But when I exit the program I get "Syntax error in update command" Im not sure why because there are no errors in the error pane at the bottom
This is the code for save button
Private
Sub
btnSave_Click(ByVal
sender As
Object,
ByVal
[Code] .....
I need to control a device with a GPIB port. I have the commands that I need to use to do this; but I don't know which is the sintaxis in Visual Basic.
For example if I need to send a instruction like "START:0.01" to the external device which are the libraries that I have to include?, how should I write the programming line to do this?
The main tasks that I need to program are sending data, receiving data, and saving data
What I am trying tot achieve is the following:User inputs data in one form that saves to the dataset table no problems. On an edit screen I want the current data saved to appear in this page within all the relevant fields but when saving I want this data to add to the dataset table as an additional line of data so the transaction records are kept.I want to add a new datarow regardless of it saving one change or all 7 changes that are possble.
e.g. Line 1 - user inputs 7 cells of data Line 2 - user amends 2 cells of data Line 3 - user amends 1 cell of data an so on. Unfortunately the terminology for certain items above may not be correct as I am still new to this programming and still on a massive learning curve.At the moment I do not have the code for what I am trying to achieve as I really dont know where to start with it.I am currently able to save the data and have it appear in the "edit" panel however only the cells changed are saved an it overwirtes the initial input.
[code]...
I'm trying to create a simple Data Grid that will automatically save changes. So far I have a data grid connected to a MS Access 2007 Database that reads the data. I can create new fields in the Data Grid, but I need to program to save the data automatically to the database on update (or on close).
View 6 Repliesi have decided to start a missle command sort of game in VB 2010, but i dont no where to begin! I have made spaceinvaders and pong so i have some idea on how to make it.
View 1 RepliesDim Connection As New OleDb.OleDbConnection
Dim dbProvider As String = "Provider=Microsoft.ACE.OLEDB.12.0;Jet OLEDB:Database Password=cSSO3sEEhrM4vY3je0qC;" 'connect to the access 2010 database, including DB Password
[code].....
First let me say that I am not sure whether or not this should go in this section or the API section, and if it needs to be moved I apologize. My issue is fairly straight forward, but for some reason I cannot get it to work.
I am trying to send a command to a command line and then submit the command. I have been trying without success to get this to work in v2008 Express and v2010 Express, Here is the code I am trying to us:
Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" ( _
ByVal lpClassName As String, _
ByVal lpWindowName As String _
[Code].....
Why it says Connection Property has not been initialized ?
PublicSub save()
Dim con AsNew OleDb.OleDbConnection
Dim adapter = New OleDb.OleDbDataAdapter
Dim cmd AsNew OleDb.OleDbCommand
Dim sqlQuery AsString
[Code]...
How to compare the result of the query..
for example i have a command "Select RemainTime from time where username = username"
how do i get the result of the query and compare it to a string[code]...
I just want the sql server 2005 command for exporting database to the excel or word file.
View 2 RepliesI'm developing a web application that provide a service of online reservation, and I need to save the data (for example in a specific day and access to them).How can I do that.Is it possible using : System.Web.UI.WebControls.Calendar?
View 1 RepliesI'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.
I have a small application that consist of five tables. The main table is called inventory. I have four tables linked to the Inventory table
[code...]
I can go in and enter data, create a new record and add more data and then click Save - nothing happens. I can cycle through the records and they will show. However when I exit and reenter the program (stop/start debugging) done of my new data is displayed.
I am thinking the problem has to be with the four tables connected to the main table via the ID's. Although a record is not being added to these subtables. So, I am not sure what's going on.
I have provided the code below. Please take a look and give me some direction.
[code...]
I have a very simple DataSet linked to a ListBox. I need the User to be able to add Data and have used the following code (in a ToolStrip command button):
Dim newFileRow As DataRow = Database1DataSet.Tables("tbl_Files").NewRow()
newFileRow("File Name") = fleName
newFileRow("File Path") = flePath
[Code]....
This seems to work ok - the new Data immediately appears in the ListBox. However, as soon as I close the form all of the Data in the DataSet is lost.
I have created a form, that calculates Hotels billing, with one box I can input Number of nights a customer stayed which is £32.50 a night per room and the other box £4.50 for breakfast, there is a deposit of £25.00 which gets deducted upon departure. I have created this form with success along with a clear button But here is the tricky part- I want to create a total button which will display a summary information about the bills paid on that day regardless of how long they have stayed and how many breakfasts consumed. this should include, the total number of bills paid, the total number of nights paid for, the number of breakfasts paid for, the total amount of all the bills added together including the deposit.
[Code]...
programing script in vb for saveing and restoring?
View 1 RepliesThis saves a bmp with nothing in it
Dim bmp As New Bitmap(PictureBox1.Width, PictureBox1.Height)
PictureBox1.DrawToBitmap(bmp, PictureBox1.DisplayRectangle)
bmp.Save("C:UsersXXXXXXXXdocuments estingoftheimage.bmp", Drawing.Imaging.ImageFormat.Bmp)
I want to be able to save the color information selected from ColorDialog.
Below is a sample of what I would like to do. I would like to be able to save the SetColor to file to set the saved color the next time the app starts.
Code:
Dim colorDia As New ColorDialog
Dim SetColor As Color
With colorDia
.ShowDialog()
SetColor = .Color
CmdBackColor.BackColor = SetColor
End With
What I have is a program that is going to monitor and store different stats about different email servers. The basic layout of the main form is a datagridview. Now this program does not need to store the information into a database as it is only going to run on one machine which is why I did not bind the datagridview to a dataset. Maybe using a datagridview is not the way I need to go but researching around the only other option would be to save the data to XML. However since the table does contain hidden fields with authentication credentials, I am a little bit hesitant about doing so.
View 3 RepliesI am new in programming, I am using VB2005, and MS Access as the database.I have create a project with an "add a new user form", so far so good, the program is saving my data with no problem.[code]What I need help with knowing how to implement or how to add the code to be able to save what ever is in the "Listbox1" into an "OLE Object" table in my Access database.
View 2 RepliesSaving all data from data grid view in vb.net 2005 into sql server 2005 database table.
View 1 RepliesI made a query for inserting a value from text box to MS ACCESS db
sql = "INSERT INTO Equipment (port_number,display_name,equipment,tonnage,user_privilage) VALUES (" & CLng(txtPort.Text) & ", '" & CStr(txtDisplay.Text) & "', '" & CStr(txtCA.Text) & "', " & CLng(txtTonnage.Text) & ", '" & CStr(cmbUser.Text) & "')"
Actually I meant for inserting the data entered in the text box, but now saving is the code itself i,e; in port_number column 'CIng(txtPort.Text) ' will be saved