We all know in ASP.NET, to get the absolute path from the relative path, you can prefix your relative path with the Tilde character as follows:
MyHyperLink.NavigateUrl = "~/Catalog/ASP/Products";
I'm currently organizing an MS Access database and setting up some SQL queries that export data into CSV files for Yahoo Store. One of the things I had to do was to create fields in the CSV file that are compound of other existing fields in the database, and some that even depended on the existence of other physical fields in the Access database.
Using LIKE statement in an SQL query requires specifying wild cards in the search pattern. In C# .NET, the wild card is %, however if you are building your SQL query directly from MS Access, I found out you need to use the asterisk (*) instead of (%) wild card to achieve the same result.
Copyright © 2007 Yousef Mannaa. All material on this site is copyrighted.
Do not publish or reproduce any of this material without written permission from