Click here to Skip to main content
15,896,421 members
Articles / Web Development / ASP.NET

Dynamically access a database through a Web Application

Rate me:
Please Sign up or sign in to vote.
4.70/5 (22 votes)
24 Nov 20028 min read 285.1K   4K   119  
Using an ASP.NET Web application to access your database remotely.
// The following ifdef block is the standard way of creating macros which make exporting 
// from a DLL simpler. All files within this DLL are compiled with the WEBAPPUTIL_EXPORTS
// symbol defined on the command line. this symbol should not be defined on any project
// that uses this DLL. This way any other project whose source files include this file see 
// WEBAPPUTIL_API functions as being imported from a DLL, whereas this DLL sees symbols
// defined with this macro as being exported.
#ifdef WEBAPPUTIL_EXPORTS
#define WEBAPPUTIL_API __declspec(dllexport)
#else
#define WEBAPPUTIL_API __declspec(dllimport)
#endif

extern "C" WEBAPPUTIL_API char * DBConnstr(char *provider, char *server, char *userid, char *password);

extern "C" WEBAPPUTIL_API char * DBGetTables(char *connectStr, char *dbName, char *schemaName, bool systemTables);

extern "C" WEBAPPUTIL_API char * DBGetViews(char *connectStr, char *dbName, char *schemaName, bool systemView);

extern "C" WEBAPPUTIL_API char * DBGetIndexes(char *connectStr, char *tableName);

extern "C" WEBAPPUTIL_API char * DBGetProcs(char *connectStr, char *dbName, char *schemaName, char *procName=NULL);

extern "C" WEBAPPUTIL_API char * DBGetQuote(char *connectStr);

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here


Written By
Web Developer
United States United States
Jim is a programmer with 22 years experience starting with UNIX/C, assembly, then DOS, OS/2, AIX, Windows Visual Studio and learning .NET.

Comments and Discussions