How to delete data by clicking

[AlfredNg86]

I'm using Visual Web Developer
SQL as a database..
Using VB code

Is it possible to delete a data by selecting the data using the mouse and then click on a del button ?

[debasisdas]

From where you want to select and delete ?

kindle post your question bit crearly.

[AlfredNg86]

Sorry...

I linked my SQL database to VWD. After design the web page from VWD and "bulid page" from VWD it will display a list of data from the SQL in the web browser. I need to able to delete the data in the web browser by using mouse to select the data and then delete it.

Sorry if I'm still not clear

[hariharanmca]

Sorry...

I linked my SQL database to VWD. After design the web page from VWD and "bulid page" from VWD it will display a list of data from the SQL in the web browser. I need to able to delete the data in the web browser by using mouse to select the data and then delete it.

Sorry if I'm still not clear

If you have time, just post your problem in point by point with the code you had tryed.

[CODE=vb]Dim strSql as String

strSql="Delete from tblTableName where fldSelectField = " & selecteddata[/CODE]
execute this query in oledb connection.

[QVeen72]

Hi,

When u Select a Row from the VWD, u will be knowing the PK or any distinct field of that Table, and use "Delete" SQL Statement to delete the Record and Refresh the webpage..


REgards
Veena