We’re back to some XML Bulk Loading links today. To start with, I received a very interesting error, summed up in this link: XML Bulk Load unable to load schema. An error occurred (Unknown Error). Not only is that a brilliant error message, but there’s very little on the Internet about it. My problem was that I was trying to access the schema from the local C drive but apparently the service running bulk uploading did not have access privileges to that file. I rectified this by putting it on the local web server (because our particular app is a web app which runs locally on individual machines).
After that, I received the even-better following error message: “Unspecified error (Exception from HRESULT: 0x80004005 (E_FAIL))”. I don’t believe that there are any posts on the internet which relate directly to the bulk uploading service, but in my case, the problem came about because I was missing an attribute row in my XML schema. It might have something to do with it being the final attribute of the schema, but it was special enough to merit this cryptic error code. So check all of your values and make sure that you aren’t missing any table fields is my advice.
Moving on to .Net controls, if you want to perform an action on each row in a GridView, it’s rather simple, as this post demonstrates. The example there is selecting a check box, but it’s generically applicable and works well for times when you have to work with the grid after data binding. And to end things with a slight bit of CSS, if you want to have two divs next to each other, make both “float:left” and as long as their widths do not exceed the width available in the container/browser window, you’ll be in good shape. I used this to have two separate forms in my MVC application: a section to add notes and a section to upload files for those notes.
* – Okay, they will parse quotation marks if you use single-quotes around values, but I use standard quotation marks because they’re less likely to occur in my particular data sets.