C# Windows Form ListView concept

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Jason Huang" <JasonHuang8888@xxxxxxxxxxx>
Date: Sat, 14 Apr 2007 13:17:08 +0800

Hi,

In my C# Windows Form application, I have a ListView control Lvw1 in MyForm.
For most cases, the Lvw1 has no more than 5 rows of data. But now comes the
situation that one user has to input approximately 100 rows into the Lvw1.

Case1, 5 rows.
Case2, 3 rows.
....
CaseX, 100 rows.

We used to process the Update/Delete as:
DELETE all rows in the Database Table which has the item value CaseX, then
INSERT into the database from the existing rows in Lvw1.
But this seems kind of too risky, I'm thinking is there a better solution
for doing the Update/Delete?

Thanks for help.

Jason

.

Follow-Ups:
- Re: C# Windows Form ListView concept
  - From: Bruce Wood
- Re: C# Windows Form ListView concept
  - From: Nicholas Paldino [.NET/C# MVP]

Prev by Date: Should I use SQL data type money or decimal given .NET datatype is decimal?
Next by Date: Ignore Keystrokes/Shortcuts after initial press
Previous by thread: Should I use SQL data type money or decimal given .NET datatype is decimal?
Next by thread: Re: C# Windows Form ListView concept
Index(es):
- Date
- Thread

Relevant Pages

Re: C# Windows Form ListView concept
... the Lvw1 has no more than 5 rows of data. ... We used to process the Update/Delete as: ... INSERT into the database from the existing rows in Lvw1. ... But this seems kind of too risky, I'm thinking is there a better solution ...
(microsoft.public.dotnet.languages.csharp)
Re: C# Windows Form ListView concept
... the Lvw1 has no more than 5 rows of data. ... INSERT into the database from the existing rows in Lvw1. ... It's only risky if you're not using a transaction. ... deletes and inserts within a single transaction. ...
(microsoft.public.dotnet.languages.csharp)