I've got a list box and I want to save it to a database. I've tried treating it like a normal textbox with a max string length of 50. However this doesn't work for some reason.
Does any one know how to save a list box to the database, and preferably with a variable length, although the latter is not a necessity.
I wish to 'record' sound into a wma,wav,midi or mp3 file, not external sound say from a microphone etc but sound played through the computer speakers on your own system however I don't know of any COM components that allows this. Is there any way to do this?
View 3 RepliesI need to logging the process list and saving it as a text file. I need it so that it will log any new program that opens up. Basically monitoring the process list.
View 2 Replieshow do you go about to Save Items that are added to a List Box into a Text File, with the Users Details, from when they log in?
View 12 RepliesI gather case info from a DB table into a list(of T) list and display it in a checkedlistbox. When an item in the checkedlistbox is selected (highlighted, not checked), the selectedindexchanged event then retrieves account information from the DB for that case and loads the different accounts for that case in another checkedlistbox.
My issue is figuring out the best way to save the different items that are checked in the accounts checked list box. Since the accounts are loaded dynamically given the selected item in the cases listbox, what would be the best way to save which accounts are selected for each case?Below is my current method of loading the listboxes and selectedindexchanged procedure. I'm fairly new to programing and this is how I was taught load most controls, by list after saving to the list from the DB (which gets very complicated when you have to keep relations between items in separate lists).
Private Sub btnSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearch.Click
Dim CasesList As New List(Of String)
CasesList = Db.GetAccounts(CDbl(txtAccountBalance.Text))
[code]....
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]...
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]...
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].....
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.
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 Repliesi 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?
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].....
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 RepliesI'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?
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..
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]...
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]......
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]...
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.
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].....
I am trying to make a program (kinda like a game, but no graphics). Well, everything on that is fine, and ive made this program once before in VB6, but that code is long gone and I am trying to make it again. Well, here is my issue. I want the users to be able to create items on the server end (as well as maps, npcs so on and so forth) and I was wondering if there is a way to do this without using a database? In VB6 I used several ini files, but this is not a recommended way of doing things anymore. I dont want each person that uses this to have to install SqlServer on their computer either.
View 4 Repliesi 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.
I use the following code to Populate DGV
Here's the code
Sub RC1Fill()
ADBConnString2()
conn = New OleDbConnection(NewAdbconnstr)
[Code]....
saving a file into database ?
View 14 RepliesI have a SQL Server database with a Table that has an image varbyte(max) field that I am using to store images. The issue is that when I am trying to insert an image in the field I need to .endEdit the dataSource before the assignment and again afer. If I don't do it before then nothing is stored. This of course only happens with the image, all other fields are updated without need to .endEdit.
View 2 Repliesi have been doing VB.net and SQL programming to design databases but with no images involved. When i
involved images, i got the error "No mapping exists from object type System.Drawing.Bitmap to a
known managed provider native type" I have a form with a picture box named Photo, a save button
called Save below is the code i used'[Code...]
Saving an Image to An SQL Database from a Visual Basic ASPNET.rtf?written in Visual Studio 2008, which is supposed to Insert Images into an SQL Database in Visual Basic ASP.NET I know it contains some errors but I can't point out exactly where I got it wrong?
[Column Name] - [Data Type] - [Allow Nulls]ImageID, Int, NOT NULLProductID, Int, NOT NULLLargeImageName, varchar(50), NULLLargeImageData, image, NULLLargeImageContentType, varchar(50), NULLSmallImageName, varchar(50), NULLSmallImageData,
[code]....
I think I have written code for saving All textbox's, maskedtextbox, datetimepicker,ombobox's ect.....I have a save button on a form called "SaveButton8" And what I want is when a user fills out the form, and when they click the savebutton8 I want all the froms, Textbox's, Maskedtextbox, Datetimepicker, Combobox's ect..... to save to the database. I have looked all over the forum with no sucess. here is my code:
Private Sub Button8_Click(sender As System.Object, e As System.EventArgs) Handles Button8.Click
'BookingTableBindingNavigatorSaveItem.PerformClick()
[code].....
i am getting this error and i cant spot the mistake: No value given for one or more required parameters.
my code:
Sub UpdateCustomer(ByVal HCNNO As Double, ByVal Forename As String, ByVal Surname As String, ByVal DOB As String, ByVal Gender As String, ByVal PasID As String, ByVal
[code].....
I have buttons working that cycles through all the records and everything shows up fine. I also made a simple DB program to test what I was doing without all the extra stuff my current program has and it works fine. Updates the dataset and then saves to the database and reflects the changes. When I tried adding it to this program, I get errors when I click "Save" and "Commit".The "Save" (updates DS) error is: "Additional information: Update requires a valid UpdateCommand when passed DataRow collection with modified rows."The "Commit" (commits changes to DB) error is: "Additional information: Syntax error in INSERT INTO statement."Not sure what either of these mean, the same code worked fine in the standalone program. Looking at another site, they show the exact Save error I'm getting and say it's because I don't have a command builder, but it's up there. [code]
View 6 Replies