saAction

Creating jQuery menu with Animated background effect.

2011-01-26T14:22:00.001Z

This is 26January2011, Republic day of India.

I was try to apply some new style in Menu style, I found that many web sites are using smooth animated background in menu. So I study it and found the logic behind the code.

Let understand here…

Here when user will mouse over to second menu, gray background will come over on second menu from the first one, with sooth scroll effect.

Here is its trick,

 <ul id="mnu">

            <li><a href="#">saAction</a></li>

            <li><a href="#">Web Technologies</a></li>

            <li><a href="#">jQuery</a></li>

            <li><a href="#">Visual Studio</a></li>

            <li><a href="#">C#</a></li>

            <li style="width: 100px; height: 60px; top: -5px;" id="mnuEffect">

            </li>

        </ul>

There will be an extra LI tag after all menu and it will animate its left position. and its height will be little bit bigger then other menu has.

and after it there will be a function to animate the position to the selected LI tag:

$('li:not(#mnuEffect)').mouseover(function () {

$('#mnuEffect').stop().animate({

  left: $(this).position().left,

  width: $(this).width()

  }, 'slow');

});

This is very simple trick, So here I created function to apply this effect to any kind of menu, and here we can apply any CSS effect for good GUI, you can download source for animated background menu from here:

Happy Programming, जय-हिंद!

SQL Server Database Publishing Wizard

2011-01-25T14:34:00.001Z

Data Transfer is one kind of headache for some time in various hosting environment, SQL Server Database Publishing Wizard enables the deployment of SQL Server databases into different hosting environment or in development server to production server on either a SQL Server 2000, 2005 server.

It generates a all required fields SQL script in a single file which can be used to recreate a database there are three best option to generate script.

Schema Only
Data Only
Schema And Data

This wizard can also directly upload databases to servers located at the shared hosting provider, but I would like to upload by generating script, It also helps as backup file of database.

You can start this wizard from SQL Server Folder:

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

Now, using with Visual Studio 2010, we can directly start Publishing Wizard from Server Explorer:

Just right click on database name and your will get “Publish to Provider…” menu.

So, have a nice stuff in Visual Studio 2010 Ultimate

Tab Control in one line of jQuery

2011-01-24T13:43:00.001Z

How to create a Tab Control, people ask me this question so many times. So finally I have decided to post its simple solution here. This is very easy task. Lets understand.

We need tabs Title in <UL>, <LI> title. something like below:

<!--This is Tab Control UL-->

<ul class="tab">

    <li>Tab1</li>

    <li>Tab2</li>

    <li>Tab3</li>

</ul>

<!--this is Tab Content UL, we have to strore data here-->

<ul class="tabContent">

    <li style="display: block;">This text for Tab 1,

        <br />111 111 111</li>

    <li>This text for Tab 2,

        <br />222 222 222</li>

    <li>This text for Tab 3,

        <br />333 333 333</li>

</ul>

Now add Below CSS: to give proper alignment.

<style type="text/css">

    .tab

        position: relative;

    .tab li

        list-style: none;

        float: left;

        border: solid 1px blue;

        padding: 10px;

        cursor: pointer;

    .tab li:hover

        background-color: #c5c5c5;

    .tabContent

        position: relative;

        clear: both;

        float: none;

    .tabContent li

        list-style: none;

        position: absolute;

        height: 100px;

        width: 300px;

        display: none;

        border: solid 1px blue;

</style>

Now it will look properly as TAB control, but still we need to add jQuery to give activate the TAB controls.

<script language="javascript" type="text/javascript">

        $(document).ready(function () {

            $('.tab li').click(function () {

                ///Hide Old content

                $('.tabContent li').fadeOut();

                ///Show related content

                $('.tabContent li:eq(' + $('li', $(this).parent()).index(this) + ')').fadeIn();

});

});

    </script>

that’s all, Tab control has been started to work.

Downlod testing Tab Control here:

How to use @font-face in CSS3?

2011-01-21T10:53:00.001Z

I have already posted before about sIFR technology but now its time to use CSS3. No more requirement for SIFR.

Now in web technology CSS3 is a have many exciting new functions and features available.
And almost @font-face font comes with :

TrueType Fonts for Firefox 3.5+ , Opera 10+, Safari 3.1+, Chrome 4.0.249.4+
EOT (OpenType) fonts for Internet Explorer 4+
WOFF (Web Open Font Format) fonts for Firefox 3.6+, Internet Explorer 9+, Chrome 5+

@font-face is able to download Font typography in client's browser from the server its "Web Embedding Fonts". and its extance will be EOT that means OpenType for Internet Explorer's embedded font support. All other browser support embedded font via "TTF" TrueType file format.

Here is the syntax to embedded font in CSS3

@font-face
{
/*Give a tempeorary Name*/
font-family: "MyFontName";

/* Below line is for IE Only */
src: url( /location_of_font_Folder/FontFileName.eot );

/* Below line is for other browser (non-IE) */
src: local("Correct Font Name in Real File"), url( /location_of_font_Folder/FontFileName.ttf ) format("truetype");
}
/* Now we can us that Font name jsut linke any other font name */
.customTitle { font-family:"MyFontName", verdana, helvetica, sans-serif; }

And in HTML it will same as existing code…

<p class="customTitle">Welcome CSS3</p>

This is very easy think, just remember that you have to write down IE syntax first in @font-face style. and you need to convert TTF to EOT for IE support. here are some online tool which are doing this.

http://www.fontsquirrel.com/fontface Download hundreds of EOT, WOFF fonts.
TTF to EOT Font converter
Web Embedding Fonts Tool (WEFT)

This is very easy to cool. isn’t it.

My New Laptop

2011-01-11T14:54:00.001Z

I have purchased HP Probook 4520s

Front side.

Sexy keyboard.

Front Look.

Intel Core i3 CPU, M350 @ 2.27GHz
3GB DDR2 Ram
32-bit Operating System
Windows 7 Operating System
2MP Web Cam
320GB hard drive
Amount 36000/-

So, get started hard work!!! :)

Happy New Year

2011-01-02T07:30:00.003Z

Hello Friends,

Happy New Year

I promise that from now I will start doing post regularly.

DataRepeater Control from Visual Basic Power Packs 3.0

2009-11-02T08:01:00.001Z

Visual Basic Power Packs 3.0 have very cool same as we web application, named DataRepeater.

lets do some cool stuff with DataRepeater control.

Add Data source.
Add Combobox in datarepeater control
Hide show controls runtime in datarepeater control

See the above image, We have a button, a DataRepeater control and in data repeater control we have a textbox, a combo box and a label which will hide and show runtime by selecting value of combobox.

So lets start, how to do this.

Create a class to save data, I am not using any DataTable for this example.

public class data1 : List<data1>
    {
        private string mName;
        private string mDdlValue;

        public data1()
        {
        }

       public string Name
        {
            get { return mName; }
            set { mName = value; }
        }

        public string DdlValue
        {
            get { return mDdlValue; }
            set { mDdlValue = value; }
        }
    }
}

In above code we have two property “Name” and “DdlValue” and it is inherited with “List” to bind data.

Now lets bind that controls with data1 class

I will use Form_Load event to do this.

/// <summary>
/// data1 variable declaration in Form Class
/// </summary>
private data1 objData = new data1();

private void Form1_Load(object sender, EventArgs e)
{
    ///Bind Textbox with Name property
    tbName.DataBindings.Add(new System.Windows.Forms.Binding("Text", objData, "Name"));

    ///Bind Combo box with DdlValue property
    comboBox1.DataBindings.Add(new System.Windows.Forms.Binding("Text", objData, "DdlValue"));
}

And databind “objData” to DataRepeater1 control, I will use button click event to do this.

private void button2_Click(object sender, EventArgs e)
{
    objData.Add(new data1());
    dataRepeater1.DataSource = null;
    dataRepeater1.DataSource = objData;
}

Ok to now when you will click on button2, it will add new item in “objData” and then, bind it to dataRepeater1 control.

But still we have to add item in combobox, So we need to use “ItemCloned” event to do this.

private void dataRepeater1_ItemCloned(object sender, Microsoft.VisualBasic.PowerPacks.DataRepeaterItemEventArgs e)
{
    ComboBox c1 = (ComboBox)e.DataRepeaterItem.Controls.Find("comboBox1", true)[0];

    c1.Items.Add("sa1");
    c1.Items.Add("sa2");
    c1.Items.Add("sa3");
    c1.Items.Add("sa4");
    c1.Items.Add("sa5");
}

you can see that now there are 5 item in combo box.

and finally let hide and show a label control dynamically, Here in example the logic is, when use select “sa2” from combo box it will show the label else it will be hide.

We have to use DrowItem event to do this.

private void dataRepeater1_DrawItem(object sender, DataRepeaterItemEventArgs e)
{
    if (objData[e.DataRepeaterItem.ItemIndex].DdlValue == "sa2")
    {
        ((Label)e.DataRepeaterItem.Controls.Find("label2", true)[0]).Text = "this is second option";
    }
    else
    {
        ((Label)e.DataRepeaterItem.Controls.Find("label2", true)[0]).Visible = false;
    }
}

So this is good to run our program, but one more thing, If you want to hide show label directly when use change value from dropdown list, you have to add SelectedIndexChanged to combobox1.

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
    ComboBox cbo = ((ComboBox)(sender));

    DataRepeaterItem prnt = (DataRepeaterItem)(cbo.Parent);

    Label objLavel = ((Label)(prnt.Controls.Find("Label2", true)[0]));
    if (cbo.SelectedIndex == -1)
    {
        return;
    }
    if (cbo.Text == "sa2")
    {
        objLavel.Visible = true;
        objLavel.Text = cbo.Text;
    }
    else
    {
        objLavel.Visible = false;
    }
}

So just press F5 to run this program.

So this is a very simple example to work with dataRepeater control, you can utilize your requirement in it and have some cool looking information in your window application!

Google Map Advance Search by Radius

2009-09-23T06:03:00.001Z

Google map allows us to create radius in its map, user will drag and drop that radius in different location and he will able to show only those pointers which are search result in his selected criteria.

Visit this example : http://maps.forum.nu/gm_sensitive_circle2.html to create radius in Google map.

Now we can get new updated radius value from JavaScript function.

We have to pass that amount to SQL Server stored procedure Below is that sql :

CREATE PROCEDURE uspAddress_GetByRadius
    @Latitude        decimal(10,8)
    ,@Longitude        decimal(10,8)
    ,@Radius        decimal(5,3)
AS
BEGIN

    DECLARE @R decimal(18,10)
    SET @R = PI()/180

    SELECT
          ACOS((SIN(@Latitude*@R)* SIN(Latitude*@R)) + (COS(@Latitude*@R)* COS(Latitude*@R) * COS(Longitude*@R - @Longitude*@R))) * 6378.137 AS Distance
          ,A.*
    FROM
          (SELECT
                 CONVERT(decimal(10,8), SUBSTRING(LMapCoordonates, 0, CHARINDEX(',',LMapCoordonates))) as Latitude
                ,CONVERT(decimal(10,8), SUBSTRING(LMapCoordonates, CHARINDEX(',',LMapCoordonates) + 1, 100)) as Longitude
                ,tblAddress.*
          FROM tblAddress) AS A
    WHERE
        ACOS((SIN(@Latitude*@R)* SIN(Latitude*@R)) + (COS(@Latitude*@R)* COS(Latitude*@R) * COS(Longitude*@R - @Longitude*@R))) * 6378.137 <= @Radius
END

We will apply Google map’s new Latitude and Longitude value and radius area to the sql server’s stored procedure and it will return only those records which are satisfy that criteria.

Online Photo Frame Creator Tool

2009-09-18T05:53:00.001Z

PicJoke is online photo editor tool, which allows to embed funny frame to our uploaded image.

There are so many frame Effects.

Have some quick fun.

jQuery 1.3 Cheat Sheet

2009-08-31T03:59:00.001Z

Download jQuery 1.3 Cheat Sheet from http://oscarotero.com/jquery/

it is also link to its example.

CK Editor

2009-08-28T05:45:00.001Z

I few months a go have posted about some WYSIWYG editor, I have come to know that there is one more tool next generation solution of FCK Editor.

Almost all developers knows about FCK Editor, Now there is a new version, CK Editor.

There is all features of FCK editor and dozens of new functionality. CK Editor is faster is fast to load and fast to use.Its current version is 3.0

See demo here.

Open ThickBox dialogbox without “HREF”

2009-08-24T07:29:00.001Z

I have seen many times that Thickbox normal works with <a href=””></a> syntax,

Ex :

Inner Page Content Syntex :

<a href="#TB_inline?height=200&width=200&inlineId=hiddenModalContentID&modal=true"
class="thickbox">Click here to show hidden modal content.</a>

IFrame Syntex :

<a href="testPage.aspx?keepThis=false&TB_iframe=true&height=200&width=200"
title="saActionPage" class="thickbox">Click here</a>

But what happen when you need to open ThickBox by click event? Here is its solution.

You can to use same syntax of HREF with “tb_show” function.

Ex :

It means you can also open thick box by any other event also.

Export GridView To Excel : Column Format

2009-08-18T07:20:00.001Z

Last Month I posted that How to export to excel from web page with data formatting.

But when you are trying to export entire grid specially with Boolean datatype column,

               string attachment = "attachment; filename=Registration.xls";
               Response.ClearContent();
               Response.AddHeader("content-disposition", attachment);
               Response.Charset = "";
               //set the Response mime type for excel
               Response.ContentType = "application/vnd.ms-excel";
               //create a string writer
               System.IO.StringWriter stringWrite = new System.IO.StringWriter();
               //create an htmltextwriter which uses the stringwriter
               System.Web.UI.HtmlTextWriter htmlWrite = new System.Web.UI.HtmlTextWriter(stringWrite);
               //instantiate a datagrid
               GridView dg = new GridView();
               dg.RowDataBound += new GridViewRowEventHandler(GridView1_RowDataBound);
               //set the datagrid datasource to the dataset passed in
               dg.DataSource = dt;
               //bind the datagrid
               dg.DataBind();
               //dg.Columns[1].ItemStyle.
               //tell the datagrid to render itself to our htmltextwriter
               dg.RenderControl(htmlWrite);
               //all that's left is to output the html
               Response.Write(stringWrite.ToString());
               Response.End();

its result:

You can see that checkbox is there, But this is not user friendly. because in excel operator are not familiar with check box in excel data.

It means there should be 1/0 or True/False in place of checkbox. lets see.

Add RowDataBound event to the grid…

GridView dg = new GridView();
dg.RowDataBound += new GridViewRowEventHandler(GridView1_RowDataBound);

Now create an event…

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        CheckBox chk = (CheckBox)e.Row.Cells[1].Controls[0];
        chk.Visible = false;
        if (chk.Checked)
        {
            e.Row.Cells[1].Text = "1";
        }
        else
        {
            e.Row.Cells[1].Text = "0";
        }

    }
}

You can see that now checkbox is invisible and we are writing 1 or 0 in the same cell, Cells[1] is static value for second column.

and now see the result…

You can see that value is now changed in to 1 inplace of checkbox.

We can change any kind of data by using RowDataBound event.

Search Google Map Location by Address

2009-07-30T10:01:00.001Z

Normally we have to pass Latitude and Longitude to get location, but Using Google API “geocoder.getLatLng()” we can get location by passing address. thanks to one of my friend Dhiren Javia to find this solution for me.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xmlns:v="urn:schemas-microsoft-com:vml">
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
<title>Google Maps API Example: Simple Geocoding</title>

var map = null;
var geocoder = null;

        function initialize() {
            if (GBrowserIsCompatible()) {
                map = new GMap2(document.getElementById("map_canvas"));
                map.setCenter(new GLatLng(22.18, 70.56), 4);
                geocoder = new GClientGeocoder();
            }
        }

showAddress(this.address.value);
</script>

</head>
<body onload="initialize();" onunload="GUnload()">
    <form action="#" onsubmit="showAddress(this.address.value); return false">
    <p>
        <input type="text" size="60" name="address" value="Rajkot" />
        <input type="submit" value="Go!" />
    </p>
    <div id="map_canvas" style="width: 500px; height: 300px">
    </div>
    </form>
</body>
</html>

Image Reflection/Shadow

2009-07-27T15:28:00.001Z

Apply image reflection effect using jQuery visit here

Reflection.js for jQuery is very cool plug-in to apply reflection in image dynamically without uploading two images. It is also allows you to add instantaneous reflection effects to your images in modern browsers, in less than 2 KB.

It will create a “Canvas” tag programmatically to show reflection and working will almost all browsers. See demo here.

Compresses and Decompresses CSS

2009-07-22T16:16:00.001Z

This is very good idea to compresses CSS file before uploading it on web server, It compress the file size and improve performance of web site. But some time we need to edit the same compresses file it is very big headache, There is a small online tool to compress and decompress CSS.

Visit here

Bing.com cool background collection

2009-07-10T09:36:00.001Z

Microsoft have launch new search web site, Bing.com, When we open this web site, there will be a cool background every day.

Find all archives of those cool background from here.

If you don’t want to load that image use this URL one time http://www.bing.com/?rb=0. Here rb=0 means No Background Image, and type rb=1 to load it.

Thumbnail image zoom to original perview using JavaScript

2009-07-09T15:42:00.005Z

Let create cool JavaScript thumbnail zoom effect.

The concept is that there will be thumbnail on page user can see it and original image will be hidden at the same time and when user rollover on that thumbnail hidden main image will smoothly resize on the same place.


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

<div>

<img src="saAction Real.jpg" alt="saAction" id="screen1" 
onmouseout="reducethumb(1); return false;" style="position: absolute;
display: none;" width="240" border="0" height="269">

<img src="saAction Thumb.jpg" alt="saAction" id="thumb1" 
onmouseover="expandthumb(1, 500, 300);">

</div>

Settings :

Thumbnail Image

id must be "thimbN", N means number example : thumb1, thumb2 etc.
add "onmouseover" event and cell "expandthumb" function
"expandthumb" have three arguments (thumbnail ID last number, main image width, main image height)

Mani Image

id must be "screenN", N means number example : screen1, screen2 etc.
Style="display:none;"
add "onmouseout" event and cell "reducethumb" function
"reducethumb" function take one argument (main image ID last number)

thats all when you will mouse over on thumbnail it will show main mage on same plase with smooth scrool effect.

Isn't it cool download demo.

Post HTML, C#, VB.net code with formating

2009-07-08T15:27:00.004Z

I have faced this problem many times posting an article on blog spot. I was not able to provide good HTML, C# or any other code with color formatting, The problem is at the HTML code was rendering as HTML and breaking the post content, It is not able to get different between our articles code and its own code.

So tried to find its solution over the net, and get many good result.

1) SimpleCode

This very simple code online tool to converter HTML in compress mode. simple and quick, Enter HTML markup, click on “Process” button and get encoded markup, you will also see preview at the buttom of the page

2) C# Code Format

This is very cool tool, It provides us to seelct language like C#, VB.Net, HTML, T-SQL and MSH. This is also option to add live number in code.

Just click on “Format My Code” button and you will get encoded HTML code with preview. See the result example below:

this is cool result, we can aslo change code style as we want, and its give CSS, it is good to apply CSS in <header> tag and the reason is that we don’t have to apply CSS file in each post.

3) CopySourceAsHtml

CSAH is one kind of add-in for Microsoft Visual Studio only It is able to work with Visual Studio 2003, 2005 and 2008.

After installing this add-in there will be a new menu in “Edit”, named “Copy as HTML…”. When you click on it will show a dialogbox for settings.

There is a one cool feature for Line Number, we enter starting line number, It is user fult when we are giving information in detailed description. Syntax highlighting, CSAH uses Visual Studio's syntax highlighting and font and color settings automatically. If Visual Studio can highlight it, CSAH can copy it, and your source should look the same in your browser as it does in your editor.

4) Encode / Decode HTML Entities

Here we have good feature that we can aslo decode give HTML.

But there is not any advance fuatures as line number or color formating.

5) BlogJet

If you want POST in your blog by any desktop application that can add post directly in your blog, BlogJet is a good software. It is a popular Windows blog client for your WordPress, TypePad, Blogger, Drupal, etc. blogs. Get convenience and speed of a native application, and the ability to write posts offline.

We can also save post in our cumputer by “bjd” file format, This application will automatically decode HTML content.

So, here are many featurs abailabel to post HTML, C#, VB.Net.

Go ahad and start posting with user friendly look.

Chart with ASP.NET 3.5

2009-07-07T07:55:00.015Z

Microsoft .Net Framework 3.5 provides Chart Control for Windows and Web applications.

let learn quick start about Chart control with Asp.net web site.

You have to download MSChart for Microsoft .NET Framework 3.5, It will install new assemblies that contain the ASP.NET and Windows Forms Chart Controls.

After its installation you have to add that control in Visual Studio's ToolBox, it will not comes automatically.

there are two ways to do it, Download Microsoft Chart Controls Add-on for Microsoft Visual Studio 2008. It is provide Visual Studio toolbox integration and IntelliSense for the Asp.NET and Windows Forms Chart controls and will start to show in toolbox, else use second way just drag and drop it's DLL file or chose item from toolbox from "[SystemDrive]\Program Files\Microsoft Chart Controls\Assemblies" all chart control's dll files are here,

Use "System.Web.DataVisualization.dll" for Web applications and "System.Windows.Forms.DataVisualization.dll" for Windows Form application

Now we are ready to use Microsoft Chart Control.

Now create a new web page and drag and drop chart control on page.

See the chart control's HTML:

Now you can bind directly form database but here lets create a class for with to fields Name and Salary.

So we have two fields here Name and Salary, lets enter some records in page load event.

Three records are entered. Now lets bind chart control.

"Series" property is use to create X and Y axis data.

protected void Page_Load(object sender, EventArgs e)
{
1. dataChart d1 = new dataChart();
3. d1.Add(new dataChart("Samir", 20));
4. d1.Add(new dataChart("Vijay", 30));
5. d1.Add(new dataChart("Ram", 15));
7. Chart1.DataSource = d1;
8. Chart1.Series["Series1"].XValueMember = "name";
9. Chart1.Series["Series1"].YValueMembers = "Salary";
10. Chart1.DataBind();
}

lets see the result :

This is column chart as default chart type, now lets change ChartType="Pie" and see the results:

There are many chart types are available and we can also create 3d chart. you can also save chart result as image using "SaveImage()" method. and also many other features. You can also bind with database using DataTable and also can write down static columns (Series) using HTML.

This is very useful control whenever we required to create chart.

Happy codding.

Create your own flash based mobile wallpaper with batry and signal level

2009-07-06T14:58:00.005Z

Many mobile user uses Flash animated wallpaper or screen sever, and they really like some kind of motion on mobile phone screen. And if you know flash and want to create some existing job with it. This quick tutorial will be help full to you.

lets create flash file which can run in your mobile?

This is very easy, lets create a flash file to apply it as wallpaper or screen sever.

I am using Flash cs2 to create this application.

Open Flash and select "Flash File (Mobile)" option.

You will get new dialog box for mobile application.

Select appropriate mobile phone device as per your requirement, I have Nokia 6300 and there for I am select using Flash Lite 2.0 16 240 X 320 from Device Set list.

click on "Create" button after selection, you will get blank flash with mobile screen layout.

Now put some images and text etc as you want:
and also create two text box to show bettye level and signal.

Chagnge those two textboxes property as dynamic and server variable.

Textbox 1 : variable name "nBattery"
Textbox 2 : variable name "nSignal"

Now create two frame, this is because frame will play it self and every time we can get new amount for battery and signal :

Now add below action script
Add this script in first frame.

Here it is that code.

fscommand2("FullScreen", 1);
nBattery = "Battery: " add fscommand2("GetBatteryLevel") add "%";
nSignal = "Signal: " add fscommand2("GetSignalLevel") add "%";

that's all.
see the preview in emulator by pressing "Ctrl + Enter"

it will compile the code and will create a SWF file.

Now transfer that "swf" file in your mobile phone. and you can user it as wallpaper or screen sever.

Remember that your mobile phone need Flash support.

Create your own name's wallpaper, screen sever and apply it in mobile phone, and send to your friends.

have some fun.

Some fun by neurological test

2009-07-05T06:54:00.005Z

Have some fun, Whether you wear Specs or not, Its Mandatory U Complete each Test in 4-5 Seconds,

This is a simple neurological test.
Sit comfortably and be calm !

1- Find the C below. Do not use any cursor help.

OOOOOOOOOOOOOOOOOOO
OOOOOOOOOOOOOOOO OOOOOOOOOOOOOOOO
OOOOOOOOOOOOOOOOOOO
OOOOOOOOOOOOOOOO OOOOOOOOOOOOOOOO
OOOOOOOOOOOOOOOOOOO
OOOOOOOOOOOOOOOO OOOOOOOOOOOOOOOO
OOOOOOOOOOOOOOOOOOO
OOOOOOOOOOOOOOOO OOOOOOOOOOOOOOOO
OOOOOOOOOOOOOOOOOOO
OOOOOOOOOOOOOOOO OOOOOOOOOOOOOOOO
OOOOOOOOOOOOOOOOOOO
OOOOOOOOOOOOOOOO OOOOOOOOOOOOOOOO
OOOOOOOOOOOOOOOOOOO
OOOOOOOOOOOOOOOO COOOOOOOOOOOOOOO
OOOOOOOOOOOOOOOOOOO
OOOOOOOOOOOOOOOO OOOOOOOOOOOOOOOO
OOOOOOOOOOOOOOOOOOO
OOOOOOOOOOOOOOOO OOOOOOOOOOOOOOOO
OOOOOOOOOOOOOOOOOOO
OOOOOOOOOOOOOOOO OOOOOOOOOOOOOOOO
OOOOOOOOOOOOOOOOOOO
OOOOOOOOOOOOOOOO OOOOOOOOOOOOOOOO

2- If you already found the C, now find the 6 below.

9999999999999999999 9999999999999999
9999999999999999 9999999999999
9999999999999999999 9999999999999999
9999999999999999 9999999999999
9999999999999999999 9999999999999999
9999999999999999 9999999999999
9999699999999999999 9999999999999999
9999999999999999 9999999999999
9999999999999999999 9999999999999999
9999999999999999 9999999999999
9999999999999999999 9999999999999999
9999999999999999 9999999999999

3- Now find the N below. It's a little more difficult..

MMMMMMMMMMMMMMMMMMM
MMMMMMMMMMMMMMMM MNMMMM
MMMMMMMMMMMMMMMMMMM
MMMMMMMMMMMMMMMM MMMMMM
MMMMMMMMMMMMMMMMMMM
MMMMMMMMMMMMMMMM MMMMMM
MMMMMMMMMMMMMMMMMMM
MMMMMMMMMMMMMMMM MMMMMM
MMMMMMMMMMMMMMMMMMM

This is NOT a joke. If you were able to pass these 3 tests, you can cancel
your annual visit to your neurologist.
Your brain is great and you're far from having Alzheimer Disease.

Congratulations!

Export to excel from web page and data formating

2009-07-03T07:13:00.005Z

Many time in commercial web sites client want to export data as excel sheet result correct with date time formatting and number decimal point formatting.

here is that kind of example.

string styles = "style> .amount { mso-number-format:0.00; } .exDate { mso-number-format: dd\\/mmm\\/yyyy; } /style> ";
//please write lessthan sign before "style" word

Table xl = new Table();
xl.BorderWidth = 1;
System.Web.UI.HtmlControls.HtmlForm form = new System.Web.UI.HtmlControls.HtmlForm();

string attachment = "attachment; filename=saActionTest.xls";

Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/ms-excel";

System.IO.StringWriter stw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htextw = new System.Web.UI.HtmlTextWriter(stw);

TableRow trTitle = new TableRow();
TableCell tcTitle = new TableCell();
tcTitle.Text = "saAction Test";
trTitle.Cells.Add(tcTitle);

TableCell tcDate = new TableCell();
tcDate.CssClass = "exDate";
tcDate.Text = DateTime.Now.ToShortDateString();
trTitle.Cells.Add(tcDate);

double m1 = 150.50;
TableRow trTitle2 = new TableRow();
TableCell tcTitle2 = new TableCell();
tcTitle2.CssClass = "amount";
tcTitle2.Text = m1.ToString();
trTitle2.Cells.Add(tcTitle2);

xl.Rows.Add(trTitle);

xl.RenderControl(htextw);
xl.Dispose();

Response.Write(stw.ToString());
Response.End();

And the excel sheet result is :

You can see that there is also date, Now Some time many developer faces date problem MM/dd/yyy or dd/MM/yyyy etc. it depends on system's setting as default though you want to add your own date format you have to apply style "mso-number-format" in your code.

There are many other style you can apply to get correct date and number decimal points amount.

mso-number-format:"0" No Decimals
mso-number-format:"0\.00" 2 Decimals
mso-number-format:"mm\/dd\/yy" Date format
mso-number-format:"m\/d\/yy\ h\:mm\ AM\/PM" D -T AMPM
mso-number-format:"Short Date" 03/07/2009
mso-number-format:"Medium Date" 05-jan-2008
mso-number-format:"Short Time" 8:67
mso-number-format:"Medium Time" 8:67 am
mso-number-format:"Long Time" 8:67:25:00
mso-number-format:"Percent" Percent - two decimals
mso-number-format:"0\.E+00" Scientific Notation
mso-number-format:"\@" Text
mso-number-format:"\#\ ???\/???" Fractions - up to 3 digits (312/943)
mso-number-format:"\0022£\0022\#\,\#\#0\.00" £12.76
mso-number-format:"\#\,\#\#0\.00_ \;\[Red\]\-\#\,\#\#0\.00\ " 2 decimals, negative numbers in red and signed
(1.86 -1.66)
mso-number-format:"\\#\\,\\#\\#0\\.00_\\)\\;\\[Black\\]\\\$\\#\\,\\#\\#0\\.00\\\$" Accounting Format –5,(5)

sIFR : Rich Accessible Typography

2009-06-30T09:50:00.002Z

Web designers have limitation to use font in web site, because fonts are comes form user computer not from web site.

But Adobe Flash have a feature to embed font in flash animation.

sIFR is meant to replace short passages of plain browser text with text rendered in your typeface of choice, regardless of whether or not your users have that font installed on their systems. It accomplishes this by using a combination of javascript,

Read more about sIFR.

See the example.

jQuery vs MooTools

2009-06-26T14:19:00.002Z

Which java script framework you are using? If you are confuse that which framework use in web development jQuery or MootTools; I suggest you to go through this article.

This web site have very useful information about jQuery and MootTools.

Visit http://jqueryvsmootools.com/

Well I like jQuery. ;)

Online Javascript compressor

2009-06-26T10:11:00.003Z

It is very good to compress javascript before you upload it before live site.

here it is a online tool to Compress and obfuscate Javascript code online completely free using this compressor.

Just enter your code and click on "Compress".

make it easy!

Add cool gadgets in you blog

2009-06-25T15:31:00.005Z

Add cool flash based gadgets in you block.

See here, click any where in flash area fish will come here to eat that food!

Visit http://abowman.com/google-modules/ too see more gadgets.

Add Automatic XML Documentation to your methods functions and events in C# and VB.net Code

2009-06-19T11:35:00.004Z

Writing inline documentation is very useful but many developers are excusing that its is taking to much time to write down comments, Friends here is a tool for you which will write XML documentation in your C# or VB.net code vary quickly.

This tool is works with Visual Studio 2005, 2008.

GhostDoc is a free Visual Studio extension that automatically generates XML documentation comments.

Its allows us to add quick documentation for :

Methods
Properties with its data type
Parameters Name
Variable Name

See the below example :

Just right click on clock on the name of the function, where will be a menu with "Document this".
Click on it and it will write word quickly documentation for you.

See here the result:

So GhostDoc is very useful tool,

happy codding.

Site is under maintenance

2009-06-17T05:43:00.003Z

I you are working on live site and you need to make some modifications on live server, during this modification you want to show a user friendly message that "Site is under maintenance" or "Site is under construction." or something like that, without affecting any page or database.

You just need to make a simple HTML page with "app_offline.htm" name and upload it on root directory of the web site. once user try to open this site, IIS will open this page in place of "default.aspx".

and you can write down, user friendly message on this page. after completing your task just delete this file or rename it. and site will start work as it is.

Wysiwym HTML Editor in Web Site

2009-06-16T07:35:00.004Z

WMD is a simple, lightweight HTML editor for blog comments, forum posts, and basic content management. You can add WMD to any textarea with one line of code. Add live preview with one line more.

See Demo here.

If any user don't want any advance functionality and just want to provide lightweight HTML editor, WMD is a very useful tool.

Some other popular editor are :

How to show Precess when user click on Submit Button using Java Script?

2009-06-15T05:54:00.005Z

When user click on "Send", "Submit", "Save" or "OK" button, page starts process for postback and user did net get idea whats going on,

Some time when there is lots of data are transferring; we need to create user friendly web application to get idea to user that still its working please wait for some time.

Using only javascript to so process or fire some function when user click on submit button, after check validations or before checking validation.

A button on page:

asp:button runat="server" id="btnSave" onclick="btnSave_Click">

One hidden div tag with processing image:


div id="divProcess" class="goProcess">
img src="http://www.blogger.com/images/bigrotation2.gif" alt="Image" />
/div>

Now one javascript function:


script language="javascript" type="text/javascript">
    function WebForm_OnSubmit() {
        if (typeof (ValidatorOnSubmit) == "function" && ValidatorOnSubmit() == false) {
            return false;
        }
        else {
            document.getElementById("divProcess").style.display = "block";
            return true;
        }
    }
/script>

that all; now when user click on submit button; it will check validations first; else it will show that image;

the javascript function name is "WebForm_OnSubmit" which fires every time when user clicks on Submit button.

CSS Z-Index is not working in IE7

2009-04-14T14:16:00.002Z

CSS Z-Index is not working in IE7 Visit here to get you answer.

Z-Index and position tag have are

Computer Programming Song!!!

2009-03-10T07:55:00.000Z

# Local variable

Mein pal do pal ka shayar hoon,
pal do pal meri kahani hai
pal do pal meri hasti hai..

# Global variable

Main har ik pal ka shayar hoon
har ik pal meri kahani hai
har ik pal meri hasti hai

# Null pointers

Mera jeevan kora kagaz
kora hi reh gaya..

# Dangling pointers

Maut bhi aati nahi
jaan bhi jati nahin.

# Goto

Ajeeb dastan hai yeh
Kahan shuru kahan khatam
Ye manzilen hain kaun si
Na woh samajh sake na hum

# Two Recursive functions calling each other

Mujhe kuchh kehna hein
mujhe bhi kuchh kehna hein
Pehle tum, pehle tum.

# The debugger

Jab koi baat bigad jaye
Jab koi mushkil pad jaye
Tum dena saath mera hamnawaz.

# From VC++ to VB

Yeh haseen vaadiyan
Yeh khula asmaan
Aa gaye hum kahan.

# Untrackable bug

Aye ajnabi, tu bhi kabhi, awaaz de kahin se.

# Unexpected bug (esp during presentation to client)

Ye kya hua, Kaise hua, Kab hua, Kyon hua

System.Web.Mail

2009-02-27T13:44:00.002Z

System.Web.Mail is a web site to get very useful information, There is also faq to send to send email different kind of email.

Date Format in RegularExpressionValidator

2009-02-26T06:42:00.003Z

You can apply date format in RegularExpressionValidator

suppose I have a textbox to apply date time by "dd/MM/yyyy" format.

I can use flowing ValidationExpression:

<asp:RegularExpressionValidator
ID="RegularExpressionValidator2"
runat="server"
ValidationExpression="(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\d\d"
ControlToValidate="myTextBox"
ErrorMessage="Enter date in dd/mm/yyyy format">
asp:TextBox>

br /

asp:Button ID="Button1" runat="server" Text="Button" /

And there is a property to something for text value in it's CS file.

public string TextValue
{
get { return TextBox1.Text; }
set { TextBox1.Text = value; }
}

Now User Control "a1"

%@ Control Language="C#" AutoEventWireup="true" CodeFile="a1.ascx.cs" Inherits="UserControlTest_a1" %

%@ Register src="a0.ascx" tagname="ASP" tagprefix="ASP" %

Now in the page load event of this second user control I want to load "a0" user control and also want to set it's "TextValue" property.

protected void Page_Load(object sender, EventArgs e)
{
///Load Control
UserControl ucDynamic = (UserControl)LoadControl("a0.ascx");

///Add User control to the page
this.Controls.Add(ucDynamic);

///Change Property value for newely added user cotrol
///here "UserControlTest" is the name of the folder in my test web site, user have to change it
((UserControlTest_a0)ucDynamic).TextValue = "saAction";
}

It mans there are two user controls "a0" and "a1", Using "UserControl" we can add user control dynamically and to access it's property we have to convert that variable in to our user control.

CSS-Trick

2008-07-14T15:27:00.000Z

Get Some CSS Trick

View Online demo, or download example!

Free HTML form builder

2008-07-08T14:15:00.000Z

Create Online HTML from

Get all CSS free!!!

Click here

ASPX Edit Helper Add-In For Visual Studio

2008-07-05T14:37:00.001Z

Don't type too much in aspx page!

just write

asp: Label

and press enter

asp:Label runat=”server” id=”asp_Label2943″ />

Download this add-in from here

Unzip download and copy to :

C:\Documents and Settings\[USER]\Application Data\Microsoft\MSEnvShared\Addins

if you did not found "MSEnvShared" and "Addins" folder then create it manually.

Open web site inside of Outlook using VSTO

2008-06-24T13:42:00.001Z

private void ThisAddIn_Startup(object sender, System.EventArgs e)
{

Office.CommandBarComboBox webControl1 = (Office.CommandBarComboBox)this.Application.ActiveExplorer().CommandBars.FindControl(26, 1740, missing, missing);

webControl1.Text = "www.sa-action.blogspot.com";

}

Find Icon

2008-06-10T14:17:00.000Z

Find, Download Cool Icon over the net,

Click Here.

C# Return Type intelsense coding style

2008-06-02T10:08:00.000Z

See this example:

This is a simple two classes "Property" and "Customer", you can see that "Cusomer" class has a method named "PropertyTest" and it will return "Property" class.

See the intelsense list.

but now this the same method intelsense list.

this is coding stuff for C#

Convert C# to VB or VB to C#

2008-04-29T15:15:00.001Z

Convert code C# to VB and VB to C# online.

Click Here

Download MSDN Reader

2008-04-02T09:23:00.000Z

This is one kind of RSS Reader software.

Using MSDN Reader we can brows MSDN Magazine very easily.

This is available on WidowsClient.net

Download MSDN Reader

Password Chacker

2008-03-12T05:54:00.000Z

Check that how strong or best password you have!!!

Click here

innerHTML in JavaScript

2008-03-04T06:37:00.001Z

I have a web page with master page.

Now there is a functionality to "Print This Page", but not full page only one table form that. and it's value comes form database.

There is one want to open a page and load that same information form database. but using javascript, it's become so easier.

Let's check...

you can see that, there is some content with master page, Now I just want to print detail page, but not master page.

so I need to give ID to that control which one I want to print,

for example:

table id="tblResult"

and right down some javascript into this page.

script language="javascript">

function OpenWindow()
{

var printContent = document.getElementById("tblPrint");
var sFeatures = "height=200,width=300,status=no,toolbar=no,menubar=no,location=no";

win = window.open("","Print", sFeatures);
win.document.write(printContent.innerHTML);
win.document.close();
win.focus();
win.print();
win.close();

}

script>

Now, right down onClick event = " OpenWindow()" in button.

Finally you click on "Print" button, It will open a new popup window and it will see also open a print dialogbox.

getElementById(IDName).innerHTML will do this job.

Now Visual Studio 2008 have small name of "getElementById" and that is "$get".

Gujarati Search Engin

2008-02-23T06:45:00.000Z

Start to search in Gujrati language.

It will display Gurati language keyborad and search result in Internet Explorer.

Download ASP.NET 3.5 Learning Video

2008-02-20T06:50:00.000Z

Download some learning Video for ASP.NET 3.5 from MSDN.

You can also download source code for them.

There are more then 100 video series for ASP.NET related technology.

Browse With

2008-02-14T07:11:00.000Z

Visual Studio have a small "Browse With..." feature in IDE.

"Browse with" menu is use to browse our web page in particular selected browser.

Right click on solution explorer, on "aspx" page.

This is "Browse with" dialog box.

You can add any new browser which is not register here, like "FireFox", "Opera" etc, by clicking on "Add" button.

Select the browser name and "Set as Default" to open every time your web site in the same browser.

You can also set bowser resolution (window size) by clicking on bellow drop down.

And there is another small one feature "Internal Web Browser", here will browser your site in you IDE directly.

Add Custom event in Web User Control

2008-02-12T15:34:00.000Z

Customer event is very easy from Web User Controls.

Just 4 steps of code for this!

1) Declare event in the user control

public EventHandler AddNew;

2) Fire that event form user controls event.

if (AddNew != null)
AddNew(sender, e);

(like button click event in that control.)

3) Now asign that event in Page_OnInit event for that control.

protected override void OnInit(EventArgs e)
{
myUserCotrol1.AddNew = new EventHandler(MyNewEventMethod);
}

4) Now wight down that method in which one you declared in page onInit event

protected void MyNewEventMethod (object sender, EventArgs e)
{
//Some code;
//Some code;
}

Done!!!!

Silver Light Learing Video

2008-01-31T07:17:00.000Z

Download 59 learning video of Silver Light from Silver.net site.

Change Squience Logic

2008-01-31T06:39:00.000Z

Create PROCEDURE usp_MoveSequence]

@ID int,

@Sequence int,

@MoveBy varChar(4)

BEGIN—PROCEDURE

SET NOCOUNT ON;

DECLARE @compateTo INT

DECLARE @compateToMax INT

DECLARE @currentSequence INT

DECLARE @NextSequence INT

DECLARE @NextRecordID INT

IF @MoveBy='UP'

Select TOP 1 @NextSequence=Sequence, @NextRecordID=ID from TableName where sequence<@Sequence ORDER BY sequence DESC

ELSE IF @MoveBy='DOWN'

Select TOP 1 @NextSequence=Sequence, @NextRecordID=ID from TableName where sequence>@Sequence ORDER BY sequence

--ENDIF

IF @NextRecordID<>0

BEGIN

UPDATE TableName SET Sequence=@NextSequence WHERE ID=@ID

UPDATE TableName SET Sequence=@Sequence WHERE ID=@NextRecordID

END

END--PROCEDURE

Indian Currency Information

2008-01-12T19:03:00.000Z

Do you want to show 1 rupees note of year 1949?

Click Here to find really very great information about currency of our country with image preview and it year.

Download Free eBook for Microsoft Visual Studio 2008

2008-01-12T18:36:00.000Z

Did you started to learn new features of Visual Studio 2008?

What's New in Microsoft Visual Studio 2008
Microsoft LINQ
Microsoft ASP.NET AJAX
Microsoft Silverlight.

Download eBook of this new version of Visual Studio from Microsoft learning center.

Download 111 Calenders for Year 2008

2008-01-07T16:01:00.000Z

Microsoft Office provides very good temples for Year 2008.

This templates are available in many formats like Word, Excel, Powerpoint, Once note, Visio

Download many attractive calenders form here.

Microsoft Download Center

2007-12-01T06:03:00.000Z

You may have seen Microsoft Download Center so many times.

But now there is a new look:

Visit Microsoft Download Center Beta!

Download ASP.NET 3.5 VIDEO

2007-11-24T19:48:00.000Z

ASP.NET site have some new video series.

Download learnig video ASP.NET 3.5 and Visual Studio 2008. And Click here to download Linq videos.

How to add validation to a WebUserControl?

2007-11-19T18:33:00.000Z

Add validation to WebUserControl, Normally when we click on ControlToVelidate property, it automatically show as all the list of WebControls of that from, But you will not find WebUserControl name there.

Solution is that just write down that WebUserControl name and type "$" sign and write down WebControl name which one is going to validate form that WebUserControl.

for example:

I created a webusercontrol and there is a textbox in that control.
I will drag that webusercontrol in my aspx page.
It's default name will be "WebUserControl1"
Now I will put a RequiredFieldValidator in my aspx page.
Then I will write down in ControlToVelidate = "WebUserControl1$TextBox1"

Because "WebUserControl1" is my web control name in my aspx page. and "TextBox1" this the name of that control in that Web User Control.

This is very ease and useful method to validate WebUserControl.

ASP.NET Control Gallery

2007-11-18T12:41:00.000Z

Click Here to get control gallery over 900 controls and components for web applications.

Control categories are:

Web Page Save As Image!

2007-09-28T16:47:00.000Z

FireFox has a grate Add-In which allows to save any web page to JPEG or PNG format.

It's Save As Image.

Click here to Download.

Save whole web page or you can also crop any part of that web site.

It's very useful.

Multipal HomePage!!!

2007-09-27T06:40:00.000Z

www.homepagestartup.com provides a very useful service that you can have multiple home page in a single browser.

It is automatically stores sites information in cookies and when you come back in this site again it will display the same, There is also Tab feature to manage more sites.

Just click on icon, add URL and save it.

You should have to register to get more features.

Hexadecimal Display

2007-09-24T09:13:00.001Z

One day when I was debugging the code. It started to show hexadecimal values automatically.

I don't know that how it was stared. and I also did not know that how to see decimal back at that time.

but it was simple option that was in Local Window that named "Hexadecimal Display".

Click on Debug Menu -> Windows -> Local.

Right Click on Local Window and get this option as pop-up menu.

Microsoft Visual Basic 2005 Power Packs 2.0

2007-09-19T03:42:00.000Z

Create shapes on form as Visual Basic 6.0 can do that directly on the form.

Power Pack 2.0 is a line, shape controls, printform component, and printer compatibility library.

It has 4 controls.

There are so many property and event.

Download Microsoft Visual Basic 2005 Power Packs 2.0

MSDN Magazine - Book

2007-09-17T14:27:00.000Z

See MSDN Magazine in a book format.

Click Here.

Have fun with moving page...

There is also another magazine for "Dr. Dobb's Journal".

AnyDDL : ASP.NET User Control

2007-09-15T06:40:00.000Z

I have created a user control "Any Drop Down List" anyDDL. Its use to show drop download list form database very quickly.

Lets create that user control.

I'm using Visual Studio 2005, Framework 2.0, SQL Server 2005, ASP.net, C# language to build it.

Start Visual Studio,
Click on Create New Web Site.
Select ASP.net web site.
Click on OK button.

Now,

click on Web Site menu or right click on project name in Solution Explorer.
Select menu named "Add New Item".
It will show a add item dialog box as bellow.

Select Web User Control there and right down its name anyDDL, click on OK button.

Now add a Drop Down List form toolbox.

Rename that drop down list with "thisDDL".

now add some following code in code behind file.

using System;
using System.Data;
using System.Data.SqlClient;

/// This Drop down list can handle all kind of Values automaticaly.
///saCode 14Sep2007

public partialclass userControls_anyDDL : System.Web.UI.UserControl
{
#region private variables
private string _SQL;
private string _WhereSQL="";
private String _allowSelectionByUserValue;
#endregion

#region Public Propertys
///SQL Stored Procedure Name Comes here.

public string SQLstring
{
get { return _SQL; }
set { _SQL =value; }
}

/// SQL where Condition
public string WhereValue
{
get { return _WhereSQL; }
set { _WhereSQL =value; }
}

/// Selected Value of Drop Down List Box
public string SelectedValue
{
get{ return ddlThis.SelectedValue;}
set{ddlThis.SelectedValue = value;}
}

/// Somthing like "---Other---" or "--Select--"
public string allowSelectionByUserValue
{
get { return _allowSelectionByUserValue; }
set { _allowSelectionByUserValue = value; }
}

#endregion

public void ReBindData()
{
BindWithData();
}

protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
BindWithData();
}
}

private void BindWithData()
{
if (SQLstring !=null)
{
string _strConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;

SqlConnection _objCon = new SqlConnection(_strConnectionString);
SqlCommand _objCmd = new SqlCommand();
System.Data.DataSet _objDataSet = new System.Data.DataSet();

_objCmd.Connection = _objCon;
_objCmd.CommandType = System.Data.CommandType.StoredProcedure;
_objCmd.CommandText = "uspAnyDll";

SqlParameter _paramSelectType = new SqlParameter("@selectType", System.Data.SqlDbType.VarChar);
SqlParameter _paramWhereValue = new SqlParameter("@WhereValue", System.Data.SqlDbType.VarChar);

_paramSelectType.Value = _SQL;
_paramWhereValue.Value = _WhereSQL;

_objCmd.Parameters.Add(_paramSelectType);
_objCmd.Parameters.Add(_paramWhereValue);

SqlDataAdapter _objAdapter = new SqlDataAdapter(_objCmd);
_objAdapter.Fill(_objDataSet);

ddlThis.DataSource = _objDataSet;
ddlThis.DataTextField = "Value";
ddlThis.DataValueField = "ID";

ddlThis.DataBind();

if (allowSelectionByUserValue != null)
{
System.Web.UI.WebControls.ListItem
_listItem = new System.Web.UI.WebControls.ListItem(allowSelectionByUserValue, "0");
_listItem.Selected = true;

ddlThis.Items.Add(_listItem);
}
if (this.SelectedValue != null)
{
ddlThis.SelectedValue = this.SelectedValue;
}
}
else
{
//Throw Expression
}

}

Now we have to create stored procedure named "uspAnyDll" to get data form SQL Server.

-- =============================================
-- Author: <sa>
-- Create date: <15Sep2007>
-- Description: <saCode>
-- =============================================

CREATE PROCEDURE uspAnyDll
--ALTER PROCEDURE uspAnyDll
@selectType varChar(50),
@WhereValue varChar(50)
AS
BEGIN

SET NOCOUNT ON;

BEGIN TRY

--you can change this name and SQL as you database requirement.
--but don't change Field name , ID and Value both are static typed in that user control.

IF @selectType='GroupData'
SELECT GroupID AS [ID], Name AS [Value] FROM tblGroupWHERE RecordStatusID=1

IF @selectType='User Information'
SELECT UserID AS [ID], UserName AS [Value] FROM tblUser WHERE CompanyID=Convert(int, @WhereValue)

IF @selectType='State'
SELECT StateID AS [ID], StateName AS [Value] FROM tblState

END TRY
BEGIN CATCH
SELECT 'Error! : ' + @@ERROR
END CATCH

END

you can write down you own query here but don't change it's title "ID" and "Value", because those are static in user control code.

Thats all.
User Control is ready to run. open default.aspx page and drag this control from Solution Explorer.

It will display a drop down list control. See it property panel.

Here is the description for each property:

allowSelectionByUserValue : Some selection message. like "---Select---"
SelectedValue : any selected value if required.
SQLstring : SQL Server stored procedure parameter comes here.
WhereValue : any where condition to pass in that stored procedure.

See, here I have create three different select query in uspAnyDll.

I drag three times anyDDL, and pass SQLstring property as "GroupData', 'User Information' and 'State'. this are actually sql stored porcedure parameters.

and just press F5.

See the result.

Now, using this user control, you can get quickly bind data.

MS Excel Formula =ISERROR()

2007-09-08T07:25:00.000Z

Start to use isError formula in excel when you are calculating something.

I have seen many time error, In Excel.

#Ref
#DIV/0
#NAME?

You can remove all this error and also vice some user friendly value or message there by using ISERROR formula.

IsError(value) returns boolean value in True or False.

try some example in your excel sheet.

=IsError(1/0)

it will return TRUE, it mean there is some error.

Here in this case you can also vice some error message using if condition.

=IF(ISERROR(1/0), "Some Error!", 1/0)

or like that.

Ok, if you don't want to write down this formula every where in your calculation and you will see #NAME?, #Ref, #DIV/0 etc. messages in your excel screen, at list you should not print out them.

You can also hide those error when did you print.

Click on Page Setup.
Click on Sheet Tab.
there is a list box named "Cell error as".
See following image.

But, IsError formula is best, this formula is form Office XP version.

Add toolbar button in Outlook 2007

2007-09-07T13:35:00.000Z

Lets create Outlook 2007 Add-In using Visual Studio 2005.

If you have not installed VSTO then Download Microsoft Visual Studio 2005 Tools for Office Second Edition Runtime (VSTO 2005 SE) (x86).

Start IDE.

Click on File, New project

Select Outlook Add-In and Click on OK.

you will find some code like this:

Public Class ThisAddIn

Private WithEvents btn1 As Office.CommandBarButton

Private Sub ThisAddIn_Startup(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Startup

End Sub

Private Sub ThisAddIn_Shutdown(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Shutdown

End Sub

End Class

Now add following code in StartUp event:

Dim explorer As Outlook.Explorer = Me.Application.ActiveExplorer()  If explorer IsNot Nothing Then
 Dim bar As Office.CommandBar = explorer.CommandBars.Add("saAction Bar", Temporary:=True)
 bar.Visible = True
 btn1 = bar.Controls.Add(Office.MsoControlType.msoControlButton, Temporary:=True) btn1.Caption = "saAction Button"
 btn1.Tag = "myOutlookAddin1.btn1"
 btn1.Style = Office.MsoButtonStyle.msoButtonCaption
End If

And declare Button click event any where in the class.

 Private Sub Btn1_Click(ByVal ctrl As Office.CommandBarButton, ByRef cancelDefault As Boolean) Handles btn1.Click        MsgBox("Hi! this is VSTO")
  End Sub

Done.

Now, Just run the project. Press F5, Outlook will automatically start and It will show a button there, and click on that button. See below "saAction Button" and messagebox.

Outlook is a very big application and using VSTO, you can utilize it's functions.

Fastest Data binding in Grid for Web App

2007-08-25T04:32:00.000Z

I think that here is the fastest way to bind a data grid for web application.

Open your database,
Right Click your table and click on Modify menu for which one do you want to bind.
Select Fields which are do you want to show in browser. user Control key to select.

Press Control + C to copy those column.
Now Open a web page in devenv.
And Click to for Control + V data binding.
See bellow

All Selected Columns and Connection string will be automatically

Press F5 to run

Result in browser.

Done. Isn't it fastest?

If you did not login with "Windows Authentication" so you have to write down password to connect that sql server in Web.config file.

Interface Implementation

2007-08-24T03:28:00.000Z

See this example here.

I have created an interface.

public interface myInterFace1
{
void Operation(string myParam);
string myName();
}

it have two methods. Operation and myName.

Now create a class.

class Program
{

}

Now, lets inherit with interface.

    class Program:myInterFace1
{

}

Now I'm using myInterFace1 in Program class, So I need to write down all methods of that interface in my class.

it's do that with rick.

Right click on inter face name near (:) sign.
It will pop up a menu, where you found "Implement Interface" menu.

Click on that menu.


class Program:myInterFace1
{
  static void Main(string[] args)
  {
  }

  #region myInterFace1 Members

  public void Operation(string myParam)
  {
      throw new Exception("The method or operation is not implemented.");
  }

  public string myName()
  {
      throw new Exception("The method or operation is not implemented.");
  }

  #endregion
}

All method of that interface will be write down there in that class automatically.

It's a very small but useful example during the development of code.

VB.NET and C# Comparison

2007-08-15T03:30:00.000Z

Here you will found programing code difference between VB.NET and C#.

Following code structures are available there with examples.

Program Structure
Comments lines
Data types
Constants
Enumerations
Operators
Choices (If)
Types of Loop
Array
Function
Working with String
Exception Handling
Namespaces
Classes and Interfaces
Constructors and Destructors
Using Objects
Structs
Properties
Delegates and Events
Console I/O
File I/O.

One line Calculator.

2007-07-28T05:52:00.000Z

Hi, Live Search, Google, Yahoo can also works like a calculator!!!

Lets try here...

Live Search result

Yahoo Search result

Some test for Google Search result

Defy All Challenges

2007-07-28T04:07:00.000Z

Defy All Challenges is Microsoft site, to get graphical representation using flash technology.

Get information about Office 2007, Vista, Web development and Visual Studio Team System.

Also have some fun there, creating your own cartoon animation.

click here for HTML version.

Visual Studio 2008 Beta 2

2007-07-27T09:32:00.000Z

Still, Just to days a go I have complete to download Visual Studio 2008 Beta 1, and do day I found that Visual Studio 2008 Beta 2 is released,

So, once again, I have started to download this new version.

Visual Studio Code Name “Orcas” Beta 1

2007-07-26T03:34:00.000Z

Finally after two weeks hard download, I have "Orcas".

Download Visual Studio Code Name “Orcas” Beta 1

Here are some screen shots:

Select .Net Framework version direct form New project dialogbox.

Create C# and Visual Basic WPF Application

Office 2007 Workbook, document direct in Visual Studio as wall as Template and Add-In.

Office 2003 Workbook, document direct in Visual Studio as wall as Template and Add-In.

Worlflow Application

There are many feature in this version which was available in Team edition of Visual Studio 2005, now they are including in this version of "Orcas".

So, I have started to learn Visual Studio 2008, What about U?

Give attachment with blog.

2007-07-25T03:33:00.000Z

We can start to give attachment with out blog.

box.net is a site where we can store our documents in a box and can be access them from anywhere.

easy to upload Images, Word document, PDF Files etc.

here is there result in a blog. There is also change view icon in top right corner.

This box is use uses Flash Player for the result.

Online Chat!

2007-07-18T16:00:00.000Z

Meebo is a great online chat application where AIM, Yahoo, Google and MSN Chat is possible in one browser only.

How to find missing number form a table?

2007-07-18T15:29:00.000Z

Please Give me the solution,

Today I had a requirement that I have to get missing number form table and start new ID form that missing value...

Ex. I have a customer table.

ID Name
1 Vijay
2 Rajesh
3 Nitin
5 Manish
6 Bipin
8 Jalpesh

Here, 4 and 7 number are missing, some one have deleted that record. and now suppose user click on add new button he want to generate that missing number.

Here a I have create a small cursor to get that value:

DECLARE @lastID int,
@crrID int

SET @crrID=1;

DECLARE curJob CURSOR FORWARD_ONLY READ_ONLY LOCAL
FOR
SELECT ID FROM Customer ORDER BY ID

OPEN curJob

FETCH NEXT FROM curJob INTO @lastID

WHILE @@FETCH_STATUS = 0 AND @crrID=@lastID
BEGIN
SET @crrID=@crrID+1
FETCH NEXT FROM curJob INTO @lastID
END

CLOSE curJob
DEALLOCATE curJob

SELECT @crrID;

Done. This SQL satisfied my requirement.

But Its now a good idea where thousands of records in a table, I think that there should be some in built functions of SQL Server 2005, who can get me those missing values without any coding and quickly also.

Do you know any other solution?

Make change in EXE of DLL using Visual Studio 2005

2007-07-16T13:28:00.000Z

You can change executable or DLL files using IDE, not a completely but most improbably.

You can make change in

Design of almost executable file
Icons of the application
Menu name
Button caption

Here I m trying to change in calculator...

Regular calculator.

Go to System32 folder select Calculator.exe file, Drag this icon in IDE, of open file form File menu of IDE.

See Here, Calc.exe in Visual Studio 2005

Open calculator design and make some change.

Now, Save that file As EXE, remember that click on "Save Calc.exe As..." menu.

Save file and open that file directly using double click.

New calculator is ready to work.

You can be a one kind of hacker, but I m trying here to show just knowledge.

Send attachement in mail with big size.

2007-07-13T16:26:00.000Z

I thick Google, Yahoo etc. mail server does not allow more then 10MB.

But here "Mail Big File" allows 100MB of attachment free.

easy three steps.

Quick Start Example to Read Write XML data using DataSet.

2007-07-13T03:13:00.000Z

It's very easy to work XML data file with DataSet.
It's just 2 line of code to Read or Write.
Here I have a XML file...

<?xml version="1.0" standalone="yes"?>

<App xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<value>Some Value1</value>

<value>Some Value2</value>

<value>Some Value3</value>

</App>

Here I'm using Visual Studio 2005 and C# language.

now right down this code in some form load event or in button click event.

//variable and dataset name
System.Data.DataSet ds = new System.Data.DataSet("myDataSet");

//file path to read xml
ds.ReadXml(Application.StartupPath + "\\myfile.xml");

//done. Start to read file.
MessageBox.Show(ds.Tables[0].Rows[0][0].ToString());
//here you will show "Some Value1" from xml file.

//Start to write file.
//change some value.
ds.Tables[0].Rows[0][0]="new value.";

//write file.
ds.WriteXml(Application.StartupPath + "\\myfile.xml");

Done.