For those new to message boards please try to follow a few simple rules when posting your question.
Choose the correct forum for your message. Posting a VB.NET question in the C++ forum will end in tears.
Be specific! Don't ask "can someone send me the code to create an application that does 'X'. Pinpoint exactly what it is you need help with.
Keep the subject line brief, but descriptive. eg "File Serialization problem"
Keep the question as brief as possible. If you have to include code, include the smallest snippet of code you can.
Be careful when including code that you haven't made a typo. Typing mistakes can become the focal point instead of the actual question you asked.
Do not remove or empty a message if others have replied. Keep the thread intact and available for others to search and read. If your problem was answered then edit your message and add "[Solved]" to the subject line of the original post, and cast an approval vote to the one or several answers that really helped you.
If you are posting source code with your question, place it inside <pre></pre> tags. We advise you also check the "Encode "<" (and other HTML) characters when pasting" checkbox before pasting anything inside the PRE block, and make sure "Use HTML in this post" check box is checked.
Be courteous and DON'T SHOUT. Everyone here helps because they enjoy helping others, not because it's their job.
Please do not post links to your question into an unrelated forum such as the lounge. It will be deleted. Likewise, do not post the same question in more than one forum.
Do not be abusive, offensive, inappropriate or harass anyone on the boards. Doing so will get you kicked off and banned. Play nice.
If you have a school or university assignment, assume that your teacher or lecturer is also reading these forums.
No advertising or soliciting.
We reserve the right to move your posts to a more appropriate forum or to delete anything deemed inappropriate or illegal.
This is my code but this code is not working,that means it
not displaying data from tables in Grid view.
public partial class _Default : System.Web.UI.Page
String a, b;
I have came across a requirement, where converting a traditional excel application (with 7-8 diff sheets and each sheet with 50k cells and lots of macros / tables in it) into a web application.
Can any one suggest me which is the best way of doing this in .net, where I have to resemble the application just like the excel sheet. Here the challenging part is importing all the data, formulea and the macros into the web application, and have the luxury of SQL server as well for data. The JSON data of each sheet along with formulas and values is coming around 4mb.
Your suggestion are valuable and very much appreciated.
It's the requirement. Where an age old traditional excel application to be converted/ redesigned as web application with out changing the look and feel much, as the client is not willing in changing the same old excel interface.
I'm exactly not sure whether this can be done by a grid. and I have big question of retrieving the data, formulas and macros of the excel application as is.
It's urgent and pls help on this.
The "requirement" seems to be to be able to access Excel workbooks over the internet (and not to eliminate Excel).
As Pete said, you can upload Excel workbooks to SharePoint and share them between users.
You get Excel "look-and-feel" and a "web application".
A "SharePoint Online" subscription starts at less than $5.00 per month where you can do a proof-of-concept. The Excel / Office components may add a few $ per month but you can cancel any time. Note that "external users" with read-only access to your SharePoint site cost nothing.
I'd be surprised if you could not get this up and running in less than a week (and no C# needed. Sorry).
of course it's some thing like accessing the excel work books over internet, along with some functionality enhancements like logs, database interactions, monitoring the data change as well.
I'm trying this in jquery, using the jquery.sheet plugin. which can be used to create a sheet just like excel. but here the problem is I'm not able to do much changes when the application demands any, as this is a free plugin and not much documentation is provided.
1. Keep in the backend "Your Excel Sheet based service". This can be implemented in you web server as a singleton (for perfomance) object that uses Interop for interacting with you Excel sheet.
2. Your web app, queries "Your Excel Sheet based service" to get the grid data to send to the browser
5. Any change is sent as a browser request to your web app (via Ajax or page reload)
6. Your web app, updates "Your Excel Sheet based service", so Excel applies the macros and calculations, and the new values are sent to the web browser on the request response (Ajax or page content)
Conceptually you get everything, and the best of both worlds. The good part is that you do not need to reimplement all your Excel logic (macros, formulas,...), the bad part is that you need to reimplement all the interface to reach this logic (grid cells paradigm, REPL cycle, ...)
Although it can be done, in practice this is far from an ideal solution as:
- An strategy is needed to avoid multiple users locking your Excel resource
- Using interop in the server might lead to memory leaks and stability issues. Also it can easily become a CPU resource hog.
- User interface and usability is greatly dependant on the chosen grid, and might depart greatly from Excel look and feel
Although the cons can easily overweigth the pros, depending on your requirements (number of users, complexity of Excel logic..), budget, resources and available time can be a way to go.
That should probably be done on the database (server?), using an SQL-statment. There it would be relative easy to manipulate your where-clause.
You're now comparing in-memory datasets. You could still iterate it for each record in table1 and see if it is contained in table2 (look up over the primary key). Also the other way around, see if anything from table2 is contained in table1. Write those to table three.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]