Only Hope: Mahesh and Mike Gold

suprotim_dotnet

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

suprotim_dotnet22y ago
Thanks Mahesh for making it simpler.
Mahesh Chand22y ago
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_dotnet22y ago
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.