[02/03] Deleting a Row from database

[kyosugi]

i'm using VS.NET 2003 n SQL 2000
my proj needs to be on a 3 tier (1st time unfortunely)

does any1 have any sample of any delete function?
i'm trying to get mine to work tis way
-user select the id of the item to be deleted via a drop down list
-user click on the delete button
and then the sql delete statement will kick in and delete the row from the database, something like this

i tried lookin on the net n tis forum for some samples for codes for the 3 layers(data, business n presentation)
i either do not understand or have looked at the wrong places
pls help

thanks in advance

[moredotnet]

R u having a datagrid control that has the delete button?

Any way the best way to do this is write a store procedure in your SQL 2000. Use ADO.NET to connect to the database & invoke the stored procedure to delete your record. Make sure you pass the data to the stored procedure.

Check out this link...

http://moredotnet.googlepages.com/ado.net2

Cheers

[kyosugi]

thx for the link
still not quite understand, lol. will try to

i'm not using a datagrid. i currently have problems to make my datagrid to appear(posted on another thread)
the whole thing is jus on a web form
i need to do the proj like a webby

[mendhak]

I think your first step is to understand how three-tier applications are built:

http://www.c-sharpcorner.com/Tutoria...3TierAppPA.asp

After that, it's a matter of implementing some simple ADO.NET

[kyosugi]

thx, will read up on it