Moojjoo Blog

SharePoint 2010 Day at Microsoft Campus in Charlotte

2011-09-14T11:50:00.000-04:00

Getting questions answered and great overview of SharePoint 2010 for the current MOSS 2007 to SharePoint 2010 project I am currently working on in my current contract.

SharePoint 2007 & 2010 Index and Search sizes

2011-09-02T12:43:00.002-04:00

If you need to review sizing of current implementation of SharePoint Index and Search

Go to > Central admin > Operations > Services on Server > Office SharePoint Server Search Service Settings

Copy the Default index file location : Run paste

Select and review properties that will provide the size of index

Next for Search simply navigate on SQL Server and right click on Search DB and review properties.

MOSS 2007 on Windows Server 2008 R2

2011-08-31T01:51:00.001-04:00

I ran into a solution for getting Central Admin to display on Windows Server 2008 R2 today. Basically you have to open IIS 7.0 and ensure that the Physical Path is correct. For some reason the install had an incorrect physical path. I fixed it and everything worked.

Next was installing MOSS 2007 SP2 slip stream on the rest of the farm. Ensure you open the port that Central Admin is installed on or you will not be able to access. LESSONS LEARNED FROM MOOJJOO

Setup new URL

2011-03-26T22:08:00.001-04:00

dotnet.mmwebs.com going to see if I can access blogger from work.

Add JavaScript to handle two scripts in ASP.NET

2010-11-19T11:08:00.002-05:00

protected void ApplyJavaScriptForPostToIris()

{

System.Text.StringBuilder sbValid = new System.Text.StringBuilder();

sbValid.Append("if (confirm('Are you sure you want to post this file to app') == true){");

sbValid.Append("this.disabled = true;");

sbValid.Append("} else { return false;}");

sbValid.Append(this.ClientScript.GetPostBackEventReference(this.btnPostToIRIS, "") + ";");

this.btnPostToIRIS.Attributes.Add("onclick", sbValid.ToString());

}

Looping through SQL Server ... This has to be saved. To many hours spent.

2010-11-09T09:47:00.000-05:00

I know I will have to do this again....

This article describes various methods that you can use to simulate a cursor-like FETCH-NEXT logic in a stored procedure, trigger, or Transact-SQL batch.

Use Transact-SQL Statements to Iterate Through a Result Set

There are three methods you can use to iterate through a result set by using Transact-SQL statements.

One method is the use of temp tables. With this method, you create a "snapshot" of the initial SELECT statement and use it as a basis for "cursoring." For example:

/********** example 1 **********/

declare @au_id char( 11 )

set rowcount 0

select * into #mytemp from authors

set rowcount 1

select @au_id = au_id from #mytemp

while @@rowcount <> 0

begin

set rowcount 0

select * from #mytemp where au_id = @au_id

delete #mytemp where au_id = @au_id

set rowcount 1

select @au_id = au_id from #mytemp

end

set rowcount 0

A second method is to use the min function to "walk" a table one row at a time. This method catches new rows that were added after the stored procedure begins execution, provided that the new row has a unique identifier greater than the current row that is being processed in the query. For example:

/********** example 2 **********/

declare @au_id char( 11 )

select @au_id = min( au_id ) from authors

while @au_id is not null

begin

select * from authors where au_id = @au_id

select @au_id = min( au_id ) from authors where au_id > @au_id

end

NOTE: Both example 1 and 2 assume that a unique identifier exists for each row in the source table. In some cases, no unique identifier may exist. If that is the case, you can modify the temp table method to use a newly created key column. For example:

/********** example 3 **********/

set rowcount 0

select NULL mykey, * into #mytemp from authors

set rowcount 1

update #mytemp set mykey = 1

while @@rowcount > 0

begin

set rowcount 0

select * from #mytemp where mykey = 1

delete #mytemp where mykey = 1

set rowcount 1

update #mytemp set mykey = 1

end

set rowcount 0

-- ================================================

-- Template generated from Template Explorer using:

-- Create Procedure (New Menu).SQL

--

-- Use the Specify Values for Template Parameters

-- command (Ctrl-Shift-M) to fill in the parameter

-- values below.

--

-- This block of comments will not be included in

-- the definition of the procedure.

-- ================================================

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Author: Robert Dannelly

-- Create date: 11/09/2010

-- Description: Resubmission Validation

-- =============================================

CREATE PROCEDURE ResubmissionValidation

-- Add the parameters for the stored procedure here

@ImportID int

AS

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT ON;

-- Insert statements for procedure here

DECLARE @ResubmissionTest TABLE

(

[ImportMetricID] [int] NULL,

[ImportID] [int] NULL,

[MetricInstanceID] [int] NULL,

[MetricValue] [varchar](100) NULL,

[NDTR] [varchar](20) NULL,

[MetricValueDate] [datetime] NULL,

[Narrative] [varchar](300) NULL,

[Resubmission] [varchar](50) NULL,

[ImportMetricStatus] [varchar](50) NULL,

[ImportFailureMsg] [varchar](200) NULL,

[CurrentMetricValue] [varchar](50) NULL

)

INSERT INTO @ResubmissionTest (ImportMetricID, ImportID, MetricInstanceID, MetricValue, NDTR, MetricValueDate, Narrative,

Resubmission, ImportMetricStatus, ImportFailureMsg, CurrentMetricValue)

SELECT ImportMetricID, ImportID, MetricInstanceID, MetricValue, NDTR, MetricValueDate, Narrative,

Resubmission, ImportMetricStatus, ImportFailureMsg, CurrentMetricValue FROM tblImportMetric WHERE ImportID = @ImportID --Need to change to Variable

-- This is used for Testing RBD

--SELECT * FROM @ResubmissionTest

DECLARE @ImportMetric_ID char(11), @Resubmission varchar(10)

SELECT @ImportMetric_ID = min(ImportMetricID) FROM @ResubmissionTest

--Begin LOOP

WHILE @ImportMetric_ID is not null

BEGIN

DECLARE @MetricInstanceID int,

@MetricValueDate DateTime

SELECT @MetricInstanceID MetricInstanceID FROM @ResubmissionTest WHERE ImportMetricID = @ImportMetric_ID

SELECT @MetricValueDate MetricValueDate FROM @ResubmissionTest WHERE ImportMetricID = @ImportMetric_ID

-- Be sure to change the values to @MetricInstanceID AND @MetricValueDate

EXECUTE ImportCheckResubmission @MetricInstanceID, @MetricValueDate, @Resubmission OUTPUT

IF @Resubmission = 'Yes'

BEGIN

UPDATE @ResubmissionTest

SET ImportFailureMsg = 'There is an existing value for this metric and interval. Please indicate if it is a resubmission.'

WHERE ImportMetricID = @ImportMetric_ID

SELECT @ImportMetric_ID = min(ImportMetricID) FROM @ResubmissionTest WHERE ImportMetricID > @ImportMetric_ID

END

END

DELETE FROM tblImportMetric WHERE ImportID = @ImportID

INSERT INTO tblImportMetric (ImportID, MetricInstanceID, MetricValue, NDTR, MetricValueDate, Narrative,

Resubmission, ImportMetricStatus, ImportFailureMsg, CurrentMetricValue)

SELECT ImportID, MetricInstanceID, MetricValue, NDTR, MetricValueDate, Narrative,

Resubmission, ImportMetricStatus, ImportFailureMsg, CurrentMetricValue FROM @ResubmissionTest WHERE ImportID = @ImportID --Need to change to Variable

--This is used for Testing

--SELECT * FROM tblImportMetric

END

GO

Demystify SQL Debugging with with Visual Studio

2010-11-04T11:36:00.004-04:00

Here is what I did to fix this issue "FINALLY"

http://www.asp.net/data-access/tutorials/debugging-stored-procedures-vb
#1 Connect using Windows Authentication as the same account on the local machine that must have sysadmin rights in the Instance of SQL Server.
#2 They use Server Explorer and connect with that same account and then once connect right click on the DB and check "Application Debuggin. I am posting this to my blog.
Great posts. By the way I feel the pain of remote individuals, my answer tell you management that if you want fast, rapid code to fork up the dough for SQL Developer Edition and do all you coding locally with a quality source control.

Robert.

GridView

2010-11-04T09:08:00.000-04:00

HTML:

Add Using for Controls or lookup very useful

2010-10-19T13:05:00.002-04:00

In VS 2008, when the caret is on the name of the class which doesnt have a using statement in the file, SHIFT+ALT+F10 will bring up a context menu to add the using statement.

Reboot Remotely

2010-10-19T11:09:00.002-04:00

When you work in distributed environment you probably use remote desktop session as you primary method of sql server machines administration. When critical windows updates are installed or when you install system or sql server service pack installation wizard promts you to restart the box in order to complete the installation. And it happens from time to time that this machine hangs on reboot process for some reason and you can no longer connect it via remote desktop. If it was you local computer you could enter into your server room and press the reset button but if it stand thousands miles away from you it becomes a real problem.

How to restart or shutdown remote machine

If you can ping this machine from other computer and you have administrators rights on that machine you may use windows utility.

On a computer that has connection to the server which needs to be restarted or shutdown go to Start -> Run and type shutdown -i

This window will show up. Press Add and type either IP or DNS of remote server.

Select shutdown or restart and press OK. That 's it. For your convenience you may run from command line constanct ping (ping servername -t) when the server actually stopped to respond to pings and when it started again.

Alternatively you can go to command prompt (start -> run -> cmd) on your workstation and Typeshutdown -r -m \\x.x.x.x
Replace x.x.x.x with the IP address or computer name of the remote machine. -r option is for restart, don't use -r if want to just shut down the system.

SharePoint Site Collection Administration

2010-08-05T08:32:00.001-04:00

Lesson learned. If you are ever asked to maintain a SharePoint site the first thing to do is say, "Grant me Site Collection Admin Rights". Why? Because if you are testing security and you do not know who the Site Collection Admin are then if you remove security the individuals in that role will still have access. (Nice 2 hour lesson learned)

AJAX Install

2010-06-17T16:06:00.000-04:00

If you develop ASP.NET applications with AJAX here is a step by step guide so you do not bang your head.

1) Download the latest version from CodePlex for AJAX.
2) Extract to a location of your choice
3) Add the AjaxControlToolkit.dll & AjaxControlToolkit.pdb to you Web layer project /bin folder
4) Create a new Tab in your Toolbox and point to the new AjaxControlToolkit.dll
5) Create a reference to your AjaxControlToolkit.dll
6) Finally ensure the line in your Web.config is that same version as your dll assembly - (Simply right click the dll and look at the properties for assembly info.

Visual Studio 2010

2010-04-16T10:39:00.001-04:00

Microsoft has released Microsoft Visual Studio 2010. I think it is time for me to upgrade to Windows 7 and start using there new tool set in order to keep up with the times.

SharePoint and SQL Sever Reporting Integration

2010-04-16T10:32:00.003-04:00

Well, I must tell you that I had to reach out to Microsoft yesterday and use 1 of my support calls with my MSDN Subscriptions. I have been tasked with integrated SQL Server Reporting Services with MOSS 2007.

This will be the first implmentation at my company and I very excited to have a fantastic presentation for my upper managment.

A lot of work has been put into this and I plan to sell this great feature.

New Trick Envrionment Variables

2010-04-01T14:18:00.002-04:00

public static string SecurePath = Environment.GetEnvironmentVariable("SECURED_APP_PATH");

You can right click on your computer > Advanced Tab > set the variables. Warning they will not take effect till a reboot.

This would not worth using for a hosted appllication when you do not have access to the server.

Time to build the app

2010-03-08T15:23:00.007-05:00

I am ready to build the app for retirement. 1 to 2 hours a day.

Define - 20 more hours
- Design DB (Completed)
- Design Workflow (Completed)
- Design UI(s) All screens (Completed)
- Design Objects (Completed)
Measure - 10 hours (2-6 Months, but will be done before I am 40 :-) )
Analyze - 40 hours (Done)
Improve (Build) - (In Process)
- Database Development (8 Hours Completed)
- Application (Web to start in Progress 2-6 months
* Web UI
* Business Layer
* Data Layer (Completed)
* Test Test Test fix fix fix test test test
* Demo to friends and family (Huge Milestone - break out Beer and Wine)

Control - Will know after Improve Phase)

Trace.axd

2010-02-19T20:38:00.004-05:00

One thing I am going to remember is Trace with ASP.NET... It is so powerfull to watch Application, Session and ViewState.

<trace enabled="true" requestLimit="40" localOnly="false" />

Very important when troubleshooting:

http://msdn.microsoft.com/en-us/library/y13fw6we%28VS.71%29.aspx

Kill Task in XP

2010-02-04T17:04:00.003-05:00

c:\>taskkill /pid 3252 /F

Force kill aspnetwp.exe....

Than stop the IIS and then delete temporary files.

Ctrl-Alt-Del on remote desktop aka server

2010-01-11T09:10:00.001-05:00

In order to send Ctrl-Alt-Del keystrokes to remote computer connected via Remote Desktop client, just press the following workaround keyboard shortcuts specially used in Remote Desktop environment:

Ctrl+Alt+End

Database Design and Audit

2009-10-30T11:24:00.001-04:00

When developing ASP.NET application that use a APP Pool and identity to make all calls to the back end database in order to have a trigger based solution for auditing.

I would recommend all your tables have updatedDT and updateBY columns in all the tables you want to audit.

Leading a Development Team

2009-09-15T14:22:00.006-04:00

New idea for a Development Team lead.

Depending on the scope of the technical requirements, it is the job of the team lead to review all documentation. PERIOD. From the technical specs the DEV LEAD develops the HLD/LLD specs, make estimates on the Business Analysis for each HLD/LLD.

Next, grant the developer the proper time to analyze the HLD/LLD requirements written by the tech lead. Tech Lead should read the HLD/LLD to ensure they are complete and time the review time and add 1 hour to allow developer the time needed to read the documentation and allow time the developer to ask questions to close gaps on missing requirements.

Once the business and the tech lead sort out these issues a developer should not code until all gaps are filled.

If you do, you will be doing rework on the project, thus costing time which as we all know == MONEY.

Team work

2009-07-22T11:55:00.000-04:00

Team work is the key important part of any project along with communication. Always communicate and work hard and do your best.

Assignments

2009-04-29T11:09:00.000-04:00

DUhG

If you see that something does not work in Visual Studio because it is not set as an assignment on a property.

Include the = symbol.

Example

li.select;

Will not work

li.select = true; //will.

Change My Documents

2009-03-31T09:15:00.000-04:00

Ability to change the My Documents path is restricted.

This setting can restrict the ability to change the current path of My Documents folder.

Click here to run a free scan for registry errors

Description:
Every user on a computer has some files and folders of personal use. The my documents folder is the users personal folder where he normally saves all his documents, pictures, music and other personal files. If more than one user account is created on the computer, windows creates the my documents folder for each account. This setting disables the users ability to change the default location/path of the my documents folder. The user can invoke the my documents properties dialog by right-clicking the folder, but the access to change the folder location is denied. For this, go to start > run menu, enter regedit and navigate to the registry path listed below. You can create a dword value disablepersonaldirchange, if this value does not exist. Now, right-click and modify the value to 1 which can restrict change in folder path. However, if you want to enable the changes, delete the value name disablepersonaldirchange. The changes take effect after a restart or logoff.

Level: Recommended For Experts Only

Registry Entries

Click here to run a free scan for registry errors

· Path: [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer\]

· Location: Current User

· Value Name: DisablePersonalDirChange

· Data Type: DWORD (DWORD Value)

· Enabled Value: 1

· Disabled Value: 0

· Action Type: Add an Entry

Screenshots

Click here to run a free scan for registry errors

First, click the Start button, and select Run. In the resulting dialog box, type "regedit"

Second, go to [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer\] and create a DWORD value "DisablePersonalDirChange.

Third, right-click on "DisablePersonalDirChange" and select 'Modify'.

Finally, set the "Value Data" to 1in the textbox provided and click on 'OK' to enable

For Loop

2009-01-26T18:40:00.000-05:00

for (initializer; condition; iterator) {
// code to execute while condition is true
}

Enable Remote Connections in SQL Express

2009-01-12T13:40:00.001-05:00

Read the following article http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

To enable remote connections on the instance of SQL Server 2005 and to turn on the SQL Server Browser service, use the SQL Server 2005 Surface Area Configuration tool. The Surface Area Configuration tool is installed when you install SQL Server 2005.

Back to the top

Enable remote connections for SQL Server 2005 Express or SQL Server 2005 Developer Edition

You must enable remote connections for each instance of SQL Server 2005 that you want to connect to from a remote computer. To do this, follow these steps:

1. Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration.

2. On the SQL Server 2005 Surface Area Configuration page, click Surface Area Configuration for Services and Connections.

3. On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Remote Connections, click Local and remote connections, click the appropriate protocol to enable for your environment, and then click Apply.

Note Click OK when you receive the following message:

Changes to Connection Settings will not take effect until you restart the Database Engine service.

4. On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Service, click Stop, wait until the MSSQLSERVER service stops, and then click Start to restart the MSSQLSERVER service.

Back to the top

Enable the SQL Server Browser service

If you are running SQL Server 2005 by using an instance name and you are not using a specific TCP/IP port number in your connection string, you must enable the SQL Server Browser service to allow for remote connections. For example, SQL Server 2005 Express is installed with a default instance name of Computer Name\SQLEXPRESS. You are only required to enable the SQL Server Browser service one time, regardless of how many instances of SQL Server 2005 you are running. To enable the SQL Server Browser service, follow these steps.

Important These steps may increase your security risk. These steps may also make your computer or your network more vulnerable to attack by malicious users or by malicious software such as viruses. We recommend the process that this article describes to enable programs to operate as they are designed to, or to implement specific program capabilities. Before you make these changes, we recommend that you evaluate the risks that are associated with implementing this process in your particular environment. If you choose to implement this process, take any appropriate additional steps to help protect your system. We recommend that you use this process only if you really require this process.

1. Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration.

2. On the SQL Server 2005 Surface Area Configuration page, click Surface Area Configuration for Services and Connections.

3. On the Surface Area Configuration for Services and Connections page, click SQL Server Browser, click Automatic for Startup type, and then click Apply.

Note When you click the Automatic option, the SQL Server Browser service starts automatically every time that you start Microsoft Windows.

4. Click Start, and then click OK.

Note When you run the SQL Server Browser service on a computer, the computer displays the instance names and the connection information for each instance of SQL Server that is running on the computer. This risk can be reduced by not enabling the SQL Server Browser service and by connecting to the instance of SQL Server directly through an assigned TCP port. Connecting directly to an instance of SQL Server through a TCP port is beyond the scope of this article. For more information about the SQL Server Browser server and connecting to an instance of SQL Server, see the following topics in SQL Server Books Online:

SQL Server Browser Service
Connecting to the SQL Server Database Engine
Client Network Configuration

Back to the top

Create exceptions in Windows Firewall

These steps apply to the version of Windows Firewall that is included in Windows XP Service Pack 2 (SP2) and in Windows Server 2003. If you are using a different firewall system, see your firewall documentation for more information.

If you are running a firewall on the computer that is running SQL Server 2005, external connections to SQL Server 2005 will be blocked unless SQL Server 2005 and the SQL Server Browser service can communicate through the firewall. You must create an exception for each instance of SQL Server 2005 that you want to accept remote connections and an exception for the SQL Server Browser service.

SQL Server 2005 uses an instance ID as part of the path when you install its program files. To create an exception for each instance of SQL Server, you must identify the correct instance ID. To obtain an instance ID, follow these steps:

1. Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Configuration Manager.

2. In SQL Server Configuration Manager, click the SQL Server Browser service in the right pane, right-click the instance name in the main window, and then click Properties.

3. On the SQL Server Browser Properties page, click the Advanced tab, locate the instance ID in the property list, and then click OK.

To open Windows Firewall, click Start, click Run, type firewall.cpl, and then click OK.

Create an exception for SQL Server 2005 in Windows Firewall

To create an exception for SQL Server 2005 in Windows Firewall, follow these steps:

1. In Windows Firewall, click the Exceptions tab, and then click Add Program.

2. In the Add a Program window, click Browse.

3. Click the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe executable program, click Open, and then click OK.

Note The path may be different depending on where SQL Server 2005 is installed. MSSQL.1 is a placeholder for the instance ID that you obtained in step 3 of the previous procedure.

4. Repeat steps 1 through 3 for each instance of SQL Server 2005 that needs an exception.

Create an exception for the SQL Server Browser service in Windows Firewall

To create an exception for the SQL Server Browser service in Windows Firewall, follow these steps:

1. In Windows Firewall, click the Exceptions tab, and then click Add Program.

2. In the Add a Program window, click Browse.

3. Click the C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe executable program, click Open, and then click OK.

Note The path may be different depending on where SQL Server 2005 is installed.

Back to the top

APPLIES TO

Microsoft SQL Server 2005 Developer Edition
Microsoft SQL Server 2005 Express Edition

Happy New Year

2009-01-02T09:10:00.001-05:00

Happy New Year to all and I am looking forward to a happy, prosperous, healthy and knowledge filled year. I wish everyone goodness and joy. Remember to focus on your family and loved ones.

This year I will be looking to achieve a weekly blog post to reflect on the week.

Moojjoo

12/21/2008 - Code thoughts

2008-12-21T00:49:00.001-05:00

I have been wondering what a laptop is like with just ubuntu. I am a .NET guy and I would have to convert to Apache, PHP, mySQL. Which are all free.

__________________________________________

Robert B. Dannelly, Jr. MCTS

http://www.mmwebs.com/

http://moojjoo.blogspot.com/

Configure Firefox to work with localhost.

2008-12-19T23:43:00.000-05:00

Here is the Solution for Other Users
Firefox - Enter username and password for "" at http://localhost - Solution
IIS uses Integrated Authentication and by default IE has the ability to use your windows user account...but don't worry, so does Firefox but you'll have to make a quick configuration change.

1) Open up Firefox and type in about:config as the url

2) In the Filter Type in ntlm

3) Double click "network.automatic-ntlm-auth.trusted-uris" and type in localhost and hit enter

4) Write Thank You To Blogger

As Always, Hope this helped you out.

Christmas is coming

2008-12-10T15:24:00.002-05:00

Christmas is coming, SANTA, SANTA....

December post

2008-12-10T15:23:00.003-05:00

Well, I must say life has been busy for November I got handed over 43 servers for a true dev to prod environment of SharePoint.

Outlook notes on desktop

2008-10-15T09:52:00.001-04:00

Credit to http://www.onetipaday.com/2006/10/15/how-to-save-put-outlook-notes-on-your-desktop

I often use the Microsoft Outlook Notes to store To-Do lists that are not related to work. I discovered this great tip a few months which allows me to put my notes on my desktop, and I love it as it means I can access my notes without having to open up Outlook.

To create a note in Outlook:

1. On the File menu, point to New, and then click Note.
2. Type the text of the note.
3. To close the note, click the × in the upper-right corner of the note.

Then to put the notes on your desktop do the following:

1. Right-click the desktop, point to New, and click Shortcut.
2. In the Type the location of the item box, type the following path: “C:\Program Files\Microsoft Office\OfficeXX\OUTLOOK.EXE” /c ipm.stickynote (note OfficeXX - XX needs to be replaced with your version of Office.
3. Click Next, name the shortcut, and then click Finish.

Now, when you double-click the shortcut, an Outlook note will appear on your desktop.

Excel Services Event ID: 5226

2008-10-15T09:45:00.001-04:00

If you have installed SharePoint per default configurations you will most likely not get issues like this, but in most enterprise installs logs and temp files are relocated. To fix the error below. Please review error then read below for solution.

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Excel Calculation Services
Event ID: 5226
Date: 10/15/2008
Time: 9:32:36 AM
User: N/A
Computer: CR2RCHIISIME
Description:
Unable to create or access workbook cache at D:\Temp\Excel Server\FileCache\BaselII-CIT-SSP-423345403\Charts. Excel Services is unable to function without a workbook cache.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Solution I manually created the D:\Temp\Excel Server\FileCache\BaselII-CIT-SSP-423345403\Charts directory then on the Security tab for the Temp directory, the WSS_ADMIN_WPG Windows group should have Full Control and the WSS_WPG Windows group should have Read & Execute, List Folder Contents, and Read permissions or higher on the folder. If they do not, assign these permissions by using the procedure in the "Assign sufficient permissions" section.

Also, this solution works if you get Trace Log errors.

Date in Task Bar

2008-08-01T08:17:00.000-04:00

Got this from Windows XP site. Worth re-post

To display the date as well as the time, you need to make the taskbar "taller" by dragging the top edge upward. This procedure is fairly simple but it does require reasonably precise mouse handling. If you are new to computing and still developing your mouse-skills, expanding the taskbar, or returning it to the default height, may prove to be a little problematical. If you are not yet confident with fiddly mouse manipulation, I would suggest that you postpone using this tip until you gain more mousing experience.

Here's how to expand the taskbar:

The taskbar needs to be "unlocked" before you can expand it. To check, right-click the taskbar and ensure that "Lock the Taskbar" is not ticked. If there is a tick, click "Lock the Taskbar" to untick it.

Close any running programs so that the taskbar is uncluttered and easier to manipulate.

Move your mouse to the top edge of the taskbar until the cursor turns into a doubled-ended arrow.

With the doubled-ended arrow displayed, hold down the left mouse button and drag the taskbar upward until it is about twice the normal height.

The day and date should now be displayed below the Notification Area clock.

If desired, you can now re-lock the taskbar.
The expanded taskbar not only permanently displays the day and date, it also provides extra display space for taskbar and notification area icons. Of course, the downside of an expanded taskbar is that you have less screen display area for programs and files.

To return the taskbar to its original height, follow the procedure outlined above but reverse the drag direction specified in step 4. That is, with the doubled-ended arrow displayed, hold down the left mouse button and drag the taskbar towards the bottom of the screen until it is the normal height.

SQL Server Reporting Services Datasource Security

2008-07-29T15:33:00.002-04:00

http://technet.microsoft.com/en-us/library/ms160330.aspx

Stored Credentials
You can store the credentials used to access an external data source. Credentials are stored in reversible encryption in the report server database. You can specify one set of stored credentials for each data source used in a report. The credentials you provide retrieve the same data for every user who runs the report.

Stored credentials are recommended as part of a strategy for accessing remote database servers. Stored credentials are required if you want to support subscriptions, or schedule report history generation or report snapshot refreshes. When a report runs as as a background process, the report server is the agent that executes the report. Because there is no user context in place, the report server must get credential information from the report server database in order to connect to a data source.

The user name and password that you specify can be Windows credentials or a database login. If you specify Windows credentials, the report server passes the credentials to Windows for subsequent authentication. Otherwise, the credentials are passed to the database server for authentication.

Windows Integrated Security
When you use the Windows Integrated Security option, the report server passes the security token of the user accessing the report to the server hosting the external data source. In this case, the user is not prompted to type a user name or password.

This approach is recommended if Kerberos is enabled. If Kerberos is not enabled, you should only use this approach if all the servers that you want to access are located on the same computer.

In other words each user would need to be added access to the Database Hosted on SQL Server

SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified or Named Pipes Provider, error: 40 - Could not open a connection to SQL S

2008-07-02T11:36:00.001-04:00

The problem was that the remote connection needed to utilize Named Pipes, but in order to utilize Named Pipes both the machine hosting the instance of SQL and the my local machine must have the alias:

With Supports instruction I went to SQL Server configuration Manager, expanded SQL Native Client Configuration and right clicked Aliases and created the alias on the machine and did the same for my personal machine and what do you know, it worked.

How to determine what ports are open

2008-07-01T22:10:00.001-04:00

start -> run -> cmd
netstat -na

look for :3306 and LISTEN on the same line...

OR..also from command prompt

telnet localhost 3306

Vitual PC 2007

2008-06-27T12:59:00.000-04:00

Well, it has been a while since I have blogged due to the project I am working on at work. The project MOSS 2007 from dev, test, and prod.

Before dev there is a place called pre-dev, where developers like myself need a place to develop, so this past March I attended the SharePoint 2007 conference where I met some great resources and obtained a VHD of MOSS 2007 and learned that most developer's develop in this fashion by downloading and installing the software from the MSDN Subscription, and routing code to a source control server.

Well I installed and could not get it to run, due to my lack of knowledge of Virtual PC 2007. I have a laptop with 1 gig of RAM and a external HD with 500 gig so I installed the VHD and fired up the Virtual PC, but I kept getting an error. Not enough memory on the host machine.

I thought to myself, "That is strange 1 gig should be enough memory to get my image up and running." Well it turns out I had to much memory allocated to the VM, so I set it back to 512mb and bam... The VM started to run, but it is also running dog slow, so in closing have 2 gig of RAM so you can allocate 1 gig to the VM.

Hope this helps out my fellow developers.

OUT... Moojjoo

Upgrading from SQL Express 2005 to SQL 2005 Developer Edition

2008-03-26T17:14:00.008-04:00

Upgrading from SQL Express 2005 to SQL 2005 Developer Edition (2 hours)

Note: First ensure you have access to the following key in the registry

You are most likely an admin if you are installing Developer Edition of SQL 2005 so be sure the following setting is set.

Go to Start > Run > enter regedit>

SYSTEM\CurrentControlSet\Control\WMI\Security ß Give Admins Full Contrl (Be sure to change this back so you don’t get yourself into trouble) >

Next slap the DVD or CD’s into your Rom Drive>

Start > Run > cmd>

Follow the prompts>

User your UID, PWD and Domain>

Your good to go when you see:>

Don't forget Service Pack 2

MCTS - SharePoint Developer

2008-03-04T18:00:00.001-05:00

Passed the Microsoft Exam SharePoint 2007 Developer

I am now officially and Microsoft Certified Technical Specialist.

Back versus Attaching to MDF

2008-02-20T09:47:00.000-05:00

Chintal my new programming parnter taught an old dog a new trick today. Instead of backing up and restoring databases simply open Windows Explorer and copy the .MDF and .LDF and zip move, copy, cut and attach back with SQL Server Management Studio SSMS.

Working with Infrastructure in the Enterprise as a Programmer Analyst

2008-02-14T11:00:00.001-05:00

For 10 years I have been working as an analyst first then putting on the programmer hat and developing applications. In corporate America you need to concentrate on your ability to work with your infrastructure architects and be very open minded. I have learned that you must take time to explain in great detail what your solution design is doing. Most web solutions involve web servers and database servers along with needing separate environments for development, user acceptance testing and production. Your solution may be Intranet or Internet, but the key to working with your infrastructure architect is to document, document, document. Use applications such as Visio to convey to them what you are trying to accomplish in the form of a picture (Remember a picture speaks a thousand words). It will save you your sanity and provide a great working relationship with your architect. Humans are not mind readers so document and draw your solution with time and patience. And last, but not least be sure to consult with your architect and have your environments built before coding a solution and ensure all the environment mirror one another, that way you will not freak out when your app works in one environment and not the other.

Words of Wisdom from an individual who loves what they do, but has pulled a bit of hair out learning the ropes.

Thanks to my mentors

Doug Cain
Larry Leonard
Eddie Clodfelter
Troy Tucker
Robert Petree
Shaun Todd
Saran
Garry Blanks
Kelly O'Donnell

Start explorer in C:

2008-02-04T21:20:00.000-05:00

Start Windows Explorer In The C Drive
In the Explorer property sheet use this path and switches in the target:

C:\windows\explorer.exe /n,/e,c:\

Since the first days Windows Explorer appeared, the list of switches reproduced below has been floating around the internet. I'm not sure who was the first to assemble the list but here it is in its entirety. Play around with it and see if one of the views is what you're seeking. Just copy and paste the bold text into the Target line on the Property Sheet of Windows Explorer. If it's not what you expected you can always switch back to the default view by using C:\WINDOWS\explorer.exe in the Target line.

"My Computer" highlighted in left side with all drives visible but not expanded and C: highlighted in right side: %SystemRoot%\explorer.exe /e,/select,c:

Desktop highlighted and nothing expanded: %SystemRoot%\explorer.exe /e,/n,/select,/root,c:

All drives visible and the system drive highlighted and expanded in full screen: %SystemRoot%\explorer.exe /e,/select

All drives visible and the system drive expanded in small screen: %SystemRoot%\explorer.exe /e,/select,%systemroot%

Only Windows Directory visible highlighted and expanded: %SystemRoot%\explorer.exe /e,/root,%systemroot%

All drives visible but only C: highlighted and expanded: %SystemRoot%\explorer.exe /e,c:

Nothing expanded and My Computer highlighted in right side: %SystemRoot%\explorer.exe /n,/e,/select,

Opens the Windows folder as a folder: %SystemRoot%\explorer.exe %systemroot%

Opens as "My Computer": %SystemRoot%\explorer.exe %systemroot%,

This opens the Desktop folder with "My Computer" highlighted: %SystemRoot%\explorer.exe %systemroot%,/select,

"Desktop" highlighted in the left side and no drives visible:
%systemroot%\explorer.exe /e,/root,::{20D04FE0-3AEA-1069-A2D8-08002B30309D},/select

"My Computer" highlighted in left side and all drives visible but none expanded:
%systemroot%\explorer.exe /e,/root,::{20D04FE0-3AEA-1069-A2D8-08002B30309D}

"Desktop" in left side highlighted and "My Computer" highlighted in right side and no drives visible:
%systemroot%\explorer.exe /e,/select,::{20D04FE0-3AEA-1069-A2D8-08002B30309D}

Kill Instance of Application

2008-01-02T09:34:00.001-05:00

Recently I was receiving an issue with an application I am supporting.

Problem

The application is a .NET Console application that using Microsoft Word to create reports. The problem is that an exception error would occur if Microsoft Word (WINWORD = Instance Name) was running.

Solution

// Code to kill Word issues if WINWORD is running on the current machine

// if word is running the reports will throw an exception so

// we must ensure the Microsoft Word application is not running

Process[] wordProcess = System.Diagnostics.Process.GetProcessesByName("WINWORD");
if (wordProcess.Length <= 1)
{

foreach (Process p in wordProcess)

{

p.Kill();

}

Year End

2007-12-20T12:44:00.000-05:00

Well, another year is coming to an end and what a year it has been. I have seen my Wife and daughter grow to be best little buddies. Also my daughter learning and an incredible pace. As for my life in the development world I took on a new job.

Switched from R.J. Reynolds to Bank of America in July. This was a great move with more challenging work. This year I can add to my resume that I am a Microsoft SharePoint 2007 Guru, Microsoft InfoPath Developer, .NET Web Service Developer, along with SQL Server Reporting Services.

Visual Studio 2008, so that will be my new challenge next year.

InfoPath - Hyper Link with data field

2007-12-18T11:14:00.000-05:00

Not mentioned in this article is that you should create another Data Element in your infopath form, example - DynamicHyperLink

concat('http://www.website.com/index.aspx?ID=',DataField)

Be sure to then use that as your data source as indicated below.

http://office.microsoft.com/en-us/infopath/HP010968051033.aspx#Insert_a_dynamic_hyperlink

Create a dynamic hyperlink in a form template

If you want a hyperlink to change depending on values in the form, you can include a dynamic hyperlink in your form template. To create this type of hyperlink, you must bind (bind: To connect a control to a field or group in the data source so that data entered into the control is saved. When a control is unbound, it is not connected to a field or group, and so data entered into the control will not be saved.) the hyperlink to a field (field: An element or attribute in the data source that can contain data. If the field is an element, it can contain attribute fields. Fields store the data that is entered into controls.) in the data source (data source: The collection of fields and groups that define and store the data for an InfoPath form. Controls in the form are bound to the fields and groups in the data source.). If the design of your form requires it, you can bind the hyperlink to one field and the display text to another field.

For example, imagine that you are designing a real-estate listing form, which is connected to a database that contains information about properties that are for sale. In the database, you might have a field that contains distinct URLs for each real estate agent. In your real-estate listing form, you can insert a hyperlink and bind it to the field in the data source that contains the URL value. If you want the hyperlink to display the name of the real estate agent rather than the URL, you can bind its display text to a field in the data source that contains the name value. When users click the agent's name on the form, that agent's Web page opens in a browser window.

In design mode, click in the form template where you want to insert a hyperlink, or select the text or picture that you want to turn into a hyperlink.
On the Standard toolbar, click Insert Hyperlink .
Under Link to on the General tab, select Data source, click Select XPath , and then select a field or group.
Under Display, do one of the following:
- To display a specific string of text for the hyperlink, click Text, and then in the Text box, type the text that you want to display.
- To have a value inside a control on the form template display as the hyperlink's text, click Data source, click Select XPath , and then select the field or group that the control is bound to.
To assign a ScreenTip that will appear when a user rests the mouse pointer over the hyperlink, click the Advanced tab, and then, in the ScreenTip box, type the text that you want to display.

Tip You can use XPath (XML Path Language (XPath): A language used to address parts of an XML document. XPath also provides basic facilities for manipulation of strings, numbers, and Booleans.) expressions to create hyperlinks that are a combination of static and dynamic data. For example, imagine that you want to create a hyperlink that links to "http://www.example.com/my name.html" where the Web server name, http://www.example.com, doesn't change, but the file name, my name, varies depending on the data that users type into a specific field in the form. In this case, you would type concat('http://www.example.com/', my:name, '.html') in the Data source box, where my:name is the name of the field to which the text box is bound. The Concat function allows you to combine static text with data from other fields in the form.

2007-12-18T08:51:00.000-05:00

dbcc checkident('table_name', reseed, 0)

Reset Database identity

Reset VS2005 IDE

2007-12-17T14:40:00.000-05:00

http://blogs.vertigo.com/personal/KeithC/Blog/Lists/Posts/Post.aspx?ID=16

2007-12-14T10:30:00.000-05:00

Answer Re: A transport-level error has occurred when sending the request to the server
Was this post helpful ?

For some reason the connection was made through Named Pipes instead of Shared Memory (the default for local connections), which suggests that SqlClient did not recognize the connection was local, and most likely tunneled Named Pipes over TCP, hence, disconnecting the network has impact.

How do you specify the server name - perhaps by its fully qualified domain name (FQDN), or IP address?

If you specify it by the hostname or "." or "(localhost)" SqlClient should recognize the local connection, and you should not see the error.

Stored Procs

2007-12-14T09:38:00.000-05:00

Please be aware if you are inserting data into a data field with a value type of int and allows null be sure to set the @Param int = null

This will prevent errors when submitting.

InfoPath class file from export

2007-12-12T09:54:00.000-05:00

xsd.exe myschema.xsd /classes /l:cs /n:[NAMESPACE]

Identity Information

2007-12-12T09:29:00.000-05:00

Introduction

About Identity Columns

If you have worked with SQL Server, you are probably familiar with identity columns. These are equivalent to the "AutoNumber" columns in Access. The main purpose of these columns is to provide a primary key to the table when a primary key cannot be defined using other fields in the table.

These columns are like any other column except that their value is not inserted by the user, but by the system itself.

Syntax

IDENTITY [ ( seed , increment ) ]

Where:

seed - Is the value that is used for the very first row that is inserted into the table.

increment- Is the incremental value that is added to the previous identity value and thereby to get new value for the new row that is going to be added.

Note: You must specify both the seed and increment or neither. If neither is specified, the default is (1,1).

A few things you need to know about the identity columns:

· They should be of data type int, smallint, tinyint, decimal or numeric with scale 0.

· They cannot contain null values

· They cannot have any default values

· The identity increment is an integral value (1, -1, 5, etc.) and cannot contain decimals. Also, it cannot be 0.

· Identity Seed is 1 by default, and so is the Identity Increment. If you leave the seed field empty, it becomes 0.

Functions associated with IDENTITY column

· @@IDENTITY
When a record is inserted into a table with an identity column, the function @@IDENTITY returns the last identity value that was inserted in the database.

Syntax

@@IDENTITY

I emphasize the phrase "last identity value" here because this may be different from the identity value of that particular table where the record was inserted.

Why? When a record is inserted and if there is any underlying trigger that modifies other tables, the value can be different. If a trigger adds a record into another table, which happens to have an identity column, @@IDENTITY will now return this new value instead.

· Scope_IDENTITY

Returns the last IDENTITY value inserted into an IDENTITY column in the same scope. A scope is a stored procedure, function, or batch. Thus, two statements are in the same scope if they are in the same stored procedure, function, or batch. It may be more clear from the example below.

Syntax

SCOPE_IDENTITY()

· IDENT_CURRENT

Returns the last identity value generated for a specified table in any session and any scope.

Syntax

IDENT_CURRENT('table_name')

· IDENT_SEED

Returns the seed value specified during the creation of an identity column in a table that has an identity column.

Syntax

IDENT_SEED('table_name')

· IDENT_INCR

Returns the increment value specified during the creation of an identity column in a table that has an identity column.

Syntax

IDENT_INCR('table_name')

Examples and Tips

Example

-- Consider the 2 Tables

CREATE TABLE Student(studId int IDENTITY(1,1), studName varchar(30))

CREATE TABLE Copy_Student(sid int IDENTITY(100,1))

--Create trigger for insert on table Student

CREATE TRIGGER trgStudent ON Student FOR INSERT

BEGIN

INSERT INTO Copy_Student DEFAULT VALUES

END

--Check The Tables

SELECT * FROM Student --No records

SELECT * FROM Copy_Student --No records

--Now do the following to check out the difference

INSERT INTO Student(studName) VALUES('Anjali Chelawat')

SELECT @@IDENTITY AS [IDENTITY]

--Returns the value 100, which was inserted by the trigger that is by the second insert statement.

SELECT SCOPE_IDENTITY() AS [SCOPE_IDENTITY]

--Returns the value 1, which was inserted by the Student table INSERT Statement before the trigger's insert statement.

SELECT IDENT_CURRENT('student') AS [IDENT_CURRENT]

--Returns last identity value inserted into Student.

SELECT IDENT_CURRENT('copy_student') AS [IDENT_CURRENT]

--Returns last identity value inserted into Copy_Student.

SELECT IDENT_INCR('student') AS [IDENT_INCR]

-- Returns the increment value of the identity column of the table Student. The value provided at the time of creation of the identity column

SELECT IDENT_SEED('student') AS [IDENT_SEED]

-- Returns the seed value of the identity column of the table Student. The value provided at the time of creation of the identity column

A Few Tips

· Allowing inserts to identity columns:

If you are inserting data from some other source to a table with an identity column and you need to ensure you retain the identity values, you can temporarily allow inserts to the identity column. Without doing so explicitly you will receive an error if you attempt to insert a value into the identity column. For example, if I have a table named MYTABLE and I want to allow inserts into the identity column, I can execute the following:

Syntax

set identity_ insert table_name on

Once you execute the command you will be able to insert values into the table's identity column. This will stay in effect in until you turn it off by executing the following:

Syntax

set identity_insert table_name off

Note: Be aware that at any time, only a single table in a session can have the identity_insert set to on. If you attempt to enable this for a table and another table already has this enabled, you will receive an error and will not be able to do so until you first turn this off for the other table. Also, if the value used for the identity is larger than the current identity value then the new value will be used for the identity seed for the column.

· Reseeding the identity value:

You can reseed the identity value, that is, to have the identity values reset or start at a new predefined value by using DBCC CHECKIDENT. For example, if I have a table named MYTABLE and I want to reseed the identity column to 30 I would execute the following:

dbcc checkident (‘table_name’, reseed, 30)

If you wanted to reseed the table to start with an identity of 1 with the next insert then you would reseed the table's identity to 0. The identity seed is what the value is currently at, meaning that the next value will increment the seed and use that. However, one thing to keep in mind is that if you set the identity seed below values that you currently have in the table, that you will violate the identity column's uniqueness constraint as soon as the values start to overlap. The identity value will not just “skip” values that already exist in the table.

Points To Remember

· IDENT_CURRENT returns the last identity value generated for a specific table in any session and any scope.

· @@IDENTITY returns the last identity value generated for any table in the current session, across all scopes.

· SCOPE_IDENTITY returns the last identity value generated for any table in the current session and the current scope.

Credit to:

All About IDENTITY Columns in Sql Server 2000

http://www.devcity.net/Articles/276/1/article.aspx

by Anjali Chelawat

Published on 10/5/2006

SQL Reporting Notes

2007-11-29T07:44:00.001-05:00

SQL Reporting Notes

I noticed an issue with SQL Reporting and the PDF formatting. I was receiving a lot of extra pages between page breaks. I realized that the grid margins had moved to be extremely wide which caused the problem.

If you have this problem be sure to check your margins.

If you are developing a 11" x 8.5" be sure that your grid is equal to your width minus the margin for left and right.

Example you have a report to be 11" wide with 1/2" margins this means your grid and I repeat cannot be wider than 10" or you will have blank pages and please be sure not to nudge it by accident.

SQL Reporting Services Expression

2007-11-27T15:18:00.000-05:00

If you ever need to insert "data not available" or "n/a" use the following code.

=IIf(Fields!HoursAllocated.Value is nothing, "No Data Supplied", Fields!HoursAllocated.Value)

ASP.NET Account locked out please check before banging your head.

2007-11-27T14:55:00.000-05:00

aspnet_wp.exe could not be started. The error code for the failure is 80004005. This error can be caused when the worker process account has insufficient rights to read the .NET Framework files. Please ensure that the .NET Framework is correctly installed and that the ACLs on the installation directory allow access to the configured account.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

aspnet_wp.exe could not be launched because the username and/or password supplied in the processModel section of the config file are invalid.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Check the following: Make sure the ASP.NET Machine Account is not locked out... It will save you a lot of headaches.

%HOME%%HOMEPATH%

2007-11-26T11:43:00.001-05:00

Have you ever needed to use RUNAS for testing security on your applications?

If so, and you have gotten a second account for testing and get weird errors such as not finding the application be sure to change the Start In to point to the actual executables location rather than the %HOME%%HOMEPATH%

Check empty array Trick

2007-11-13T10:46:00.000-05:00

The old trick for checking for an empty array is

Dim X() As String

If (Not X) = -1 Then
Debug.Print "empty"
Else
Debug.Print "UBound is " & UBound(X)
End If

InfoPath and Web Services

2007-11-07T12:09:00.000-05:00

Have you ever had this issue developing a Web service with InfoPath?

InfoPath cannot submit the form.
An error occurred while the form was being submitted.
The SOAP response indicates that an error occurred:

System.Web.Services.Protocols.SoapException: Server did not recognize the value of HTTP
Header SOAPAction:http://localhost <-- Questions Have you changed the URL here but it the change does not work on the Submit for the InfoPath form?

Well first things first. Every time you update the Web service you need to re-do the connection to the Web service inside of InfoPath. I discovered this after about 2 hours of trying to find out what I was doing wrong in my code VS.NET 2005 UGH!!!!

Hack away fellow gurus.

More to come on the solution I am working on. I am thinking about creating a White Paper and I will include all Blogs that have helped me with this solution.

Data Types

2007-10-10T15:26:00.000-04:00

Data types defined for SQL Server http://msdn2.microsoft.com/en-us/library/aa258271(SQL.80).aspx

Difference between varable and fixed -

When you design your tables, it helps to understand the tradeoffs of using variable length columns versus fixed length columns. Variable length columns reduce database size because they take only what is required to store the actual value. Fixed length columns always take maximum space defined by the schema, even when the actual value is empty. The downside for variable length columns is that some operations are not as efficient as those on fixed length columns. For example, if a variable length column starts small and an UPDATE causes it to grow significantly, the record might have to be relocated. Additionally, frequent updates cause data pages to become more fragmented over time. Therefore, we recommend that you use fixed length columns when data lengths do not vary too much and when frequent updates are performed (Microsoft - http://technet.microsoft.com/en-us/library/ms172432.aspx.

Unicode vs. Non-Unicode - The primary difference between unicode and non-unicode data types is the ability of unicode to easily handle the storage of foreign language characters which also requires more storage space.

Remember

2007-09-25T14:26:00.000-04:00

WorksheetFunction. in excel VBA

Blog of the Day

2007-09-25T10:39:00.001-04:00

Well, the latest update. I have moved into some VBA code. So what is VBA? VBA stands for Visual Basic for Application (Office). I have to admit at first I was a little stand offish, but after playing with the tools in the Office application I am a bit taken by the power. Just like all Microsoft products the Object Model is easy to pick up.

I am actually developing some reporting in Excel from SharePoint lists being populated by InfoPath Forms. I hope to be moving into the InfoPath to Web services to SQL server to us SQL reporting soon. I will keep everyone updated.

Adding an image

2007-09-13T16:01:00.000-04:00

Moojjoo's Blog Image Post

Test

2007-09-13T15:38:00.001-04:00

Testing blog post from email

Backup and Restore on SQL Server

2007-09-11T10:11:00.000-04:00

thanks to moonguy on MSDN he saved me many hours of work.

When you try to backup, SQL Server 2005 shows the default backup path i.e. c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\ . This directory default has SQL user rights. Go to Backup directory and check the user name. Its very big name and I have not checked how SQL server adds it in allowed users list. You can do 2 things:

1. Let the Server take backup on default directory and copy the file in your desired folder. I did that.

2. Give same kind of permissions to your desired folder as Backup directory has.

Hope it solves the issue.

Moonguy

Classes, Objects and Methods oh my!!!!!

2007-09-05T11:03:00.000-04:00

I read a great article the other day for the newbies to C# and OO development http://www.devarticles.com/c/a/C-Sharp/Introduction-to-Objects-and-Classes-in-C-sharp/

Take some time to read it.

Settings.Settings .NET C#

2007-08-14T09:06:00.000-04:00

I just learned the newest feature for adding configuration to .NET application (Console, Windows Forms, Web forms, ets.)

Settings.Settings are created when you start your application. This allows you to build out Settings that scope either the application or user. But the big question was how do you access them in the code.

Simple.

Try this

Properties.Settins.Default.[Intellisense takes over and find your setting]

That easy.

InfoPath Designer Mode

2007-07-13T08:12:00.000-04:00

Well, after all the research I found Tim Pash as you can see in the post below. It seems that in the Corporate Enviroment you have to request that you have the setting deployed to you by your Microsoft Office Deployment and Configuration team. So with that being said, if you do not see the designer feature in InfoPath send a request to you Information Technology Team.

InfoPath

2007-07-11T08:11:00.000-04:00

Well,

I am now back contracting because of my love to CODE. I have a new venture at Bank of America using SharePoint, InfoPath, and Visual Basic for Applications (VBA). My first task is to figure out how to enable InfoPath to allow me to design?

I found a great resource from the Tim Pash: http://blogs.msdn.com/timpash/archive/2006/02/08/Prevent-Design-Mode-For-Users.aspx?CommentPosted=true#commentmessage

Update from comparison of two SQL tables

2007-06-21T11:47:00.001-04:00

UPDATE o
SET Amount=Price
FROM orders o JOIN items i ON (o.ItemNumber=i.ItemNumber)

UPDATE o SET EmpActive = 0 FROM ComplianceEmployee o
JOIN ComplianceEmployeeLoad i ON (o.EmpID = i.EmpID)

Update from comparison of two SQL tables

2007-06-21T11:47:00.000-04:00

UPDATE o
SET Amount=Price
FROM orders o JOIN items i ON (o.ItemNumber=i.ItemNumber)

UPDATE o SET EmpActive = 0 FROM ComplianceEmployee o
JOIN ComplianceEmployeeLoad i ON (o.EmpID = i.EmpID)

GoDaddy.com System.Net.Mail Solution

2007-05-20T23:29:00.000-04:00

Here is the C# version of the GoDaddy.com ASP.NET 2.0 Send Mail by Moojjoo http://www.mmwebs.com

Web.Config
<?xml version="1.0"?>

<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<system.web>

<customErrors mode="Off"/>
<compilation debug="true"/> 

</system.web>
<system.net>

<mailSettings>
<smtp>

<network

host="relay-hosting.secureserver.net" />
</smtp>

</mailSettings>
</system.net>

</configuration>

.cs code behind for your .aspx page

protected void btnSubmit_Click(object sender, EventArgs e)
{

MailMessage myMail = new MailMessage();

myMail.From = new MailAddress("from@yourdomain.com");
myMail.Subject = "Contact Form";

MailAddressCollection myMailTo = new MailAddressCollection();
myMail.To.Add("to@domain.com");

StringBuilder sb = new StringBuilder();
sb.Append("Last Name: " + txtFirstName.Text + " ");

sb.Append("First Name: " + txtFirstName.Text + " ");
sb.Append("Address: " + txtAddress.Text + " ");

sb.Append("City: " + txtCity.Text + " ");
sb.Append("State: " + ddlState.SelectedValue + " ");

sb.Append("Zip: " + txtZip.Text + " ");
sb.Append("Email: " + txtEmail.Text + " ");

sb.Append("Questions/Comments: " + txtQandC.Text + " ");string strBody = sb.ToString();
myMail.Body = strBody;

myMail.IsBodyHtml = true;

SmtpClient smtp = new SmtpClient();
smtp.Credentials = CredentialCache.DefaultNetworkCredentials;

try

{

smtp.Send(myMail);

myMail = null;
}

catch (System.Exception ex)
{

Response.Write(ex.Message);

}

}

Moojjoo Õ¿Õ

http://www.mmwebs.com

http://www.autoinventoryonline.com/

Advanced Unit Testing, Part I - Overview - The Code Project - C# Programming

2007-04-29T12:07:00.000-04:00

Great article on Unit Testing

Advanced Unit Testing, Part I - Overview - The Code Project - C# Programming

ASP.NET 2.0 - Membership and Roles

2007-01-28T17:42:00.000-05:00

Today, I have been working with SQL Server 2000 and Visual Studio 2005 to increase my speed in development by using Strongly Typed Datatypes and the Membership/Roles provided by SQL.

For now I am going to jump into using the Membership/Roles provided by ASP.NET.

Microsoft has made it easy to setup membership/role for you Web application, but did not explain the needs most freelance developers must use in order to use rented Web hosting space.

As for my self I develop on http://www.idevconsultants.com/ servers and they run SQL 2000. And not to mention I do not have keys to the server so I have to develop with what I can without making changes to IIS. This is the same for most developers.

So here is the trick to use this new membership tools.

Scott Gu blog http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx explains the ends and outs, but basically the secret is to run the following tool:

Open a command-line window on your system and run the aspnet_regsql.exe utility that is installed with ASP.NET 2.0 in under your C:\WINDOWS\Microsoft.NET\Framework\v2.0.xyz directory. This tool will build all the Tables, StoredProcs needed to run the membership tools in ASP.NET 2.0.

VERY IMPORTANT: Next in your WEB.CONFIG name your connection string to

Again DO NOT I REPEAT DO NOT change the name...

Testing Visual Studio with Firefox

2007-01-10T11:33:00.000-05:00

In my job I develop for Intranets (IE) and Internet (All Browsers) and order to test Firefox I found the following article which was crucial to setting up the Firefox browser for testing an ASP.NET 2.0 application in order to get NTLM to work.

http://brennan.offwhite.net/blog/2005/07/22/firefox-authentication-with-ntlm/

Be sure to add localhost to your proxy if needed.

SQL

2006-11-11T12:06:00.000-05:00

This week I was told about a book titled, "Gurus Guide to Transact SQL". So being told about the book I headed to the local Borders with my daughter to check the book out. This book first and for most is better purchased online it is a lot cheaper.

This book is the ultimate guide to SQL Server Transact-SQL. T-SQL is a must for any developer utlizing SQL Server as their backend DBMS (Data Base Management System).

Back on the blog

2006-10-15T21:06:00.000-04:00

Moojjoo here and I am would like to apologize for not writting more. Having a 7 month old is a lot of work and not to mention the full plate I have at work lately.

I am very excited that my current company R.J. Reynolds Tobacco Company is finally moving forward to ASP.NET 2.0 and Visual Studio 2005.

As for coding I have really been researching the ability to use tiers in development so I can use as much resuse as possible.

Til Later

Using .NET Outlook to send formatted email

2006-06-16T12:08:00.000-04:00

Imports Microsoft.Office
Imports Microsoft.Office.Core
Imports System.Runtime.InteropServices
Imports Outlook = Microsoft.Office.Interop.Outlook

Public Class TestOutlookMail
Inherits System.Web.UI.Page

#Region " Web Form Designer Generated Code "

'This call is required by the Web Form Designer.
Private Sub InitializeComponent()

End Sub
Protected WithEvents Button1 As System.Web.UI.WebControls.Button
Private app As Outlook.ApplicationClass

'NOTE: The following placeholder declaration is required by the Web Form Designer.
'Do not delete or move it.
Private designerPlaceholderDeclaration As System.Object

Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
'CODEGEN: This method call is required by the Web Form Designer
'Do not modify it using the code editor.
InitializeComponent()
End Sub

#End Region

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
app = New Outlook.ApplicationClass
End Sub

'Private Sub button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
' CreateEmailMessage()
'End Sub 'button1_Click

'Private Sub CreateEmailMessage()
' 'Initialize the envelope values.
' Dim strTo As String = "yourname@yourdomain.com"
' Dim strBCC As String = "yourname@yourdomain.com"
' Dim strCC As String = "yourname@yourdomain.com"
' Dim strSubject As String = "Outlook Automation"
' Dim strBody As String = "Hello World"

' 'Automate the Outlook mail item.
' app = New Outlook.ApplicationClass
' Dim mItem As Outlook.MailItemClass = CType(app.CreateItem(Outlook.OlItemType.olMailItem), Outlook.MailItemClass)
' 'Dim As Outlook.MailItemClass = CType(doc.MailEnvelope.Item, Outlook.MailItemClass)
' 'Outlook.MailItemClass mi = (Outlook.MailItemClass)app.CreateItem
' mItem.To = strTo
' mItem.BCC = strBCC
' mItem.CC = strCC
' mItem.Subject = strSubject
' mItem.BodyFormat = Outlook.OlBodyFormat.olFormatHTML
' mItem.HTMLBody = strBody
' 'mItem.ItemEvents_Event_Close += New Outlook.ItemEvents_CloseEventHandler(Me.wApp_Close)

' 'wApp.Visible = True

' ' Loop until there are no more references to release.
' While Marshal.ReleaseComObject(mItem) > 0
' End While
' mItem = Nothing

' ' Invoke the .NET garbage collector.
' GC.Collect()
' GC.WaitForPendingFinalizers()
'End Sub 'CreateEmailMessage

Private Sub button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim Subject As String = "This is my Subject"
Dim Body As String = "This is my Body"

Dim mi As Outlook.MailItemClass = CType(app.CreateItem(Outlook.OlItemType.olMailItem), Outlook.MailItemClass)
mi.BodyFormat = Outlook.OlBodyFormat.olFormatHTML
mi.HTMLBody = Body
mi.Subject = Subject
mi.Display(New Object)

Dim ni As Outlook.NoteItemClass = CType(app.CreateItem(Outlook.OlItemType.olNoteItem), Outlook.NoteItemClass)
ni.Body = "This is my Body again"
ni.Display(New Object)

Dim pi As Outlook.PostItemClass = CType(app.CreateItem(Outlook.OlItemType.olPostItem), Outlook.PostItemClass)
pi.Subject = Subject
pi.BodyFormat = Outlook.OlBodyFormat.olFormatHTML
pi.Body = Body

pi.Display(New [Object])
End Sub 'button1_Click

End Class

DropDown in DataGrid, How to Select

2006-06-15T12:43:00.000-04:00

This is a two parter. First we will discuss on to add a "Select Value" to the Drop Down List after we populate the DropDown with Data from the Database then I will discuss how to Select that value using the OnItemDataBound from the DataGrid.

Inside the DataGrid you must use a Template like so

SQL Time Converter

2006-06-08T09:04:00.000-04:00

Private Sub BuildSQLTime(ByVal strProdDate, ByVal strProdTime)
Dim SQLDateTime As DateTime
Dim strDate As String = strProdDate
Dim strTime As String = strProdTime

Dim DateArray(2) As String
DateArray(0) = strDate.Substring(0, 2)
DateArray(1) = strDate.Substring(2, 2)
DateArray(2) = strDate.Substring(4, 2)

Dim tempDateTime As String
Dim newDateTime As DateTime

tempDateTime = DateArray(1) & "/" & DateArray(2) & "/" & DateArray(0)
newDateTime = Convert.ToDateTime(tempDateTime & " " & strTime)
'newDateTime = DateTime.Now

lblResults.Text = newDateTime
End Sub

Update to Access Folders without reboot

2006-05-30T09:12:00.000-04:00

Need to access a folder you were just given access to? No need to reboot. Simply go to Start > Run > Type CMD At the dos prompt type gpupdate

SQL Server Leading Zeros for CHAR Type

2006-05-19T10:51:00.000-04:00

declare @DirectiveNumber char(6)
declare @DirLength int

SET @DirectiveNumber = (SELECT DirectiveNumber FROM dbo.tblPlants WHERE PlantId = '1201')

--UPDATE dbo.tblPlants SET DirectiveNumber =
SET @DirectiveNumber = @DirectiveNumber + 1

Select @DirLength = LEN(@DirectiveNumber)

IF (@DirLength = 1)
SET @DirectiveNumber = '00000' + @DirectiveNumber
IF (@DirLength = 2)
SET @DirectiveNumber = '0000' + @DirectiveNumber
IF (@DirLength = 3)
SET @DirectiveNumber = '000' + @DirectiveNumber
IF (@DirLength = 4)
SET @DirectiveNumber = '00' + @DirectiveNumber
IF (@DirLength = 5)
SET @DirectiveNumber = '0' + @DirectiveNumber

UPDATE dbo.tblPlants SET DirectiveNumber = @DirectiveNumber WHERE PlantId = '1201'

SELECT @DirectiveNumber

ASP.NET 2.0

2006-05-16T23:01:00.000-04:00

WOW,

Well I just deployed my first ASP.NET 2.0. What a difference from 1.x.

I learned that you can deploy by using a publish and precompiled mode that will not cause a slow load the first time a user accesses the site, but the issue with using that is that when you make change you have to redeploy all the .aspx and .dll files again. That kinda sucks.

However, after a little research I found a tool that add-ons from microsoft: http://msdn.microsoft.com/asp.net/reference/infrastructure/wdp/

This feature more reflects the ASP.NET 1.x way of creating dlls

How do I hide a column in my Datagrid if AutoGenerateColumns is set to True?

2006-05-12T15:43:00.000-04:00

Question: How do I hide a column in my Datagrid if AutoGenerateColumns is set to True?

Answer: AutoGenerated columns do not appear in the Datagrid's Columns() collection, and so the usual method of hiding a Datagrid column will fail:

'Will NOT work for AutoGenerated columns:
Datagrid1.Columns(1).Visible = False

So the place to handle this is in the ItemDataBound event of the Datagrid:

<asp:DataGrid id="Datagrid1" runat="server" AutoGenerateColumns="True" OnItemDataBound="Datagrid1_OnItemDataBound"/>

Codebehind
Private Sub Datagrid1_OnItemDataBound(s As Object, e As DatagridItemEventArgs)
e.Item.Cells(1).Visible = False
End Sub

AUTOEVENTWIREUP .NET

2006-05-09T15:12:00.000-04:00

WARNING...

Auto Event Wireup will fire your ASP.NET pages twice be warned.

Parse Error When adding new Web pages to application

2006-05-08T16:01:00.002-04:00

I am banging my head on this one... All of my other Web forms work fine but now...

I am getting the following error when adding new Web forms to my application:

I just added simple Web form with Hello World typed on the page.

Server Error in '/XXX.QuipSap.WebUi' Application.

Parser Error
Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.

Parser Error Message: Could not load type 'XXX.QuipSap.WebUi.TestForm'.

Source Error:

Line 1: <%@ Page Language="vb" AutoEventWireup="false" Codebehind="TestForm.aspx.vb" Inherits="XXX.QuipSap.WebUi.TestForm"%>
Line 2:
Line 3:

Source File: c:\inetpub\wwwroot\XXX.QuipSap.WebUi\TestForm.aspx Line: 1

SOLUTION:
OK as crazy as a solution that this sounds, but I am not to happy with the solution but it works.

When I create add a new Web form I just remove the inherits part from the first line of the aspx page. If I add labels or buttons and double click on them VS.NET 2003 adds back the inherits and magically (HMM I say magically because if I knew what was fixing it I would not be writting this) fixes the issue.

Parse Error When adding new Web pages to application

2006-05-08T16:01:00.001-04:00

Parse Error When adding new Web pages to application

2006-05-08T16:01:00.000-04:00

Parse Error When adding new Web pages to application

2006-05-08T16:00:00.000-04:00

VB.NET Grid Headaches

2006-04-13T15:37:00.000-04:00

Be sure to enable Viewstate

NT Propogate across network

2006-04-07T08:02:00.000-04:00

gpupdate

Reset NT Security

2006-04-07T08:00:00.001-04:00

gpupdate

Reset NT Security

2006-04-07T08:00:00.000-04:00

gpupdate

Right click command prompt

2006-01-29T09:23:00.000-05:00

Here's a handy tip that I got from a co-worker, who found it in the book Microsoft Visual C# .NET Step by Step. It creates a shortcut in the right click context menu of Windows Explorer to open a command prompt in the current directory. When I need to run scripts in a very long directory name, this is very handy.

So here's how you set it up:

Open up windows explorer
Tools -> Folder Options.
File Types Tab
Select the Folder file type
Click Advanced
Click New
For the Action type what ever you want the context menu to display, I used Command Prompt.
For the Application used to perform the action use c:\windows\system32\cmd.exe (note on win2k you will want to specify the winnt directory instead of the windows directory)

You can also use this feature to attach context actions to file types. Or if you want to create a right click open with option for any file type (for instance I like to be able to open any file with notepad, see: my blog entry here.

Arrays

2006-01-20T16:13:00.000-05:00

Well I guess it is time to start being a true programmer and master arrays. So what did I learn day one about using arrays.

If you are going to use C# and want a dynamic array you better use the following code... (HINT USE AN ARRAY LIST)

int i = 0;
ArrayList al = new ArrayList();
while (myReader.Read())
{
al.Add(myReader.GetInt32(0));
i = i + 1;
}

Directory .NET Functions

2006-01-13T16:59:00.000-05:00

NET Framework Class Library

Directory Members

Moojjoo Blog

SharePoint Stats

2006-01-13T13:02:00.000-05:00

Getting Usage Statistics on Sharepoint Portal 2003 Areas
This comes from this microsoft blog

"There are pages available in Windows SharePoint Services that will allow you to obtain usage statistics for WSS Sites. However, this is not the case for Areas in SharePoint Portal Server 2003. There are no built-in hyperlinks in the Admin pages for viewing usage statistics for a give Area.

Does this mean that usage statistics are not available for Areas in SPS 2003? No, it just means that you have to know a backdoor URL to get to the pages that display the stats. Here is the format of the URL:

http://{your portal name}/_layouts/1033/usageDetails.aspx

This URL will take you to a usage statistics page for the Home Area of your portal. (Note: the 1003 is the designator for you language, so it will be different if not using U.S. English).

If you want to look at usage statistics for a Subarea, for instance, News, you would modify the URL to look as follows:

http://{your portal name}/News/_layouts/1033/usageDetails.aspx"

Moojjoo Blog

Validating Edits in Grids

2006-01-11T16:53:00.000-05:00

When using the Grid Web Controld a lot of times I find myself needing to customize the edit functionality to use validation. The following are the procedures that I use to customize the Data Grid Web Controld.

In order to implement a customization in a datagrid you need to implement a template

<asp:TemplateColumn HeaderText="Gift Amount">
<itemtemplate>
<asp:label id="lblAward_Amount" text='<%# DataBinder.Eval(Container.DataItem, "Gift_Amount", "{0:c}") %>' Runat="server" />
</itemtemplate>
<edititemtemplate>
<asp:textbox ID="txtGift_Amount2" text='<%# DataBinder.Eval(Container.DataItem, "Gift_Amount", "{0:c}") %>' runat="server" />
<asp:regularexpressionvalidator id="Regularexpressionvalidator1" runat="server" ControlToValidate="txtGift_Amount2"
ErrorMessage="Money Values only example 20.00 no commas!" ValidationExpression="\d*.\d{2}"></asp:regularexpressionvalidator></asp:boundcolumn>
</edititemtemplate>
</asp:TemplateColumn>

To access this in the code behind you must using the following:

// This will access the control inside the data grid.
tempGiftAmount = (((TextBox)e.Item.FindControl("txtGift_Amount2")).Text);

Inserting Null Values into SQL Server "FINALLY"

2005-12-28T16:08:00.000-05:00

After many months of frustration I finally discovered the code to post null values into SQL Server.

cmd.Parameters.Add("@Emp_EID", System.DBNull.Value);

Validating Multi-line text boxes in ASP.NET using regular expression validator

2005-11-01T09:30:00.000-05:00

Validate Multi-line text box in ASP.NET with Regular Expression

^[\s\S]{0,200}$

200 is the Character count

Comment out server side asp.net code

2005-10-20T13:32:00.000-04:00

How to comment out server side code

<%-- <asp:Button . . . . /> --%>