Copy data from Excel and paste in GridView and database in ASP.Net

Question

any help for pasting a data from excel to gridview

veil · Accepted Answer

i have a solution to my problem i add the value to clipboard before i add it to a temporary table HTMLlttextarea id34TextArea134 name34TextArea134 cols348034 rows341034gtlttextareagtltbr gtltaspButton Text34Save34 OnClick34ReloadCtlClick34 runat34server34 OnClientClick34pasteContent34 gtltbr gtltaspGridView ID34GridView134 runat34server34 gtNamespacesusing SystemDataSqlClientusing SystemDatausing SystemConfigurationCprotected void ReloadCtlClickobject sender EventArgs e    string constr  ConfigurationManagerConnectionStrings34conString34ConnectionString    int i  0    string clip  RequestForm34TextArea134    string part  clipSplit39n39    for i  0 i lt partLength  1 i            using SqlConnection con  new SqlConnectionconstr                    using SqlCommand cmd  new SqlCommand34INSERT INTO Table1 VALU

Mudassar · Answer

Your way does not work in all browsers and hence check this cross browser solutionCopy and paste data from Excel  Clipboard to GridView in ASPNet

Copy data from Excel and paste in GridView and database in ASP.Net

Company

Explore

Follow us

Contact Us