i'm using the below code to insert data from listview to sql table
but the problem is that i won't data duplicate i try to use trim but not works
can some one help to insert new data only if it's exist
and sure if not will add nothing and i wish some one can help most of time no one reply here i dunno why
My first thread to as for something here but i like daniweb a lot i'm trying to save data from listview to sql server[code]...
View 10 Replieshave here a code to save the data in my listview to my database but its not working.
Dim lvitem
Dim iCount As Integer
Dim iLoop As Integer
[code].....
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) " + _
[Code]...
Dim lvitem As Object
Dim iCount As Integer
Dim iLoop As Integer
[code]....
That is my code. message box show up but the record is not saved in my database?
I am using Crystal Enterprise 10 to run Adhoc Query to generate reports.My database has data with 4 digits after decimal point. But, the Ad Hoc query report rounds the data to 2 digits and displays that. Is there a way I can change this default behaviour to show the data as it is without rounding it?
View 5 RepliesI 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.
View 1 Repliesi 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?
how to save records in listview into ms access database table using a button, i've tried with my codes but nothing is saved in the database `Inline Code Example Here`
private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim con As New OleDbConnection
[Code].....
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.
Below is a project that I am creating and with it is a listview table with name and telephone number I can add and remove contacts no problem that part is solved
What I am trying to solve the problem to is how to save that data once the form is closed and be at the same point when I close the form'[code...]
conn.Open()
myCommand.CommandText = "INSERT INTO recipeformula (prod_id, prod_name, mat_id, mat_name, mat_no, unitmeasure) VALUES ('" & TextBox2.Text & "', '" & TextBox1.Text & "', @a1, @a2, @a3, @a4)"
myCommand.Parameters.AddWithValue("@a1", SqlDbType.Int)
[code]....
[code]the bold part must be changed cause everytime i open the saved file, word success is the data in there.
View 3 Repliesthis is the code for my save button
Dim iCount As Integer
Dim iLoop As Integer
Dim query3 As New MySqlCommand
[Code]....
every time i hit save, there is no error but it does not save on my database.
i already know how to save in excel using openfiledialog. but what i want to happen is that when i save another file, i want it to be saved in my existing file but in a different sheet.[code]
View 1 Replieshow to save in excel using openfiledialog. but what i want to happen is that when i save another file, i want it to be saved in my existing file but in a different sheet.
this is my code for saving
Public Sub saveExcelFile(ByVal FileName As String)
Dim xls As New Excel.Application
Dim sheet As Excel.Worksheet
[Code]......
can anyone teach me how to save data in microsoft access database and retrieving it back from database?[code]so, how do i save it in that and how do i load their data by typing their ic no only..
View 5 RepliesMost 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?
View 4 Repliesi'm have a payment form and a listview in this form. i'm adding about 3 item in the listview, so it has 3 row. but how can i insert the items in one of the column into database.
for example for listview
id item netmount
123 Stock1 113.00
[code]....
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)
[Code].....
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..
i have codes for adding data to listview from database but there's a problem ..
Public Sub showmyrecords()
Dim lvi As ListViewItem
Dim dt As New DataTable
[code].....
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 & "'"
I know how to cut off characters at the end of a string using vb script, which uses the LEFT(string, #) syntax, however, how do i do this using vb.net?
and my second question, I have a string being sent into a drop down menu that gets the data pulled from an access database using a data source control. How do I format it so say, it only shows the first 100 characters of that string in the dropdown?
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.
View 20 RepliesDo you have any sample project - OOP In VB.net?
a project that save data in database By oop(Object-oriented programming)
I need to pick data from one database and save it in a different database.[code]...
View 10 RepliesThe following code runs without an error, however, it doesn't save the values PayStatus, ReceivedDate and Comments to the tblProjectPatients. These fields do exist in the table.
Eventhough Yes, No, Inv are set to True or False if checked or unchecked.
[Code]...
how to save and show Richtextbox's data in database and retrive it in saved format and which datatype should be used to save that data. i am using vb.net and MY SQL?
View 2 RepliesI 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.
View 1 RepliesI have a ListView control set up in details mode with 5 columns. It is populated by code using the following subroutine:
For j = 0 To 14
cmd = New OleDbCommand("SELECT TeacherName, ClassSubject, BookingDate, BookingPeriod FROM " & SchemaTable.Rows(i)!TABLE_NAME.ToString() & " WHERE (((BookingDate)=" & Chr(34) &
[code]....