How to select Third row from excel and store in database

Question

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.

Rajneesh Chaubey · 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 { 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.

Nitin Sontakke · Answer

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.

Nanddeep Nachan · Answer

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

How to select Third row from excel and store in database

Answers (3)