Query about storing the MS Excel sheet into database

Question

Hiiii I need to store the MS Excel sheet as Entity into the database using C# please suggest me

nagendra prasad · Answer

Thanks Joginder Banger

Joginder Banger · Answer

Hi Nagender Prasad I have done it before some time it's may help you. string holdcolumnname = ; //Array.ForEach(Directory.GetFiles((Server.MapPath(~/admin/Import/))) File.Delete); // Delete for all file in the Import Directory. string path = string.Concat((Server.MapPath(~/admin/Import/ + youfileName))); directoryName.PostedFile.SaveAs(path); string temp = Path.GetExtension(path); if (temp == .xls) comman = new OleDbConnection(Provider=Microsoft.ACE.OLEDB.12.0;Data Source= + path + ;Extended Properties=\Excel 8.0;HDR=YES;IMEX=1;\;); else comman = new OleDbConnection(Provider=Microsoft.ACE.OLEDB.12.0;Data Source= + path + ;Extended Properties=\Excel 12.0;HDR=YES;\;); comman.Open(); OleDbCommand cmd = new OleDbCommand(SELECT * FROM [Sheet1$] comman); conn.Open(); DbDataReader dr = cmd.ExecuteReader(); dt.Load(dr);