How to select Third row from excel and store in database

Sumit Ringane

Hello,

I want to select third row from excel with entire column value . and this value in database table . using C# window application how I do this ?

please any one to know .

please post answer.

thank you.

3 Replies

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

Rajneesh Chaubey8y ago
Accepted answer
Hi Sumit,
Soppose you have loaded all the values from excel to datatable. Now create a cloned datatable(do not create or copy in a new datatable). I have tested the below code and it works:
DataTable dt = new DataTable();
dt = objDA.GetAll();//you have loaded all the rows from excel
int a = dt.Rows.Count;//you will get row count
DataTable newDataTable = dt.Clone();//cloned datatable
for (int i = 0; i <= a; i++)
{
if (i == 3)
{
DataRow row = dt.Rows[i];
newDataTable.Rows.Add(row.ItemArray);
//Now all values of 3rd row are there in newDataTable.
}
}
Hope it helps.
Happy coding!!
Thanks.
Nanddeep Nachan8y ago
Here is an article to read Excel data in DataSet
https://www.codeproject.com/Tips/509179/Read-Excel-File-into-DataSet-in-ASP-NET-Using-Csha

Use the same DataSet or filtered part of it to update to database
Nitin Sontakke8y ago
It always nicer to know what you have already tried. If you haven't tried anything already I suggest you google and put atleast bare minimum code and try.

Share the Excel you intend to read. Share the errors you are getting.

Share the table structure in script / text format so what we can create it at our end.

Please help us to help you better.