Open your Internet Information Services manager and from the [your machine]/Web Sites/ Default Web Site node select the virtual folder which stores your project. Right Click and select Properties to select the ASP.NET tab page. Make sure the correct version ASP.NET Version is selected. I have VS.NET 2003 and 2005 beta 1 running side-by-side on […]
Month: September 2007
Categories
Creating a Stored Procedure – MySQL 5.0
DELIMITER$$ CREATE PROCEDURE testing(IN ID INT) BEGIN SELECT COUNT(*) AS numrows FROM clients.clients_domain; END$$ DELIMITER; The “DELIMITER $$” statement causes MySQL to use two dollar signs ($$) as it’s end-of-line delimiter, instead of a semi-colon (;). This will allow any SQL between the BEGIN and END to have a semi-colon at the end of the […]
public void dgBoundItems(object sender, DataGridItemEventArgs e) { foreach(TableCell cell in e.Item.Cells) { ///e.Item.DataSetIndex = row ///e.Item.Cells.GetCellIndex(cell) = column if (e.Item.Cells.GetCellIndex(cell) == 2 && e.Item.DataSetIndex > 0) { ///If the salary is less than 5000 the color must be red. if (Convert.ToInt32(cell.Text.Trim()) < 5000) { cell.ForeColor = Color.Red; } } } }