WebProWorld Dev Forum | I need help with a user portal Please forgive the usage of incorrect terms. So far my web design experience is limited to FP, Xara and other similar wysiwyg type programs.
ASP and headers question Here's the situation. I've got a custom 404 in ASP that is used to direct people to the correct page and correct product info based on information from the incorrect URL. |
| Recent Articles | Microsoft Releases Newest Visual Studio and SQL Server Microsoft announced availability of Visual Studio 2005 Beta 2, Microsoft .NET Framework 2.0 Beta 2 and the SQL Server 2005 April Community Technology Preview (CTP).
Meet the Community at OSBC Panel with Brian Behlendorf from Apache/Collabnet, Josh from PostgreSQL, Chris Hoffman from Mozilla, Larry Wall from Perl and David Wheeler from Bricolage. Moderated by Christian Einfeldt, "How these communities result..."
Serialize This - Saving Objects in PHP When building my website "Crossword Heaven" I came across a problem. I created a PHP object called "crossword" but needed to save the information in the object to a database. Now considering that this object contained a lot of information this was not an easy thing to do. Or was it?
What if Intelliseek Bought Technorati? The more I think about Intelliseek, the more I think they'll either try to muscle Technorati out of their market or they'll buy 'em. Intelliseek's BlogPulse Conversation Tracker is the sort of tool that I expected Technorati to build last year.
Google to Host Vlogs? InternetWeek reports that Larry Page said today that the company will soon let the general public upload self-produced videos to Google's servers, partly in an effort to learn more about how to more efficiently search and display information about video-based data.
Mastering Regular Expressions in PHP A regular expression is a pattern that can match various text strings. Using regular expressions you can find (and replace) certain text patterns, for example "all the words that begin with the letter A" or "find only telephone numbers". Regular expressions are often used in validation classes, because they are a really powerful tool to verify e-mail addresses
Web Development Processes And Technical Environments The process of Web application development is critical to the success of web-based projects. The proper processes can not be enforced unless technical environments are properly setup. Technical environments are required for development, test and production.
Apple Strikes Back at iTunes Hack Apple Computer has "closed" (cough) a security hole that allows users to download mp3s from the iTunes Music Store and purchase songs stripped of antipiracy protections according to a post on the subterrain.net blog. PyMusique emerged online last week as a copy protection-free interface into the popular iTunes store...
|
|
04.20.05
Connecting And Accessing Data Through ADO.NET
By Pawan Bangar
Microsoft's ADO.NET technology offers a solution to many of the problems associated with data access.
Accessing data has become a major programming task for modern software programming, both for standardalone applications and for web based applications. Microsoft's ADO.NET technology offers a solution to many of the problems associated with data access.
ADO.NET is an improvement to Microsoft ActiveX Data Objects (ADO). It is a standards-based programming model for creating distributed data-sharing applications. ADO.NET offers several advantages over previous versions of ADO and over other data access components. These benefits fall into the following categories:
Interoperability
Maintainability
Programmability
Performance.
Connecting to a database:
For performing and operation we need to connect to a database. This is done automatically through ADO connection, of which code is associated with VS.net Programming environment.
Connecting Database
sharp1.cs class xyz1 {
public static void main()
{
try
{
System.Data.ADO.ADOConnection s;
S=new System.Data.ADO.ADOConnection();
System.Console.Writeline("C-Sharp);
}
catch(System.Exception e)
{
System.console.Writeline(e.ToString());
}}}
Above program can be compiled through command line at DOS promot giving command line option as /r:System.Data.Dll
Because the code for ADO.Connection is available at this DLL. The above program consists of an object s resembling as System.ado.adoconnection .
Thus we are creating the object s by the statement:
System.Data.ADO.ADOConnection s;
From the output it is clear that the constructor has thrown no exception, as otherwise catch block would have been executed.
About the Author: Presently working in the capacity of the Technical Director of Birbals, an e-consulting firm based in India dedicated in providing innovative and effective web, Hospitality and consultancy services to public, private and non-profit organizations. Successfully founded Birbals and other IT companies like Ebirbals and SeoBirbals. |
Microsoft Great Plains ECommerce: Overview For Developer
By Andrew Karasev
Microsoft Business Solutions Great Plains was designed back in the early 1990s as the first graphical ERP/accounting system for mid-size businesses.
The architects of Great Plains Dexterity - this is the internal mid-shell, all Great Plains was written on, designed it to be easily transferable between graphical operating systems (MAC, Windows, Solaris - potentially) and database platforms - initially Great Plains was available on Ctree (both Mac and PC) and Btrieve, a bit later high end version Dynamics C/S+ was available on Microsoft SQL Server 6.5. But the idea was to catch or switch winning/losing database platform - nobody could predict if MS SQL Server, Oracle or DB 2 become a dominant DB platform, like Windows among OS. All these trade-ins for being potentially cross-platform application make the life of nowadays eCommerce developer difficult.
eCommerce developers were using Microsoft IIS and ASP-based Great Plains eCommerce around 4 years ago. Today, with the move to .Net and ASPX platform, server based scripts are replaced with .Net code behind approach and Great Plains eCommerce should be rewritten.
Microsoft Great Plains subdivision released SDK - eConnect which was targeted to eCommerce developers to manipulate Great Plains objects, such as Customer, SOP Order, Invoice, Quote, etc. What is a bit unpleasant - eConnect requires license key and is quite expensive for small internet eCommerce sites.
Custom Stored Procedures. Companies, like Alba Spectrum Technologies have implemented multiple diversified eCommerce projects with Great Plains at the back end. So, these custom stored procedures are available on the market, but they are not packaged as eConnect and could be purchased on the individual agreement base with Microsoft Great Plains partner.
Some Great Plains tables structure logic is required. You usually need consultant help, however you could try to make maximum work done. Tool->Resource Desciption->Tables, re-sort by Table Group technical name, then make test transactions in Great Plains (SOP module) and see where records go. This is how you design and test your queries.
About the Author: Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies – USA nationwide Microsoft CRM, Microsoft Great Plains customization company, based in Chicago, California, Texas, New York, Georgia and Florida and having locations in multiple states and internationally (www.albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer. |
|