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 […]
Author: Melvin
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; } } } }
Categories
Finding Duplicates with SQL
Here’s a handy query for finding duplicates in a table using the GROUP BY and HAVING statement. Suppose you want to find all email addresses in a table that exist more than once: SELECT email, COUNT(email) AS NumOccurrences FROM users GROUP BY email HAVING ( COUNT(email) > 1 ) You could also use this technique […]
Categories
Inline IF’ Statement
C# string s; s = (true ? “True” : “False”); //s will be “True” VB.NET Dim s As String s = If(True, “True”, “False”) ‘s will be “True” ‘In the following you cannot rely on a particular function ‘not being called if the other argument is selected by Expression ‘(notice IIf vs. If) s = […]
Categories
DateTime Format String
DateTime now = new DateTime(2006, 9, 07, 15, 06, 01, 08, DateTimeKind.Local); now.ToString(); //”09/27/2006 15:06:01″ Year now.ToString(“%y”); //”6″ now.ToString(“yy”); //”06″ now.ToString(“yyy”); //”2006″ now.ToString(“yyyy”); //”2006″ Month now.ToString(“%M”); //”9″ now.ToString(“MM”); //”09″ now.ToString(“MMM”); //”Sep” now.ToString(“MMMM”); //”September” Day now.ToString(“%d”); //”7″ now.ToString(“dd”); //”07″ now.ToString(“ddd”); //”Thu” now.ToString(“dddd”); //”Thursday” Hour now.ToString(“%h”); //”3″ now.ToString(“hh”); //”03″ now.ToString(“hhh”); //”03″ now.ToString(“hhhh”); //”03″ now.ToString(“%H”); //”15″ now.ToString(“HH”); //”15″ […]
Categories
Problems with MagicAjax
I added what is below to my web.config file: <httpModules> <add name=”MagicAjax” type=”MagicAjax.MagicAjaxModule, MagicAjax”/> <add name=”ScriptModule” type=”Microsoft.Web.Services.ScriptModule”/> </httpModules> And I got: Could not load file or assembly ‘MagicAjax’ or one of its dependencies. The system cannot find the file specified. (C:\Inetpub\wwwroot\TheTracker\web.config line 48) The solution I found that worked was adding the MagicAjax assembly to […]
Categories
SQL: YYYYMMDD
SELECT CONVERT(VARCHAR(8), GETDATE()-365, 112) This is a way to query and get the date in the following format: YYYYMMDD I came across some dates saved in the database in this format as a varchar and had to use this to initially get the date and then convert it from and integer to varchar.
Categories
Standard Date Formats
View Standard Date Formats
Error: Back up the transaction log for the database to free up some log space. To recover from a full transaction log If the log is 100% full you cannot truncate it by backing it up, since the backup has to be recorded in the transaction log. For version 6.5, use: DUMP TRANSACTION dbName WITH […]