DotNet Stuff

We have moved

2012-09-18T20:11:00.000-07:00

Hello Friends,

We have permanently moved to our new portal at Publish Article

Now and onwards we will update our new portal http://www.publisharticle.in

Thank you.

Enum Examples or How to Bind the DropDownList With Enum?

2012-02-24T23:31:00.000-08:00

Enum is the type provided by dotnet, it stores constant value in it. When we want to specify some constant value to use in the project then it is very usefull for readability.

In this post I will show you how to declare an enum and how to use it in the program.
Here I have bind the enum to the dropdown list

Declare the enum as below

public enum Days { Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday }

In aspx page I have added DropDownList named ddlDays as below

 <asp:DropDownList ID="ddlDays" runat="server">
        </asp:DropDownList>

Now below is the code to bind dropdownlist control with above enum

// Add first item to the drop down list to select lable
        ddlDays.Items.Add("--Select Days--");

        string[] enumNames = Enum.GetNames(typeof(Days));
        foreach (string item in enumNames)
        {
            int value = (int)Enum.Parse(typeof(Days), item);
            ListItem listItem = new ListItem(item, value.ToString());
            //Add one by one item to the drop down list
            ddlDays.Items.Add(listItem);
        }

Out put is displayed in the side image.

Supported languages by SyntaxHighlighter

2012-02-14T06:28:00.000-08:00

Syntax highlighter is a tool which will highlight the code in correct Syntax. When on your blog or web site you want to show some programming code then it is very useful.

In my next post I will show you how to add Syntax Highlighter in blogger or any webpage.

Below is the list of all the supported languages with their aliases.

Language	Aliases
C++	cpp, c, c++
C#	c#, c-sharp, csharp
CSS	css
Delphi	delphi, pascal
Java	java
Java Script	js, jscript, javascript
PHP	php
Python	py, python
Ruby	rb, ruby, rails, ror
Sql	sql
VB	vb, vb.net
XML/HTML	xml, html, xhtml, xslt

For more detail visit: http://code.google.com/p/syntaxhighlighter/wiki/Languages

Change cursor to hand on mouseover using jQuery

2012-02-12T04:57:00.000-08:00

When ever we need to change the mouse cursor using JQuery then we can do it very easily.

In my today's post I will show you how can we change the mouse cursor to the Hand type cursor while user hover mouse on the particular element.
It is very simple just look at the below JQuery code.

$(document).ready(function() {
  $("#elementid").hover(function() {
    $(this).css("cursor", "hand");
  });
});

In above code 'elementid' is the name of the element on which you want a mouse pointer as a hand while hovering a mouse over it.

Happy Coding...

SQL SERVER – 2005/2008 – User Defined Function to Strip HTML String Without Regular Expression

2012-01-07T21:53:00.000-08:00

Suppose sometimes we are saving HTML string into the database(SQL Server).
Now when we want to display some limited characters on the web page like first 200 char,
return string will not be proper HTML as it will leave some open HTML tag into it and hense it will not render HTML properely on the web page and also disturb our page html.
So to avoide this problem we can strip html from the sql server. I have written an SQL UDF for that as below.

Following UDF takes input as HTML and returns TEXT only.
If there is any single quotes in HTML then it must be replaced with two single quotes while passing to the function as a input.

Create Function [dbo].[StripHTML]
(@HTMLString VarChar(Max))
Returns Varchar(Max)
As
Begin
    Declare @StartChar Int
    Declare @EndChar Int
    Declare @Length Int
    Set @StartChar = CharIndex('<',@HTMLString)
    Set @EndChar = CharIndex('>',@HTMLString,CharIndex('<',@HTMLString))
    Set @Length = (@EndChar - @StartChar) + 1
    While @StartChar > 0 AND @EndChar > 0 AND @Length > 0
    Begin
        Set @HTMLString = Stuff(@HTMLString,@StartChar,@Length,'')
        Set @StartChar = CharIndex('<',@HTMLString)
        Set @EndChar = CharIndex('>',v,CharIndex('<',@HTMLString))
        Set @Length = (@EndChar - @StartChar) + 1
    End
    Return LTrim(RTrim(@HTMLString))
End
Go

Example:
Declare @HTMLString As VarChar(Max) = '<table class="tempwrapper"> '+
'<tr><td colspan="3">.NET that will convert a string so that it can be eg I would like to convert the string "a < b" '+
'to "a &#3C; b".</td> </tr> </table>'
Select SUBSTRING(@HTMLString,0,100)
Select SUBSTRING([dbo].[StripHTML](@HTMLString),0,100)
-> <table class="tempwrapper"> <tr><td colspan="3">.NET that will convert a string so that it can be e
-> .NET that will convert a string so that it can be eg I would like to convert the string "a &lt

Here I have attached a screen shot of the UDF at action.

Happy Programming :-)

Script All the Stored Procedures, Views, Triggers and Functions from The Database

2011-12-17T07:08:00.000-08:00

In my previous post I have show you how to generate database script using Wizard. In this article I will show you how to generate script for database object programmatically or using query

In SQL Server 2005/2008 Management studio you can script all the database object using ‘SQL Server Script Wizards’. But sometime we do not have the permission to generate a script using wizard then we are help less. But don’t worry now we have a solution for that as well. I will show you how to script all database objects programmatically.

To script All the Stored Procedures from the Database:

DECLARE @ScriptText As VARCHAR(MAX) = ''
DECLARE @AllScriptText As VARCHAR(MAX) = ''

DECLARE script_sp CURSOR FOR
SELECT SM.Definition
FROM SYS.SQL_Modules As SM INNER JOIN SYS.Objects As Obj
ON SM.Object_ID = Obj.Object_ID WHERE Obj.Type = 'P'
OPEN script_sp

FETCH NEXT FROM script_sp INTO @ScriptText

WHILE @@FETCH_STATUS = 0
BEGIN
--Set @AllScriptText = @AllScriptText + 'go' +@ScriptText;
Print @ScriptText;
FETCH NEXT FROM script_sp INTO @ScriptText
END
--Select @AllScriptText;
CLOSE script_sp
DEALLOCATE script_sp

But Remember if you have created all the procedure with encryption then you will get the null value.

Now suppose you want all the views as a script then use below query,

DECLARE @ScriptText As VARCHAR(MAX) = ''
DECLARE @AllScriptText As VARCHAR(MAX) = ''

DECLARE script_sp CURSOR FOR
SELECT SM.Definition
FROM SYS.SQL_Modules As SM INNER JOIN SYS.Objects As Obj
ON SM.Object_ID = Obj.Object_ID WHERE Obj.Type = 'V'
OPEN script_sp

FETCH NEXT FROM script_sp INTO @ScriptText

WHILE @@FETCH_STATUS = 0
BEGIN
--Set @AllScriptText = @AllScriptText + 'go' +@ScriptText;
Print @ScriptText;
FETCH NEXT FROM script_sp INTO @ScriptText
END
--Select @AllScriptText;
CLOSE script_sp
DEALLOCATE script_sp

Now suppose you want all the functions as a script then use below query,

DECLARE @ScriptText As VARCHAR(MAX) = ''
DECLARE @AllScriptText As VARCHAR(MAX) = ''

DECLARE script_sp CURSOR FOR
SELECT SM.Definition
FROM SYS.SQL_Modules As SM INNER JOIN SYS.Objects As Obj
ON SM.Object_ID = Obj.Object_ID WHERE Obj.Type = 'FN'
OPEN script_sp

FETCH NEXT FROM script_sp INTO @ScriptText

WHILE @@FETCH_STATUS = 0
BEGIN
--Set @AllScriptText = @AllScriptText + 'go' +@ScriptText;
Print @ScriptText;
FETCH NEXT FROM script_sp INTO @ScriptText
END
--Select @AllScriptText;
CLOSE script_sp
DEALLOCATE script_sp

If you need to generate a script for all the triggers from the database then we have to make little bit changes in query. We will join sys.triggers table in place of sys.objects as below.

DECLARE @ScriptText As VARCHAR(MAX) = ''
DECLARE @AllScriptText As VARCHAR(MAX) = ''

DECLARE script_sp CURSOR FOR
SELECT SM.Definition
FROM SYS.SQL_Modules As SM INNER JOIN SYS.triggers As Obj
ON SM.Object_ID = Obj.Object_ID
OPEN script_sp

FETCH NEXT FROM script_sp INTO @ScriptText

WHILE @@FETCH_STATUS = 0
BEGIN
--Set @AllScriptText = @AllScriptText + 'go' +@ScriptText;
Print @ScriptText;
FETCH NEXT FROM script_sp INTO @ScriptText
END
--Select @AllScriptText;
CLOSE script_sp
DEALLOCATE script_sp

Happy Scripting…….

SQL Server – 2008 – Generate Script of Database, Generate script to copy whole database schemas and All other object in database, like Tables with data, SPs, Views, Triggers, Functions, Database constraints etc.

2011-11-26T03:45:00.000-08:00

Check how to create a script using T-SQL

While we are working on any project and uses SQL Server as a database, we often need to copy database schema either with data or without data to create database on other server. So it inspires me to write down the blog post about ‘how to generate SQL script using SQL Server Management Studio’

Here I will explain step by step process with screen shot that how we can copy database schema with all the database objects.

First of all open SQL Server Management Studio and expand databases node like below images step 1.

Step 1

Now select the database for which you want to generate SQL Script as like below image Step 2. Here I have selected pubsdatabase for demo. Right click on selected database, click on Tasks option and then click Generate Scripts... I have marked option with red circle in image.

Step 2

Once you click on Generate Scripts option from above image it will show up the below image step 3

Just click on the next button from below image step 3

Step 3

Now in below image you can see the list of all the available databases, by default on which database you have right clicked it is selected but you can change here if you want to generate script for other database. In Step 4 image there is one check box labelled with ‘Script all objects in the selected database’. Check this check box if you want to generate script for all the objects from database, if you will not check this check box it will ask on next step for database object selection.

Step 4

After selecting the database and checking check box it will show up the below image step 5.

Here you can select what you want to include in script, like script table with data or without data, you want to add script like if exist then drop the object first then create it etc. For scripting table with all the data select true in script data option as I have selected in below image. Then click on next button.

Step 5

Now this step 6 has some output file type and file location related options. I have selected 3^rd radio button in below image for generating a script in New Query Window but if you don’t want to generate script in new query window and want to generate script into clipboard then select 2^nd radio button labelled with Script to Clipboard. If you want to generate script in a file then select 1^st radio button Script to file, once you select this option it will ask file name and directory to save the file on hard drive.

I have marked files to generate option as a 3 and then 3.1 and 3.2 in the red colour. If you want to generate whole script in one single file then select single file (3.1), by default it is selected. If you want to generate different file per object then select 3.2 option. If you select 3.2 option and suppose you have 10 tables in database then it will generate 10 different SQL file.

Step 6

Step 7 below image is just a summary page, showing all the options you have selected till step. Just click on the finish button to proceed.

Step 7

Step 8 showing the progress for generating database script

Step 8

Step 9 showing the successfully completion of script generation process.

Step 9

Step 10 shows that all database object has been scripted in new query window for pubs database. Now your script is ready...

Step 10

Please let me know if you have any question on this script generation wizard.

Error: A network-related or instance-specific error occurred while establishing a connection to SQL Server.

2011-11-20T00:43:00.001-08:00

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

This is the common error for sql server while establish connection from visual studio to sql server.

If you encounter this error, while establishing connection from visual studio to to sql server, than first things to check in web.config file that have you set sql server instance name properly and correct?

You can encounter above error if you have

Change your PC name or sql instance name
or you have installed new isntance of sql server.

EG. Currently your PC name is 'PCName', and sql instance name is 'SQLServer'
Now you are changing your computer name from 'PCName' to 'MyPC' or sql server instance name from 'SQLServer' to 'MySQLServer' then you must change connection string
in your web.config file like below sample connection string

Old Connection String:
Data Source=PCName\SQLServer;Initial Catalog=SampleDBName;Integrated Security=True

New Connection String:
Data Source=MyPC\MySQLServer;Initial Catalog=SampleDBName;Integrated Security=True

Solution:
First check your sql server instance name after opening sql server management studio, then check connection string in your vs.net solutions,
then compare both instance name if both instance name are not same then please make both name same and save changes you made in web.config file and run the project

How to display Image in Repeater Control from folder?

2011-10-19T10:45:00.000-07:00

Download full project

Recently I was working on a project where I needed to dispaly an images into Repeater control from Folder. So I thought let me create a blog post for that and share it with my reader.
It is very simple to display an image into repeater control from folder just like below.
In this project I have used one file upload control from where we are uploading images to one specific folder and then display all the uploaded images to the repeater control using an array.

Here is html code for .aspx page

 
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Untitled Page</title>
    <style type="text/css">
    #lblErrorMessage{color:#FF0000;}
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:Label ID="lblErrorMessage" runat="server" EnableViewState="false"></asp:Label>
        <asp:FileUpload ID="fuUpload" runat="server" />
        <br />
        <asp:Button ID="btnFileUpload" runat="server" Text="Upload File" 
            onclick="btnFileUpload_Click" />
    </div>
    <div>
        <asp:Repeater ID="rptImage" runat="server" Visible = "true">
            <ItemTemplate >
                    <img ID="imgLeft" runat="server" src='<%# Container.DataItem %>' alt='' style="height:100px;width:100px;" />
            </ItemTemplate>
        </asp:Repeater>
    </div>   
    </form>
</body>
</html>

Here code sample is explained in small peices.

    Page Load Event
    In page load event just calling a bindImages which will find all the images from folder and then bind it to the Repeater.

    string folderPath = "images/";
    protected void Page_Load(object sender, EventArgs e)
    {
        BindImages(folderPath);
    }

//bindImages Function
In below function we are getting all the images to the string array then loop through it and get the file name from whole path and concat it with folder path and again assign it to array element. Once all the image path changed then bind an file path array to the Repeater.

 public void BindImages(string folderPath)
    {
        //get all the files from flder
        string[] strImgs = System.IO.Directory.GetFiles(Server.MapPath(folderPath));
        //Loop through all the file and get only file name and concat it with folder name
        for (int count = 0; count < strImgs.Length; count++)
        {
            string filePath = strImgs[count];
            filePath = filePath.Substring(filePath.LastIndexOf('\\')+1);
            string newFilePath = folderPath + filePath;
            strImgs[count] = newFilePath;
        }
        // Bind an image file name to repeater.
        rptImage.DataSource = strImgs;
        rptImage.DataBind();
    }

When save button clicked then this code will check that file is selected or not, based upon file selected it will take an action.

//Before procceding check that user has select file

 
        if (fuUpload.HasFile)
        {
            //Call save File method
            SaveUploadedFile(fuUpload.PostedFile);
            BindImages(folderPath);
        }
        else
        {
            // Notify user that file is not selected
            lblErrorMessage.Text = "Please select a file to upload.";
        }

        Code for SaveUploadedFile function
below code will create a folder path to save image to the disk then check that the file name is exist in target folder if yes then it will contact counter number at begining of the file name and again check for duplicate file name, once file name found then it will save image with that file name on the disk.

    void SaveUploadedFile(HttpPostedFile file)
    {
        // Secify the path to save file.

        string savePath = Server.MapPath("Images/");
        // Get the name of the file to upload.
        string fileName = fuUpload.FileName;

        string pathToCheck = savePath + fileName;
        string tempfileName = "";
        // Check at target that file is exist with same name then change filename while saving
        if (System.IO.File.Exists(pathToCheck))
        {
            int counter = 1;
            while (System.IO.File.Exists(pathToCheck))
            {
                tempfileName = counter.ToString() + fileName;
                pathToCheck = savePath + tempfileName;
                counter++;
            }
            fileName = tempfileName;
        }
        else
        {
            lblErrorMessage.Text = "Your file was uploaded successfully.";
        }
        savePath += fileName.Replace(" ","");
        //save uploaded file to disk
        fuUpload.SaveAs(savePath);

Here I have uploaded full project code for the reference. You can download it from the top

Output:

How to make Firefox the default browser?

2011-06-28T06:01:00.000-07:00

If you have more then one browser like IE, FF, Safari or Chrome then windows or any other operating system needs to know which browser to use by default?

This article will show you the step how to set firefox as default browser.

From the menu bar select on Tools → Options and it will open following screen

Figure 1

As per above figure select advance option from options then go to General tab.

In the system defaults panel there is a button with captions Check Now Just click it and it will ask for the confirmation, click on OK button and you are done. You can see confirmation dialog box like Figure 2

Figure 2.

Note: MSN Messenger and other applications may open Internet Explorer regardless of which browser is the default. Also, Internet service providers like PeoplePC Online, Juno and NetZero may provide connection software that automatically launches Internet Explorer.

Table and Stored Procedure helptext using Keyboard - SQL Server Keyboard Shortcut

2011-06-07T10:56:00.000-07:00

In the world of programming keyboard shortcuts are very useful for fast developing either in SQL server, DotNet or any programming language or any database.

In my project I always use SQL Server for backend and for editing or viewing SP or Database Table structure I used right click on Database object and then select either design as Figure 1 or modify as Figure 2 option. But it’s little bit lengthy procedure for getting a result.

Figure 1

Figure 2

So I was searching for shortcuts using that we can easily get the desire result and I found that.

How to do that for Table?

In my Sample Database there is one table Customer_Orders. Just drag that table to query window or copy the name of table and paste it to query window. Then select it and just press Alt+F1 it’s default from Management Studio and it will show each and every details in result area like Figure 3.

Figure 3

How to do that for Sps?

In my Sample Database there is one Sp getAllOrders. Just drag that sp to query window or copy the name of sp and paste it to query window. Append sp_helptext at the beginning of the sp name with space and select all and press F5 key and it will show the result in below pane.

Still it’s required 2 to 3 actions so set some default key for sp_helptext command using below steps.

Step 1 Go to Toolsà Options menu like Figure 4

Figure 4

In Figure 4 from left panel select keyboard option and from right side Ctrl+F1 has empty table cell. Add sp_helptext command there and press ok. Here you can set some keyboard shortcuts if you want like Ctrl+F2, Ctrl + F3 and more

Now open new query window drag sp name on query window and select it and press Ctrl+F1 and you can see result like Figure 5.

Figure 5

Figure 6

Above Figure 5 and Figure 6 both are same but still there is a little and important difference so let me take an opportunity to explain that difference. In Figure 5 the result is displaying in grid and in Figure 6 result is displaying as a plain text. If you check at the top then there is tooltip in yellow strip with text Results to Grid and Results to Text. Both options are at the top of the query window. If you see the result in grid view then you will loose the formation of the sp like indentation, spacing, beautify etc. But if you view result in plain text format then it will preserve all the format when you have created or modified sp.

How to Exclude your Own Visits From Blogger Stats?

2011-05-06T22:26:00.000-07:00

When we are developing any blog or website then normally we want to watch the traffic on our site or blog. There are lots of traffic source tracker sites and tools are available on the net, but I found 2 more effective tools where we can check our traffic stat very easily. 1 is Google Analytic and second one is Blog Stat which is recently launched in blogger platform.

Blogger stats is excellent way to track world wide traffic on you blogger blog. It is now built in facility by http://blogger.com and very much similar to Google Analytic and it will be similar because both are from Google only.

Benefit of Blogger stat
Main benefit of blogger stat is you do not need to add any external code to track your traffic source like hitstat, google analytics, sitemeter etc.

In Google analytic is was easy to exclude your own visits but how to exclude your own visit from blogger stat?

So here the step by step guide to exclude your own visit from blogger stat.

First go to http://www.blogger.com and login there.

From dash board might you have more then 1 blog so find your blog where you want to exclude your stat and click on stat tab on that blog details like below figure 1

Figure 1

Now in overview section(tab) on stat tab there is page view details at right side like pageview today etc under that widget you can see don't track own visit link, see below figure 2

Figure 2

now once you click on that link don't track own visit it will open on small popup with 2 radio button.
Track my pageview and
Don't track my pageview

select second option don's track my page view and click on save button like below figure and you are done. Now blogger will exclude you own visit from traffic source details.

How to Prevent or disable copy content of your blog/site

2011-05-05T03:37:00.000-07:00

If you want that visitor will not be able to copy your content from web page then it's easy using JavaScript.

It's not full proof way there are other alternate they can copy but it will not be easy way for them to copy content by just selecting required content, right click and click on copy.

Just add following JavaScript code to your blog templates and it will be secure that other user will not be able to copy content easily.

Just go to Blogger Dashboard.

Click on Design Tab –> then click on Page element.

Now you can see add a gadget link many places. Just click any one of them and select HTML and Javascript widget and paste following code to opened dialog box.

Then save the templates and check it. If it's working fine then you are done else you have made some mistake, to correct it repeat the process.

Enjoy the post. If you like my post then either left a comment or do subscribe my rss in you favourite rss feed reader to get latest update from me.

Generating a random number in JavaScript

2011-05-01T06:29:00.000-07:00

Today I was working in a DayPilot project it was something like Google or outlook calender. In that project when I was creating or editing event, it was using java script popup. But it was showing old value rather than new or updated value when popup open. This was happening due to JavaScript because it was running from cache.

How to fill new or updated value in control it was a big concern? So what I had done is just create one random number and append it at the end of URL so every time new http request will be different in browser and it will not run from cache.

So now how to generate a random number?

Lets begin by looking back. As discussed in this post to generate a random number in JavaScript, the code:

var randomnumber=Math.random();

Math.random(x) :

This is the function which will return next random number between 0.0 to 0.999999 so this will generate decimal number every time. If we require integer number then we can convert it using either round or floor function.

Math.round(x)

The round() method rounds a number to the nearest integer.

Math.floor(x)

The floor() method rounds a number DOWNWARDS to the nearest integer, and returns the result.

So finally we can use it as like this

randomnumber = Math.floor(Math.random());

randomnumber = Math.round(Math.random());

it will return value between 0 to 9

The New Google Analytics Available to Everyone

2011-04-27T22:29:00.000-07:00

The New Google Analytics Available to Everyone

Hey Google has recently launched the newer version of the Google Analytic to track the site or blog traffic.

I am very happy after seeing the newer version of Google Analytics and Google has announced that it is in beta stage and available to every user in all the languages.

New look of the Dashboard

How to check newer version of the Google Analytics

Sign in to your Google Analytic and see the link at top right of your account

Check below screen shot for more details.

New version of Google Analytic has some enhancements as below.

A redesigned Google Analytics platform to enable major new functionality
A streamlined interface to make it easier to get to the information you want
Improved report performance for faster reports

Currently, we are showcasing the following features in the new version of Analytics:

A completely redesigned, faster interface.
Multiple dashboards—build a custom dashboard for each department.
Event Goals! Track your PDF downloads as goals with events, or configure 2 minutes play time on a video as a goal.
More powerful custom reports—you can pre-filter reports and build additional data views.
New Term Cloud visualization.

Some features will be introduce in Google Analytic very soon as below

Exporting reports to PDF
Emailing reports
Migrating a custom report from the current Analytics version to the new version
Linking a new AdWords or AdSense account
In-Page Analytics

For more details please go to here

Some screen shot from new analytic

List of All Built-In / System SQL Server Stored Procedures

2011-04-24T05:04:00.000-07:00

Hey today I was searching for some system procedures to get system data and I found that on MSDN there is a list of all the native/system procedures with explanation.

It took some time for me to get the exact stored procedure what I was searching for so I thought it will help others as well so I am giving you a link of that MSDN page...

List of All Built-In / System SQL Server Stored Procedures

but remember that some times on MSDN link will change (Broken link). So might be when you read this it's broken if it is so just let me know my providing comment at the bottom of the post.

Thanks.

Disable Back Button in Browser using JavaScript

2011-04-14T03:20:00.000-07:00

While we are developing any web application then some times it's necessary to disable the back button effect from the browser. This is common in banking websites and other sites where security is major concern. User may hit the back button from the browser and forget to log out from the site.

There fore it's required to disable browser's back button.

So here is the code which will prevent user to go back on previous page.

<title>New event</title>

</head>

window.history.forward();

function noBack() { window.history.forward(); }

</SCRIPT>

</HEAD>

<BODY onload="noBack();"

onpageshow="if (event.persisted) noBack();" onunload="">

</body>

</html>

Code for Page 1.

<title>New event</title>

</head>

</HEAD>

<BODY>

Page 2

</body>

</html>

Code for page 2.

Here I have given 2 pages page 1 and page 2. From page 1 I am going to page 2 using page 2 link. Now if I will click on page 2's browser back button it will go to page 1 but from page 1 it will again forward to page 2 so user can't go to the page 1 using back button.

Note : Above code is tested in IE 9.0 and Firefox 3.6.8

Concatenation in SQL, Using For XML PATH(), Concatenate more than one rows in one field

2011-04-08T01:29:00.000-07:00

Some times it is required to concatenate more no of rows into one single filed separated by commas. There are some options for that like we can write our own UDF for that, in sql server built in COALESCE function is there with this function we can achieve it. But some time need is different or we want to achieve it in different way then there is another option that I am going to explain using FOR XML PATH().

Let me first show me my table design

and also show me the data which I have inserted for this testing purpose

Have you tried to access data in xml format from sql table, not yet ? Then try below query and see the result.

SELECT Employee_Name FROM Emp_Tech FOR XML path('')

When you run above query then you can see result like <Employee Name>Tarun</Employee Name>.... conti... and when you click on the resulted row then it will open .xml file in query window. But here we are understanding how to merge that all the rows into single row with comma separated so let me write a query for that.

SELECT

DISTINCT

Employee_tech,employee_name =

substring( (SELECT

',' + Employee_Name

FROM

Emp_Tech et2

Where

et2.Employee_Tech = et1.Employee_Tech

FOR XML PATH(''), ELEMENTS

),2,500)

FROM

Emp_Tech et1

And this is the out put for that query

Out put

List all the table in given database

2011-04-06T02:48:00.000-07:00

Think that you have a database more than 1-2 hundred database tables and you want to get list of all the tables in particular database. I was working on a project with more than 356 table and required to get the list of all the table with column names, column types and length of data type so first I searched for list of table finding query and it give me different different result.

Then I thought let me write a quick post about all the available query which can list all the tables from specific database.

For a demo purpose I have created only 2 tables in one database and write a query for quick result and better image

Let's check one by one.

SELECT * FROM information_schema.tables

Above query will return the data from information_schema table. It has only tables related info.

look at the result with below screen shot

SELECT * FROM sysobjects WHERE xtype='U'

Above query will retrieve result from system object table which have all the information related to database like Primary Key, Stored Procedure, User table etc....

look at the result with below screen shot

SELECT * FROM Sys.Tables

Above query get the result along with object_id which will be very useful for join if you want to get column names etc. This object id will be tied with other table.

look at the result with below screen shot

exec sp_msforeachtable 'print ''?'''

Above query is little bit different than all other options. It will simply prints table name on the screen rather than returning a result in table.

look at the result with below screen shot

How to use Rank( ), Dense_Rank( ) and Row_Number( ) function

2011-04-02T13:54:00.000-07:00

Understanding Row Number Function

Here we will see the Row_Number(), Rank() and Dense_Rank()
function with details and example

Look at the Figure 1 which has some data and in next
figure 2 we are going to explain about the use of above mentioned function.

Above figure has query and result we can see that there are 14
rows with column jobid, job_disc, minimum value and maximum
value.

Now see figure 2

Using ROW_NUMBER() Function

In figure 2 we can see the result of ROW_NUMBER() function, it just a sequential order starts from 1 to the number of rows returns within a result set.

Using RANK() Function

In figure 2 we can see the result of RANK() function, If result of two or more rows are same then it will give same rank and put a gap of repeated no of rows in next sequential number for next row. As we can see in figure 2 for row number 2,3 and 4 has same rank as 2, and for row number 5 it direct assign rank 5 and eliminate rank 3 and 4 because it's repeated in previous row.

Using DENSE_RANK() Function

In figure 2 we can see the result of DENSE_RANK() function, if result of two or more rows are same then it will assign same rank but for the next rank of next row it will not put any gap and assign continuous number to the next rank of next row. Like above example it will not eliminate rank 3 and 4. It will assign rank 3 for row number 5th.

Enjoy Reading ..........

Find All The Database Name in SQL SERVER

2011-04-01T21:27:00.000-07:00

Get all the available database in SQL Server, using following command.

Following all the command will list all the database on SQL Server.

--In SQL Server 2008

--This is the Stored Procedure which will retrieve database name and size in kb and remark

Exec sp_databases

This stored procedure will retrieve more column then previous sp and return size in mb rather than kb.
And owner of db, created date, and status of the database like status, updatability, useraccessibility etc.

Exec sp_helpdb

and finally below 2 sps will retrieve detailed information about the database mostly in technical terms.

Technically terms in the sense dbid,status, file path etc.

Select * From sys.databases

Select * From sys.sysdatabases

A new way to communicate -- April fool by google 2011

2011-04-01T01:30:00.000-07:00

The mouse and keyboard were invented before the Internet even existed. Since then, countless technological advancements have allowed for much more efficient human computer interaction. Why then do we continue to use outdated technology? Introducing Gmail Motion -- now you can control Gmail with your body.

See here https://mail.google.com/mail/help/motion.html

How To Generate Rich Text Box using Javascript

2011-03-31T03:15:00.000-07:00

Screenshot for Editor

Rich Text entered into RTB

HTML in RTB

Download project

Introduction

If you are developing any site and in you site some section need user input in Richtext format then you can't use textarea because it's limitation is there. In market there are lots of control available freely and paid as well. But have you think ever how to develop our own text editor, so we can customize as per our choice, need. There is not Dll limitation.

Today I will show you how to develop your Richtext Box using Javascript and HTML with CSS.

I will not develop complete Richtext box here, but some basic of the Richtext Box and left remaining things for your exercise.

Add one HTML page to your project.

Then in head section add below style for DropDown list

.select

{

background-color:#CCCCCC;

border-width:1px;

font-family:Calibri,Verdana, Tahoma;

margin:0;

font-size:10px;

}

</style>

Add this line too in head section

This is the file which encode and decode HTML tag to toggle between Design mode and HTML mode.

Add below code also inside head tag

function Set()

{

getIFrameDocument("textEditor").designMode = "On";

getIFrameDocument("textEditor").focus();

}

function getIFrameDocument(editor)

{

// If Fire fox Mozilla

if (document.getElementById(editor).contentDocument)

{

return document.getElementById(editor).contentDocument;

}

// If Internet Explorer

else

{

// IE

return document.frames[editor].document;

}

</script>

// Set function to set the design mode on and focus as well. This function will get call once page loaded successfully.

// getIFrameDocument function will be used to check it's an IE or Fire Fox.

This is the another Javascript code snippets which will be used to edit the document text as per our command

add it to the head tag

var isDesignMode = true;

function fontEdit(command, y)

{

switch (command)

{

case 'bold':

if (document.getElementById('bold').src.toString().indexOf("over") != -1)

{

document.getElementById('bold').src = "images/bold.gif";

}

else

{

document.getElementById('bold').src = "images/bold.over.gif";

}

break;

case 'italic':

if (document.getElementById('italic').src.toString().indexOf('over') != -1)

document.getElementById('italic').src = 'images/italic.gif';

else

document.getElementById('italic').src = 'images/italic.over.gif';

break;

case 'underline':

if (document.getElementById('underline').src.toString().indexOf('over') != -1)

document.getElementById('underline').src = 'images/underline.gif';

else

document.getElementById('underline').src = 'images/underline.over.gif';

break;

case 'justifyleft':

if (document.getElementById('justifyleft').src.toString().indexOf('over') != -1)

document.getElementById('justifyleft').src = 'images/justifyleft.gif';

else

document.getElementById('justifyleft').src = 'images/justifyleft.over.gif';

break;

case 'justifycenter':

if (document.getElementById('justifycenter').src.toString().indexOf('over') != -1)

document.getElementById('justifycenter').src = 'images/justifycenter.gif';

else

document.getElementById('justifycenter').src = 'images/justifycenter.over.gif';

break;

case 'justifyright':

if (document.getElementById('justifyright').src.toString().indexOf('over') != -1)

document.getElementById('justifyright').src = 'images/justifyright.gif';

else

document.getElementById('justifyright').src = 'images/justifyright.over.gif';

break;

case 'insertorderedlist':

if (document.getElementById('insertorderedlist').src.toString().indexOf('over') != -1)

document.getElementById('insertorderedlist').src = 'images/numberedlist.gif';

else

document.getElementById('insertorderedlist').src = 'images/numberedlist.over.gif';

break;

case 'insertunorderedlist':

if (document.getElementById('insertunorderedlist').src.toString().indexOf('over') != -1)

document.getElementById('insertunorderedlist').src = 'images/bulletedlist.gif';

else

document.getElementById('insertunorderedlist').src = 'images/bulletedlist.over.gif';

break;

case 'outdent':

if (document.getElementById('outdent').src.toString().indexOf('over') != -1)

document.getElementById('outdent').src = 'images/outdent.gif';

else

document.getElementById('outdent').src = 'images/outdent.over.gif';

break;

case 'indent':

if (document.getElementById('indent').src.toString().indexOf('over') != -1)

document.getElementById('indent').src = 'images/indent.gif';

else

document.getElementById('indent').src = 'images/indent.over.gif';

break;

case 'default':

break;

}

getIFrameDocument("textEditor").execCommand(command, "", y);

textEditor.focus();

}

function ChangeMode()

{

if (isDesignMode == true)

{

isDesignMode = false;

document.getElementById('mode').src = 'images/mode.html.gif';

document.getElementById('mode').title = 'HTML View';

Encoder.EncodeType = "entity";

var encoded = Encoder.htmlEncode(getIFrameDocument("textEditor").body.innerHTML);

getIFrameDocument("textEditor").body.innerHTML = encoded;

}

else

{

isDesignMode = true;

document.getElementById('mode').src = 'images/mode.design.gif';

document.getElementById('mode').title = 'Design View';

var decoded = Encoder.htmlDecode(getIFrameDocument("textEditor").body.innerHTML);

getIFrameDocument("textEditor").body.innerHTML = decoded;

}

</script>

Now javascript is over and we will add HTML code to the page.

Before that we will code Set function on page load event

like this

And code is as below.

</a>

</a>

</a>

</a>

</a>

</a>

</a>

</a>

</a>

</a>

</a>

</div>

<option value="Arial">Arial</option>

<option value="Courier New">Courier New</option>

<option value="Monotype Corsiva">Monotype</option>

<option value="Tahoma">Tahoma</option>

<option value="Times">Times</option>

</select>

</select>

<option value="color">Color</option>

<option style="color: black;" value="black">Black</option>

<option style="color: blue;" value="blue">Bblue</option>

<option style="color: green;" value="green">Green</option>

</select>

</div>

</iframe>

That's it, and we are done.

Just run the html page and you can see a nice Rich Text Box.

This code is tested in IE 8.0, Fire Fox 3.6.8 and Google Chrome 10.0.648.204.

There are some toolbar image quality issues that you can fix at your end.

So start improving Rich Text Box Editor and share it with our community over here.

Count Down Timer Using JavaScript.

2011-03-27T00:20:00.000-07:00

Download Sample Timer

Sometimes we have seen on some site that they are showing countdown timer for some particular event. Main purpose of countdown timer is to calculate reaming time for that event in reverse direction.

It will mostly display in Days-Hours-Minutes and Seconds

We can change this format and also look and feel for countdown timer.

I have created one small countdown timer using JavaScript language just go through and let me know if you need more clarification on it.

Screen shot of Timer

After 40 seconds it will show like below figure.

Here is the code and it's explanation

<html>

.head{font-weight:bold;font-size:25px;color:#00f;}

.text{font-weight:normal;font-size:20px;color:#222222;}

</style>

<body>

<!--

// Assign future date here in format of

dateFuture = new Date(2011,4,4,12,0,0);//Year-Month-Day-Hour-Minute-Seconds. Month starts from zero, 0 for jan and 11 for dec

function GetCount(){

dateNow = new Date();//grab current date

amount = dateFuture.getTime() - dateNow.getTime();//calc milliseconds between dates

delete dateNow;

// time is already past

if(amount < 0){

document.getElementById('countbox').innerHTML="Now!";

}

// date is still good

else{

days=0;hours=0;mins=0;secs=0;out="";

amount = Math.floor(amount/1000);//kill the "milliseconds" so just secs

days=Math.floor(amount/86400);//days

amount=amount%86400;

hours=Math.floor(amount/3600);//hours

amount=amount%3600;

mins=Math.floor(amount/60);//minutes

amount=amount%60;

secs=Math.floor(amount);//seconds

if (days != 0)

{

out += "<span class='head'>"+days + "</span> <span class='text'>day" + ((days != 1) ? "s" : "") + ",</span> ";

}

if (days != 0 || hours != 0)

{

out += "<span class='head'>"+hours + "</span> <span class='text'>hour" + ((hours != 1) ? "s" : "") + ", </span>";

}

if (days != 0 || hours != 0 || mins != 0)

{

out += "<span class='head'>"+mins + "</span> <span class='text'>minute" + ((mins != 1) ? "s" : "") + ", </span>";

}

out += "<span class='head'>"+secs +"</span> <span class='text'>seconds</span>";

document.getElementById('countbox').innerHTML=out;

//This function will call every one second, it's second param is milisecond

setTimeout("GetCount()", 1000);

}

window.onload=function(){GetCount();}//call when everything has loaded

//-->

</script>

</body>

</html>

This is the output of above code

Add Cross Tab Report in Crystal Reports Tutorials Part-5

2011-03-05T05:11:00.000-08:00

This post is permanently moved at below URL

http://publisharticle.in/KB/CBCE292653D34/Add-Cross-Tab-Report-in-Crystal-Reports-Tutorials-Part-5