Friday, March 23, 2007

How To Setup SQL Server Reporting Services for email delivery

Here is how to get SQL Server Reporting Services email to work:

You simply need to edit the RSreportserver.config file and enter your mail host name.

In the section; you need to alter the following two lines in the reportserver.config:

mail.yourname.com
ReportServer@yourname.com

For further information, see Microsoft's long winded version here:
Configuring a Report Server for E-Mail Delivery

Wednesday, March 07, 2007

Changing the web.config while web server is running

When an ASP.NET application launches a watch is put on the web.config file. ASP.NET will detect if the web.config changes while the application is running.

When ASP.NET detects a change it will spin up a new version of the application with the new settings in effect.

Any in process information, such as data kept in Session, Application, and Cache will be lost (assuming session state is InProc and not using a state server or database).

http://www.odetocode.com/Articles/345.aspx

Monday, January 08, 2007

Windows Vista Beta: How to dual-boot Windows XP and Windows Vista - Lifehacker

If you need to get out of Vista, and get back to XP, try this:

Windows Vista Beta: How to dual-boot Windows XP and Windows Vista - Lifehacker:

"type FIXBOOT followed by FIXMBR "

I was unable to modify the boot order and defaults from within XP. Vista uses a new system. So, if you wish to remove Vista, be very careful. Don't just blunder in from XP and remove the partition... The technique that I used was to boot off the XP CD and enter a recovery console. Then, after logging is as administrator, type FIXBOOT followed by FIXMBR and exit to reboot. It goes without saying that you should be sure that you have a backup before doing this. You do, don't you? This will get you back to your original XP boot process.

Thursday, September 14, 2006

How to access control in FormView

How to access control in FormView: "TextBox DataTitle = (TextBox)DataSourceItemView.FindControl('DataTitle');"




=================
protected void FormView1_ItemCreated(object sender, EventArgs e)
{
if (FormView1.CurrentMode == FormViewMode.Insert)
{
TextBox txtName =
FormView1.Row.FindControl("CategoryNameTextBox") as TextBox;

txtName.Text = "New Name...";
}

}
==================

Thursday, August 10, 2006

Richard Dudley : The Assembly Version ( [ASSEMBLYVERSION] ) does not match the Database Version ( [DATABASEVERSION] )

Richard Dudley : The Assembly Version ( [ASSEMBLYVERSION] ) does not match the Database Version ( [DATABASEVERSION] ): "The Assembly Version ( [ASSEMBLYVERSION] ) does not match the Database Version ( [DATABASEVERSION] ) "

I think this is mainly a connection problem. Be sure to stop the Visual Studio Web server in the tool tray.

Wednesday, August 09, 2006

Error: Failed to generate a user instance of SQL Server... | differentpla.net

Error: Failed to generate a user instance of SQL Server... differentpla.net: "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed."

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]+$');
}"

Wednesday, June 07, 2006

Is a Temporary Table Really Necessary?

Is a Temporary Table Really Necessary?

Shows how to do looping in SQL.

WHILE @lngLoopCount <> 0BEGIN
SET @strTabName = (SELECT strTableName FROM #tTables WHERE numID = @lngLoopCount)
EXEC sp_spaceused @strTabName
SET @lngLoopCount = @lngLoopCount - 1END

Tuesday, June 06, 2006

Unskilled and Unaware of It: How Difficulties in Recognizing One's Own

Unskilled and Unaware of It: How Difficulties in Recognizing One's Own
Incompetence Lead to Inflated Self-Assessments

http://www.apa.org/journals/features/psp7761121.pdf