I'm trying to save the contents for a listbox, which can contain up to 10 records(items) as follow:
1 + 1 = 2
1 - 1 = 0 and so on.
The code that I currently have is recording only the last item of the listbox
Below what I have so far:
Imports System.Xml.Serialization
Imports System.IO
Public Class SerializeData
' Save - serialize the object to disk...'
[Code].....
I'm writing an application in vb.net 2008. It's basically a randomised image quiz. I have saved questions, answers and time taken to answer questions into 3 listboxes: listboz1, listbox2 and listbox3. I'm trying to add the content of all into a csv file. This is my code below which only saves the contents of one listbox to a txt file. How do I get a combination of all listboxes in the file with format (L1,L2,L3)? I alos want to add the user name and the date the test/ quiz was taken.
[Code].....
I am compiling a quiz, so the question number, user response and time taken to answer questions are sent to 3 listboxes. I wanted to save the file name (from the login form, date and listbox contents to a text file. I have scoured numerous codws...none of them work..all with errors. I have tried to look at Streamwriting listboxes. But can not find a way to add multiple listboxes to one text box. Actually none of the codes (including the Sub SaveToKnownFileWithDelimiter (below) I have looked at work.
This is my quiz code so far....
Public Class Form1
Dim intPic As Integer
Dim pickedImg As New List(Of Integer)
[Code].....
i am going to be saving data with DPAPI encryption. i am not sure whether i should just have one big file with all the data or should i break up the data into separate files, where every file is its own record. i suspect the entire dataset would be less than 10mb, so i am not sure whether it's worth it to break it down into about a few hundred separate files or should i just keep it one file?
View 2 RepliesLets say you have a few text boxes, I know how to save the information in each box to a text file, but that creates a file for each box. Is it possible to save the contence of lots of different text boxes to 1 text file, and then when loading them it would load it all back to the right places?
View 9 RepliesI have a sign up sheet that I am creating for a project I'm working on and the sign up sheet works and I can enter all my data into the text fields and save the info but when I go to open the file again all the data is pushed into one text box and not in their own fields?
If there a trick in the SaveFileDialog that I can use to save each field to file then open them back in their own field?
Here's a screen shot of the before and after the program [URL]
And here is code behind the Save button [URL]
I am using VB2008 now, couple of simple questions.
1) Is there some way to limit what my user puts in their textbox to numbers only? Or is there some way to check afterwards that the string only contains numbers and delete it if it contains anything else?
2) How to open a file, save the values of 5 text boxes into the file and then close the file?
I am trying to get the information inputted from multiple textboxes to save to a single text file.
Here's what I got.
Private Sub btn_done_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btn_done.Click
Dim FILE_NAME As String = "C:UsersTrevorDocumentsDraftAC est.txt"
Dim i As Integer
Dim aryText(2) As String
[Code] .....
I'm looking to be able to save and load the content from multiple structured arrays and variables into/from an encrypted file, is there any reliable source of information or tutorial that I'd be able to use for this? I've never written a program in visual basic that writes to/reads from a file.
I'm using microsoft visual studio 2008.
saving data from a text field and multiple combo boxes to a file on a server in visual basic 2008
View 1 RepliesI have a datagridview on my form which is not bounded to any database table.The datagridview is only used for data entry. When the user has populated the datagridview and click the save button, I want to be able to save all the rows into a table in my database.At the moment, if more than one row is populated, my code is saving only the second row of the datagridview and everything else is ignored. If only one row is populated, it works fine.I am using Oracle database 11g and a store procedure to insert the records. Below is my code.
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
Dim cmd As New OracleCommand("MHMS_Package.Insert_Service", conn)
Dim strCmd As New OracleCommand("MHMS_Package.Insert_Service_Details", conn)[code].....
I have a DatagridView which displays the following: IDNo, SubjectName, FirstName,MI, LastName, YearLevel, Address, Gender. I want to save whatever is displayed in it to my database...My code below does not save the SubjectName all the rest are saved.
Private Sub btnRegister_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRegister.Click
Try
[code].....
I would like to display the multiple records in multiple textboxes Following is my tables and data:
tblJan with these data:
col id
1
2
3
col January
10
20
30
now i want to display the value 10 in one textbox and the value 20 in another textbox and so with the value 30 in another textbox..
The following code throws an error on saving a record: "Conversion from string "TDT" to type 'Integer' is not valid" The following code is highlighted:
da.InsertCommand.Parameters.Add("@TDT", OleDbType.Date, "TDT")
"TDT" is a MS Access field name for storing date.
I am trying to learn XML, for which i have created a simple Employees Program. I want to save the records of the employee in an xml file, so far i have the following code:
vb
Private Sub SaveRecord(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim XMLSettings As New XmlWriterSettings
XMLSettings.Indent = True
XMLSettings.IndentChars = " "
XMLSettings.NewLineOnAttributes = True
[Code] .....
This is only working for a single record, How should I insert more employees records within this xml file?
Using vs2008 9.0.30729.1 SP. Inserting a new record works but editing a record doesn't. Tried databindingsource but no joy as well.
Private Sub Gr1A_CheckedChanged_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Gr1D.CheckedChanged, Gr1C.CheckedChanged, Gr1B.CheckedChanged, Gr1A.CheckedChanged
sAns1 = ""
If Gr1A.Checked = True Then
sAns1 = "A"
ElseIf Gr1B.Checked = True Then
[Code] ......
how to permanently save to text files then re-open all of the information again using SFD and OFD. Now my teacher has come back at me and said that i need to be able to save the information from multiple text boxes and have the text in certain labels to also be saved into the one text file (the labels need to be done because it is a database and these labels are like the fields and the right text box needs to match the right label)
View 39 RepliesMy program runs with no errors, but the actual .accdb file does not reflect changes when I make them in the running program. Also when I fill in the text boxes and click the "Add New Item" Button, the "ID" text box displays a -1. "ID" is the primary key in my Access Database.
Imports System.Data.OleDb
Public Class addMemberForm
Inherits System.Windows.Forms.Form
[code].....
I am using the following codes to Save records to MySQL database from VS2008.
Dim cmd As New MySqlCommand
If cmdSave.Text = "&Save" Then
'save computer main
ConnectComputerDB()
cmd.Connection = CompDBCon
cmd.CommandText = "INSERT INTO tbl_items " _
[Code] .....
Is it the right way and proper method to save records to MySQL database...?
I'm working on a simple data logging program, and I have little to no database experience. I wrote a little VB forms app to log the data to ms access and then graph the data, but I'm having trouble with adding records to the database. First, I created a simple one table database in access. Then, I added the database to the project as a data source, and gave it a data set using the wizard. Right now my code looks like this:
[Code]...
There are no problems during build or run time, but I do not see changes to database after the program runs.
How do I update records in a dataset with records in a transaction file?
View 3 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]...
I have two problems with my datagridview in VB 2005 that I did not encounter in VB6. I would like to add multiple records to a datagridview by allowing the user to tab and type.When they get to the end of a record and tab it should go to the next record like Access does. The user can move to the next record and it even shows the pencil on the left leading them to believe that a new record is being created. But, it will not create the record unless they first click on my button that will add the record with the code BindingSource2.AddNew(). I use a bindingsource to populate the datagridview. Here are some snipits of my code for clarity:
DataGrid2.DataSource = BindingSource2
GetDataDetail(
"Select * from [Order Detail] Where [Order Detail ID] = Null")
[code].....
i can't seem to add to records on the one row i get the error saying "Column count doesn't match value count at row 1"but it works when i only add one record.
Imports MySql.Data.MySqlClient
Public Class PatientInfo
Dim ServerString As String = "Server=sappracticedb.db.7735192.hostedresource.com; User
[code].....
I have problem and I've been looking for a week now on how to solve it. Yesterday I thought I solved but apparently I didn't when I tried the query with new data added in my database.Here's my query
Public Function getTicketsByBeginstation(ByVal station As String) As Array
Dim r As Array
r = (From u In treinDataContext.Tickets Where u.ritId =[code].....
The problem I have is: when I have a station selected there are more than 1 trajecten (connections in English) but I had to use the .first else Visual Studio would give the error "the '=' operator is not defined for 'integers' and 'system.linq. IQueryable(of integer)".
So I give the name of a station -> I have to select all trajectens with the given station as beginstation -> I have to select all ritten which have the given trajecten -> I have to select all tickets which have the given ritten So: I have to show all tickets for a certain station.
I have following data in my table:
slno Name Age City
1 Ron 22 Dallas
2 Jonny 26 Texas
Now i use the following method to access data:
Try
Using connection As New SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=E:Visual Studio 2008ProjectsSmart SyncronixSmart SyncronixSmartDB.mdf;Integrated Security=True;User Instance=True")
[Code]....
I have a form that is going to displays the same field from each of my 185 records. How do I get it to show all records for that field without using a data grid. If you think of this form as a layout of a parking lot and each field is a parking spot then what I am trying to do is display the assigned parking spots. When you click on the spot I want to open a second form that I already created to display and edit that spot.
View 3 RepliesqueryStr = "INSERT INTO tbl_user_ldr_responses (rec_num, ques_no, response, comment) " & _
recnum & ", " & "1, " & "'', " & reader.GetValue(1) & " UNION ALL" & _
recnum & ", " & "2, " & "'" & reader.GetValue(2) & "', " & "''"
How can I fix my string so that it will resemble the below SQL code to insert multiple records with one insert command?
INSERT INTO thetable (field1, field2)
SELECT value1, value2
UNION ALL
[Code]......
Using the FileHelpers library to do some great things in VB.NET. Parsing files with dynamic classes built from text file templates. One thing I can't find: A way to read in a single record and determine that it should result in the generation of two records.[code]Ideally in this next line I would like it to see certain conditions and be able to generate two records from a single source line. Dim PayRecords() As Object = engine. Transform Records(FromRecords)Alternately, if there is a way to implement the "ITransformable(Of ..." TransformTo() and have it return multiple records, I could put the logic in the dynamic class definition TransformTo() method.[code]
View 1 RepliesHow to create datatable with multiple records.
View 6 Replies