excel file upload in asp.net

Question

excel file upload then update our sql server table in asp.net using c#.

Vimlesh Mishra · Answer

i have done my problem. thanks dear for ur help...

Sanjeeb Lenka · Answer

hi share your sample code i will modify.

Vimlesh Mishra · Answer

any sample demo please send my email id. vimleshmishra2008@gmail.com only for bulk update.

Sanjeeb Lenka · Answer

if you want both insert and update the try do it using a single stored procedure. if the id is null it will insert. if not it will update..

Vimlesh Mishra · Answer

its a insert not a update. how to pass.. update tablename set fildname='?' where primaryfild='1' how to make this format upload time. please help me.

Sanjeeb Lenka · Answer

What the problem you are facing in that example.

Vimlesh Mishra · Answer

not working. besacaly i am bulk update our table.

Sanjeeb Lenka · Answer

hi refer to this link for example http://www.aspdotnet-suresh.com/2010/09/import-data-from-excel-to-sql-database.html http://www.aspsnippets.com/Articles/How-to-Import-Excel-Sheet-data-into-SQL-Server-using-ASPNet.aspx