SmallWorkarounds

Silverlight Toolkit October 2009 Released

aashish.gupta@smallworkarounds.com (Aashish) — Wed, 21 Oct 2009 13:43:59 PDT

I am glad to announce that my favorite Silverlight Toolkit has a next release out for production use earlier release was in July 2009 and now its the October Release.

You can download this release at http://silverlight.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=30514#DownloadId=88327

Change List includes

Visual Studio 2010 Support

All controls updated to provide a great design time experience in Visual Studio 2010

Charting

All classes now unsealed
ISeries interface introduced as base interface for all Series
Breaking change: StylePalette renamed Palette and type changed to IEnumerable<ResourceDictionary> from IEnumerable<Style>
LegendItemStyle introduced to provide easier customization of LegendItem

Drag & Drop

Drag & drop support added for common items controls such as ListBox, TreeView, DataGrid, and charting controls.
System.Windows.Controls.Data.Toolkit assembly added.
The System.Reactive assembly is now installed alongside other Silverlight Toolkit binaries.

Other Updates

Accordion

Themes updated to add support for this control

ChildWindow

Themes updated to add support for this control

DataForm

Themes updated to add support for this control

DataPager

Themes updated to add support for this control

DomainUpDown

Mouse wheel support added to change value

GlobalCalendar

Mouse wheel support added to navigate between months in year mode and years in decade mode

GridSplitter

Themes updated to add support for this control

TimePicker / TimeUpDown

Mouse wheel support added

TreeMap

VB Sample added

System.IO.FileNotFoundException Could not load file or assembly 'App_Web, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified

aashish.gupta@smallworkarounds.com (Aashish) — Mon, 05 Oct 2009 09:13:07 PDT

I recently faced this problem with one of my WCF services, i was unable to find the reason for this as it complains that it could not load an assembly which in my case never existed.So seeing the error i knew that it was not my fault but it was the fault of the framework itself.

What i know and what seemed to me is that this error occurs due to some invalid data in the temporary files which .net creates while running an application.Due to the differences in the code of the temporary files from the actual code this error arises.

Little help from Google suggested me that it’s a known issue and Microsoft has not yet found any fix for this situation although there are a few workarounds which you can do in order to escape from this problem.

In this article i will discuss those workarounds and remember there is no specific workaround so you have to test all whichever may suite you.

First of all just try this one and see if it works then its the easiest, just make a note of whichever control is causing trouble to you it could be your masterpage, you usercontrol or your web service or WCF service.Just go to that control or service and simply edit something, just deleting a small space or pressing an enter key and deleting some white spaces would do and save the document, what this will do is it will ask the runtime to regenerate the temporary file and the regenerated temporary file will be correct as earlier somehow the temporary file generated for this file was incorrect.So most of the times this would do the trick especially in case of services.
If the first solution doesn’t help you then you can go to c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files and delete all the files and force a complete recompile of the whole application.You have to be very careful in deleting the temporary files and don’t try this on the production server this tip is for those who know about the working of .net.If some files are locked then you can unlock them using “Unlocker”
If the above 2 steps don’t work for you then add the batch= “false” compilation tag in your web.config

I think these three steps are sufficient to overcome this problem.

Moreover one thing which i want to add is that never directly start updating your production website with the new updates by just copying the new files on the production server, before copying just take the website down i.e pause the website and once your are done with your changes again put the website to go live or else you will run into this trouble every now and then.

If you have faced similar problems and you found some other solution or cause to this problem you can just share it here with smallworkarounds readers to help the community.

Happy Programming!!!!!!!!!!!!!!!!!!

Customizing Asp.net menu control to use jQuery,Superfish and CSS Friendly Control Adapters

aashish.gupta@smallworkarounds.com (Aashish) — Mon, 05 Oct 2009 01:07:04 PDT

I have used Asp.net menu controls in a lot of applications earlier but now a days with so many new things and controls asp.net menu control seems to lag in many basic functionalities, there are various other options available to be used as a replacement of the asp.net menu control.

But what i loved with the asp.net menu control was its seamless integration with the sitemap datasource and with no hassle i could display whole of my site’s navigation in the menu control by just configuring them in the sitemap file.

What i disliked most was that the menu control by default is rendered as a table structure and not as div structure.

So to fight this abnormality Microsoft released CSS Friendly Control Adapters so that most of the controls which are rendered as tables can be rendered as a simple and clean div structure.

But today i was experimenting with other available options and i found a really cool Superfish jQuery plug-in which we can attach with the asp.net menu control to achieve very cool affects.

In this article i will share the steps on how to hook up the Superfish jQuery Menu plug-in into your asp.net website to beautify your asp.net menu control.

Also please check various option available with the Superfish plug-in on how it can be customized from the Superfish plug-in website.

http://users.tpg.com.au/j_birch/plugins/superfish/#examples

Now let’s look at the steps to integrate superfish menu with asp.net menu

Download the superfish menu from http://users.tpg.com.au/j_birch/plugins/superfish/#download
Direct link http://users.tpg.com.au/j_birch/plugins/superfish/superfish-1.4.8.zip
Unzip the package and you will find the following files in the zip version

Main JavaScript file which is required is superfish.js along with jQuery any version.js rest files are optional and are used if we use some advanced features and customizations with the superfish menu.

Main CSS file is superfish.css and for this demo we will modify this file only.

After downloading the superfish menu files now we should download the CSS Friendly Adapter from http://cssfriendly.codeplex.com/
Place the CSSFriendly.dll into your website bin folder and the CSSFriendlyAdapters.browser in your App_Browser folder.Also remember to comment out the unwanted code from the CSSFriendlyAdapters.browser file as we are dealing only with the menu.

 <controlAdapters>
      <adapter controlType="System.Web.UI.WebControls.Menu"
               adapterType="CSSFriendly.MenuAdapter" />
      <!--adapter controlType="System.Web.UI.WebControls.TreeView"
               adapterType="CSSFriendly.TreeViewAdapter" />
      <adapter controlType="System.Web.UI.WebControls.DetailsView"
               adapterType="CSSFriendly.DetailsViewAdapter" />
      <adapter controlType="System.Web.UI.WebControls.FormView"
               adapterType="CSSFriendly.FormViewAdapter" />
      <adapter controlType="System.Web.UI.WebControls.DataList"
               adapterType="CSSFriendly.DataListAdapter" />
      <adapter controlType="System.Web.UI.WebControls.GridView"
               adapterType="CSSFriendly.GridViewAdapter" />
      <adapter controlType="System.Web.UI.WebControls.ChangePassword"
               adapterType="CSSFriendly.ChangePasswordAdapter" />
      <adapter controlType="System.Web.UI.WebControls.Login"
               adapterType="CSSFriendly.LoginAdapter" />
      <adapter controlType="System.Web.UI.WebControls.LoginStatus"
               adapterType="CSSFriendly.LoginStatusAdapter" />
      <adapter controlType="System.Web.UI.WebControls.CreateUserWizard"
               adapterType="CSSFriendly.CreateUserWizardAdapter" />
      <adapter controlType="System.Web.UI.WebControls.PasswordRecovery"
               adapterType="CSSFriendly.PasswordRecoveryAdapter" /-->
    </controlAdapters>

Also download the latest version of jQuery, otherwise there is already a version of jQuery in the Superfish package.
Now start creating your pages and once you are done , just create a sitemap file to list your whole website.

<?xml version="1.0" encoding="utf-8" ?>
<siteMap xmlns="http://schemas.microsoft.com/AspNet/SiteMap-File-1.0" >
    <siteMapNode url="" title=""  description="">
        <siteMapNode url="Default.aspx" title="Home" description=""/>
        <siteMapNode url="AboutUs.aspx" title="About Us"  description="" />
        <siteMapNode url="Services.aspx" title="Services"  description="" >
            <siteMapNode url="Services/Service1.aspx" title="Service1" description="">
                <siteMapNode url="Services/SubService1.aspx" title="SubService1" description="" />
                <siteMapNode url="Services/SubService2.aspx" title="SubService2" description="" />
                <siteMapNode url="Services/SubService3.aspx" title="SubService3" description="" />
                <siteMapNode url="Services/SubService4.aspx" title="SubService4" description="" />
            </siteMapNode>
            <siteMapNode url="Services/Service2.aspx" title="Service2" description=""/>
            <siteMapNode url="Services/Service3.aspx" title="Service3" description=""/>
            <siteMapNode url="Services/Service4.aspx" title="Service4" description=""/>
        </siteMapNode>
        <siteMapNode url="ContactUs.aspx" title="Contact Us" description=""/>
    </siteMapNode>
</siteMap>

After building all this your solution architecture should be like this.

Now just the master page configuration is left and you are ready to go then

<%@ Master Language="C#" AutoEventWireup="true" CodeFile="Default.master.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>

    <script src="Scripts/jquery-1.3.1.js" type="text/javascript"></script>

    <script type="text/javascript" src="Scripts/superfish.js"></script>

    <link type="text/css" href="~/Styles/superfish.css" rel="stylesheet" media="screen"
        runat="server" />
    <link href="Styles/stylemain.css" rel="stylesheet" type="text/css" />

    <script type="text/javascript">
        $(document).ready(function() {
            $('ul.AspNet-Menu').superfish();
        }); 
    </script>

    <asp:ContentPlaceHolder ID="head" runat="server">
    </asp:ContentPlaceHolder>
</head>
<body>
    <form id="form1" runat="server">
    <div id="outerWrapper">
        <div id="header">
            <div id="logo">
                <asp:HyperLink runat="server" NavigateUrl="~/Default.aspx" ID="lnkLogo">    
                </asp:HyperLink>
            </div>
        </div>
        <div id="menu">
            <asp:Menu ID="menuMain" runat="server" DataSourceID="stmpDataSource" Orientation="Horizontal">
            </asp:Menu>
            <asp:SiteMapDataSource ID="stmpDataSource" runat="server" ShowStartingNode="false" />
        </div>
        <div id="mainContent">
            <asp:ContentPlaceHolder ID="ContentPlaceHolder1" runat="server">
            </asp:ContentPlaceHolder>
        </div>
        <div id="footer">
        </div>
    </div>
    </form>
</body>
</html>

Important :- By default the Superfish menu css file contains the settings aligned with the ul name sf-menu but the asp.net menu control renders the ul element as AspNet-menu so the important step is to replace all the occurrences of sf-menu in the superfish.css with AspNet-menu to make this menu work.

You can download the sample project and plug and play with the CSS file customized for the asp.net menu if you find difficulties in customizing by your self.

After embedding this in your master page you are done with the settings and customization and you are ready to go, i got this menu in just 15 minutes so simple and so easy.

Working Demo can be seen here http://www.smallworkarounds.com/demos/superfish.demo/

Download the Demo from http://www.smallworkarounds.com/blog/democode/Superfish/Superfish.Demo.zip

Happy Programming!!!!!!!!!!!!!!!!!!!!

Microsoft supporting web startups and independent web developers by providing free software's for 3years

aashish.gupta@smallworkarounds.com (Aashish) — Thu, 24 Sep 2009 04:05:20 PDT

Microsoft has launched today a very exciting program called WebSiteSpark for individual developers and small web startup companies having less than 10 employees.

Given below are few software licenses which will be given free to you for 3 years

3 licenses of Visual Studio 2008 Professional Edition
1 license of Expression Studio 3 (which includes Expression Blend, Sketchflow, and Web)
2 licenses of Expression Web 3
4 processor licenses of Windows Web Server 2008 R2
4 processor licenses of SQL Server 2008 Web Edition
DotNetPanel control panel (enabling easy remote/hosted management of your servers)

IMHO it is very good initiative by Microsoft to promote small companies and individuals to leverage their products and build next generation application on the web.

More information can be found here

http://weblogs.asp.net/scottgu/archive/2009/09/24/announcing-the-websitespark-program.aspx

http://www.microsoft.com/web/WebSiteSpark

Saving Changes is not permitted.The changes you have made require the following tables to be dropped and recreated..Sql Server 2008 Management Studio Express Error

aashish.gupta@smallworkarounds.com (Aashish) — Sun, 20 Sep 2009 14:39:07 PDT

If you have just installed Sql Server 2008 Express Edition and you have your default settings then you probably might get this error when your want to change some table and then save changes.

In the default settings “Prevent Saving changes that require table recreation” is checked which prevents to save the changes which you make in the design of the table.

So in this article i will talk less and give you a walkthrough on how to remove this ugly error and to keep it explanatory i will use images rather then simple text.

So the error looks like this

Now the stepwise solution is :-

Click Cancel on this screen and then click OK on the next screen.
On the top menu bar select the Tools option and inside tools select the Options menuitem.

3.Inside options select the “Designer” and in the designer context form “uncheck” the option which says “Prevent Saving changes which requires recreation”.

4.Click OK and you are done and now save changes to your table and your error should no vanish.

Happy Programming!!!!!!!!!!!!

Unable to connect to Sql Server 2008 Express Edition Remotely using the IP and the named instance

aashish.gupta@smallworkarounds.com (Aashish) — Sun, 20 Sep 2009 14:34:30 PDT

If you are trying to connect your sql server 2008 express edition instance remotely and facing problems while connecting it although you have tried all the possible solutions in the book then the problem can be a really very silly thing and what’s that thing , i will describe it shortly. If you are getting the below mentioned error then there might be many reasons for that error.

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) (.Net SqlClient Data Provider)

So in the list of probable reasons is :-

Check if the sql server 2008 express edition service and sql server browser services are running or not, if not then please run them first.

First check whether TCP/IP is enabled in the Sql Server Configuration Manager Tool and select the instance of sql server 2008 express edition for that, if not enabled enable it.

If TCP/IP is enabled then check your firewall settings open two ports 1433 and 1434 on the firewall, generally 1433 is meant for Sql server and 1434 is meant for sql server browser. 1433 is TCP port and 1434 is UDP port
The silly mistake which happens when working with sql server 2008 express edition is that by default it runs on dynamic ports so you can’t run it remotely with all the above configuration and it will lead to frustration.So what to do then, the solution is just go to properties of the TCP/IP and in the TCP Port just give whatever port you want your sql server to be run on.That will do the trick for you.

After doing the port settings now check the firewall rules and open the respective ports which you have just configured and your sql server instance will run remotely.

Happy Programming!!!!!!!!!!!!!!!!!!!!

Adding Google Friend Connect to Blogengine.net Blog

aashish.gupta@smallworkarounds.com (Aashish) — Thu, 03 Sep 2009 02:02:18 PDT

Today i am shifting my blog from BlogSpot to custom domain, so i will be doing a series of post in all the hassles i have to face during this exercise and share my experience with you, so that any one else in plans of shifting the blog to custom domain and also the blog code being open source, should not face the same problems as i am facing.

Smallworkarounds was known for its unique look and feel and various plugins customized in the heart of Google’s blogger.Still the new blog is not even close to the look and feel of the current BlogSpot version but its OK for now i will be rewriting the whole code myself within few days as i get time from my busy schedule.

I will be writing mostly on how to transfer each module you see on Smallworkarounds on blogspot to www.smallworkarounds.com.

For today i will be discussing how to integrate Google’s Friend Connect into BlogEngine.net.

First of all let me tell you why i chose blogengine.net, the obvious reason is that i have already worked on blogengine.net and i am familier with most of its code and I can do tweaks to it’s code in no time.

Secondly what i found after googling was that blogengine.net is the leader in the open source blog engines built in .net. Although there are few other competitors but again all comes to personal choice you can use anyone of the other products out there.

I faced few issues with blogengine.net on Godaddy but i will be dealing those issues in the upcoming posts.

So let’s begin the journey from what i am currently doing and leave the rest for future.

Currently i have all my posts imported from blogger to blogengine.net with some minor errors which i am tweaking daily.

In my blogspot blog i was having a Google Friend Connect toolbar which used to pop up at the bottom, but now the question is how to get the same popup bar with same followers in your blogengine.net blog with your custom domain.

Googling a bit lead me to this post by Mayank Raichura , he has done all the hard work but what he has implemented is a little different from what i wanted.

You can download his sample from here

Hi implementation lets you to have google friend connect only inside the posts pages not on all the pages as this is clear from his code i modified his code a bit and everything then worked just fine for me.

 public void CreateFriendConnectBar(ServingEventArgs e)
    {
        settings = ExtensionManager.GetSettings(GetType().Name);

        //Settings should be retrieved after this...
        string sb_Site_ID = settings.GetSingleValue("Site_ID").ToLower();
        string sb_Div_Tag_ID = settings.GetSingleValue("Div_Tag_ID").ToLower();
        string sb_Scope_of_Social_Bar = "SITE";        
        bool sb_Allow_Anonymous_Post = bool.Parse(settings.GetSingleValue("Allow_Anonymous_Post").ToLower());

        //End Settings Retrieval
        e.Body += "\n<!-- Google_Friend_Connects_Social_Bar extension by Mayank Raichura -->\n";
        e.Body += BuildHTML(sb_Site_ID, sb_Div_Tag_ID, sb_Scope_of_Social_Bar, sb_Allow_Anonymous_Post);
    }
    private void Post_Serving(object sender, ServingEventArgs e)
    {
        post = (Post)sender;
        CreateFriendConnectBar(e);
    }

I removed his code where he is checking whether it is a post page or stuffs related to posts which he is checking in his first few lines and created a method called CreateFriendConnectBar(ServingEventArgs e) which i call from the Post_Serving event basically i am not checking that is the post null or something else, this will run in every case.

The important thing which you have to do other then what is stated is instead of this line

string sb_Scope_of_Social_Bar = "PAGE";

just replace “PAGE” with “SITE”, then just follow the instruction given on his blog to complete the steps.

string sb_Scope_of_Social_Bar = "SITE";

One more thing which most of you will forget is that consider a situation wherein from your previous blogspot blog your were having 2000 followers then you definitely would not want to lose your followers by just going and creating a absolutely new account for the new domain hosting.

So the solution for this is just go to your Google Friend Connect account and remap the url or site url field to your new website on the custom domain.

Also as a quick tip make sure your are having rpc_relay and canvas files in your website root folder.

Text not scaling properly during animation in Silverlight

aashish.gupta@smallworkarounds.com (Aashish) — Wed, 26 Aug 2009 10:42:37 PDT

If you are facing the problem where you text is not scaling properly and the animation is not coming smooth then in this kind of situation you have to use something which can find the nearest neighbor and convert the values in accordance with this nearest neighbor.

If you are using Silverlight then you can do this very easily by typing just one line of code.

For Silverlight 2 you have to type

RenderOptions.TextRenderingMode = “RenderForAnimation”

For Silverlight 3 you have to type

TextOptions.TextHintingMode = "Animation"

Both of these ensure that the text animation is proper, if you don’t use these properties then you will find sometime when you are applying some scaling or any other rendering transformation on any container which also contains some text element then this text element inside the container will also scale.

I will give main emphasis on Silverlight 3 property i.e TextOptions.TextHintingMode

This property takes one of two possible values: Animated or Fixed.

“Animated optimizes for animation by using a more efficient, but less visually precise, smoothing algorithm. Text is still readable and the loss of precision is not that severe.”

Fixed uses an algorithm that is optimized for visually precise text smoothing, but can lead to performance issues. For example, when animations are applied to properties of a text element, in particular FontSize, you might see jitters. When transforms, positioning, or projections are applied to text elements, you might see performance issues. Fixed is the default.

You can apply this property to a layout container and the setting will apply to any text element within that container. However, in general, you should apply this property directly to a text element, such as a TextBlock, TextBox, or Glyphs, where the animations applied will only affect the text.

Happy Programming!!!!!!!!!!!!!!!

Deleting User Alerts in Sharepoint (MOSS 2007)

aashish.gupta@smallworkarounds.com (Aashish) — Mon, 24 Aug 2009 14:59:15 PDT

Setting alerts in MOSS 2007 is very easy just go to any list or library right click on Actions Tab and the last option available is the Alert Me feature. Configuring these alerts is very simple and is a child’s play but customizing the alert emails which are sent and sending list specific email alerts and stuffs like this are little bit tricky.

Don’t worry here we are not discussing those horrifying issues but here we are simply going to discuss on how to delete the alerts which user has set on a particular list. There is a very simple process to do this you don’t need to write code for that but i am sharing this with you as for the novice programmer it’s a tedious task to find actually where to go to delete these alerts.

Just go to “Site Actions” on the top right corner of your sharepoint site and then click “Site Settings”.

Now look for the Site Administration section under that look for the User Alerts.

Once the User Alerts page is opened select a user for which you want to delete the alert, as you select the username from the dropdown list then all the alerts related to that user will be displayed.
Now you can select single or multiple alerts and click on the “Delete Selected Alert” link to delete the selected alert.

Stay tuned for more articles on Sharepoint (MOSS 2007)

Happy Programming!!!!!!!!!!!!!!!!!!!

Finding and changing the default timer interval for timer jobs in Sharepoint

aashish.gupta@smallworkarounds.com (Aashish) — Thu, 20 Aug 2009 12:34:16 PDT

Many times we need to change the default timer settings either by increasing the default time or by decreasing the default time of the timer jobs for a particular sharepoint site.

Particularly if you want to send an email as soon as an action is performed within the sharepoint, in such a scenario you will need to decrease the default timing of the timer job.

There are two commands by which you can achieve this very easily:-

Finding the default time of the timer job, the delay in sending mails could be due to the default timing of the timer jobs which is by default 5 minutes.

stsadm –o getproperty –pn job-immediate-alerts –url http://yoursharepointsiteurl:yourportno

Decreasing the default time of the timer job to 1 minute.

stsadm –o setproperty –pn job-immediate-alerts –url http://yoursharepointsiteurl:yourportno –pv “every 1 minutes”

That’s all you need to do to adjust the default timer job timing delays.

Happy Programming!!!!!!!!!!!!!!!!!

Smallworkarounds on Mobile

aashish.gupta@smallworkarounds.com (Aashish) — Wed, 19 Aug 2009 08:42:28 PDT

Hi readers, i am pleased to announce that Smallworkarounds has been launched for the mobile platform using Mobify.Me service.

You can find the mobile version of Smallworkarounds at www.smallworkarounds.mobify.me

Now you can view your favourite new articles on your mobile set.There will be few more upgrades in future for this mobile site.

I came across mobify.me through Woork and as soon as i used it, i started liking this service.

I highly recommend you to go through this article on Woork to follow the steps to mobify your website.

O3D:- Google Releases 3D support open api for web browsers

aashish.gupta@smallworkarounds.com (Aashish) — Sat, 15 Aug 2009 17:16:00 PDT

O3D is an open-source web API for creating rich, interactive 3D applications in the browser. This API is shared at an early stage as part of a conversation with the broader developer community about establishing an open web standard for 3D graphics.

The latest release is O3D Release 0.1.40.1

O3D is available in Internet Explorer, Firefox, Chrome, and Safari and works on any Linux, Mac, and Windows computer that meets the minimum hardware requirements.

You can watch the sample here http://o3d.googlecode.com/svn/trunk/samples/beachdemo/beachdemo.html

You can download O3D from http://code.google.com/apis/o3d/

MOSS 2007 :- Editing a user profile

aashish.gupta@smallworkarounds.com (Aashish) — Sat, 15 Aug 2009 16:34:02 PDT

There are times when you need to edit the user profiles and relate some meaningful data other then the default data which the user brings from its active directory or standalone profile.

For this task you need to know where exactly you can modify the user profile.

This article will tell you one possible way of modifying the user profile and relating an email address to the user.

1.Open the Central Administration and from the central administration select the Shared Service Provider link.

2.In the shared service provider open the User Profiles and properties link.

3.After clicking the User Profile link you will be redirected to a page where you will find profile and import settings.On this page click on the view user profiles link, clicking on this link will take you to a page where you will find all the details related to the user, you can edit and save changes inside many of the given user related properties.

4. View User Profile will redirect you to a page where you can find all the users now you can click on any of them and as soon as you click the dropdown around them you will find options saying Edit,Delete and Manage Personal Site, now just click on Edit link to start editing the user profile.

5.Now a detailed screen will be opened for you where you can edit any of the properties among several properties which are there.You can associate work phone,title,office,department, email and many other attributes to the selected user which we are editing.

6.After making all your changes, just click on the Save and Close button at the top of the Information to save your changes.

And that’s all what you need to change the user’s profile, this is one of the method to reach here there can of course be other ways to reach at the same section, i would love to know about some other ways by which you people are manipulating the user profiles.

Happy Programming!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Can't Uninstall SQL Server 2005 Express Tools:- Error while installing Sql Server Management Studio Express 2008

aashish.gupta@smallworkarounds.com (Aashish) — Fri, 07 Aug 2009 03:34:38 PDT

The SQL Server 2005 Express Tools are installed. To continue, remove the SQL Server 2005 Express Tools.

If you are getting the above error while installing Sql Server Management Studio 2008 then probably you might try the below given solutions one by one to fix this error.

I m not certain what will work for you but i have added all the options which i found after spending some time on the net which various people have given and for me the most common one worked which also i have listed below.

Rename the key “HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\90”. This worked for me i renamed the whole folder to “old” and then the installation started passing all the test.

Once Sql server Management Studio is installed successfully, then restart your system sql server installation will automatically ask you for a restart.

After restarting you will see that your sql server 2005 instance will stop working because you played with the 90 directory and if you try to rename old to 90 then the system will not allow you to do so as it already created an entry name 90 for you having “Tools” and “Shell”.

So now we are in deep trouble what to do next, what i did was i again renamed the 90 entry which it created to 70 and the entry for sql server 2005 which we renamed as old, again back to 90 and voila everything works fine now.

Both sql server installations are running side by side and both management studios are also running side by side anyways we can open old database in SSMS 2008 so there is no need to have SSMS 2005 unless and until there is some special requirement.

This was the hit and trial method and it worked for me for the first time but i would not suggest this method to be done on any full fledged install although you may test this on your virtual pc or vmware installation as it might corrupt your sql server 2005 installation in some cases.

2.Try uninstalling any redgate products if you have installed any especially Red Gate Sql Prompt, this also caused issues to some users.

3.Try uninstalling sql server Management Studio 2005 before installing SSMS 2008

Above listed three ways will do the task for you, if you have resolved the problem in some other easy and concrete way then please do post your comment.

Happy Programming!!!!!!!!!!!!!!

Renaming MOSS 2007 or Sharepoint Server

aashish.gupta@smallworkarounds.com (Aashish) — Fri, 31 Jul 2009 17:47:50 PDT

Many times there are situations when you have to rename a MOSS installation either in your virtual PC environment and also sometimes in production, although the production one is little uncommon but the point is a sharepoint developer at one point or other want’s to rename his sharepoint server.

Renaming the server simply will screw up all the settings inside the sharepoint as many places there are hardcoded references to the previous server which has to be remapped in order to run the MOSS server with the new server name.

Here in this article i will explain you the step by step process for renaming the MOSS server.There are few resources available on the net which helps you in achieving the same but it was hard for me to find a good resource, so i thought to pen it down so that it can help everyone using Sharepoint.

Steps:-

Change Alternate Access Mappings
Run stsadm for renaming the server.
Rename the server physically on windows explorer.
Reboot the server
Update login credentials
Restart IIS
Change identity references in IIS
Reconfigure search index

1.Change Alternate Access Mappings

This is the first and foremost step to rename the Sharepoint server.Alternate access mappings can be found at Central Administration>Operations>Alternate Access Mappings

Click on the web application url and edit the url to have the new server name.This you have to do manually for every website.

2.Run stsadm for renaming the server.

You have to rename the server using stsadm before actually or physically renaming the sharepoint server.

The command to rename the server is

“stsadm –o renameserver –newservername “[yournewservername]” -oldservername “[youroldservername]“ ” and this is also shown in the figure below:-

stsadm can be found in “C:\ProgramFiles\Common Files\Microsoft Shared\web server extensions\12\bin\

Developers can set the path to be globally accessible for ease of using stsadm instead of navigating to the whole path.How to configure environment variables in order to get the stsadm available globally can be found here :- http://smallworkarounds.blogspot.com/2009/07/sharepoint-quick-tip-add-stsadmexe-to.html

3.Rename the server physically in the windows explorer

For this step just right click on the My Computer icon in the start menu and click on properties then on the Computer Name tab just click Change button and rename it to whatever new name you want to give to your sharepoint server installation.

4.Reboot the server

After following all the 3 steps mentioned above just reboot your sharepoint server.

5.Update Login Credentials

Updating credentials is must as sharepoint server is still mapped to the old username inside the domain and will thus cause problems.To update credentials we will again use stsadm.exe

“stsadm –o updatefarmcredentials –userlogin “newservername\username” –password “yourpassword”

6.Restart IIS

IIS needs to be restarted in order to reflect the changes which we have just made in the above steps.

Remember to restart the IIS using iisreset/noforce from the command prompt.

7.Changing Identity references in IIS

After doing all these changes still sharepoint website’s application pools are mapped to the old username and servername which were used to install the Sharepoint inside the farm.So in order to get rid of this old server name we have to manually change the Identity references in the IIS.

Remember if the identity says “Predefined” and the value is set to Network Service then there is no need to play and touch those settings, let them be like that only.

But if the Identity is configurable then you have to replace the old servername with the new servername in the username section and if you want to change the password then you have to type the password and retype it to confirm and press ok

After this step almost everything is done you just have to configure search index to function properly.

8.Reconfigure Search Index

After renaming the sharepoint server the search index have to be reconfigured the best possible solution is to drop the search index and rebuild it.

After doing all these changes you may still find at some places where few links are referencing your old server name and clicking those links does nothing more then giving a blank page to user saying nothing exists on the server like that which he is asking for.

In such scenarios you have to use your hit and trial method and have to find the root element which is causing this trouble and definitely that would be configurable just you have to figure out which is the right spot to configure this.

After doing this you might face problems with MySite which can be fixed once editing the People & Groups section of the MySite administration.

At last you can navigate through various pages to check that whether your MOSS 2007 server is working or not.

Disclaimer :- This article is based on my testing under my virtual environment things may vary and i advice not to test and play with your production farm sharepoint installations as this might damage your sharepoint server.

Happy Programming !!!!!!!!!!!!!!!!!!

Sending List of Complex objects to Sql server 2005 and persisting it in the database

aashish.gupta@smallworkarounds.com (Aashish) — Tue, 28 Jul 2009 06:23:32 PDT

There are situations when you have to do multiple inserts on a single event there are multiple ways to handle this situation.The simplest and which most of the developers do and make a blunder is making individual calls to the database.

One common example can be a grid which have facility of multiple Insert in such a situation on a single add button click you have to make hundreds of insert or even thousands,there are more genuine scenarios such as, suppose you are making a Silverlight CMS system and you have to save the state of the page containing various sections such as Header,MenuBar,MainContent and Footer which have all the things customizable, in such a scenario you have to save hundreds of settings on a single save button click and you again have to show the user his settings when he again loads the website.

For such situations involving hundreds or thousands of db inserts and updates making individual calls over the network is not at all good,instead i will say that its the worst approach.

There are other approaches,most common of them is sending a list of comma separated values.Ideally this can be said to be a workaround if you are sending just an array or a list of one or two field objects.But for complex objects its the worst solution which i have ever seen and this solution very well persist over the internet.

But its has various disadvantages first one is that there is complex string manipulation associated with this approach,you will be sending something like this “5,6,9,8,45,78,5,6” and then splitting this string on the comma’s(,).Another disadvantage is that this approach is sql injection prone and above all string manipulation is never considered a good design paradigm.

So here in this article i will discuss about the way which i think is the best way to persist changes to the database in such a situation.

We will be making use of xml support of the sql server 2005 and xml serialization of objects in C# to achieve our goal.

Example Description:-This example is an application in Silverlight 2.0 with WCF,Linq,

[Serializable]
    [DataContract]
    public class WebsiteContainer
    {
        [DataMember]
        public int WebsiteContainerID { get; set; }

        [DataMember]
        public int UserID { get; set; }
        [DataMember]
        public double LogoHeight { get; set; }
        [DataMember]
        public double LogoWidth { get; set; }
        [DataMember]
        public double LogoTop { get; set; }
        [DataMember]
        public double LogoLeft { get; set; }
        [DataMember]
        public string LogoFileName { get; set; }
        [DataMember]
        public string BgColor { get; set; }
        [DataMember]
        public string Text { get; set; }
        [DataMember]
        public double TextFontSize { get; set; }
        [DataMember]
        public string TextFontFamily { get; set; }
        [DataMember]
        public double TextLeft { get; set; }
        [DataMember]
        public double TextTop { get; set; }
        [DataMember]
        public string TextColor { get; set; }
        [DataMember]
        public double TextScale { get; set; }
        [DataMember]
        public double Padding { get; set; }
        [DataMember]
        public int ContainerTypeID { get; set; }
        [DataMember]
        public int WebsiteID { get; set; }
        [DataMember]
        public double ContainerHeight { get; set; }
        [DataMember]
        public double ContainerWidth { get; set; }

    }

Its important to note that you have to place a serializable attribute on top of the class declaration so that this class’s object can be serialized to XML while sending it to Sql server.

Now the second step is to write the C# code to serialize this object to XML to transmit over the network.

  public static string SerializeObject<T>(List<T> objects)
        {
            StringBuilder sb = new StringBuilder();
            foreach (var obj in objects)
            {
                try
                {
                    XmlWriterSettings writerSettings = new XmlWriterSettings();
                    writerSettings.OmitXmlDeclaration = true;
                    writerSettings.Indent = true;
                    
                    using (XmlWriter xmlWriter = XmlWriter.Create(sb, writerSettings))
                    {
                        XmlSerializer xs = new XmlSerializer(typeof(T));
                        XmlSerializerNamespaces ns = new XmlSerializerNamespaces();
                        ns.Add(String.Empty, String.Empty);
                        xs.Serialize(xmlWriter, obj, ns);
                    }
                }
                catch
                {
                    return string.Empty;
                }
            }
            return sb.ToString();
        }

Above function will take a list of type T and then iterate through each object inside the list and serialize the object and append the serialized object string to a stringbuilder ‘sb’

Here i would like to mention the real thing which you might miss is that , by default the writer settings are set to bring namespaces and xml dtd information which will result in error saying “XML parsing: line 1, character 841, text/xmldecl not at the beginning of input”

To rectify this error you have to add the writerSetting.OmitXmlDeclaration = true and also add empty namespaces using the XmlSerializerNamespaces this will give you a clean xml which can be parsed by the sql server 2005

Finally we return the string builder object after converting it to string.

After this step we have a serialized string of the whole list of objects as shown in given figure

Now the next step is to get this xml serialized object list into the stored proc.Given below is the code on how can you retrieve this list in sql server 2005

Create PROCEDURE [dbo].[SaveWebsite]
@WebsiteContainerXML XML

AS
BEGIN
DECLARE @WebsiteID INT

	SET NOCOUNT ON;
	
SET @WebsiteID = (SELECT TOP 1 WebsiteContainerValues.ID.value('.','INT') FROM @WebsiteContainerXML.nodes('/WebsiteContainer/WebsiteID') as WebsiteContainerValues(ID) )

		BEGIN TRANSACTION
		DELETE FROM dbo.WebsiteContainer WHERE WebsiteID = @WebsiteID	
		IF @@ERROR <> 0
 BEGIN
    ROLLBACK
    RAISERROR ('Error deleting records', 16, 1)
    RETURN
 END
		INSERT INTO dbo.WebsiteContainer (
			UserID,
			LogoHeight,
			LogoWidth,
			LogoTop,
			LogoLeft,
			LogoFileName,
			BgColor,
			[Text],
			TextFontSize,
			TextFontFamily,
			TextTop,
			TextLeft,
			TextColor,
			TextScale,
			Padding,
			ContainerTypeID,
			WebsiteID,
			ContainerHeight,
			ContainerWidth,
			IsRightAligned
			
		) 
		SELECT 
				WebsiteContainerTab.WebsiteContainerCol.value('UserID[1]','int') AS UserID,
                WebsiteContainerTab.WebsiteContainerCol.value('LogoHeight[1]','float') AS LogoHeight,  
                WebsiteContainerTab.WebsiteContainerCol.value('LogoWidth[1]','float') AS LogoWidth,  
                WebsiteContainerTab.WebsiteContainerCol.value('LogoTop[1]','float') AS LogoTop,  
                WebsiteContainerTab.WebsiteContainerCol.value('LogoLeft[1]','float') AS LogoLeft,  
                WebsiteContainerTab.WebsiteContainerCol.value('LogoFileName[1]','varchar(50)') AS LogoFileName,  
                WebsiteContainerTab.WebsiteContainerCol.value('BgColor[1]','varchar(50)') AS BgColor,  
                WebsiteContainerTab.WebsiteContainerCol.value('Text[1]','varchar(50)') AS TEXT,  
                WebsiteContainerTab.WebsiteContainerCol.value('TextFontSize[1]','float') AS TextFontSize,  
                WebsiteContainerTab.WebsiteContainerCol.value('TextFontFamily[1]','varchar(50)') AS TextFontFamily,  
                WebsiteContainerTab.WebsiteContainerCol.value('TextTop[1]','float') AS TextTop,  
                WebsiteContainerTab.WebsiteContainerCol.value('TextLeft[1]','float') AS TextLeft,  
				WebsiteContainerTab.WebsiteContainerCol.value('TextColor[1]','varchar(50)') AS TextColor,  
				WebsiteContainerTab.WebsiteContainerCol.value('TextScale[1]','float') AS TextScale,  
				WebsiteContainerTab.WebsiteContainerCol.value('Padding[1]','float') AS Padding,
				WebsiteContainerTab.WebsiteContainerCol.value('ContainerTypeID[1]','int') AS ContainerTypeID,  
				WebsiteContainerTab.WebsiteContainerCol.value('WebsiteID[1]','int') AS WebsiteID,  
				WebsiteContainerTab.WebsiteContainerCol.value('ContainerHeight[1]','float') AS ContainerHeight,  
				WebsiteContainerTab.WebsiteContainerCol.value('ContainerWidth[1]','float') AS ContainerWidth,
				WebsiteContainerTab.WebsiteContainerCol.value('IsRightAligned[1]','bit') AS IsRightAligned    
          FROM @WebsiteContainerXML.nodes('//WebsiteContainer') AS WebsiteContainerTab(WebsiteContainerCol) 
		

IF @@ERROR <> 0
 BEGIN

    ROLLBACK


    RAISERROR ('Error Inserting in WebContainers', 16, 1)
    RETURN
 END
 COMMIT 

END

You can refer the syntax to retrieve and iterate through the serialized list and then inserting into the database.

Important to make a note that you don’t have to manually iterate through to get the count and then again run some loop inside the stored proc for storing the above syntax will automatically iterate through all the nodes and insert each record.

Happy Programming!!!!!!!!!!!!!!!!!!

Integrating Silverlight 2.0 with Sharepoint MOSS2007

aashish.gupta@smallworkarounds.com (Aashish) — Mon, 20 Jul 2009 15:08:08 PDT

Silverlight is a revolutionary technology and its much in demand these days,Sharepoint is an old player but very extensive and offer a lot of features which make it alluring for medium to large enterprise.

Sharepoint already provide a lot of out-of the box features but as silverlight is catching up every now and then you will have a requirement from the client to integrate silverlight with sharepoint.

So in this article i will tell you how to integrate silverlight with sharepoint.Although there can be various ways of doing so i m following the webparts approach as it seems simple to me there are other simple approaches in which we can add a contentweb part in which we can give the source of the iframe as an hosted xap on silverlight live streaming server’s but being a developer this approach seems to me a little creepy and also there are very few resources which clearly tell how to integrate silverlight 2.0 into Sharepoint or MOSS2007.

Create a silverlight 2.0 application and copy the xap and project .dll file in a separate folder.
Configure MIME Types on the sharepoint server to accept .xap,.xaml,.xbap file extensions.
Change the web.config of the application or website where you want silverlight to be integrated.
On the sharepoint server create a WebPart project.
Copy the resources i.e xap and the project dll file in the directory specified in the web part project silverlightcontrol source
Deploy the webpart project to the required site where you want silverlight to show up.
Edit the page where you want to add the silverlight control and click add webpart and you are done.

Create Silverlight 2.0 application
- Create a silverlight 2.0 application and build that solution and copy and past its xap file and the project dll file into another folder whose content we will copy later into the wwwroot and website name of the sharepoint site where we want to deploy this silverlight application.
Configure MIME types in IIS on the sharepoint server
- If you don’t have mime types configured on your iis server on the machine where you have your sharepoint installed, then first step is to configure the mime types on the IIS.
- For IIS 6 you can either right click on whole of the website section or on specific website where you want the mime types to be configured.After right clicking go to the http header section from there select the mime types.

After selecting mime types click on new if the silverlight mime types are not present.

Add all the three mime types shown in the above figure and then click ok.Now your IIS is configured to accept and render xaml, xap and xbap

3.Change the web.config file of the sharepoint website for which you want to integrate silverlight.

This is very important step because if you leave this step in between even if you do all other things correctly then also nothing will get rendered in the final webpart when you deploy the webpart and include it on your page.
So we have to follow a little hacky approach in order to get the configuration file correct.
So first step is open your visual studio and create a new asp.net 2.0 application

We are creating asp.net 2.0 application because sharepoint is using mostly asp.net 2.0 references and it’s not having any web.config enteries related to silverlight and ajax features of the 3.5 framework.
It is recommended to make a copy of the web.config so that if any error occurs you can restore the original version.
Now we should open the web.config of the sharepoint website in the same solution.web.config of the sharepoint website can be found at “c:\inetpub\wwwroot\wss\VirtualDirecotries\yourwebsitename\web.config”
Open this web.config and copy and paste the content in the original asp.net 2.0 web application web.config.
Now right click on the web project and click properties and change the target framework to .net framework 3.5 and then save the web.config file for the sharepoint website.

Now you have to add the following two entries in your web.config, first one is in the <system.web><compilation><assemblies> section add the below line

<add assembly="System.Web.Silverlight, Version=2.0.5.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>

Next entry to be added is in the <system.web><pages><controls> section just add the line as given below

<add tagPrefix="asp" namespace="System.Web.UI.SilverlightControls" assembly="System.Web.Silverlight, Version=2.0.5.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>

After adding these two entries just save the web.config file and you are done with the web.config changes.

4.Create a webpart project on the sharepoint server

For creating a web part project in Visual Studio 2008 you need to install “Windows SharePoint Services 3.0 Tools: Visual Studio 2008 Extensions, Version 1.2” which can be downloaded from here
After installing WSS3.0 tools Visual studio extensions you will have a new Sharepoint project type in C# section,from there choose webpart project and give your project some name.

Delete the default webpart folder which will be created and click on the add new item and then select webpart from the list.

Add two references to this project one is System.Web.Extensions and the other one is System.Web.Silverlight

In the yourwebpartname.cs file make changes so that it should look similar in code as given below

using System;
using System.Runtime.InteropServices;
using System.Web.UI;
using System.Web.UI.SilverlightControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Serialization;

using Microsoft.SharePoint;
using Microsoft.SharePoint.WebControls;
using Microsoft.SharePoint.WebPartPages;

namespace TangramWP
{
    [Guid("6b31932f-7245-4d78-912c-56033008e775")]
    public class TangramSilverlightWP : System.Web.UI.WebControls.WebParts.WebPart
    {
        private Silverlight silverlightControl = null;
        public TangramSilverlightWP()
        {
        }
        protected override void OnLoad(EventArgs e)
        {
            base.OnLoad(e);
            ScriptManager scriptManager = ScriptManager.GetCurrent(this.Page);
            if(scriptManager==null)
            {
                scriptManager = new ScriptManager();
                this.Controls.AddAt(0,scriptManager);
            }
        }
        protected override void CreateChildControls()
        {
            base.CreateChildControls();
            silverlightControl = new Silverlight();
            silverlightControl.ID = "TangramSilverlight";
            silverlightControl.Source = "/Bin/Tangram.xap";
            silverlightControl.Width = new Unit(500);
            silverlightControl.Height = new Unit(400);
            Controls.Add(silverlightControl);
        }
    }
}

5.Copy resources such as xap and the project dll inside the specified location inside the sharepoint website.

Now in the bin directory of your sharepoint website just copy your .xap file and the silverlight application which is in my case Tangram.dll.

6.Deploy the web part solution created

Right click on the solution and click properties in the debug section just change the “Start Browser with url” with the location of your sharepoint website.

Right click on the webpart solution which you have created and just click deploy to deploy the solution to the sharepoint website.

After successful deployment click on the edit page section in the site actions of your website and select the web part which you just deployed its generally in the miscellaneous section.

If all goes well and you have followed each step you will see the silverlight application rendered in your webpart.

Happy Programming!!!!!!!!!!!!!!!!!!!!

Sharepoint Quick Tip:- Add stsadm.exe to your environment variables to execute it from anywhere

aashish.gupta@smallworkarounds.com (Aashish) — Sun, 19 Jul 2009 13:40:04 PDT

This is a very small but tremendously useful tip for the beginners of WSS 3.0 or MOSS 2007.Especially when you are using the free version WSS 3.0 many times you need to use this command line utility call stsadm.exe.

As you need it many times every time you need to navigate to its directory which is “C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\bin”

So as a quick workaround what you can do to save your time is to set this path in environment variables section.

Just right click on your MyComputer and select Properties

In the advanced section select environment variables and then below select the path.In the path put semi-colon after the last entry and add one more path as c:\Program Files\Common Files\Microsoft Shared\web server extensions\12\bin.

After doing this just click OK and you are done.

Now you can run stsadm.exe from anywhere in the command prompt as it’s available globally as an environment variable.

This tip is meant for a sharepoint newbie.

Microsoft Charting Controls:- How to setup and start building your first chart application

aashish.gupta@smallworkarounds.com (Aashish) — Mon, 13 Jul 2009 04:50:24 PDT

If you need charting support in your asp.net application then you don’t need to look for any other 3rd party charting controls.Microsoft with its release of .net framework 3.5SP1 and Visual Studio 2008 SP1 provided the facility of charting within the development environment.

You just have to download and install the right packages and then configure your configuration files correctly to setup your charts to see them up and running.

Here in this article i will tell you where to download and install the required things for working with Microsoft Charts and how to configure you web.config in order to setup your charting controls.

First of all these are the links to download the prerequisite to start playing with Microsoft Chart Controls

Now the second thing is adding the chart control to your toolbox.

Just right click on your toolbox’s data tab and select Choose Item from the menu.
In the dialogue box opened select the two dll’s marked in the image below, after adding these you are good to go with Microsoft Charting.

After adding these controls to the toolbox just drag and drop the control on to your page.It will automatically create a Register directive entry on your page if it does not create then you can do it manually, just add the below lines to your page in a Register directive.

<%@ Register Assembly="System.Web.DataVisualization, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
    Namespace="System.Web.UI.DataVisualization.Charting" TagPrefix="asp" %>

After dropping the chart control on to your page you will have the markup like this

<asp:Chart ID="Chart1" runat="server">
    <Series>
        <asp:Series Name="Series1">
        </asp:Series>
    </Series>
    <ChartAreas>
        <asp:ChartArea Name="ChartArea1">
        </asp:ChartArea>
    </ChartAreas>
</asp:Chart>

Now the third thing is configuring your web.config file in order to make chart controls work properly,otherwise you will receive errors complaining about the http get request and other similar errors.

<appSettings>
    <add key="ChartImageHandler" value="storage=file;timeout=20;dir=c:\TempImageFiles\;" />
</appSettings>

<httpHandlers>
...
    <add path="ChartImg.axd" verb="GET,HEAD" type="System.Web.UI.DataVisualization.Charting.ChartHttpHandler, System.Web.DataVisualization, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" validate="false" />
...
</httpHandlers>

<handlers>
...
    <add name="ChartImageHandler" preCondition="integratedMode" verb="GET,HEAD" path="ChartImg.axd" type="System.Web.UI.DataVisualization.Charting.ChartHttpHandler, System.Web.DataVisualization, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
...
</handlers>

These three web.config entries are sufficient to make your chart control work.

If for the first setting you don’t want to use the drive location which is currently configured as c:\TempImageFiles\ you can replace it with web location of your website as instead of dir use url=”~\tempImages\”,this will use the tempimages folder created inside your website root.

Stay tuned for more articles on Microsoft Charting Controls

Happy Programming!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

The base class includes the field 'ReportViewer1', but its type (Microsoft.Reporting.WebForms.ReportViewer) is not compatible with the type of control (Microsoft.Reporting.WebForms.ReportViewer)

aashish.gupta@smallworkarounds.com (Aashish) — Mon, 13 Jul 2009 00:40:13 PDT

If you are getting this error while using old reports from your legacy application then you can try out the following solutions

Change in your Web.config all "Microsoft.ReportViewer.WebForms, Version=8.0.0.0,..." to " Microsoft.ReportViewer.WebForms, Version=9.0.0.0,..." and in controls "Register Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0,..." to "Register Assembly="Microsoft.ReportViewer.WebForms, Version=9.0.0.0,..."
Clean your solution and delete the related dll files and then again rebuild the solution.

Generally doing step 1 will resolve the problem as in legacy applications its configured to use Version=8.0.0.0

Best and simple approach to deal with JSON Dates problem

aashish.gupta@smallworkarounds.com (Aashish) — Sun, 28 Jun 2009 13:22:09 PDT

It might be very frustrating for the guys who decided to try for the so called great revolution using jQuery and asp.net,WCF and Linq in combination.

Their adventure with the code might come to an end first on the WCF configuration step or secondly handling the JSON serialization over the wire.

Although its really simple to configure the WCF service for your JSON wire transfer requirement but its certainly a little confusing.

Another problem which comes after successful configuration of the WCF services with your application is dealing with “Dates”.

This problem arises due to the fact that there no javascript literal called Date.Everytime we need a date we create a new object of the date such as:-
Date myDate = new Date(“28/04/2008”);

If you write the date like the below given syntax then its not the actual date but its only ordinary string which is of no use as such and does not solve our purpose.

var  myDate = “28/04/2008”;

So the response which you will receive from the server in the JSON format will contain all the dates in a surprising format which can be easily parsed if you are using Micorosft Ajax. But if you are on your own using direct jQuery $ajax() then your life is in trouble.

To workaround this strange Date problem there are few possible ways out of which :-

Parse the response from the server on your own and just use the regex to remove \/ symbol and then evaluating the date string and converting it to Date($1) and returning this date.Although this method is the so called correct one but still its little too complicated and it seems to be the only standard workaround for solving this problem.Given below is some custom implementation for showing how you can parse and evaluate the response received from the server.Always keep in mind that this code would need some change if you are using some other type of replacer symbols in the JSON,this is just a reference example how to parse the response and then evaluating it to get the correct dates.

  $.ajax({
        type: "POST",
        url: pagePath + "/" + methodName,
        contentType: "application/json; charset=utf-8",
        data: paramList,
        dataType: "text",
        processData: false,
        success: function(msgg) {
            var msg = JSON.parse(msgg, function(key, value) {
                var a;
                if (value != null) {
                    if (value.toString().indexOf('Date') >= 0) {
                        a = /^\/Date\((-?[0-9]+)\)\/$/.exec(value);
                        if (a) {
                            var dt = new Date(parseInt(a[1], 10));
                            return (dt.getMonth() + 1) + "/" + dt.getDate() + "/" + dt.getFullYear();
                        }
                    }
                    return value;
                }
            });
            successFunction(msg);
        },
        error: function(xhr, status, error) {
            errorFunction(xhr, status, error);
        }
    });

Here in this example we are getting the actual response in the variable msgg.After invoking the success we are parsing the response and then we are searching for the Date values in the string where ever found we are removing the unnecessary symbols \/ and then parsing the 10 digit date and after this step converting it to actual date and finally returning the value.

Although its a little tricky approach but it works fine,you might have to change the parsing method a little bit as according to your needs to make it work for you.

2.Another simple solution is forget about the Date thing on the client side consider every thing as string on the client and also in your business logic and application layer.Although it doesn’t sounds good and many of us don’t agree on this but its the simplest possible workaround to make things work quickly.

So for achieving this no need to make any changes in your database schema just let the dates be dates only in your schema.

What we will do is we will pass date as string from the UI using BusinessObjects to the Service Layer and DataAccessLayer and after reaching the database we will convert these values back to string and while retrieving those dates from the database they should be converted again back to string so that we are not again running into the same old problem.

Converting date to string while retrieving back the date to be displayed somewhere on the page

CONVERT(CHAR(11),datemodified ,106) AS datemodified,
		CONVERT(CHAR(11),datecreated,106) AS datecreated

There are various other choices available with changing the last code part to receive date in various other formats.

By using this mechanism you will never run into this date trouble again

Differences between an abstract class and an interface in C#

aashish.gupta@smallworkarounds.com (Aashish) — Fri, 19 Jun 2009 22:19:44 PDT

Most of the new developers are always confused as when, where and why we should use an interface or an abstract class.Although both abstract classes and interfaces serve the same purpose to some extent but yet they are different in many terms.

Although both act as a sort of contract but there are some major differences in both of them which i will sum up in this article

Interfaces belong to interface type where as abstract classes belong to class type
Interface contain only abstract methods which the type who implements the interface should give its declaration whereas abstract class may contain both abstract methods as well as concrete methods.
Abstract class can extend another class and implement multiple interfaces, where as an interface cannot be inherited from a class.
If A is your abstract class and B is a class which extends A, then in this situation you can have B only extend from A not from any other class i.e no direct multiple inheritance is supported and this in a sense is achieved by interfaces as we can implement any no of interfaces for a given class.
Both follow a different paradigm as interfaces are implemented whereas classes are extended.

So both concepts are a kind of generalization and are used in situations where we cannot in reality define the object which we are talking about this line means for example if we say a car then its a very general specification and no such entity exists in real which we can say is a car.But if you say “Ferrari” then it does make sense and you can identify a unique instance.

So to define car’s action we can use either abstract classes or interfaces to declare the general car functionalities.

After doing that we can go ahead and create a Ferrari class which either can derive from your abstract class or can implement the interface created by you.

Using abstract classes or interfaces totally depends on what type of inheritance are you following if your applications is sounding to use multiple inheritance then its always better to go with interfaces and if you know that with a particular class the derived class need not be derived from another class then you can go ahead with abstract classes.

These are the main differences and some similarities between these two.If you want to add something else do leave a comment.

Happy Programming!!!!!!!

Ext.js 2.2 intellisense in Visual Studio 2008

aashish.gupta@smallworkarounds.com (Aashish) — Tue, 16 Jun 2009 10:51:33 PDT

Today i was playing with ext.js a very nice little java script framework which can give you very stunning UI at the end if you have little patience.

Although Visual Studio 2008 provides support for java script intellisense but it is rather bleak or dull so when it comes to jQuery there is a vsdoc file for our rescue.

But what about when you are playing with other javascript libraries like ext.js

So i found a very good link which talks about getting ext.js 2.2 intellisense in Visual Studio 2008 which i wanted to share with you all

http://www.spket.com/ext-intellisense-visual-studio.html

I will be doing a series of articles on ext.js in future as i have started playing with it.

Happy Programming !!!!!

Integrating Paypal with Blogger or any other Blog Provider

aashish.gupta@smallworkarounds.com (Aashish) — Mon, 15 Jun 2009 03:42:09 PDT

If you want to earn from your blog you have many options such as Adsense,Adbrite,LakeQuincy Media and there are several other advertising giants which will help you make more money.

But another good way to make money from your blog is by providing a way through which users who want to donate you some bucks can directly donate it to you and the best possible solution which comes to my mind is PayPal.

Here in this article i will show you how easy it is to integrate the paypal into your blog.I have done it on blogger,you can follow similar steps and embed it in any blogging platform

After clicking the Merchant Services tab search for the word Donations and click it then you will see the below screen.
Fill the form and selecting your choice and preferred buttons and then click Create Button

After clicking on create button you will be provided with a code.Now you have to just place that code into your blog’s code to make it running.

I will show you how to integrate it into blogger
Login to your blogger account and go to Layout tab.Click on add a gadget

After adding a popup window will be opened.Just enter the heading which you want to be displayed and also write few lines of your own choice which you want to display.After writing all this just paste the code which you got above i.e after creation of your button.

Click Save and that’s it your paypal donation button is now integrated with your blogger blog.

Publishing Database to GoDaddy server using Database Publishing Wizard

aashish.gupta@smallworkarounds.com (Aashish) — Sun, 14 Jun 2009 22:32:29 PDT

GoDaddy shared hosting supports database publishing wizard which is a good news as earlier there were creepy means to publish the database to the godaddy servers.Now you can publish your database either in full or only the required objects to the godaddy server.

Follow the steps given in the below link to publish your database directly to the godaddy server

http://products.secureserver.net/products/hosting/PublishingWithDPW.htm

If you dont have Database Publishing Wizard already installed then you can download and install it from

http://www.microsoft.com/downloads/details.aspx?FamilyId=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en

After installation you will find the database publishing wizard in

C:\Program Files\Microsoft SQL Server\90\Tools\Publishing\1.2\SqlPubWiz.exe

But remember to backup your existing database prior to uploading or deleting the already existing database.