How to add excel coloum value in datatable
i have excel like below
sno name
1 raju
2 vamshi
3 fgh
and add date field in every colum as "jan14"
i am using below query ....but how to write date fied affected in all coloums
Query = string.Format("Select [sno],[name] FROM [{0}]", "Sheet1$");
OleDbCommand Ecom = new OleDbCommand(Query, OleDbcon);
OleDbcon.Open();
DataSet ds = new DataSet();
OleDbDataAdapter oda = new OleDbDataAdapter(Query, OleDbcon);
OleDbcon.Close();
oda.Fill(ds);
DataTable Exceldt = ds.Tables[0];
SqlBulkCopy objbulk = new SqlBulkCopy(conn);
Richard PorterPosted Feb 26, 2015, 4:57 AM
shi lianghongPosted Jan 8, 2015, 10:03 PM
http://stackoverflow.com/questions/6426828/how-to-add-new-column-with-value-to-the-existing-datatable
add column value to specific row :
https://social.msdn.microsoft.com/Forums/en-US/22ef006e-1136-42fb-a268-a5c969024da2/add-column-value-to-specific-row-in-datatable?forum=csharpgeneralAdding new column with values to existing DataTable c#:
http://www.dotnetobject.com/Thread-Adding-new-column-with-values-to-existing-DataTable-c
And you can also use some third party component for C#.
Vithal WadjePosted Jan 8, 2015, 2:10 AM
http://www.c-sharpcorner.com/UploadFile/0c1bb2/bind-gridview-from-excel-file-records-using-Asp-Net-C-Sharp/
Dinesh VijayakumarPosted Jan 8, 2015, 1:42 AM
You can refer my code snippet http://www.c-sharpcorner.com/Blogs/47185/how-to-read-records-from-excel-to-datatable-in-C-Sharp.aspx
Thanks
Dinesh