I have a Listview with 5 columns. It display data taken from 2 textbox, 1 combobox, 1 datetimepicker and auto generated number. I want to save all these data to a database. While trying with my code I was getting some errors. I add my whole project here . Below is my code -
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click For x As Integer = 0 To ListView1.Items.Count - 1 CMD.Connection = CN CMD.CommandText = "INSERT INTO SaveData (CatID, Item, SubItem, Date, Amount) " + _
I have a Listview with 5 columns. It display data taken from textbox. I want to save all these data to a database. I am using VB 2010 Express with Access database. I have tried the various codes in this forum but seem not be able to work it out. What code should i use? Also i have found many suggesting that a datagridview is a better option, how would i update the DGV with data from the textbox control, as this POS application and calculations are done for eventual printing of a receipt and saving the data to the db.
i am currently working on an Application Manager that basically will free up my desktop of all my shortcuts by adding them to a program, or in my case, the listview object. Basically, so far i have set up a toolbar on top with a few options that will add listview objects, listview groups, remove those, and some other help and support things.
What i want to do is allow the user to add a listview object, which will be an application shortcut- they can choose the name, the icon, descriptions, whatever. (In essence, i am basically moving the desktop style of shortcuts into an application, where you can categorize and organize these shortcuts).
The questions i have are: 1. Is the listview object a good option for what i am trying to accomplish? 2. I saw that you can import imagelists, but how can i incorporate that to include icon pictures selected when a user adds an application? 3. How do you save listview data? 4. Anyone have a good strategy on how to approach this project? 5. Do i/Should i make an 'application' class that handles all the application information rather than using direct listview methods?
I have a question because in my I.O.File. I use this to save the data in the listview in a c: est.txt but the problem is that it only save one data and every time I click the save the previous data that I save is deleted and it change the new one that I save. And also when I click the remove in the listview it will also delete the data that save in the c: est.txt and the format should like this
First name | lastname | address | rae alanah new york john smith los angeles
Here the code that I did... Dim myFile As String = "C: est.txt" '//file location System.IO.File.WriteAllText(myFile, TextBox1.Text & " " & ComboBox1.Text & " " & TextBox4.Text & " " & ComboBox2.Text & " " & TextBox3.Text & " " & TextBox2.Text & " " & TextBox5.Text) Or you can also create new code base on ur understanding. This is the first time I use the I.O file or file stream in vb.net because my crystal report does not detect my database that's why I need to do this.
Most of the project I do, I use the datagridview to display the data from the database. What is the different between the datagridview and listview? If I want to display the data from the database, should I use the datagridview or the listview?
What I want is that when i select the data from the listview1 it will also delete the corresponding data in the database im using mysql database...these is my code
Dim Button = MessageBox.Show _ ("Are you sure you want to delete this Data?", _ "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1)
so far that is my code..it work but in order to delete the data from database i use the datagridview does not what i want ,what I want is that when i select the item in the listview the corresponding data in the listview it will also delete in database... that code i post is that u need to select the data in listview1 and also select the data from the datagridview in order to delete the data in database..
ive written a query to show data from my database in a listview (using more than or equal to in the query itself) the problem is it doesnt show all my data that is greater than what i have put in and it still shows some data however that is less than,
SELECT * FROM Room WHERE [Room Size] > = '" & Noofppl.Text & "' AND [Number of PC's] > = '" & noofpcs.Text & "'"
Just curious on how i can save information, like settings, and usernames etc. in my app, but i dont have a database? Or say i wanted to create a licenc key for my app, how can i make sure a window comes up before it with a lic. key check or somethingl ike that.
I have a ListView setup in details mode that looks like this: When the user presses the delete button, I need to go ahead and delete their record from the database. This I can do fine, but I'm stuck on how I retrieve the data that is highlighted in the ListView control. I've tried using Google but all the examples I found have failed to work.
if this question has already been answered many times, but I am new to VB and I don't really understand any of the examples I have found by trying to research this topic. I am using VB 2008 Express Edition. My List View is called listView.