Prevent entering data into DB twice

[mg]

In the click event handler of an imagebutton (WebForm), my C# code gets the values in some textboxes and insert these values into database tables

The page reloads itself after this event and the text boxes are cleared

The user can then repeat the process

How can I prevent the user from inserting the original values in the textboxes more than once.

[ASP.Confused]

Lets say that there is a text box named tbx_name. You would use the
following string as your query string (in VB.NET):

Dim sql as string = "SELECT * FROM tblMyTable WHERE username='" +
tbx_name.Text + "'"

If the EOF flag is set, then the record doesn't exist.

<[e-mail]> wrote in message
news:09**********************************@microsof t.com...

In the click event handler of an imagebutton (WebForm), my C# code gets the values in some textboxes and insert these values into database tables.
The page reloads itself after this event and the text boxes are cleared.

The user can then repeat the process.

How can I prevent the user from inserting the original values in the

textboxes more than once.

[ASP.Confused]

Or if you are using SQL, you can set fields to not have duplicates.
<[e-mail]> wrote in message
news:09**********************************@microsof t.com...

In the click event handler of an imagebutton (WebForm), my C# code gets the values in some textboxes and insert these values into database tables.
The page reloads itself after this event and the text boxes are cleared.

The user can then repeat the process.

How can I prevent the user from inserting the original values in the

textboxes more than once.

[ASP.Confused]

NOTE: the way I described how to do the SQL string works with ADO, don't
know about ADO.NET, but I would think it would be the same.

"ASP.Confused" <anonymous@> wrote in message
news:e4*************@tk2msftngp13.phx.gbl...

Lets say that there is a text box named tbx_name. You would use the
following string as your query string (in VB.NET):

Dim sql as string = "SELECT * FROM tblMyTable WHERE username='" +
tbx_name.Text + "'"

If the EOF flag is set, then the record doesn't exist.

<[e-mail]> wrote in message
news:09**********************************@microsof t.com...

In the click event handler of an imagebutton (WebForm), my C# code gets

the values in some textboxes and insert these values into database tables.

The page reloads itself after this event and the text boxes are cleared.

The user can then repeat the process.

How can I prevent the user from inserting the original values in the

textboxes more than once.