Displaying Excel Information in ASP Pages
Question: How can ASP query an Excel sheet and get all the books’ names that reside in that Excel document using ADO (or any other way)? I want to display
Question: How can ASP query an Excel sheet and get all the books’ names that reside in that Excel document using ADO (or any other way)? I want to display
Question: In Visual InterDev I have successfully added a data connection. In the Data View I can see all my tables, fields, etc. My database resides on a SQL 7
Question: My Web site does not seem to be doing anything with the Session_OnStart procedure I have written. Any thoughts as to why? Answer: Many times programmers place the Global.asa
If your page design includes attractive and colorful fonts, you may not want to use an ordinary HTML Submit button on your form. Sometimes you may want to submit the
There are times when you have to use the exec(…) method of java.lang.Runtime class to launch a program. For example: public void some_method()…String[] commandArray = new String[1];commandArray[0] = “some_program”;java.lang.Runtime rt
hat’s a Sneaky ASP Trick? It’s a simple, elegant non-traditional solution to an ASP development issue. This article explains how to display a progress indicator in your ASP page when
roperty lists are a convenient means of storing user preferences andapplication configuration information in a file.The java.util.Properties class makes managing property lists easy.It is a Hashtable intended only to store
bjects you build don’t always have to be related to a database entity. In fact, some of the best objects are pure service objects that know how to talk to
hile lurking on the SQL List server, I happened upon a suggestion that eliminates the need for writing your own cursors to accomplish common database administration tasks. These tasks apply
Question: We have users coming into our homepage from two different servers. I would like to differentiate what gets shown (text, links, and so forth) based on the server that
The actual size of the built-in integral types are machine dependent (see also the Tip Standards Provide Guarantees Regarding the Sizes of Integral Types): //built-in integral types with machine-dependent sizeschar
In general, a derived class that inherits a pure virtual member function from its abstract base class implements this function. The opposite is also true: a virtual member function that
Char, short, int, and long have implementation-defined sizes. However, Standard C and C++ provide a few guarantees about their sizes. Both standards guarantee that char has at least 8 bits,
Always set the Description property of your ActiveX projects (found in Properties) to be prefixed with your company name or initials. That way, all your internal objects and components will
Although Microsoft Internet Information Server (IIS) eventually removes your unused database objects (called garbage collection), poor coding can squander the server’s resources. If your Web server drags or even fails
A Data Source Name (DSN) server is one that receives replication data through ODBC. This DSN can be accessed only through Microsoft SQL Server because replication is being used. The
Question: I can start excel on my server from an ASP script and then create and save a document. When I’m done, Excel doesn’t shutdown. I’ve tried various commands to
Question: After significant development time, a wonderful class derived from CWnd was created by our team to pull together text, graphics, etc. in a Paintbrush type of application. Now, we’d
Question: I have a DHTML form that is dynamically generated based on a user’s selection from a list box. It generates a table line for product information which includes text
Question: When a user accesses an application on my site, a sessionID is generated. After the application is accessed the user leaves the machine alone until the session times out.
If your Web page is formatted to look best in a certain size of window, you can try resizing the visitor’s browser using the resizeTo() method. Do this when the
You should use single quotes to enclose character strings within Transact-SQL queries when used with MS SQL Server. The advantage is that your queries will work regardless of the QUOTED_IDENTIFIER
Question: I have a char array, for example: char orig_amt [20]. I need to convert this to an int orig_amt so I can do some calculation. Is there a command
Question: As a rule of thumb, a query that does a join will run faster if the table with the least number of rows is referenced first in the FROM-clause
Question: How can I delete more than 1 Item from the listbox at once? Answer: I don’t believe the Windows list box allows you to delete more than one item
Question: I am working on an assignment that asks us to determine why using C++ is a bad choice, from a software engineering perspective.So far, I have found that C++
Question: I have 2 databases in SQL7. I need to attach one table, TB1, from DB1 to DB2, to run a join query. My query uses TB1 from DB1 and
Question: I have a small console program that requires I pass arguments for it to run specific functions. I want to change the code so it automatically runs a set
Question: How do I read in both a character string and int value from a file? The data I am trying to read looks like this: Name1 10 10 10Name2
Question: I have a message box that comes up to warn the user that they are terminating the application as it normally should be left running. I want to know