Salahuddin Ahmed's Blog

BizTalk Map Breaks When Schema Changes

2012-01-11T18:10:00.001+06:00

Many times we see that links within BizTalk map break when there is some change in the schema used in the map.

One of the reasons for maps to break the links is changing the target namespace of the source or destination schema. To avoid breaking of the links within map, we should set the Ignore Namespace for Links property of the map to “Yes”.

If the root node name changes in a schema, all the links within map break. You need to rebuild the links again or open the .btm file in notepad and replace the old root node name with new root node name.

Changing the version of the .net assembly housing custom functoids or helper functions used in the map breaks the links using those assemblies. In this case we should update the .btm file directly in notepad to update the version of the referenced assembly.

If the schema element/attribute name changes the associated links break. Adding new elements/attributes/records doesn’t break the existing links. Those changes are automatically reflected in the map when map is reloaded.

That's it.

Setting CSS Opacity with jQuery that Passes W3C Validation

2011-02-03T01:29:00.014+06:00

Setting CSS opacity directly using jQuery is much more practical and easier to implement, because the code is exactly the same for all browsers and passes W3C validation as well. Let us see how jQuery sets CSS opacity on a div element.

Here ".boxcaption" is a class name of a div element where the opacity .5 ( 50%) will take place.

That’s it.

Use StringBuilder Class instead of String Class when you manipulate string object

2010-01-21T23:43:00.005+06:00

Use System.Text.StringBuilder Class instead of System.String Class when you have to manipulate string objects in a loop. Each time you append a string object in a loop it is actually discarding the old string object and recreating a new one which is relatively expensive operations.

Have a look at the following example where the string object ‘message’ is discarded each time.

public string MyMessage(string[] lines)
{
string message = String.Empty;
for(int i=0;i<lines.length;i++)
{
message+=lines[i];
}
return message;
}

The System.String Class object is immutable. Every time you use System.String Class, you create a new string object in memory. In situations where you need to perform repeated modifications to a string object, the overhead associated with creating a new string object can be costly. The System.Text.StringBuilder Class can be used when you want to modify a string object without recreating a new one. Using the System.Text.StringBuilder Class can boost performance when concatenating many string objets together in a loop.

Have a look at the following example where the System.String Class object is replaced with the System.Text.StringBuilder Class.

public string MyMessage(string[] lines)
{
StringBuilder message =new StringBuilder();
for(int i=0;i<lines.length;i++)
{
Message.Append(ines[i]);
}
return message;
}

That’s it.

How to create an installer in order to distribute a .NET windows application?

2010-01-09T00:03:00.004+06:00

After you have developed a .NET windows application you need to follow the following steps to create an installer in order to distribute your application. The resulting windows installer file is a combination of the application, dependent files, registry files, and instructions for installation.

1. Go to File menu then click Add to follow Add->New Project->“Add New Project” window opens
2. Double click “Other Project Types” and then click “Setup and Deployment Projects” to choose “Setup Project” from the given templates. Give a name (e.g. Setup) for the project in the name text box and then finally click “OK” button. After that “File System” window might opens immediately.
3. Now newly created “Setup” project appears in solution explorer accompanied with your application project created earlier.
4. Select “Setup” project and then right click to follow Setup->View->File System->”File System” window opens.
5. You can see here three folders such as Application Folder, User’s Desktop, and User’s Program Menu under “File System on Target Machine”.
6. Select Application Folder and then right click to follow Add->Project Output->Select Primary Output(Contains the DLL or EXE built by the project.) from “Add Project Output Group” window->Click “OK” button
7. Select User’s Desktop Folder and then right click on the right panel to follow Create New Shortcut->”Select Item in Project” window opens->Select Primary Output file from Application Folder>Click “OK” button->Chang the shortcut to name it “Setup”
8. Select User’s Program Menu Folder and then right click on the right panel to follow Create New Shortcut->”Select Item in Project” window opens->Select Primary Output file from Application Folder> Click “OK” button->Change the shortcut to name it “Setup”
9. Now if you want to change the manufacture’s name or anything else just select “Setup” project to change “Setup” project’s Deployment Project Properties as per your requirement.
10. Finally build your application project after successfully build the “Setup” project. When completed, Setup.msi file can be appeared in the application Debug or Release folder depending upon the properties settings (Select and then right click “Setup” project to follow Properties ->Setup Property Pages)
11. Prerequisites: Windows installer 3.1 and most importantly .NET Framework 3.5 must be installed on the target machine where your application project will be installed with the help of Setp.msi installer. .NET Framework 3.5 installation is mandatory because application and controls written for the .NET Framework version 3.5 require the .NET Framework redistributable package version 3.5 to be installed on the computer where the application or controls runs.

That's it.

Meta Tags: Important factors for your website and SEO

2010-01-01T23:14:00.006+06:00

HTML meta tags hold important information about your website and also put impact on SEO resulting efficient page rank. There are many kinds of meta tags but I would rather describe some important meta tags which really rock. These are given as bellow:

Title Meta Tag
Title meta tag refers to the name of your website. It appears in the reverse bar of the browser. Title of your web site can be seen in the search results. Title meta tag format is as follows:

Description Meta Tag
Description meta tag refers to the actual target of your website. Your websitesite description can be seen in the search results as well. Description meta tag format is as follows:

Keywords Meta Tag
Keywords meta tag is less important in case of popular Google search engine. However, keywords as a meta tag is followed by SEO process to index your web pages. Keywords meta tag refers to the descriptive terms of your website contents. Keywords meta tag format is as follows:

Robots Meta Tag
Robots meta tag allows search engine robot (e.g. Google Bot) to crawl web pages starting from index page of your website and continuing with the rest of the web pages. Robots meta tag format is as follows:

However, in case of a particular page should not be indexed by a search engine then the robots meta tag format will be as follows:

Meta tags must be placed in between HTML HEAD tag e.g.

A sample implementation of meta tags is as follows:

<head>

<meta content="<title>Salahuddin Ahmed's Blog</title>" name="title"/>

<meta content="It is all about C#.NET, ASP.NET, ADO.NET, SQL Server, Crystal Report, HTML, JavaScript, XML, AJAX, CSS, and Flash."name="description"/>

<meta content="C#.NET, ASP.NET, ADO.NET, SQL Server, Crystal Report, HTML, JavaScript, XML, AJAX, CSS, Flash" name="keywords"/>

<meta content="all, index, follow" name="robots"/>

</head>

That’s it.

How to truncate database tables in SQL Server?

2009-12-23T17:00:00.012+07:00

Suppose you have created a database containing three tables with no foreign key constraints. Now simply execute the following commands:

TRUNCATE TABLE [dbo].[table1]
TRUNCATE TABLE [dbo].[table2]
TRUNCATE TABLE [dbo].[table3]

that's it.

But what if some of your tables have foreign key constraints? Don't worry there is a solution as follows.Suppose table1 and table2 have foreign key constraints with reference to table1. Now follow the following steps:

1. ALTER TABLES-[Drop Foreign Key Constraints]

ALTER TABLE [dbo].[table2] DROP CONSTRAINT FKtable2
ALTER TABLE [dbo].[table3] DROP CONSTRAINT FKtable3

2. TRUNCATE TABLES

TRUNCATE TABLE [dbo].[table1]
TRUNCATE TABLE [dbo].[table2]
TRUNCATE TABLE [dbo].[table3]

3. ALTER TABLES-[Add Foreign Key Constraints]

ALTER TABLE [dbo].[table2] ADD CONSTRAINT FKtable2 FOREIGN KEY (Id) REFERENCES [dbo].[table1] (Id)

ALTER TABLE [dbo].[table3] ADD CONSTRAINT FKtable3 FOREIGN KEY (Id) REFERENCES [dbo].[table1] (Id)

that's it.

C#.NET Coding Standards

2009-12-22T14:10:00.003+07:00

Naming Conventions and Standards:
1. Use Pascal casing for Class names.
Pascal Casing - First character of all words are Upper Case and other characters are lower case. Example: SalahuddinAhmedBlog
2. Use Pascal casing for Method names.
3. Use Camel casing for variables and method parameters.
Camel Casing - First character of all words, except the first word are Upper Case and other characters are lower case. Example: salahuddinAhmedBlog
4. Use the prefix “I” with Camel Casing for interfaces.
5. Use Meaningful, descriptive words to name variables. Do not use abbreviations.
6. Do not use single character variable names like i, n, s etc. Use names like index, temp.
One exception in this case would be variables used for iterations in loops.
7. Do not use underscores (_) for local variable names.
8. All member variables must be prefixed with underscore (_) so that they can be identified from other local variables.
9. Do not use variable names that resemble keywords.
10. Prefix boolean variables, properties and methods with “is” or similar prefixes.

Indentation and Spacing:
1. Use TAB for indentation. Do not use SPACES. Define the Tab size as 4.
2. Comments should be in the same level as the code (use the same level of indentation).
3. Curly braces should be in the same level as the code outside the braces.
4. Use one blank line to separate logical groups of code.
5. There should be one and only one single blank line between each method inside the class.
6. The curly braces should be on a separate line and not in the same line as if, for etc.
7. Use a single space before and after each operator and brackets.
8. Use #region to group related pieces of code together.
9. Keep private member variables, properties and methods in the top of the file and public members in the bottom.

Accessing control from another form in C#.NET

2009-12-09T13:01:00.006+07:00

Say you have two forms(Form_One and Form_Two) in your project. Suppose Form_One contains SplitContainer control. Now you want to use the SplitContainer control object into the Form_Two. How? The solution is as follows.

At first you have to declare the SplitContainer control object as public instead private in the Form_One.Designer.cs as bellow.

public System.Windows.Forms.SplitContainer splitContainer1;

Then you have to create Form_Two object and call Form_Two from Form_One class using the following code.

Form_Two frmTwo = new Form_Two(this);
frmTwo.Show();

Then you can get the SplitContainer control object in the Form_Two using the following code.

public partial class Form_Two : Form
{
public Form_Two()
{
InitializeComponent();
}
private void BtnSplitCtr _Click(object sender, EventArgs e)
{
splitContainer1.Panel2.Controls.Clear();
}
}

However, the above code is not enough. You have to modify the Form_Two class as bellow. Otherwise NullReferenceException(Object reference not set to an instance of an object) can be occurred. The modified code is given bellow.

public partial class Form_Two : Form
{
private Form_One frmOne;
public Form_Two(Form_One frm)
{
InitializeComponent();
frmOne = frm;
}
private void BtnSplitCtr _Click(object sender, EventArgs e)
{
frmOne.splitContainer1.Panel2.Controls.Clear();
}
}

That's it.

SQL Server database auto-backup done simply using windows scheduler

2009-12-07T16:09:00.004+07:00

To accomplish database backup automatically just go through the following steps. However at first store the following script with sql extension e.g autobackup.sql in a disk drive.

DECLARE @MyBackupName nvarchar(250)
SET @MyBackupName = 'C:\Backup\YourDB' + convert( varchar(10), getdate(), 112 ) + '.BAK'
BACKUP DATABASE [YourDB] TO DISK = @MyBackupName
WITH
NOFORMAT,
NOINIT,
NAME = N'[YourDB]-Full Database Backup',
SKIP,
STATS = 10

Step 1. Go to control panel menu as Start->Settings->Control Panel.
Step 2. Now open the ‘Scheduled Tasks’ for scheduling purpose.
Step 3. Double click ‘Add Schedule Task’ and then click ‘Next’.
Step 4. Now browse for ‘SQLCMD.EXE’ file. (It can be found where SQL Server has been installed.)
Step 5. When it is ok type a name for this task.
Step 6. Then select the time and day you want this task to start.
Step 7. When it is ok click ‘Next’ then you must enter admin password.
Step 8. Just click ‘Finish’.
Step 9.
SQL SERVER 2005 EXPRESS EDITION:
When finished properly you will see "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\SQLCMD.EXE" in the Run Text Box which is not sufficient at all. So replace "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\SQLCMD.EXE" with "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\SQLCMD.EXE" -SSALAHUDDIN\SQLEXPRESS -i"E:\autobackup.sql" in the Run Text Box.

SQL SERVER 2000 PERSONAL EDITION:
"C:\Program Files\Microsoft SQL Server\80\Tools\Binn\osql.exe" -SSALAHUDDIN -Usa -P123 -i"F:\autobackup.sql"

SALAHUDDIN is my server name. Your server name should simply replaces SALAHUDDIN.

Standard path format:[SQL Server 2005 Express and 2000 Personal Edition]
“SQLCMD.Exe path” –S[Server Name] –i[”autobackup.sql file path”]
“OSQL.Exe path” –S[Server Name] –Usa –P123 –i[”autobackup.sql file path”]

The path depends on as you have installed and stored SQL Server and autobackup.sql respectively.

Privacy Policy

2009-03-26T00:01:00.003+06:00

Privacy Policy for salahuddinahmed.blogspot.com

If you require any more information or have any questions about our privacy policy, please feel free to contact us by email at sumu2007@gmail.com.

At salahuddinahmed.blogspot.com, the privacy of our visitors is of extreme importance to us. This privacy policy document outlines the types of personal information is received and collected by salahuddinahmed.blogspot.com and how it is used.

Log Files
Like many other Web sites, salahuddinahmed.blogspot.com makes use of log files. The information inside the log files includes internet protocol ( IP ) addresses, type of browser, Internet Service Provider ( ISP ), date/time stamp, referring/exit pages, and number of clicks to analyze trends, administer the site, track user’s movement around the site, and gather demographic information. IP addresses, and other such information are not linked to any information that is personally identifiable.

Cookies and Web Beacons
salahuddinahmed.blogspot.com does use cookies to store information about visitors preferences, record user-specific information on which pages the user access or visit, customize Web page content based on visitors browser type or other information that the visitor sends via their browser.

DoubleClick DART Cookie
.:: Google, as a third party vendor, uses cookies to serve ads on salahuddinahmed.blogspot.com.
.:: Google's use of the DART cookie enables it to serve ads to users based on their visit to salahuddinahmed.blogspot.com and other sites on the Internet.
.:: Users may opt out of the use of the DART cookie by visiting the Google ad and content network privacy policy at the following URL - http://www.google.com/privacy_ads.html

Some of our advertising partners may use cookies and web beacons on our site. Our advertising partners include ....Google Adsense

These third-party ad servers or ad networks use technology to the advertisements and links that appear on salahuddinahmed.blogspot.com send directly to your browsers. They automatically receive your IP address when this occurs. Other technologies ( such as cookies, JavaScript, or Web Beacons ) may also be used by the third-party ad networks to measure the effectiveness of their advertisements and / or to personalize the advertising content that you see.

salahuddinahmed.blogspot.com has no access to or control over these cookies that are used by third-party advertisers.

You should consult the respective privacy policies of these third-party ad servers for more detailed information on their practices as well as for instructions about how to opt-out of certain practices. salahuddinahmed.blogspot.com's privacy policy does not apply to, and we cannot control the activities of, such other advertisers or web sites.

If you wish to disable cookies, you may do so through your individual browser options. More detailed information about cookie management with specific web browsers can be found at the browsers' respective websites.