Deleting column's all values

Question

Hi. I am using an excel file for db and I want to delete all rows in a column when clicking a button. How can i do this?

Deepak Bhatia · Answer

I can not understand the problem i.e. you want to delete all column values corresponding to all rows or you want to delete all column value in a row.

Jisss shyam · Answer

hi if you are using microsoft excel driver to connect to excel then you can directly delete rows by using sql query like delete from [bookname] where thanks

jinge · Answer

Loop all the rows and set the string to string.Empty. For example. Foreach( var row in datatable.Rows) { row[columnName] = String.Empty; }