By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,084 Members | 1,969 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,084 IT Pros & Developers. It's quick & easy.

How to delete data by clicking

P: 4
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 ?
Sep 10 '07 #1
Share this Question
Share on Google+
4 Replies


debasisdas
Expert 5K+
P: 8,127
From where you want to select and delete ?

kindle post your question bit crearly.
Sep 10 '07 #2

P: 4
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
Sep 10 '07 #3

hariharanmca
100+
P: 1,977
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.

Expand|Select|Wrap|Line Numbers
  1. Dim strSql as String
  2.  
  3. strSql="Delete from tblTableName where fldSelectField = " & selecteddata
execute this query in oledb connection.
Sep 10 '07 #4

QVeen72
Expert 100+
P: 1,445
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
Sep 10 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.