Posted by: Vijay Modi | October 22, 2009

ASP.NET 4 Beta 2 and Visual Studio 2010 Beta 2 Released

Today, I just visited http://ASP.Net and found that Microsoft has released ASP.Net 4 Beta 2 and Visual Studio 2010 Beta 2. You can find some of the exciting changes on the following URL:

http://www.asp.net/learn/whitepapers/aspnet4/#_TOC1_1

And you can find Breaking changes on the following URL:

http://www.asp.net/learn/whitepapers/aspnet4/breaking-changes/

Some new features are really amazing. Lets start with this new one instead of using old.

Cheers with ASP.Net 4 Beta 2 :-)
Vijay Modi

Posted by: Vijay Modi | October 20, 2009

Find table from Column Name in an MSSQL Database

From the following query you can find all the tables contains the ‘FirstName’ column.

SELECT
table_name=sysobjects.name,
column_name=syscolumns.name
FROM sysobjects
JOIN syscolumns ON sysobjects.id = syscolumns.id
WHERE sysobjects.xtype=’U’ AND syscolumns.name like ‘FirstName’
ORDER BY sysobjects.name,syscolumns.colid

Regards,
Vijay Modi

Posted by: Vijay Modi | October 17, 2009

Let me know your Suggessions…

Hi Friends,

Its Diwali celebrations here in India.

May the festival of lights be the harbinger of joy and prosperity. As the holy occasion of Diwali is here and the atmosphere is filled with the spirit of mirth and love, here’s hoping this festival of beauty brings your way, bright sparkles of contentment, that stay with you through the days ahead.
Best wishes on Diwali and New year.

For this Diwali and coming New Year, I want to know your suggessions for this blog. I want to improve my blog and for this I need your help. Please add your suggessions, so that I can improve this blog and write more interesting articles.

Happy Diwali and Happy New Year :)

Regards,

Vijay Modi

Posted by: Vijay Modi | October 11, 2009

Validation on User Registration

Mostly we are giving functionality for registration on the website and use the website. And using our registration page, user can register him/her and set the UserName and password whatever he/she want. Here we are inserting some validations on client side and server side for checking the data entered by user is valid or not. However one more validation we require on Server side. This is regarding the UserName. We are providing functionality like user can create any UserName. We are checking on server side that the UserName enetered by User is exist or not. And if userName not exist we are creating that User with the UserName that he/she set on registration page.

However we should set one more validation on this registration page for UserName that the user cannot create UserName with the website domain name. Like if site domain name is “www.testing.com”, then user cannot create UserName, which contains the Domain Name in his UserName. Means user cannot register with UserNmae like ‘testing’, ‘testing123′, ‘123testing123′, ‘123testing’, ect…
This is very important as once user register with these name, he can sent mail to other person using that same ID from the website. So we should add validation on server side that the User cannot register with the UserName which contains domain name.

We should also add validation for some common names too. Like we should add validation on server side that the user cannot register with some common names like “hr”, “info”, “information”, “contacts”. So we should also add these list in our Server Side validation. So that user cannot register with these types of UserName.

Let me know your input for the same.

Thanks & Regards,
Vijay Modi

Posted by: Vijay Modi | October 7, 2009

Barcode Specifications

I created an application to generate barcode based on the user inputed data. I have written an application for generating barcode based on “Code 128″. I generated that Borcode based on the following specification.
http://www.spatula.net:8000/proc/barcode/code128.src
You can find all barcode specifications on the following link:
http://www.spatula.net:8000/proc/barcode/index.src

Thanks & Regards,
Vijay Modi

Posted by: Vijay Modi | September 25, 2009

How to Use C# code in vb project. ?

Today, I was facing a problem to how to use C# code in vb WebProject. I got the solution from the following URL:
http://timheuer.com/blog/archive/2007/02/28/14002.aspx

To resolve this error, please go into the following location:
C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.1\Data

and delete “ib_logfile0″ and “ib_logfile1″.

Then go to Services and start your MySql. It will resolve the error and start you MySql.
Why: According to my search: Open the my.ini file and check the InnoDB variables’s size. When above file exides the mentioned size it will prompt this(“Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.”) error.

I was getting this error while running my biztalk application. After searching on search engine, I have not received any response. Then I tried to see the host instances are working properly or not. And there I found the actual solution. That my application reunning in a host instance(test) was not running. I start that orchestraion and test my application. Its working fine now. Check your Host Instances working properly in which you have configured your BizTalk application. It will resolve your error.

Posted by: Vijay Modi | July 19, 2008

Biztalk : PartUpdateDisallowedException Exception

When you are going to update any message in Construct shape which is already constructed, then you will receive this type of error. Like you are receiving msg1 and just after this receive shape, you are going to construct this message once more. In this type of situation, you will receive this type of error.

Solution:
To resolve this error,create a new message in orchestration view of same type. And use this new message in new message in construct shape. Same problem can occur when you are sending message to .net assembly too. So make sure when you want to update any message, it must be new.

Enjoy,:)
Vijay Modi

Today, I go through a solution to send XLangMessage to .net assembly from an Orchestration and update it. After update I need it in my Orchestration. For this I have created a project which I think it can help others.

I have created an Orchestration project named “CallNetAssemblyBySendingXLangMessageAndUpdate”. I have added the following simple schema in this project named “Book.xsd”.

Then I have created added an orchestration named “CallAssemblyXLangMessage.odx” in project. In this orchestration I am receiving the Book.xsd type message in receive shape. After this I have added the message assignment shape in the transform shape to update the values of message received of Book.xsd type. In this Construct shape I am creating a new message of Book.xsd type. In this message assignment shape I am calling the .net assembly in which I am updating the message.

I am sending the message in .Net assembly method as XLANGMessage parameter. Before going further I want to explain how I am accepting the message and updating it and return it.

For this I have added a new Class Library Project named “UpdateXLangMessage” in the Solution.

You need to create the Book class of Book.xsd created in Orchestration project by using XSD.exe util. You can create this class by using the following command at Visual Studio Command Prompt:

xsd.exe /c Book.xsd

This will create a Book.cs class. Add this project in class library project UpdateXLangMessage.

Now to receive XLangMessage and update it I have added the following class in this project.

========================================================

using System;
using Microsoft.XLANGs.BaseTypes;
namespace UpdateXLangMessage

public class UpdateMessage
{
public static Book UpdateBookMessage(XLANGMessage xlngMsg)
{
//Serialize message into Book Object
Book objBook = (Book)xlngMsg[0].RetrieveAs(typeof(Book));
try
{
//Update Book Object
objBook.Author = “Vijay Modi”
objBook.BookID = “00001″
objBook.BookName = “Biztalk 2006 R2″
objBook.Price = “Free”
objBook.Publisher = “Testing Publisher”
}
catch (XLANGsException xlngEx)
{
throw xlngEx;
}
catch (Exception ex)
{
throw ex;
}
//return book object
return objBook;
}
}
}

=========================================================

Build this class. Assign a Strong Name key to this project and add it in GAC using following command in Visual Studio Command Prompt.

gacutil /i UpdateXLangMessage.dll

Now we are going back to our Orchestration project. In Orchestration project add the reference of the .Net class library project.

Now in our Orchestration’s message assignment shape write the following expression:

//msgBookNew is the new message created of Book.xsd schema type

//msgBook is the message received in receive shape

msgBookNew = UpdateXLangMessage.UpdateMessage.UpdateBookMessage(msgBook);

Add the send shape just below the Transform shape in the orchestration. Assign the msgBookNew message in this send shape. The orchestration will look like as below:

Now deploy your orchestration project and test it. Some important reference I have found on the net are as below:

Reference:
http://support.microsoft.com/kb/917841
http://msdn.microsoft.com/en-us/library/aa995576.aspx

You can write your comments here:)

Regards,
Vijay Modi

Older Posts »

Categories