Dotnetindex.com

Page and User Control Communication

This article shows how the page and user controls within the page can communicate together with a little more work. It shows how the use of interfaces or custom page classes can make the application more efficient and reduce code.

Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAssassin, ClamAV)

This document describes how to install a mail server based on Postfix that is based on virtual users and domains, i.e. users and domains that are in a MySQL database. I'll also demonstrate the installation and configuration of Courier (Courier-POP3, Courier-IMAP), so that Courier can authenticate against the same MySQL database Postfix uses.

MySQL backup,compress and FTP from WinForms app

From your Windows Forms application, implement two menu commands
a) backup entire MySQL database, compress it and send it with FTP to a ftp server
b) reverse = fetch from FTP server, uncompress, restore to MySQL

PHP Security

Writing PHP applications is pretty easy. Most people grasp the syntax rather quickly and will within short time be able to produce a script that works using tutorials, references, books, and help forum forums like the one we have here at PHP Freaks. The problem is that most people forget one of the most important aspects that one must consider when writing PHP applications. Many beginners forget the security aspect of PHP.

Displaying mySQL table structures in PHP

You can get information about tables using SHOW TABLE STATUS query. This query gives you a detailed info about all tables in your database.

Parsing XML/RSS feeds easily with SimpleXML

In this tutorial, we will try to parse an RSS feed using SimpleXML . SimpleXML is a new focus provided in PHP5. It's a very useful object. This powerful object converts XML data to object. SimpleXML is enabled by default.

Methods of Session Object

Session object is a very useful helper to store and track information for web clients. When you've create a session object, a cookie will be sent to client's browser and thsi will be used to store data. Session object contains three methods: Abandon, Contents.Remove and RemoveAll

Simple-XMLRSS-Parser--Part-II

This is second and extended version of simple XMLRSS parser. Simple XML/Parser is a XML parser designed for to parse most valid news and blog feeds. No database required to work with it. All you need is to include a subroutine in your code and call it. This version can also choose and display a limited number of feed.

Sending-queries-to-mySQL

PHP send quesries to mySQL using mysql_query function. mysql_query function returns boolean (True or False) value which your quesry does not return any records. Queries (sql statements) like SELECT, SHOW, DESCRIBE, EXPLAIN return false value on error. If query is true, returning value must pass to mysql_fetch_array().

Beginning-Ajax-and-ASPNET-35

Ajax is a great helper to us while developing rapid applications without worrying us at power of asynchronous. In Visyal Web Developer 2008 comes with builtin Atlas and ASP.NET3.5 . In this tutorial, I try to show you what's ajax and database querying at same time.

A-timesaver-control-GridView

ASP.NET 2 has got several new foucs on development. Probably gridView will be your best friend of you. The GridView control automates many of the features of the DataGrid control. You have a full control on viewing, sorting, paging and editing. This sample is only a beginner guide but I hope that you will discover many features of gridView.

Using-File-Uploading-Control

.NET comes with great features. Anymore your do not need any additional code libraries to upload files to your web server. Microsoft.NET includes itself a file upload wizard. Now we will examined and play with this tool. I've used Visual Web Developer 2008 and ASP.NET 3.5 to create this sample application.

 

Executing-SQL-Server-Stored-Procedure-from-Perl

This article illustrates how to setup a development environment using Perl and SQL Server on the following platforms: Microsoft Windows, Red Hat Linux, and Sun Solaris. Step by step, you can learn, and may choose, the best way that fits into your own requirements.

Error-5132-Returned-Maintaining-81-Triggers-Using-Pre81-ADS-Clients

The Error "5132: The Specified database object name is not valid. There is no such named Trigger in the data Dictionary" (is returned when trying to maintain a trigger that has been created with Advantage version 8.1 or greater using a pre-8.1 Advantage Client (i.e. ARC).

When-using-the-following-SQL-statement-the-error-2117-Unexpected-extra-token-is-returned

An Order By clause is illegal in an SQL INSERT INTO statement.
By default a table is a set of unordered rows. With ADT tables this is especially true due to record recycling. When a row is marked for deletion the physical row is not removed from the table but is marked as "free". During an INSERT statement any rows that are marked as free will be used first. Due to this behavior rows may be inserted into the table at odd location. Rather then inserting the rows in a specific order it is best to retreive the rows in a specific order using the ORDER BY clause in a SELECT statement.