Deleting column's all values

Deepak Bhatia17y ago

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.

0

Jisss shyam17y ago

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

0

jinge17y ago

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

0