asp.net - cannot find installable isam even -

- 

 string filepath = configurationmanager.appsettings["filepath"].tostring();             string filename = string.empty;             if (testupload.hasfile)             {                 try                 {                     string[] allowedfile = { ".xlsx" };                     string fileext = system.io.path.getextension(testupload.postedfile.filename);                     bool validfile = allowedfile.contains(fileext);                     if (!validfile)                     {                         page.clientscript.registerstartupscript(this.gettype(), "scripts", "<script>alert('upload excel file');</script>");                     }                     else                     {                         int filelen = testupload.postedfile.contentlength;                         if (filelen < 1048567)                         {                             filename = path.getfilename(server.mappath(testupload.filename));                             testupload.saveas(server.mappath(filepath) + filename);                             string filepath = server.mappath(filepath) + filename;                             oledbconnection xlcon = null;                             if (fileext == ".xlsx")                             {                                 xlcon = new oledbconnection(@"provider=microsoft.ace.oledb.12.0;data source" + filepath + ";extended properties =\" excel 12.0 xml;hdr=no;imex=1;\"");                             }                             xlcon.open();                             datatable dt = xlcon.getoledbschematable(oledbschemaguid.tables, null);                             string xlsheetname = dt.rows[0]["table_name"].tostring();                             oledbcommand xlcmd = new oledbcommand(@"select * [" + xlsheetname + "]", xlcon);                             oledbdataadapter xladpt = new oledbdataadapter(xlcmd);                             dataset xlset = new dataset();                             xladpt.fill(xlset);                             page.clientscript.registerstartupscript(this.gettype(), "scripts", "<script>alert('file uploaded');</script>");                             xlcon.close();                             filedatagrid.datasource = xlset;                             filedatagrid.databind();                         }                         else                         {                             page.clientscript.registerstartupscript(this.gettype(), "scripts", "<script>alert('uploaded file size should not greater 1mb');</script>");                         }                     }                 }                 catch (exception exp)                 {                     page.clientscript.registerstartupscript(this.gettype(), "scripts", "<script>alert('" + exp.message + "');</script>");                 }             }             else             {                 page.clientscript.registerstartupscript(this.gettype(), "scripts", "<script>alert('select file upload');</script>");             }

i using code import excel file gridview in asp.net,but giving exception "cannot find installable isam".i have checked many solutions microsoft forums didn't work.i use ms office 2016, visual studio 2015 enterprise. how resolve problem.


Comments

Post a Comment

Popular posts from this blog

ios - MKAnnotationView layer is not of expected type: MKLayer -

-
Image
so code works fine logger riddled message. there way rid of or suppress it? postannotation.swift class postannotation: mkpointannotation { //mark: properties let post: post //mark: initialization init(post: post) { self.post = post super.init() self.coordinate = cllocationcoordinate2d(latitude: post.latitude, longitude: post.longitude) self.title = post.title self.subtitle = post.timestring() } } adding annotation let annotation = postannotation(post: post) self.map.addannotation(annotation) func mapview func mapview(_ mapview: mkmapview, viewfor annotation: mkannotation) -> mkannotationview? { if annotation mkuserlocation { return nil } var annotationview = mapview.dequeuereusableannotationview(withidentifier: "pin") as? mkpinannotationview if annotationview == nil { annotationview = mkpinannotationview(annotation: annotation, reuseidentifier: "pin")
Read more

ZeroMQ on Windows, with Qt Creator -

-
i have installed zmq link given below on windows 7. http://zeromq.org/distro:microsoft-windows 1) have c++ project in qt-creator , i'm using zmq c++ binding (zhelpers.hpp etc). 2) have added .lib installed zmq folder qtcreator 3) while compiling, compiler looks _imp__zmq_verion, in .dll files present in .lib have __imp_zmq_version. 4) causing undefined reference zmq_version. anyone else faced problem , has solution ?
Read more

unity3d - Unity SceneManager.LoadScene quits application -

-
i have 2 different scenes 1 named 'main' , other 'game' both added scenes in load. when use scenemanager.loadscene("game"); works no problem when tried return main scene code if (input.getkeydown (keycode.escape)) { scenemanager.loadscene("main"); } strangely game quits. thanks. sorry interruption. somewhere on other script found code. if (input.getkeydown (keycode.escape)) { application.quit (); } that's bad, know...
Read more