Only Hope: Mahesh and Mike Gold

Question

Dear Mahesh and Mike.. Please help me out with this problem. I have a confusion with the ListView control. In my form, I have three combo boxes, one Add button, one Save button and a listview. Step 1:The comboboxes is being populated by a dataset. Step 2: On clicking the add button, the listview should get populated with the contents of the combobox.text. (I can repeat Step2 a number of times, each time selecting a different value in the comboBox and adding it to the ListView) Step 3: on clicking the Save button, all the data in the listview should be saved in a database. How will I accomplish this task using the same dataset for both the activities? How will I populate the dataset using the columns and fields in the Listview and update it to the database. plz help with code or explanation will do. thanks sui

suprotim_dotnet · Answer

Thanks Mahesh for making it simpler.

Mahesh Chand · Answer

Now you are saving values in the DataSet just you need to do is when calling DataAdapter.Update send only changed rows. DataAdapter.Update method takes a parameter (second) which is DataRowState type. Set it to DataRowState.Changed (something like that) only.

suprotim_dotnet · Answer

To make things clear its not that i am unable to do it. I just want an efficient way of doing it. I will post some code. Please tell me if there is an efficient way of doing it. I want to populate the ListView first and then update the Database with all records of the Listview. DataRow row; for (int i=0; i < this.MyListView.Items.Count; i++) { row = this.MyDataSet.Tables[MyTable].NewRow(); row[MyColumnOne] = this.MyListView.Items[i].Text; // if you have more than one column: row[MyColumnTwo] = this.MyListView.Items[i].SubItem[1].Text; row[MyColumnThre] = this.MyListView.Items[i].SubItem[2].Text; // etc.etc.etc. this.MyDataSet.Tables[MyTable].Rows.Add(row); } thanks.