how to delete colomn data?

Chinna Netha

11y1.5k

ID	name	Score	paper-II	image
1	vinod	12	paper-II
2	vinod	10	paper-I	null
3	vinod	0	paper-II	null
4	vinod	15	paper-I
5	vinod	12	paper-III	null
6	vinod	15	paper-IIII
7	vinod	16	paper-II
8	vinod	18	paper-II	null
9	vinod	13	paper-I	null

In Image column user did not upload image in first two or more times after that upload an image again user want to change that image so how delete first image and insert new image

13 Replies

Know the answer? Post it — somebody with the same question will find it here.

Khargesh Rajput11y ago
Accepted answer
Follow this link
may help you

http://stackoverflow.com/questions/19586658/c-sharp-update-if-record-exists-else-insert-new-record
0
Chinna Netha11y ago
tq u so much sir
+1
Chinna Netha11y ago
sir,
tell me ado.net code sir
if exists how to write code in ado.net
0
Khargesh Rajput11y ago
at button_click

first select * from table where id=@id

if exist then
use upate

else insert
-1
Chinna Netha11y ago
but i want user first time upload insert command.
user second time upload update command executed.
two commands only one button tell me
plz help me
0
Khargesh Rajput11y ago
insert into table (ID,name,Score, paper-II,image) values (@ID,@name,@Score, @paper-II,image)

update table set image=@image where id=@id

http://blog.sqlauthority.com/2010/06/08/sql-server-merge-operations-insert-update-delete-in-single-execution/

http://www.techonthenet.com/sql/insert.php
http://www.techonthenet.com/sql/update.php
0
Chinna Netha11y ago
PLZ TELL ME
how to write code
insert and update
0
Khargesh Rajput11y ago
for first time entry you have to use insert query and for update use update query
0
Chinna Netha11y ago
For registered user we can use update panel . but for new user we can not update we will use insert na?
0
Khargesh Rajput11y ago
update statement will not delete entire column

use update table set image='yourimagefile' where id='row_id which you want to update'
0
Chinna Netha11y ago
I want to delete old image but not entire image column
0
Vikram Agrawal11y ago
Hi Chinna,
Khargesh is right.
No need to delete the column data
The update statement itself doing the same. First it will delete that row and then after it will add new row.
0
Khargesh Rajput11y ago
U can update data.

why you need to delete the column ????
0