The ASP.NET/MYSQL Project

Contents:

• Using Variables in MySQL query commands
• DataGrids, Gridview, ListView Notes, including Custom Paging on these controls.
• Select a MySQL table from a dropdown list and execute a SQL command on it.
• Insert Data into a MySQL table from ASP.NET.
• Create a LIMIT statement based on select SUM() of another table.
• Repeater/ListView OnItemDatabound - working code that demos letting you conditionally modify displayed data as it is rendered (loaded in a Ajax TabContainer control w/ Lazy Load).
• Newbie FAQ and/or Problems

Non-MySQL, but ASP.NET related:

• Multi-Column DropDownList without using a 3rd party control. Also shows a query to return a fixed-width field from MS Access.

Items of Interest:

• Issue Tracker (Ticket Tracker, Help Desk) Starter Kit Open Source, asp.net, Visual Basic (VB). The Issue Tracker enables project teams to keep track of outstanding issues, assigned owners, history and related issues through a Web-based interface. It is a little rough, but that's why they call it a "starter kit." (Note: It is "open source" but not GPL).
• Dependent Dropdowns - javascript (yahoo maps) in asp.net. -- no mysql, but it wouldn't be hard to pull the data from a db. This is a good example of dependent dropdown lists without using Ajax. The dropdowns select locations to load from Yahoo Map! It is also really hard to find good examples of this in asp.net.
• dotForum.zip  ITCN dotForum 2004+,  published under GPL license. The ITCN Asp.Net Forum 2004+ is the same version as ITCN Asp.Net  Forum 2004, only updated for Dot Net 3.5 and includes some very minor bug fixes that caused some pages not to load in Dot Net 3.5 / Visual Studio 2008. The new default setup is to use the included  Access mdb file, but it could be adapted to other database backends.
  
• jThreadedComments  A simple, but professionally coded threaded comment system (C#, Asp.net 3.5) released under GPL v3. This was a vworker.com project and is rough, but usable. It was designed for use on a company intranet. It was devloped to be as "drop-in" as possible, and works by passing it a row ID of a gridview or listview.
  

Tags:  asp.net 3.5, Visual Basic, VB, MySQL 5.1, MySQL .net connector