Thursday, July 27, 2006

Clear the List of URLs That Appear in the Internet Explorer Address Bar

How Can I Clear the List of URLs That Appear in the Internet Explorer Address Bar?
Q
Hey, Scripting Guy! How can I clear the list of URLs that appear in the Internet Explorer address bar?
-- GA
A
Hey, GA. You know, if you’ve ever pondered the question, “What is it that makes the Scripting Guys different from other Microsoft employees?” well, we can save you some time and trouble by just giving you the answer: the Scripting Guys are dumber than other Microsoft employees. For example, it turns out that the list of URLs that appear in the Internet Explorer address bar drop-down list are stored in the registry; to be more specific, they are stored in this registry key:HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\TypedURLs


Hey, Scripting Guy!

Tuesday, July 18, 2006

BET: Excel - Functions User Defined - REVERSE

BET: Excel - Functions User Defined - REVERSE: "Returns the contents of a cell with all the characters reversed."

Chris Hays's Reporting Services Sleazy Hacks Weblog

Here is how to create a green bar alternating line color in Microsoft Reporting Services:


Chris Hays's Reporting Services Sleazy Hacks Weblog

Wednesday, July 12, 2006

Free - Reporting on Hierarchical Recursive data using MS Reporting Services - ColdFusion Development - CFzone.NET

Here is how to do a reporting services in C#:

Free - Reporting on Hierarchical Recursive data using MS Reporting Services - ColdFusion Development - CFzone.NET


private void Form1_Load(object sender, EventArgs e)
{
//declare connection string
string cnString = @"Data Source=(local);Initial Catalog=northwind;" + "User Id=northwind;Password=northwind";
//use following if you use standard security
//string cnString = @"Data Source=(local);Initial
//Catalog=northwind; Integrated Security=SSPI";
//declare Connection, command and other related objects
SqlConnection conReport = new SqlConnection(cnString);
SqlCommand cmdReport = new SqlCommand();
SqlDataReader drReport;
DataSet dsReport = new dsEmployee();
try
{
//open connection
conReport.Open();
//prepare connection object to get the data through reader and
// populate into dataset
cmdReport.CommandType = CommandType.Text;
cmdReport.Connection = conReport;
cmdReport.CommandText = "Select FirstName + ' ' + Lastname AS
EmployeeName, EmployeeID, ReportsTo From Employees";
//read data from command object
drReport = cmdReport.ExecuteReader();
//new cool thing with ADO.NET... load data directly from reader
// to dataset
dsReport.Tables[0].Load(drReport);
//close reader and connection
drReport.Close();
conReport.Close();
//provide local report information to viewer
reportViewer.LocalReport.ReportEmbeddedResource =
"RecursiveData.rptRecursiveData.rdlc";
//prepare report data source
ReportDataSource rds = new ReportDataSource();
rds.Name = "dsEmployee_dtEmployee";
rds.Value = dsReport.Tables[0];
reportViewer.LocalReport.DataSources.Add(rds);
//load report viewer
reportViewer.RefreshReport();
}
catch (Exception ex)
{
//display generic error message back to user
MessageBox.Show(ex.Message);
}
finally
{
//check if connection is still open then attempt to close it
if (conReport.State == ConnectionState.Open)
{
conReport.Close();
}
}
}

Thursday, July 06, 2006

The Bumpy Blog : IsNumeric in C#, WHY NOT?

Here is how to do a "IsNumeric in C#":


using System.Text.RegularExpressions;

static bool IsNumeric(string inputString)
{ return Regex.IsMatch(inputString, "^[0-9]+$"); }



I found it here:
The Bumpy Blog : IsNumeric in C#, WHY NOT?: "static bool IsNumeric(string inputString)
{
return Regex.IsMatch(inputString, '^[0-9]+$');
}"