<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:georss='http://www.georss.org/georss' xmlns:gd='http://schemas.google.com/g/2005' xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-3669958512396381171</id><updated>2012-01-27T09:21:39.498-08:00</updated><category term='C#'/><category term='Crystal Report'/><category term='Free Web Site Templates'/><category term='Windows XP'/><category term='Category'/><category term='RDLC Report'/><category term='Gridview'/><category term='MS Access'/><category term='javascript'/><category term='Technology'/><category term='CSS'/><category term='Free Wallpapers'/><category term='Download Free Games'/><category term='Others'/><category term='asp.net(c#) interview question'/><category term='XML'/><category term='Windows7'/><category term='Jquery'/><category term='Oracle'/><category term='Web Service'/><category term='asp.net(c#)'/><category term='sql server'/><category term='Ajax'/><category term='DOS'/><title type='text'>.NET Mixer</title><subtitle type='html'>ASP.NET Tutorials, C#.NET, VB.NET, AJAX, SQL Server, XML, Javascript, Jquery, GridView Tutorials / Articles and Code Examples.</subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default?max-results=100'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><link rel='next' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default?start-index=101&amp;max-results=100'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>203</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>100</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-8517592657237780136</id><published>2012-01-27T09:18:00.000-08:00</published><updated>2012-01-27T09:21:39.523-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#) interview question'/><title type='text'>Basic introduction of HTTP Protocol</title><summary type='text'>At first what is Protocol? Protocol means a way of communication between two or more parties. To connect two parties like client and server at first we need to establish a connection between them and after that we need to start communication in such a way so that anyone can understand each other. To establish a connection we need a special protocol named Transmission Control Protocol/Internet </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/8517592657237780136/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2012/01/basic-introduction-of-http-protocol.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/8517592657237780136'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/8517592657237780136'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2012/01/basic-introduction-of-http-protocol.html' title='Basic introduction of HTTP Protocol'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-9025124883240201180</id><published>2012-01-16T09:05:00.000-08:00</published><updated>2012-01-16T09:09:45.144-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#) interview question'/><title type='text'>Basic difference on GET and Post HTTP methods</title><summary type='text'>Might be this the first interview question by the viva board. Which is very basic and you have to explain clearly. That's why i am trying to write the post "Basic difference between GET and POST method". Basically both method is used for submitting data into server. Read the differences from below:
Post Mechanism:
1. GET request is sent via URL.
2. Post request is sent via HTTP request body or </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/9025124883240201180/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2012/01/basic-difference-on-get-and-post-http.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/9025124883240201180'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/9025124883240201180'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2012/01/basic-difference-on-get-and-post-http.html' title='Basic difference on GET and Post HTTP methods'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_Get_Post_Difference.png' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-4439892984280474961</id><published>2012-01-08T09:08:00.000-08:00</published><updated>2012-01-08T09:18:06.165-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#) interview question'/><title type='text'>Short description on MIME type</title><summary type='text'>MIME = Multi-purpose Internet Mail Extensions.
This article will explain "What is ENC MIME type". Its a commonly used basic viva/written interview question. MIME type is a standard way of defining file types between HTTP Client and HTTP Server. Without a standard MIME type both client and server can not understand what type of file client received since a file has many extensions like HTML and </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/4439892984280474961/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2012/01/short-description-on-mime-type.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/4439892984280474961'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/4439892984280474961'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2012/01/short-description-on-mime-type.html' title='Short description on MIME type'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-6258393571496583231</id><published>2011-12-09T10:09:00.000-08:00</published><updated>2011-12-09T10:10:59.665-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#) interview question'/><title type='text'>Learn Tutorial of Asp.net Page Life Cycle</title><summary type='text'>When a user send request to the Web server, the page passes a lot of events during initialization and disposal. Generally an Asp.net aspx page contains a lot of server side controls as well as HTML controls &amp; user controls. Most of the developer does not bother the life cycle events. But its not a good practice because to be a good &amp; knowledgeable developer or programmer you have to learn the </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/6258393571496583231/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2011/12/learn-tutorial-of-aspnet-page-life.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/6258393571496583231'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/6258393571496583231'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2011/12/learn-tutorial-of-aspnet-page-life.html' title='Learn Tutorial of Asp.net Page Life Cycle'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_ASP_Netpagelifecycle.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-4971923415537129436</id><published>2011-12-07T10:18:00.000-08:00</published><updated>2011-12-07T10:18:53.265-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='sql server'/><title type='text'>The OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction : SQL SERVER ERROR</title><summary type='text'>In many Sql Server forum i found the error "The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction". That's why i am decided to describe this error with a solution that i have resolved yesterday. One simple solution is Sql Server has a service named "Distributed Transaction" which you need to ON to resolve this problem. But one </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/4971923415537129436/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2011/12/ole-db-provider-sqloledb-was-unable-to.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/4971923415537129436'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/4971923415537129436'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2011/12/ole-db-provider-sqloledb-was-unable-to.html' title='The OLE DB provider &apos;SQLOLEDB&apos; was unable to begin a distributed transaction : SQL SERVER ERROR'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-4411078055005356640</id><published>2011-12-07T10:06:00.000-08:00</published><updated>2011-12-07T10:06:18.596-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Windows7'/><category scheme='http://www.blogger.com/atom/ns#' term='Windows XP'/><title type='text'>Activate your inactive utility folder option task manager</title><summary type='text'>Sometimes in Windows operating system we did not found some utilities like:


1. Folder Option
2. Task Manager
3. Control Panel
4. System Restore
5. Run Menu
6. Context Menu
7. My Computer
8. Search Option
9. Command Console
10. Registry Editor
11. MS Configure

This will happen due to virus attack.

Solution:
One software named Re-Enable will help you to activate inactive utility as per your </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/4411078055005356640/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2011/12/activate-your-inactive-utility-folder.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/4411078055005356640'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/4411078055005356640'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2011/12/activate-your-inactive-utility-folder.html' title='Activate your inactive utility folder option task manager'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-502875803377154530</id><published>2011-12-07T09:47:00.000-08:00</published><updated>2011-12-07T09:47:03.570-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Windows XP'/><title type='text'>Speed up or keep active the RAM activity</title><summary type='text'>In using of Windows most of the times system creates page files which will act like virtual memory. But those virtual files may not clear automatically when you shut down the PC or Laptop which slows the RAM speed eventually. You can automatically or forcefully remove or delete the virtual files when shutting down your computer.
To do this follow the below steps:

1. Go to Start then Control </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/502875803377154530/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2011/12/speed-up-or-keep-active-ram-activity.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/502875803377154530'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/502875803377154530'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2011/12/speed-up-or-keep-active-ram-activity.html' title='Speed up or keep active the RAM activity'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-6928954816682826376</id><published>2011-12-07T09:28:00.000-08:00</published><updated>2011-12-07T09:30:11.232-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Windows7'/><category scheme='http://www.blogger.com/atom/ns#' term='Windows XP'/><title type='text'>Can not delete file Now delete file easily</title><summary type='text'>In maximum time virus or for other problems like:

1. The file is in use by another program or user
2. The source or destination file may be in use 
3. Make sure the disk is not full or write-protected and that the file is not currently in use
4. Cannot delete file: Access is denied

You may not delete a file easily. For such type of problem the shortest solution is "FileASSASSIN". FileASSASSIN </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/6928954816682826376/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2011/12/can-not-delete-file-now-delete-file.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/6928954816682826376'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/6928954816682826376'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2011/12/can-not-delete-file-now-delete-file.html' title='Can not delete file Now delete file easily'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_Fileassassin.png' height='72' width='72'/><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-5541290048155030287</id><published>2011-05-17T03:12:00.000-07:00</published><updated>2011-05-17T03:12:06.920-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>Make Regular Expression Checker in 10 minutes using Asp.net C#</title><summary type='text'>In most of the times we need to make or create a regular expression to find matching patterns from a given string or a file. Many languages support this feature like Javascript and also Asp.net C#. Regular expresion makes our life easy. Few days ago i have done a dataminig project where i found that how much necessary the regular expression is. I understand its power and capability. The developer</summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/5541290048155030287/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2011/05/make-regular-expression-checker-in-10.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/5541290048155030287'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/5541290048155030287'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2011/05/make-regular-expression-checker-in-10.html' title='Make Regular Expression Checker in 10 minutes using Asp.net C#'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_Regular_Expression_checker.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-5780423608083328981</id><published>2011-05-12T08:55:00.000-07:00</published><updated>2011-05-13T13:44:09.899-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Jquery'/><title type='text'>Jquery to generate Random Number</title><summary type='text'>In many forums i found a question "How to generate a Random Number using Jquery?". Its easy to generate a Random number because Jquery provides us builtin Math library function Math.random() to generate the number. To get the output you have to put a number range. Then the the mehod Math.random() will give you a Random Number. You can also use this technique for dice, random image script, or </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/5780423608083328981/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2011/05/jquery-to-generate-random-number.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/5780423608083328981'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/5780423608083328981'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2011/05/jquery-to-generate-random-number.html' title='Jquery to generate Random Number'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_Jquery_Random_number.jpg' height='72' width='72'/><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-1604074914194256011</id><published>2011-05-11T06:54:00.000-07:00</published><updated>2011-05-17T03:21:27.551-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Jquery'/><title type='text'>Create generate on the fly JQuery dynamic content</title><summary type='text'>In many cases developers need to add dynamic contents in a DIV. In my lattest project i have done a critical job. In this post i am sharing just a simple example on how to add dynamic contents in a DIV. By following this example you can generate on the fly dynamic contents, controls like Button, Link etc. The output look like below:




To do this fisrt add an asp.net aspx page. Then paste the </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/1604074914194256011/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2011/05/create-generate-on-fly-jquery-dynamic.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/1604074914194256011'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/1604074914194256011'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2011/05/create-generate-on-fly-jquery-dynamic.html' title='Create generate on the fly JQuery dynamic content'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_Jquery_Dynamic_Contents.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-5186243469487519681</id><published>2011-03-27T02:37:00.000-07:00</published><updated>2011-03-27T02:37:26.256-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><category scheme='http://www.blogger.com/atom/ns#' term='XML'/><title type='text'>Validate XML aganist an XSD in Asp.Net C#</title><summary type='text'>Most of the times when we are working with XML we need to validate the XML file from an XSD file. Here i am showing an code example how one can validate XML file using an XSD in Asp.Net C#.

To do that add an aspx page in your project.











Now under Page_Load event write the below code:
using System;
using System.Xml;
using System.Text;
using System.Xml.Schema;

public partial class </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/5186243469487519681/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2011/03/validate-xml-aganist-xsd-in-aspnet-c.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/5186243469487519681'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/5186243469487519681'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2011/03/validate-xml-aganist-xsd-in-aspnet-c.html' title='Validate XML aganist an XSD in Asp.Net C#'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-246423722134440931</id><published>2011-03-27T02:10:00.000-07:00</published><updated>2011-03-27T02:10:15.883-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><category scheme='http://www.blogger.com/atom/ns#' term='XML'/><title type='text'>Creating XSD file from an XML file in Asp.Net within few seconds</title><summary type='text'>There are a lot of tools in the internet you will get to create XSD file from an XML file but you need to download then install or may be convert on-line. But there is good news that Asp.Net has built in menu to create XSD file from an XML file. 












To do that first write the below XML file in VisualStudio:
&lt;?xml version="1.0" encoding="utf-8" ?&gt;
&lt;Home&gt;
  &lt;Menu text="Books" url="</summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/246423722134440931/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2011/03/creating-xsd-file-from-xml-file-in.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/246423722134440931'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/246423722134440931'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2011/03/creating-xsd-file-from-xml-file-in.html' title='Creating XSD file from an XML file in Asp.Net within few seconds'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-5886471652465995376</id><published>2011-03-27T01:19:00.000-07:00</published><updated>2011-03-27T01:23:33.216-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>Bind DataSource into DataList example in Asp.Net</title><summary type='text'>The DataList control is a standard control of Asp.Net like others. It is used to display repeated list of data or items. You can bind any datasource in this DataList control like DataTable, SqlDataReader and XML etc. In most e-commerce site use DataList control to display products insted of repeater control. Here in this example i will show you how one can bind data to DataList control in runtime</summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/5886471652465995376/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2011/03/bind-datasource-into-datalist-example.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/5886471652465995376'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/5886471652465995376'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2011/03/bind-datasource-into-datalist-example.html' title='Bind DataSource into DataList example in Asp.Net'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_DataList_table.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-6484889418804570642</id><published>2011-03-23T03:10:00.000-07:00</published><updated>2011-03-23T03:12:36.880-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Others'/><title type='text'>Center middle the content of a DIV based web page</title><summary type='text'>When browsing we found a lot of website midle centered. The question is how developer doing this. In forums i found many times this question. Its simple and easy to middle the content for div based design. To do that wrap up all div in one div and then apply some CSS to middle or center the web page.I want to make the below example:










To do that add an aspx page in your project. Then add </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/6484889418804570642/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2011/03/center-middle-content-of-div-based-web.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/6484889418804570642'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/6484889418804570642'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2011/03/center-middle-content-of-div-based-web.html' title='Center middle the content of a DIV based web page'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-8634646587092524894</id><published>2011-03-23T00:58:00.000-07:00</published><updated>2011-03-23T01:01:14.361-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>Tricks for URL Rewriting using Request.PathInfo in Asp.Net</title><summary type='text'>To publish cleaner URL in your Asp.Net application you can use URL Rewriting. The most popular reason for URL Rewriting is let you have implemented pages based on query string like http://yourdomain/product.aspx?Brand=Lux. But now you want to change the URL to http://yourdomain/product.aspx/Lux for SEO purpose. There is a lot of way to implement this. One of the easy trick is you can achieve URL </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/8634646587092524894/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2011/03/tricks-for-url-rewriting-using.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/8634646587092524894'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/8634646587092524894'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2011/03/tricks-for-url-rewriting-using.html' title='Tricks for URL Rewriting using Request.PathInfo in Asp.Net'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-4901591213889490162</id><published>2011-03-21T04:24:00.000-07:00</published><updated>2011-03-21T04:24:37.463-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><category scheme='http://www.blogger.com/atom/ns#' term='Ajax'/><category scheme='http://www.blogger.com/atom/ns#' term='Jquery'/><title type='text'>Check user name login name email address availability using jquery ajax in Asp.Net page</title><summary type='text'>In most registration page we need to check the availability of user name or email address using Jquery/Ajax. Because it will be hectic job for user to rewrite the data after getting post back error that user name already taken or email address already taken. So it would be very helpful for user if he can check his name or login name or email address availability in time without losing any data. </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/4901591213889490162/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2011/03/check-user-name-login-name-email.html#comment-form' title='2 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/4901591213889490162'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/4901591213889490162'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2011/03/check-user-name-login-name-email.html' title='Check user name login name email address availability using jquery ajax in Asp.Net page'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_Check_User_login_2.jpg' height='72' width='72'/><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-7761567289083233383</id><published>2010-12-29T22:34:00.000-08:00</published><updated>2010-12-29T22:35:41.701-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='javascript'/><title type='text'>Create a javascript ToolTip within 10 minutes for Asp.net page</title><summary type='text'>Sometimes we need to create handy javascript tooltip for client. Here in this article i will show how one can create a javascript tooltip within very short time by using DIV object. To do that here i use a DIV as a tooltip container. When i need to show the tooltip then i have set the DIV visibility style to 'visible' otherwise 'hidden'. Very simple right? Lets start:










Add an Aspx page </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/7761567289083233383/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/12/create-javascript-tooltip-within-10.html#comment-form' title='2 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/7761567289083233383'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/7761567289083233383'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/12/create-javascript-tooltip-within-10.html' title='Create a javascript ToolTip within 10 minutes for Asp.net page'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_Javascript_Tooltip.jpg' height='72' width='72'/><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-7560038901998914214</id><published>2010-12-03T05:40:00.000-08:00</published><updated>2010-12-03T05:43:51.958-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>Using Server.Transfer how to pass values from source page to destination page</title><summary type='text'>It's not possible to pass value using query string from source page to destination page when using Server.Transfer. To pass data or value from source page to destination page while using Server.Transfer you can use HttpContext object. To do that add two aspx pages in your project &amp; give name source.aspx &amp; destination.aspx. In source.aspx page place a LinkButton. And under the LinkButton Click </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/7560038901998914214/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/12/using-servertransfer-how-to-pass-values.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/7560038901998914214'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/7560038901998914214'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/12/using-servertransfer-how-to-pass-values.html' title='Using Server.Transfer how to pass values from source page to destination page'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_server_transfer.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-8162375551575525176</id><published>2010-12-03T05:34:00.000-08:00</published><updated>2010-12-03T05:46:20.141-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>Difference Between Server.Transfer vs Response.Redirect</title><summary type='text'>There is a common question for developers in Asp.net interview board that "What is the difference between Response.Redirect and Server.Transfer". In a common term we can use both to redirect the user from source page to destination page. But there are some differences in between Response.Redirect and Server.Transfer, which i want to share with you.
Response.Redirect:
1. A round trip occurs to the</summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/8162375551575525176/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/12/difference-between-servertransfer-vs.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/8162375551575525176'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/8162375551575525176'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/12/difference-between-servertransfer-vs.html' title='Difference Between Server.Transfer vs Response.Redirect'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-8371417611050620566</id><published>2010-11-26T23:09:00.001-08:00</published><updated>2010-11-26T23:34:11.393-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><category scheme='http://www.blogger.com/atom/ns#' term='XML'/><title type='text'>How to bind XML File or XML DataSource to a DataList Control in Asp.Net</title><summary type='text'>DataList control is an important control in Asp.Net applications. Most of the times we need to bind DataList control from a Database using Ado.Net datasource. But sometimes we need to bind XML file as Datasource into a DataList control. Here in this article i will demonstrate how one can bind XML data into a DataList control using the datasource XmlDataSource. The output will be:


To do the </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/8371417611050620566/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/11/sphow-to-bind-xml-file-or-xml.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/8371417611050620566'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/8371417611050620566'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/11/sphow-to-bind-xml-file-or-xml.html' title='How to bind XML File or XML DataSource to a DataList Control in Asp.Net'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_XML_DataList.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-1367232074751050137</id><published>2010-11-26T06:29:00.000-08:00</published><updated>2010-11-26T06:31:19.815-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>Web Parts Drag &amp; Drop functionality in Asp.net Pages</title><summary type='text'>It’s my first article on Asp.net Web Parts. Basically it’s an introduction article how one can start to learn the high end feature of Asp.net web parts. As you knew that most of the portal contains several block. In general the end user can not change the page block orientation or positioning which is termed as personalization. The Asp.net Web Parts gives us the personalization facility with </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/1367232074751050137/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/11/web-parts-drag-drop-functionality-in.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/1367232074751050137'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/1367232074751050137'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/11/web-parts-drag-drop-functionality-in.html' title='Web Parts Drag &amp; Drop functionality in Asp.net Pages'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_Web_Part_1.jpg' height='72' width='72'/><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-8876070184425870419</id><published>2010-11-13T23:48:00.000-08:00</published><updated>2010-11-13T23:48:11.105-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Others'/><title type='text'>How to Install Firebug Add-on in your Mozilla Firefox Browser</title><summary type='text'>The web developers most important tool is Firebug. It's basically a Mozilla Firefox add-on which makes our I mean developers life is very ease to debug and develop web pages. To inspect HTML or ASPX page elements even javascript one can easily use the firebug add-on. The firebug application provide us to detect bugs on any website. It can identify any tag mistakes or CSS conflicts that you have </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/8876070184425870419/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/11/how-to-install-firebug-add-on-in-your.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/8876070184425870419'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/8876070184425870419'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/11/how-to-install-firebug-add-on-in-your.html' title='How to Install Firebug Add-on in your Mozilla Firefox Browser'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_Tools_AddOns_1.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-97283808535199825</id><published>2010-11-03T03:56:00.000-07:00</published><updated>2010-11-03T03:59:35.801-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='sql server'/><title type='text'>How to use optional parameter in SQL server SP</title><summary type='text'>When you are going to write a generic SP for any business purpose you may realize the necessity of optional parameter. Yes Sql server gives us the opportunity to use optional parameter in SP arguments. You may write a SP with 3 arguments but based on your business rule you may pass one or two or three valuse as you want. This policy not only ease our life but also help us to write short SP. Here </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/97283808535199825/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/11/how-to-use-optional-parameter-in-sql.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/97283808535199825'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/97283808535199825'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/11/how-to-use-optional-parameter-in-sql.html' title='How to use optional parameter in SQL server SP'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-8931401663414299517</id><published>2010-11-01T04:55:00.000-07:00</published><updated>2010-11-03T05:01:10.373-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='sql server'/><title type='text'>Error: 'object could not be found' or 'invalid object name'?</title><summary type='text'>As a Developer i thought you may experience one of two errors frequently, even though you thought the object already exist. The error like below:
Msg 208, Level 16, State 1, Line 1
Invalid object name 'Table/View Name'.

OR

Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure ''.






Solution:
To Avoid Such type of error keep in mind always the following considerations:

1. The</summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/8931401663414299517/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/11/error-object-could-not-be-found-or.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/8931401663414299517'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/8931401663414299517'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/11/error-object-could-not-be-found-or.html' title='Error: &apos;object could not be found&apos; or &apos;invalid object name&apos;?'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-2897638674924718757</id><published>2010-11-01T04:11:00.000-07:00</published><updated>2010-11-03T04:14:39.772-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='sql server'/><title type='text'>How to determine whether a table is exist or not in Sql Server database</title><summary type='text'>In some cases we need to identify whether a table is exist or not in a sql server database. This is very simple &amp; now i am sharing with you. Hope it will works like a handbook for you.













Query:
IF EXISTS (SELECT 1 
    FROM INFORMATION_SCHEMA.TABLES 
    WHERE TABLE_TYPE='BASE TABLE' 
    AND TABLE_NAME='tablename') 
        SELECT 'table exists.' 
ELSE 
        SELECT 'table does not </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/2897638674924718757/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/11/how-to-determine-whether-table-is-exist.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/2897638674924718757'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/2897638674924718757'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/11/how-to-determine-whether-table-is-exist.html' title='How to determine whether a table is exist or not in Sql Server database'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-4273759723393047308</id><published>2010-10-10T09:43:00.000-07:00</published><updated>2010-10-10T09:45:39.235-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Jquery'/><category scheme='http://www.blogger.com/atom/ns#' term='Gridview'/><title type='text'>Jquery to read DatakeyNames value of Selected Rows of GridView in Asp.Net</title><summary type='text'>As we know GridView is a very popular control. We always experiment to enhance the GridView control to provide better experience to user. Since javascript is also a popular clientside language, most of the times we use this in client side operations like validation, Row coloring, cell coloring etc. Now a days Jquery is more popular so that in this article i will explain how you can capture the </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/4273759723393047308/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/10/jquery-to-read-datakeynames-value-of.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/4273759723393047308'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/4273759723393047308'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/10/jquery-to-read-datakeynames-value-of.html' title='Jquery to read DatakeyNames value of Selected Rows of GridView in Asp.Net'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_DataKeyName_Jquery.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-679689147259332317</id><published>2010-10-06T01:36:00.000-07:00</published><updated>2010-10-06T01:36:38.109-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Jquery'/><title type='text'>Jquery to Get selected items from CheckBoxList</title><summary type='text'>In many forums i found that developers asking this question. I have answered in many forums and now i decide to write a post on how to get selected items or selected values of checkboxlist using Jquery. This is not an easy job. You need to loop through the checkbox list to get all selected items/values. Here if you look at my code example you will get the loop structer. Here i use comma separator</summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/679689147259332317/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/10/jquery-to-get-selected-items-from.html#comment-form' title='2 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/679689147259332317'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/679689147259332317'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/10/jquery-to-get-selected-items-from.html' title='Jquery to Get selected items from CheckBoxList'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_Checkbox_jquery.jpg' height='72' width='72'/><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-1496160766353384160</id><published>2010-10-05T04:46:00.000-07:00</published><updated>2010-10-05T04:46:25.943-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Jquery'/><title type='text'>How to Set Get RadioButtonList Selected Value using Jquery</title><summary type='text'>In one of my previous post i have written an article on "How to get set RadioButtonList value using javascript". Since Jquery now a popular scripting language thats why in this post i am going to explain how one can access or get or read or set RadioButtonList value using Jquery. Using javascript we can directly use RadioButonList click handler but in Jquery we can't. So what is the solution? Yes</summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/1496160766353384160/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/10/how-to-set-get-radiobuttonlist-selected.html#comment-form' title='2 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/1496160766353384160'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/1496160766353384160'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/10/how-to-set-get-radiobuttonlist-selected.html' title='How to Set Get RadioButtonList Selected Value using Jquery'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_Radio_Jquery.jpg' height='72' width='72'/><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-6995730141421912440</id><published>2010-10-05T01:50:00.000-07:00</published><updated>2010-10-05T01:50:42.918-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Jquery'/><title type='text'>How to Display / Show Hide toggle a Div using Jquery</title><summary type='text'>The man who starts to learn Jquery, basically this post is for you. As a developer i knew that in most web applications we need to do the same job many times. Previously i have explained how one can display/show hide a div using Javascript. For Javascript version please click here. But recent days we were very familiar with Jquery &amp; love to write Jquery method instead of Javascript. In this </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/6995730141421912440/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/10/how-to-display-show-hide-toggle-div.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/6995730141421912440'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/6995730141421912440'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/10/how-to-display-show-hide-toggle-div.html' title='How to Display / Show Hide toggle a Div using Jquery'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_Div_Toggle_Jquery.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-7115793529576831185</id><published>2010-09-30T07:34:00.000-07:00</published><updated>2010-09-30T07:34:55.979-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>Jquery to get set read access IFrame content TextBox Value Data</title><summary type='text'>As you know that this days smart developers doesn't use IFRAME. But in our job always developers need to handle legacy systems. I found such type of legacy application. Now i am trying to modify the user requirement. To do that i need to read or access IFrame content as well as get or put some data from parent page to IFRAME. Since i did it thats why i want to share with you how one can access/</summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/7115793529576831185/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/09/jquery-to-get-set-read-access-iframe.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/7115793529576831185'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/7115793529576831185'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/09/jquery-to-get-set-read-access-iframe.html' title='Jquery to get set read access IFrame content TextBox Value Data'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_IFrame_Jquery.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-1184122672877231135</id><published>2010-09-27T03:27:00.000-07:00</published><updated>2010-09-27T03:29:19.930-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='DOS'/><title type='text'>How to merge all files into one file using DOS command</title><summary type='text'>Some days ago one of my friend ask me a problem that he needs to import csv file to a SQL Server database. But the problem is there is a huge number of small files. He does not want to import one by one. He needs to merge or together all files in a single file so that he can import using SQL Server import wizard only one file. Since it was a one time job for reconcilation, I suggest him use a DOS</summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/1184122672877231135/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/09/how-to-merge-all-files-into-one-file.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/1184122672877231135'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/1184122672877231135'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/09/how-to-merge-all-files-into-one-file.html' title='How to merge all files into one file using DOS command'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-1394838918320128194</id><published>2010-09-21T04:10:00.000-07:00</published><updated>2010-09-22T21:53:46.477-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><category scheme='http://www.blogger.com/atom/ns#' term='Jquery'/><title type='text'>Jquery to get SelectedValue SelectedIndex SelectedText of a DropdownList in Asp.net</title><summary type='text'>When you bind a DropdownList by data sometimes it may require to do something in the client side using javascript or jquery. To read the same post using javascript click here. In this article i will show you how one can get DropdownList SelectedValue, SelectedText &amp; SelectedIndex. So that you can now play with Asp.net DropdownList control. The output like below:


An example of complete code is </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/1394838918320128194/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/09/jquery-to-get-selectedvalue.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/1394838918320128194'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/1394838918320128194'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/09/jquery-to-get-selectedvalue.html' title='Jquery to get SelectedValue SelectedIndex SelectedText of a DropdownList in Asp.net'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_DropdownList_1_Jquery.jpg' height='72' width='72'/><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-5046252279526138574</id><published>2010-09-16T22:45:00.000-07:00</published><updated>2010-09-16T22:47:19.354-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='C#'/><title type='text'>How to merge two or more files using C#</title><summary type='text'>Few days ago i have a requirement to make a processing engine which will download, decode &amp; staging almost 70k+ ASN files. So that i have developed an ASN Decoder using Turbo C. Then make a DLL to use this decoder in my C# project. Everything is good but one problem is that my processing exe will take almost 6 hours to process all files. After reviewing my source code i found that each time my </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/5046252279526138574/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/09/how-to-merge-two-or-more-files-using-c.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/5046252279526138574'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/5046252279526138574'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/09/how-to-merge-two-or-more-files-using-c.html' title='How to merge two or more files using C#'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-1863155310124864202</id><published>2010-08-04T01:28:00.000-07:00</published><updated>2010-09-16T01:33:20.636-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='javascript'/><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>How to prevent avoid Session Timeouts in an Asp.Net C# vb.net Page</title><summary type='text'>As we knew that its a very big problem specially when developers provide a very large entry page to users. It will be Irritating for users after entering all data &amp; then session timeout occur. To prevent or avoid session timeout problem, there is no fixed or specific or direct way to handle. But one can handle this problem using javascript asynchronous call. But one thing keep in mind that time </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/1863155310124864202/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/08/how-to-prevent-avoid-session-timeouts.html#comment-form' title='2 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/1863155310124864202'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/1863155310124864202'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/08/how-to-prevent-avoid-session-timeouts.html' title='How to prevent avoid Session Timeouts in an Asp.Net C# vb.net Page'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-6699995314693197878</id><published>2010-08-03T01:20:00.000-07:00</published><updated>2010-09-16T01:25:28.720-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>Maintaining Scroll Position after Asp.Net Page PostBack</title><summary type='text'>Sometimes we need to Maintain scroll position after page postback specially if the page is a large page &amp; user need to work in the middle portion of the page. In this article i will give you a simple tips on How to maintain Scroll Position after Asp.Net Page PostBack. To do that in the Page Directive of your large Asp.Net Page, add the property 'MaintainScrollPositionOnPostback' and set its value</summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/6699995314693197878/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/08/maintaining-scroll-position-after.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/6699995314693197878'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/6699995314693197878'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/08/maintaining-scroll-position-after.html' title='Maintaining Scroll Position after Asp.Net Page PostBack'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-4406525812109164617</id><published>2010-08-02T02:32:00.000-07:00</published><updated>2010-09-16T02:34:39.339-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>Error: Specified string is not in the form required for an e-mail address</title><summary type='text'>This error may occur when you are working with .net 1.1 means when using the namespace Sytstem.Web.Mail. If we want to send email to multiple or more than one person usually we use like:

To=aaaaaaa@gmail.com;bbbbbbbb@gmail.com;ccccccccc@gmail.com;

This will work in the namespace Sytstem.Web.Mail because here we use semicolon to split or separate email ID's.

But the ERROR: "Specified string is </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/4406525812109164617/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/08/error-specified-string-is-not-in-form.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/4406525812109164617'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/4406525812109164617'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/08/error-specified-string-is-not-in-form.html' title='Error: Specified string is not in the form required for an e-mail address'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-1774829859654106072</id><published>2010-08-02T01:02:00.000-07:00</published><updated>2010-09-16T01:14:20.694-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='sql server'/><title type='text'>Syntax of Shrinking SQL Server database mdf and log file</title><summary type='text'>The below code snippet will help you to shrink the database. Run the code snippet through your SQL Server query analyser.
















backup log &lt;database_name&gt; with truncate_only 
use &lt;database_name&gt; 
dbcc SHRINKFILE (&lt;database_name_Log&gt;,2) 
dbcc ShrinkDatabase (&lt;database_name&gt;, 2)
</summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/1774829859654106072/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/08/syntax-of-shrinking-sql-server-database.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/1774829859654106072'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/1774829859654106072'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/08/syntax-of-shrinking-sql-server-database.html' title='Syntax of Shrinking SQL Server database mdf and log file'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-2881401537629733328</id><published>2010-07-28T22:57:00.000-07:00</published><updated>2010-07-28T22:57:49.107-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><category scheme='http://www.blogger.com/atom/ns#' term='XML'/><title type='text'>How to bind or populate Dropdownlist from XML file</title><summary type='text'>Few days ago i got an email from one of my reader. He wants more article on XML specially on Dropdownlist. Here in this article i will explain how one can bind or populate XML data into a Dropdownlist control. Asp.net DataSet provide us a method named ReadXml where we can initially load XML file. After that we can populate Dropdownlist DataTextField &amp; DataValueField by DataSet default view table.</summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/2881401537629733328/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/07/how-to-bind-or-populate-dropdownlist.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/2881401537629733328'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/2881401537629733328'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/07/how-to-bind-or-populate-dropdownlist.html' title='How to bind or populate Dropdownlist from XML file'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-1514296923071752431</id><published>2010-07-26T08:50:00.000-07:00</published><updated>2010-07-26T08:50:15.192-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='CSS'/><title type='text'>Apply CSS to create Image Border</title><summary type='text'>Sometimes Asp.net developers need to enhance the UI by using image border. Though it's a bit easy in Asp.net image controls by using SKIN to manage image borders but it will be a bit difficult to manage HTML image control without CSS. Here in this post i will show you how one can apply CSS in both Asp.net image control and HTML image control. To do that first write the below CSS:










&lt;style</summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/1514296923071752431/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/07/apply-css-to-create-image-border.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/1514296923071752431'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/1514296923071752431'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/07/apply-css-to-create-image-border.html' title='Apply CSS to create Image Border'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-4972413732896770834</id><published>2010-07-25T09:26:00.000-07:00</published><updated>2010-07-25T09:26:22.069-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>How to convert ArrayList to Array in Asp.net C# VB.Net</title><summary type='text'>In many cases developers have to create ArrayList to achieve dyanamic array functionalities. But sometimes you may need to convert the ArrayList to an array. For example if you are wnat to trnsfer csv data to ORACLE database then if you use bindarray then the conversion is required. Otherwise you won't to insert data into oracle databse. This is only one scenario but for lot of reasons you may </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/4972413732896770834/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/07/how-to-convert-arraylist-to-array-in.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/4972413732896770834'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/4972413732896770834'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/07/how-to-convert-arraylist-to-array-in.html' title='How to convert ArrayList to Array in Asp.net C# VB.Net'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-8927891478197908302</id><published>2010-07-25T07:05:00.000-07:00</published><updated>2010-07-25T09:32:24.093-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>Creating Using Dynamic Array's in Asp.Net C# VB.Net</title><summary type='text'>In some cases developers need to use dynamic arrays in Asp.net. But it’s not straight forward as like VB. If you were a VB developer then you knew that for dynamic array's VB uses REDIM keyword to generate dynamic array's. Here in this post i will discuss how developer can use dynamic arrays in asp.net pages. Basically there is no straight forward way to use but you can achieve the dynamic size </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/8927891478197908302/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/07/creating-using-dynamic-arrays-in-aspnet.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/8927891478197908302'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/8927891478197908302'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/07/creating-using-dynamic-arrays-in-aspnet.html' title='Creating Using Dynamic Array&apos;s in Asp.Net C# VB.Net'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-6321064774496285359</id><published>2010-06-15T21:59:00.000-07:00</published><updated>2010-06-15T21:59:22.375-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='C#'/><title type='text'>VC++ fatal error LNK1104: cannot open file 'Export.def'</title><summary type='text'>When you want to create a DLL file to use in C# windows application or from other applications then you may experience the below error:



Exception: fatal error LNK1104: cannot open file 'xxx.def'

Reason:
You define the definition file from Project--&gt; Project Properties. But the project won't get the definition file in the project path.

Solution:
Create or copy the definition file into the </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/6321064774496285359/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/06/vc-fatal-error-lnk1104-cannot-open-file.html#comment-form' title='2 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/6321064774496285359'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/6321064774496285359'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/06/vc-fatal-error-lnk1104-cannot-open-file.html' title='VC++ fatal error LNK1104: cannot open file &apos;Export.def&apos;'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_fatal_error.jpg' height='72' width='72'/><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-471189491412468067</id><published>2010-06-15T21:41:00.000-07:00</published><updated>2010-06-15T21:41:33.989-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='C#'/><title type='text'>Error: Unable to find an entry point named 'xxx' in DLL 'yyy.dll'</title><summary type='text'>To access any DLL file from C# windows application or from other application an entry point is required. Otherwise you will get the below exception:



Unable to find an entry point named 'xxx' in DLL 'yyy.dll'
OR
Entry point not found exception / error.

When you create any DLL file in VC++ from a turbo C program then you must have create a definition file where you will define the DLL entry </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/471189491412468067/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/06/error-unable-to-find-entry-point-named.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/471189491412468067'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/471189491412468067'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/06/error-unable-to-find-entry-point-named.html' title='Error: Unable to find an entry point named &apos;xxx&apos; in DLL &apos;yyy.dll&apos;'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_Entrypointnotfound.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-618580440394858625</id><published>2010-06-13T05:54:00.000-07:00</published><updated>2010-06-13T06:01:21.754-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='C#'/><title type='text'>Make Turbo C DLL to use in C# windows application</title><summary type='text'>In some cases of our professional life we need to parse or decode or handle large number of file. As you knew that for IO purpose turbo C is faster than other technologies like dot net or something else. In my cases i need to develop an ASN decoder where i need to decode more than million of files. In such cases i need to develop a ASN decoder. In my cases i have done the following way:
1. Create</summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/618580440394858625/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/06/make-turbo-c-dll-to-use-in-c-windows.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/618580440394858625'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/618580440394858625'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/06/make-turbo-c-dll-to-use-in-c-windows.html' title='Make Turbo C DLL to use in C# windows application'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_CreateCPlusProject.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-6256402865718998600</id><published>2010-06-08T03:59:00.000-07:00</published><updated>2010-06-08T03:59:13.266-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='C#'/><title type='text'>Run-Time Check Failure #2 - Stack around the variable 'hexByte' was corrupted</title><summary type='text'>If you are going to develop any game or decoder then you may experience this error. Today when i am developing an ASN decoder for our company i faced the error below:
Run-Time Check Failure #2 - Stack around the variable 'hexByte' was corrupted.

To develop my decoder first i need to develop a turbo C program. Then convert this code into a DLL. When i am calling the dll function from my C# </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/6256402865718998600/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/06/run-time-check-failure-2-stack-around.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/6256402865718998600'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/6256402865718998600'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/06/run-time-check-failure-2-stack-around.html' title='Run-Time Check Failure #2 - Stack around the variable &apos;hexByte&apos; was corrupted'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_DLLError.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-5077066492082014449</id><published>2010-06-03T03:28:00.000-07:00</published><updated>2010-06-03T03:28:15.796-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='C#'/><title type='text'>ERROR: Items collection cannot be modified when the DataSource property is set</title><summary type='text'>Basically we get this error when we try to add a data into the combobox after binding the combobox by using datasource property. If we use to bind data in this way comboBox1.Items.Add then we didn't get any error. But if we want to add data after binding then we will get below error:

Items collection cannot be modified when the DataSource property is set.



Screenshot is given below:



Lets </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/5077066492082014449/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/06/error-items-collection-cannot-be.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/5077066492082014449'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/5077066492082014449'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/06/error-items-collection-cannot-be.html' title='ERROR: Items collection cannot be modified when the DataSource property is set'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_ItemsCollectionNotFound.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-7147168273344550279</id><published>2010-05-30T03:17:00.000-07:00</published><updated>2010-06-03T03:28:55.282-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='C#'/><category scheme='http://www.blogger.com/atom/ns#' term='Oracle'/><title type='text'>Insert bulk data into oracle using SQLLoader in C#</title><summary type='text'>Sometimes we need to insert a large volume of data into the Oracle database. Sometimes data comes from comma seperated csv file or from a comma seperated text file. By reading this article you can insert data from both source to oracle. There are mainly two ways to insert bulk data into Oracle:
1. Using Bindarray
2. Using SqlLoader

Here in this article i will explain how one can use to insert </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/7147168273344550279/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/05/insert-bulk-data-into-oracle-using.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/7147168273344550279'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/7147168273344550279'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/05/insert-bulk-data-into-oracle-using.html' title='Insert bulk data into oracle using SQLLoader in C#'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_Oracle_Table.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-8671598064393231139</id><published>2010-05-16T23:34:00.000-07:00</published><updated>2010-05-16T23:34:07.368-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><category scheme='http://www.blogger.com/atom/ns#' term='Gridview'/><title type='text'>How to read hidden field data in GridView Asp.net C#</title><summary type='text'>In some cases developers need to collect more data instead of datakeynames. In that cases developers use hidden field to retain those important data. Here in this article i wil show how one can use hidden field to store some important data &amp; how can read those. For simplicity here i use a product table &amp; use ID in a hidden field to read them from server side SelectedIndexChanged event. The </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/8671598064393231139/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/05/how-to-read-hidden-field-data-in.html#comment-form' title='2 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/8671598064393231139'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/8671598064393231139'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/05/how-to-read-hidden-field-data-in.html' title='How to read hidden field data in GridView Asp.net C#'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_ProductTable.jpg' height='72' width='72'/><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-5006079170845192541</id><published>2010-05-13T08:57:00.000-07:00</published><updated>2010-05-13T09:04:01.464-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='sql server'/><title type='text'>Error: The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator</title><summary type='text'>When you google this error you will get a lots of solution. But no one help me to resolve my problem. So i am working on this issue to find out my solution &amp; finally i got a simple problem which i want to share with you. My situation is i have a link server (SQL Server 2008) with my working Sql server 2005. I have created a table in the link server means Sql server 2008 which is given below:


</summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/5006079170845192541/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/05/error-text-ntext-and-image-data-types.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/5006079170845192541'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/5006079170845192541'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/05/error-text-ntext-and-image-data-types.html' title='Error: The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_2008table.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-5650476351692429292</id><published>2010-05-11T23:07:00.000-07:00</published><updated>2010-05-11T23:08:15.126-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Jquery'/><title type='text'>Set alternate table row color using JQuery</title><summary type='text'>In many cases we need to represent data in tabular format so that user can easily read data in straightforward way. It will be more helpful for users if we can give or set different row color for alternate rows of the table to distinguish one row from another. To do that i have googled and found some examples. But each example will not consider the header row of the table. I need to color </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/5650476351692429292/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/05/set-alternate-table-row-color-using.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/5650476351692429292'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/5650476351692429292'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/05/set-alternate-table-row-color-using.html' title='Set alternate table row color using JQuery'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_JQuery_Alternaterow.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-96302298251828550</id><published>2010-05-11T01:42:00.000-07:00</published><updated>2010-05-11T01:42:24.872-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Jquery'/><title type='text'>How to get set read TextBox value using JQuery</title><summary type='text'>As we knew that using javascript to read or get or set textbox value is easy but due to JQuery notation novice developers always make mistakes to read textbox value. Here in this article i will show you how one can get set read textbox value or textbox text using JQuery.








To run the example first add a page in your project. Then add three textboxes and one command button to do sum like </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/96302298251828550/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/05/how-to-get-set-read-textbox-value-using.html#comment-form' title='3 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/96302298251828550'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/96302298251828550'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/05/how-to-get-set-read-textbox-value-using.html' title='How to get set read TextBox value using JQuery'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_JQuery_SUM.jpg' height='72' width='72'/><thr:total>3</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-6856582974921230987</id><published>2010-05-10T22:42:00.000-07:00</published><updated>2010-05-10T22:42:46.169-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Jquery'/><title type='text'>How to declare JQuery variable &amp; What is JQuery $ sign symbol</title><summary type='text'>In my first article i have discussed on how to start JQuery in your asp.net application. Here in this article i will explain how one can declare simple JQuery variable as well as object type Jquery variable also i will explain what does it mean by Jquery $ sign.
At first What is variable:
In programming, a variable is a value that can change, depending on conditions or on information passed to </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/6856582974921230987/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/05/how-to-declare-jquery-variable-what-is.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/6856582974921230987'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/6856582974921230987'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/05/how-to-declare-jquery-variable-what-is.html' title='How to declare JQuery variable &amp; What is JQuery $ sign symbol'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-951555860768627810</id><published>2010-05-10T03:30:00.000-07:00</published><updated>2010-05-10T03:32:17.452-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Jquery'/><title type='text'>Introduction on using JQuery in Asp.net application</title><summary type='text'>In a single line jQuery is a fast, lightweight client side library that is CSS3 compliant and supports almost all browsers. The jQuery framework is extensible and very nicely handles DOM manipulations, CSS, AJAX, Events and Animations. By using JQuery you can dramatically reduce your client side code. Jquery code is completely separate from your HTML code. Around the world many JQuery gurus </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/951555860768627810/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/05/introduction-on-using-jquery-in-aspnet.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/951555860768627810'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/951555860768627810'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/05/introduction-on-using-jquery-in-aspnet.html' title='Introduction on using JQuery in Asp.net application'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_JQuery1.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-7614049602441483426</id><published>2010-05-09T23:01:00.000-07:00</published><updated>2010-05-10T03:34:02.567-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>Master page image path problem in asp.net C#</title><summary type='text'>As you knew that master page uses absolute image URL which cause problem to reference an image inside other folder. The problem occurs due to below reasons:

1. Master page is in the root folder
2. Images under another root folder
3. Aspx pages under another root folder

As a result you will get "Image not found" or "Image file path not exist" error.

Scenarios like below will help you to </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/7614049602441483426/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/05/master-page-image-path-problem-in.html#comment-form' title='6 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/7614049602441483426'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/7614049602441483426'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/05/master-page-image-path-problem-in.html' title='Master page image path problem in asp.net C#'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_Master_image.jpg' height='72' width='72'/><thr:total>6</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-1257592413248653187</id><published>2010-05-09T04:02:00.000-07:00</published><updated>2010-05-09T04:03:19.024-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>TreView control to display hierarchical data or group break down data or relational data in Asp.Net</title><summary type='text'>In most of the cases developers need to display Hierarchical data or group breakdown using TreeView control in Asp.Net. Most of the ways you can follow to display such type of group data or relational data or hierarchical data such as gridview, repeater control but if something related to navigational issues then I think TreeView control is the perfect control to display Hierarchical or group or </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/1257592413248653187/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/05/treview-control-to-display-hierarchical.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/1257592413248653187'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/1257592413248653187'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/05/treview-control-to-display-hierarchical.html' title='TreView control to display hierarchical data or group break down data or relational data in Asp.Net'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_Dept_Sub_tech.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-4263038881328992624</id><published>2010-05-04T03:00:00.000-07:00</published><updated>2010-05-04T03:01:33.406-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='MS Access'/><title type='text'>80040E14 - MS Access Syntax Error message</title><summary type='text'>You may face the "Error: 80040E14 - MS Access Syntax Error message" when you want to execute or run an Insert, Update, Delete or even Select statement. There were several types of error you may encounter like below:
1. Syntax error in FROM clause
2. Syntax error in INSERT INTO statement
3. Syntax error in UPDATE statement
4. Syntax error (missing operator) - caused by ' mark
5. Syntax error (</summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/4263038881328992624/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/05/80040e14-ms-access-syntax-error-message.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/4263038881328992624'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/4263038881328992624'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/05/80040e14-ms-access-syntax-error-message.html' title='80040E14 - MS Access Syntax Error message'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-2568137467045472676</id><published>2010-04-22T03:58:00.000-07:00</published><updated>2010-04-22T06:50:39.358-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>Runtime Add Dynamic DropdownList And Handle SelectedIndexChanged Event in ASP.NET C# VB.NET</title><summary type='text'>In most of the cases developers need to add dynamic controls in asp.net application using code behind or runtime. Here in this article I will explain how one can add dynamically Asp.Net Server side DropdownList control in runtime and assign or handle SelectedIndexChanged event in asp.net using C# and VB.NET. Most of the developers claims that dynamic controls loose data after postback. But if you</summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/2568137467045472676/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/04/runtime-add-dynamic-dropdownlist-and.html#comment-form' title='3 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/2568137467045472676'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/2568137467045472676'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/04/runtime-add-dynamic-dropdownlist-and.html' title='Runtime Add Dynamic DropdownList And Handle SelectedIndexChanged Event in ASP.NET C# VB.NET'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_Dynamic_DropdownList.jpg' height='72' width='72'/><thr:total>3</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-6913817067809819664</id><published>2010-04-20T04:57:00.000-07:00</published><updated>2010-04-22T06:54:39.212-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><category scheme='http://www.blogger.com/atom/ns#' term='Gridview'/><title type='text'>Runtime Dynamically Creating Bound and Template Columns in GridView using Asp.net C#</title><summary type='text'>In some complex scenarios developers need to create runtime GridView dynamically. So obviously developers need to create dynamic columns for dynamic gridviews. Here in this article I will explain how one can develop or implement runtime dynamically create bound column as well as template column of a GridView control and also how to bind data into the dynamically created GridView. For simplicity </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/6913817067809819664/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/04/runtime-dynamically-creating-bound-and.html#comment-form' title='5 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/6913817067809819664'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/6913817067809819664'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/04/runtime-dynamically-creating-bound-and.html' title='Runtime Dynamically Creating Bound and Template Columns in GridView using Asp.net C#'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_Dynamic_GridView.jpg' height='72' width='72'/><thr:total>5</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-1280089273230838975</id><published>2010-04-20T01:10:00.000-07:00</published><updated>2010-04-22T06:59:49.883-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><category scheme='http://www.blogger.com/atom/ns#' term='Gridview'/><title type='text'>Sort Sorting GridView control Manually in Asp.net C#</title><summary type='text'>Asp.net SqlDataSource control ease our lives because if you are using SqlDataSource control to bind a GridView control then no need to sorting gridview or paging gridview control since you will achieve it automatically. But if you are using different datasource like Datatable, DataSet then you need to GridView sorting manually. Here in this article I will show you how you can develop GridView </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/1280089273230838975/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/04/sort-sorting-gridview-control-manually.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/1280089273230838975'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/1280089273230838975'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/04/sort-sorting-gridview-control-manually.html' title='Sort Sorting GridView control Manually in Asp.net C#'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-3793386354206162568</id><published>2010-04-19T05:33:00.000-07:00</published><updated>2010-04-19T05:33:26.286-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>Get all running Sql Server instances name within network using Asp.Net C# vB.Net</title><summary type='text'>Basically who did sql server operational job in any organization sometimes requires to get all running sql server instances name. Here in this asp.net C# VB.Net article i will give you a simple code snippet how you can achieve this. After running my sample code you will get all running sql server instances in your Local Area Network (LAN)/Network even from your local PC like below:


To run the </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/3793386354206162568/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/04/get-all-running-sql-server-instances.html#comment-form' title='3 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/3793386354206162568'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/3793386354206162568'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/04/get-all-running-sql-server-instances.html' title='Get all running Sql Server instances name within network using Asp.Net C# vB.Net'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_Sqlserver_Instance.jpg' height='72' width='72'/><thr:total>3</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-3867390851323872310</id><published>2010-04-18T03:42:00.000-07:00</published><updated>2010-04-18T03:42:37.878-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>How to bind Menu control with XML file in Asp.net C# VB.Net</title><summary type='text'>Now developers uses Asp.Net Menu Control as a navigation control. Using this control one can build the navigation system of a website very dynamically. Simply by using this menu control you can create Even complex navigation. It gives us a lot of inbuilt feature like collapse completely or expanded completely. You can also make a navigation down to any level. This Menu Control is very useful when</summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/3867390851323872310/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/04/how-to-bind-menu-control-with-xml-file.html#comment-form' title='2 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/3867390851323872310'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/3867390851323872310'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/04/how-to-bind-menu-control-with-xml-file.html' title='How to bind Menu control with XML file in Asp.net C# VB.Net'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_Menu_XmlDatasource.jpg' height='72' width='72'/><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-544561951565535550</id><published>2010-04-18T01:44:00.000-07:00</published><updated>2010-04-21T01:48:16.272-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><category scheme='http://www.blogger.com/atom/ns#' term='Gridview'/><title type='text'>GridView paging manually in Asp.net C#</title><summary type='text'>GridView paging will be required when data volume is higher. If you are using SqlDataSource control to bind a gridview control then no need to paging gridview because you will achieve it automatically. But if you use different datasource then you need to do mannual paging. To enable paging in gridview control at first set the AllowPaging="true" and also define the page size by PageSize="3". In </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/544561951565535550/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/04/gridview-paging-manually-in-aspnet-c.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/544561951565535550'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/544561951565535550'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/04/gridview-paging-manually-in-aspnet-c.html' title='GridView paging manually in Asp.net C#'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_GridView_paging_1.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-8633889269403956754</id><published>2010-04-17T01:09:00.000-07:00</published><updated>2010-04-17T01:13:04.141-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><category scheme='http://www.blogger.com/atom/ns#' term='XML'/><title type='text'>How to bind XML file in a TreeView control using Asp.net C#</title><summary type='text'>By using Asp.net TreeView control we can give enhanced UI experience to the user. We can specially use TreeView control to display hierarchical data like MLM tree, Sitemap. We can bind data into the TreeView control from database self referencial table as well as from a XML file. Here in this article or tutorial i am going to explain how one can bind XML data into a TreeView control as well as we</summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/8633889269403956754/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/04/how-to-bind-xml-file-in-treeview.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/8633889269403956754'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/8633889269403956754'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/04/how-to-bind-xml-file-in-treeview.html' title='How to bind XML file in a TreeView control using Asp.net C#'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_DefineXMLDatatSource1.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-6240433092318792928</id><published>2010-04-15T04:10:00.000-07:00</published><updated>2010-04-15T04:11:45.881-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Crystal Report'/><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>How to pass set Crystal Report Parameter value from asp.net c# in runtime</title><summary type='text'>When you design a crystal report most of the time you need to use crstal report parameter specially to design report header. Like you are going to ouptut a report which contains a ceratin date data or may date range data. SO that you need to write the date range or date to specify the report data date. In this scenario you need to use Crystal report parameter because the data you will bind, may </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/6240433092318792928/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/04/how-to-pass-set-crystal-report.html#comment-form' title='4 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/6240433092318792928'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/6240433092318792928'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/04/how-to-pass-set-crystal-report.html' title='How to pass set Crystal Report Parameter value from asp.net c# in runtime'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_Parameter1.jpg' height='72' width='72'/><thr:total>4</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-323006955463219496</id><published>2010-04-15T04:03:00.001-07:00</published><updated>2010-04-15T04:05:52.783-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>Get the Time Difference Between Two Date Time in ASP.NET C# VB.Net</title><summary type='text'>In some cases ASP.NET C# VB.Net developers need to find out Time Difference or timediff method or timediff function to get the time between two Time. Here in this article i will show you how you can achieve this:












C# Code:
protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            DateTime dtFrom;
            DateTime dtTo;
            </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/323006955463219496/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/04/get-difference-between-two-date-time-in.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/323006955463219496'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/323006955463219496'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/04/get-difference-between-two-date-time-in.html' title='Get the Time Difference Between Two Date Time in ASP.NET C# VB.Net'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-4232364652950297898</id><published>2010-04-15T03:58:00.000-07:00</published><updated>2010-04-15T04:01:11.222-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>Best way to pass multiple query string value from one page to another page with Response.Redirect method</title><summary type='text'>In most of the cases developers need to pass more than one or multiple query string value from one page to another page. Here in this example i will show you how one can pass multiple values from one page to another page in an efficient way. Let I have a product row and want to send product data from one page to another page so the code will looks like:









protected void Page_Load(object </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/4232364652950297898/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/04/best-way-to-pass-multiple-query-string.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/4232364652950297898'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/4232364652950297898'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/04/best-way-to-pass-multiple-query-string.html' title='Best way to pass multiple query string value from one page to another page with Response.Redirect method'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-2251319277711062630</id><published>2010-04-15T03:50:00.000-07:00</published><updated>2010-04-15T03:53:28.037-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>Unable to evaluate expression because the code is optimized or a native frame is on top of the call stack</title><summary type='text'>Error: 
Unable to evaluate expression because the code is optimized or a native frame is on top of the call stack

Reason/Root Cause:
When we call Response.Redirect("") to redirect an aspx page to another aspx page from try/catch block in asp.net code, you will receive the above error.










Sample error code:
protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)</summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/2251319277711062630/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/04/unable-to-evaluate-expression-because.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/2251319277711062630'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/2251319277711062630'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/04/unable-to-evaluate-expression-because.html' title='Unable to evaluate expression because the code is optimized or a native frame is on top of the call stack'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-1773290928496286883</id><published>2010-04-13T10:31:00.000-07:00</published><updated>2010-04-13T10:35:43.257-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>Runtime Add Dynamic Button And Handle Click Event in ASP.NET C# VB.NET</title><summary type='text'>In most of the cases developers need to add dynamic controls in asp.net application using code behind or runtime. Here in this article i will explain how one can add dynamic Asp.Net Server side Button in runtime and assign or handle click event in asp.net using C# and VB.NET.
To add a asp.net server side button control when page is loaded. We need to write the below code segment under page_Load </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/1773290928496286883/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/04/runtime-add-dynamic-button-and-handle.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/1773290928496286883'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/1773290928496286883'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/04/runtime-add-dynamic-button-and-handle.html' title='Runtime Add Dynamic Button And Handle Click Event in ASP.NET C# VB.NET'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-8973638450010479577</id><published>2010-04-13T10:10:00.000-07:00</published><updated>2010-04-13T10:24:36.736-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Others'/><category scheme='http://www.blogger.com/atom/ns#' term='Windows XP'/><title type='text'>Error: Cannot delete file because it's being used by another person or program</title><summary type='text'>Sometimes you may getting the error when attempting to delete a file which is used by another program or user. In this case you can not rename,move or delete this file or folder.
The error like:
Cannot remove folder xxxxxx: It is being used by another person or program.Close any programs that might be using the file and try again.

And the screen like below:


Solution:
1. Try to findout which </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/8973638450010479577/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/04/error-cannot-delete-file-because-its.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/8973638450010479577'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/8973638450010479577'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/04/error-cannot-delete-file-because-its.html' title='Error: Cannot delete file because it&apos;s being used by another person or program'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_Remove_delete_file.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-2848374122732828897</id><published>2010-04-13T10:03:00.000-07:00</published><updated>2010-04-13T10:03:07.232-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Others'/><title type='text'>How to import data from Excel file to Oracle table using toad</title><summary type='text'>In some cases developers need to import excel file date into a oracle table. Here in this article i will explain step by step how one can import excel data into oracle table using TOAD.

The following are the steps to follow import data from Excel sheet to a Oracle Table:

First the Table must exist with the same or equal number of colums as that in the excell sheet.
Now from TOAD go to:
1. </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/2848374122732828897/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/04/how-to-import-data-from-excel-file-to.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/2848374122732828897'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/2848374122732828897'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/04/how-to-import-data-from-excel-file-to.html' title='How to import data from Excel file to Oracle table using toad'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-9213402771026063150</id><published>2010-04-12T09:05:00.000-07:00</published><updated>2010-04-12T09:05:50.561-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='javascript'/><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>Add to Favorites (IE) / Bookmark (Mozilla Firefox, Opera) Page Javascript</title><summary type='text'>Developers basically use shortcut command to add a page into favorite list or bookmark list but most of the users does not know how they can add an important page into their favorite list or bookmark list. Thats why if developer add a bookmark link or add to favorite link on important pages so that users can easily bookmark the page. Here in this article i will explain how one can add favorites </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/9213402771026063150/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/04/add-to-favorites-ie-bookmark-mozilla.html#comment-form' title='2 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/9213402771026063150'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/9213402771026063150'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/04/add-to-favorites-ie-bookmark-mozilla.html' title='Add to Favorites (IE) / Bookmark (Mozilla Firefox, Opera) Page Javascript'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_Bookmark_Add_toFavorites.jpg' height='72' width='72'/><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-2648148005115773517</id><published>2010-04-11T00:54:00.000-07:00</published><updated>2010-04-11T09:57:07.954-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><category scheme='http://www.blogger.com/atom/ns#' term='Ajax'/><title type='text'>Ajax to update GridView after certain interval using Asp.net C#</title><summary type='text'>In most of the cases like Dashboard developers often need to update GridView data after certain interval. In this Asp.Net article i am going to discuss Updating GridView using AJAX. To do that first create a new aspx page in your project. Then drag and drop the below controls within the page.
1. ScriptManager
2. UpdatePanel
3. GridView
4. Timer







Now your aspx HTML markup looks like below:
&lt;</summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/2648148005115773517/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/04/ajax-to-update-gridview-after-certain.html#comment-form' title='4 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/2648148005115773517'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/2648148005115773517'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/04/ajax-to-update-gridview-after-certain.html' title='Ajax to update GridView after certain interval using Asp.net C#'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>4</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-6586065460607027915</id><published>2010-03-25T06:07:00.000-07:00</published><updated>2010-03-25T06:08:39.928-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>Failed to access IIS metabase ASP.NET 1.1 2.0 3.5 Web Server Error</title><summary type='text'>After installing IIS server when you browsing Asp.net web site or an asp.net aspx page in IIS server then you may getting or encounter an error named "Failed to access IIS metabase".

Error Description: 
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception</summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/6586065460607027915/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/03/failed-to-access-iis-metabase-aspnet-11.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/6586065460607027915'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/6586065460607027915'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/03/failed-to-access-iis-metabase-aspnet-11.html' title='Failed to access IIS metabase ASP.NET 1.1 2.0 3.5 Web Server Error'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_Metabase_Error.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-6859758965075674061</id><published>2010-03-25T03:07:00.000-07:00</published><updated>2010-04-11T09:59:34.209-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>Bind Enum Types to a DropdownList control in asp.net C#</title><summary type='text'>In some cases we need to bind Enum data into a DropdownList. So in this article or tutorial i will explain "How one can bind enum into a DropdownList in Asp.net". After searching a lot of time i found all codes are inline but i want to control enum from a single class. So that i can manage enums from a single file. As a developer we need enum in most cases like Status,Type etc. So that i want to </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/6859758965075674061/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/03/bind-enum-types-to-dropdownlist-control.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/6859758965075674061'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/6859758965075674061'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/03/bind-enum-types-to-dropdownlist-control.html' title='Bind Enum Types to a DropdownList control in asp.net C#'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_Bind_Enum.png' height='72' width='72'/><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-5370190716680732933</id><published>2010-03-10T00:22:00.000-08:00</published><updated>2010-04-11T23:00:22.592-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>How to Run Time Dynamically Build ConnectionString in Asp.Net</title><summary type='text'>Asp.net gives developers a class to build runtime dynamically connectionstring named SqlConnectionStringBuilder. Here in this article I will show you by an example. Please have a look at the below code example which will help you to understand how one can build dynamically connectionstring with less error possibilities.













Code Example:
using System;
using System.Data;
using </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/5370190716680732933/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/03/how-to-run-time-dynamically-build.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/5370190716680732933'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/5370190716680732933'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/03/how-to-run-time-dynamically-build.html' title='How to Run Time Dynamically Build ConnectionString in Asp.Net'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-5669409316795256205</id><published>2010-03-09T22:42:00.000-08:00</published><updated>2010-03-09T22:45:04.941-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='javascript'/><title type='text'>How to Show hide toggle display a DIV using javascript</title><summary type='text'>In many cases developers need to show hide or toggle div container based on user requirement. Some of SEO specialists told that hiding a div is against SEO. But I want to tell that if your div appear with unchanged contents by user interaction then it’s ok for SEO. In many cases like you want to display a popup type window (which is basically a div) then you need to show or hide a div. Here in </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/5669409316795256205/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/03/how-to-show-hide-toggle-display-div.html#comment-form' title='2 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/5669409316795256205'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/5669409316795256205'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/03/how-to-show-hide-toggle-display-div.html' title='How to Show hide toggle display a DIV using javascript'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_Display.jpg' height='72' width='72'/><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-4654968995811455245</id><published>2010-03-09T02:50:00.000-08:00</published><updated>2010-04-11T22:58:40.160-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Crystal Report'/><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>Runtime dynamically bind data into a crystal report using Asp.net C#</title><summary type='text'>Reporting is the most sensitive part of any database driven application. Without reporting system never completed. Fortunately we found again crystal report with Asp.net which ease our life as well as reduce a lot of coding. Now we just by drag and drop can create a report within a minute. This is true that from other reporting services, crystal report is the powerful and most popular reporting </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/4654968995811455245/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/03/runtime-dynamically-bind-data-into.html#comment-form' title='9 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/4654968995811455245'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/4654968995811455245'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/03/runtime-dynamically-bind-data-into.html' title='Runtime dynamically bind data into a crystal report using Asp.net C#'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_Add_CrystalReport.jpg' height='72' width='72'/><thr:total>9</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-5388488922150341212</id><published>2010-03-08T00:55:00.000-08:00</published><updated>2010-03-08T00:56:41.893-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='javascript'/><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>Display Original Image Size in new or popup window when clicking on the thumbnail Image using javascript</title><summary type='text'>In many cases like photo album application or e-commerce website product display page or e-commerce shopping cart we need to display thumbnail image first and then when user click on this image we want to show the full or original image in a popup window. In this article i will explain how one can display a full or enlarge or zoom image from thumbnail image. The output likes below:


To do that </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/5388488922150341212/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/03/display-original-image-size-in-new-or.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/5388488922150341212'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/5388488922150341212'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/03/display-original-image-size-in-new-or.html' title='Display Original Image Size in new or popup window when clicking on the thumbnail Image using javascript'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_Thumbnail_Flower.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-2561125536596484843</id><published>2010-03-07T22:36:00.000-08:00</published><updated>2010-04-11T22:57:06.806-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>How To Get Number of Days or Date Difference between two Dates in C# Asp.Net</title><summary type='text'>In case of date time calculation from front end we need to find out the days difference between two given dates by user. Dates may come from dtpicker or from calendar control whatever we will use asp.net built in subtract method to identified the number of days or date difference between two dates. In this article i will show you to identify datediff between two dates in both C# and Vb.Net front </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/2561125536596484843/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/03/how-to-get-number-of-days-or-date.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/2561125536596484843'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/2561125536596484843'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/03/how-to-get-number-of-days-or-date.html' title='How To Get Number of Days or Date Difference between two Dates in C# Asp.Net'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-438768033498975838</id><published>2010-03-07T04:03:00.000-08:00</published><updated>2010-04-11T10:11:07.602-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='javascript'/><title type='text'>How to detect tab key is pressed by user in javascript</title><summary type='text'>In many times we need to check or detect Tab key from cross browser javascript method to implement some business logic. In this regard here i want to show you how one can detect that user pressed or enter Tab key. One can also detect the TAB key to cancel the action. So you can do lots of work based on checking TAB key depends on user or client requirement.
Keep in mind one thing that TAB Key </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/438768033498975838/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/03/how-to-detect-tab-key-is-pressed-in.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/438768033498975838'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/438768033498975838'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/03/how-to-detect-tab-key-is-pressed-in.html' title='How to detect tab key is pressed by user in javascript'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-778830547280557234</id><published>2010-03-04T00:19:00.000-08:00</published><updated>2010-03-04T00:19:45.745-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>Run-time Error: Control 'controlname' of type 'Button' 'TextBox' 'GridView' 'CheckBox' must be placed inside a form tag with runat=server</title><summary type='text'>I found this error in Asp.Net when i am trying to add a control dynamically in the page. The error is Control 'controlname' of type 'Button' must be placed inside a form tag with runat=server. The error comes when you trying to add the control like GridView, Button, TextBox, RadioButton, RadioButtonList, CheckBox, CheckBoxList out side the form tag of your aspx page in runtime or dynamically. </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/778830547280557234/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/03/run-time-error-control-controlname-of.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/778830547280557234'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/778830547280557234'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/03/run-time-error-control-controlname-of.html' title='Run-time Error: Control &apos;controlname&apos; of type &apos;Button&apos; &apos;TextBox&apos; &apos;GridView&apos; &apos;CheckBox&apos; must be placed inside a form tag with runat=server'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_inside_form_error.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-6155216844928799066</id><published>2010-03-02T22:53:00.000-08:00</published><updated>2010-04-11T11:12:34.702-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='sql server'/><title type='text'>Set a database to read only mode using SQL Server 2005 / 2008</title><summary type='text'>In most DBA or Database Administration purpose we need to set a Database to readonly mode. Here i will show you how you can set Database in Read Only mode for Sql server 2005 &amp; Sql Server 2008. One thing keep in mind that you can not use same sql command for both sql server 2005 and 2008. Thats why here i will show the different ways to manage a Database to Read Only mode.
The another important </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/6155216844928799066/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/03/set-database-to-read-only-mode-using.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/6155216844928799066'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/6155216844928799066'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/03/set-database-to-read-only-mode-using.html' title='Set a database to read only mode using SQL Server 2005 / 2008'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_readonly_db.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-8831605110272960737</id><published>2010-03-02T00:30:00.000-08:00</published><updated>2010-03-02T00:33:03.314-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='javascript'/><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>WaterMark in ASP.Net TextBox Multiline TextBox TextArea using JavaScript</title><summary type='text'>Basically developers use watermark textbox to give a small hint to the user to input valid or meaningfull data. We found a lot of way to watermark a TextBox using Javascript but in this article or tutorial i will explain a very simple and easy way to implement watermark in textbox / textarea / multiline TextBox. A sample output is given below:


The main javascript method to implement watermark </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/8831605110272960737/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/03/watermark-in-aspnet-textbox-multiline.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/8831605110272960737'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/8831605110272960737'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/03/watermark-in-aspnet-textbox-multiline.html' title='WaterMark in ASP.Net TextBox Multiline TextBox TextArea using JavaScript'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_watermark_textbox.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-573732806198234553</id><published>2010-02-25T04:11:00.000-08:00</published><updated>2010-04-11T22:54:57.609-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><category scheme='http://www.blogger.com/atom/ns#' term='Gridview'/><title type='text'>Efficient best Syntax to Open a SqlConnection in Asp.Net 2.0 3.5</title><summary type='text'>To describe the best way to open sql server connection in asp.net here i am choosing to bind the gridview because in most of the cases the major task is to bind GridView data. You can make more generous method to collect sql server data but here my intension is to show you how you can open sql server connection efficiently.












Please have a look at the code sample:
protected void </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/573732806198234553/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/02/efficient-best-syntax-to-open.html#comment-form' title='2 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/573732806198234553'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/573732806198234553'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/02/efficient-best-syntax-to-open.html' title='Efficient best Syntax to Open a SqlConnection in Asp.Net 2.0 3.5'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-8438153953894171152</id><published>2010-02-25T03:03:00.000-08:00</published><updated>2010-04-11T22:54:00.128-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='sql server'/><title type='text'>Kick expire close all user connection from Sql Server 2005 / 2008 Database</title><summary type='text'>In some cases DBA's need to expire or close all connections from SQL server 2005 / SQL server 2008 database such as for attach detach DataBase, Make DB readonly, perform maintenance tasks etc. For such type of issues DBA wants to get exclusive access to the database. To do so, you can set the database to Single User Mode, which permits only one database connection at a time. At that moment if </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/8438153953894171152/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/02/kick-expire-close-all-user-connection.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/8438153953894171152'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/8438153953894171152'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/02/kick-expire-close-all-user-connection.html' title='Kick expire close all user connection from Sql Server 2005 / 2008 Database'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-3807701682656932040</id><published>2010-02-24T03:07:00.000-08:00</published><updated>2010-02-24T03:09:46.843-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><category scheme='http://www.blogger.com/atom/ns#' term='Gridview'/><title type='text'>How To get RowIndex of Asp.Net GridView in the RowCommand Event</title><summary type='text'>As we know that if we add any button control or image button control or link button within the GridView and click to generate postback event then GridView RowCommand Event will fire. But the problem is from this RowCommand method we did not easily get the cliclked or selected GridView row index number. To get the RowIndex of Asp.Net GridView in the RowCommand Event we have two options.
1. Using </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/3807701682656932040/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/02/how-to-get-rowindex-of-aspnet-gridview.html#comment-form' title='3 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/3807701682656932040'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/3807701682656932040'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/02/how-to-get-rowindex-of-aspnet-gridview.html' title='How To get RowIndex of Asp.Net GridView in the RowCommand Event'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_RowCommand_RowIndex.jpg' height='72' width='72'/><thr:total>3</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-2964765721042007473</id><published>2010-02-24T00:11:00.000-08:00</published><updated>2010-02-24T00:11:44.119-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>ERROR: The process cannot access the file because it is being used by another process</title><summary type='text'>In most of the cases specially in image manipulation time developers faced an error like:The process cannot access the file because it is being used by another process.
The error happened because when you try to access an object of image or Font just immediately after you use it. Because the dot net framework does not destroy the resource before you calling. To resolve this problem you have to </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/2964765721042007473/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/02/error-process-cannot-access-file.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/2964765721042007473'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/2964765721042007473'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/02/error-process-cannot-access-file.html' title='ERROR: The process cannot access the file because it is being used by another process'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-6309972934872974027</id><published>2010-02-23T02:14:00.001-08:00</published><updated>2010-04-11T22:52:13.931-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>Convert DataTable to DataView in Asp.net C# in VS 2008</title><summary type='text'>The following sample code will demonstrate the convertion from DataTable to DataView in C# in VS 2008. 
In VS 2008, DataView have one method which accept datatable as input parameter and it return the converted result as dataview by using DataView(). Ok now look at the converting DataTable to DataView example code:










protected void Page_Load(object sender, EventArgs e)
    {
        if (!</summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/6309972934872974027/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/02/convert-datatable-to-dataview-in-aspnet.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/6309972934872974027'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/6309972934872974027'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/02/convert-datatable-to-dataview-in-aspnet.html' title='Convert DataTable to DataView in Asp.net C# in VS 2008'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-3725552517304940946</id><published>2010-02-23T02:12:00.001-08:00</published><updated>2010-04-11T22:51:07.893-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>How to convert SqlDataReader or DataReader to DataSet in Asp.Net</title><summary type='text'>In some cases most of the asp.net C# vb.net developers need to convert or converting SqlDataReader or DataReader to a DataSet to meet some technical challenges. Here i will show you converting SqlDataReader to a DataSet in a simple way. The code sample is given below:












protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string sql =</summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/3725552517304940946/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/02/how-to-convert-sqldatareader-or_23.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/3725552517304940946'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/3725552517304940946'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/02/how-to-convert-sqldatareader-or_23.html' title='How to convert SqlDataReader or DataReader to DataSet in Asp.Net'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-1766354181071565035</id><published>2010-02-23T02:10:00.000-08:00</published><updated>2010-04-11T22:47:19.452-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>How to convert SqlDataReader or DataReader to DataTable in Asp.Net</title><summary type='text'>In many cases we need to convert or converting SqlDataReader or DataReader to a DataTableto meet some technical challenges. Here i will show you converting SqlDataReader to a DataTable in a simple way. The code sample is given below:













protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string sql = "SELECT B.Name [Brand Name],</summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/1766354181071565035/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/02/how-to-convert-sqldatareader-or.html#comment-form' title='2 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/1766354181071565035'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/1766354181071565035'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/02/how-to-convert-sqldatareader-or.html' title='How to convert SqlDataReader or DataReader to DataTable in Asp.Net'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-8325324174550860293</id><published>2010-02-22T01:06:00.000-08:00</published><updated>2010-04-11T22:46:27.996-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='javascript'/><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><category scheme='http://www.blogger.com/atom/ns#' term='Gridview'/><title type='text'>How to read GridView row column data using javascript</title><summary type='text'>In some cases we need to read GridView row column data using javascript specially for search purpose. Also there were lots of reason to read GridView data using javascript. If you can read gridview data from a javascript function then you can implement lot of eye catching interface for your client.
The below javascript function wiil read gridview contents or loop through gridview rows:









</summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/8325324174550860293/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/02/how-to-read-gridview-row-column-data.html#comment-form' title='2 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/8325324174550860293'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/8325324174550860293'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/02/how-to-read-gridview-row-column-data.html' title='How to read GridView row column data using javascript'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_Gridview_read_javascript.jpg' height='72' width='72'/><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-4436234965974051077</id><published>2010-02-18T03:37:00.000-08:00</published><updated>2010-04-11T22:45:31.086-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>Check user internet connectivity using Asp.Net C#</title><summary type='text'>In some cases specially for AJAX projects Asp.net C# VB.Net developers need to check user internet connection before attempting to connect to remote server. Also another important usage is for dashboard where after certain time interval you may need to know does the user connected with the network or not. Here in this article i will describe how one can find user internet connectivity using </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/4436234965974051077/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/02/check-user-internet-connectivity-using.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/4436234965974051077'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/4436234965974051077'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/02/check-user-internet-connectivity-using.html' title='Check user internet connectivity using Asp.Net C#'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_InternetConnection.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-1450869133307089461</id><published>2010-02-17T00:42:00.000-08:00</published><updated>2010-04-11T22:43:45.209-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>How to get readonly textbox value in codebehind or CS file</title><summary type='text'>As we know that when we declare a textbox as readonly then we didnot get value from that readonly textbox from code file. Because asp.net rejects any changes in readonly textbox after postback. Here in this article i will describe ASP.NET Read Only TextBox lose client side changes, values across post back? Why Readonly Text box values are empty in code behind ? Issue in Retrieving textbox value </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/1450869133307089461/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/02/how-to-get-readonly-textbox-value-in.html#comment-form' title='14 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/1450869133307089461'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/1450869133307089461'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/02/how-to-get-readonly-textbox-value-in.html' title='How to get readonly textbox value in codebehind or CS file'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_readonly_textbox.jpg' height='72' width='72'/><thr:total>14</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-9164831748822436654</id><published>2010-02-16T04:32:00.000-08:00</published><updated>2010-02-16T04:33:59.933-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><category scheme='http://www.blogger.com/atom/ns#' term='Gridview'/><title type='text'>How to Loop through GridView Rows Asp.net C#</title><summary type='text'>This is a small tips for asp.net C# vb.net novice developers. We can loop through GridView rows using two ways:

1. Use GridViewRow class to loop through or navigate the GridView rows from outsite the GridView control's event.

2. Use general for loop based on GridView Rowcount method.

In this article i will generate the following interface:


Loop through GridView rows using GridViewRow class:
</summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/9164831748822436654/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/02/how-to-loop-through-gridview-rows.html#comment-form' title='3 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/9164831748822436654'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/9164831748822436654'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/02/how-to-loop-through-gridview-rows.html' title='How to Loop through GridView Rows Asp.net C#'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_GridView_Loop.jpg' height='72' width='72'/><thr:total>3</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-8814169203929155643</id><published>2010-02-16T03:35:00.000-08:00</published><updated>2010-02-16T03:35:09.711-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Others'/><title type='text'>How to Set Internet Explorer IE as Default Browser</title><summary type='text'>Do you really like internet explorer? If yes and plan to use it for all of your Internet browsing needs, you have to consider making internet explorer or IE as your default browser. Basically it was happen when you install more than one browser than you may dont get Internet Explorer as your default browser. Here in this article i will show you how one can set internet explorer as his deafult </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/8814169203929155643/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/02/how-to-set-internet-explorer-ie-as.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/8814169203929155643'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/8814169203929155643'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/02/how-to-set-internet-explorer-ie-as.html' title='How to Set Internet Explorer IE as Default Browser'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_IE.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-6583245808609568709</id><published>2010-02-08T00:05:00.000-08:00</published><updated>2010-02-08T00:05:53.716-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Technology'/><category scheme='http://www.blogger.com/atom/ns#' term='Others'/><title type='text'>Apple rainbow logo t-shirt</title><summary type='text'>Anything with Apple is going to be a hit at the moment. This T Shirt has a cool image of the enterprise but it is much more than that, as this has a flashing logo not fixed. Means this logo is lives!!

See here:


Specification:
The T-Qualizer is made from 100% cotton.
1 x Battery pack and sound sensor.
Panel is powered by a detachable battery pack.
The battery pack can be unplugged for washing </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/6583245808609568709/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/02/apple-rainbow-logo-t-shirt.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/6583245808609568709'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/6583245808609568709'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/02/apple-rainbow-logo-t-shirt.html' title='Apple rainbow logo t-shirt'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_apple_light_tshirt.gif' height='72' width='72'/><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-1588543436320345009</id><published>2010-02-07T05:33:00.000-08:00</published><updated>2010-02-07T05:35:24.191-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='javascript'/><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>How to disable multiple button click in Asp.net</title><summary type='text'>Disabling or preventing multiple mouse button click event on Asp.net page is a common task. Specially when you want to develop an e-commerce site client must want to disable the payment button after first click of the user. So that user can't click twice or double or multiple time.Normally we have used an onclick javascript event to diable the button after first click. In Asp.net each serverside </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/1588543436320345009/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/02/how-to-disable-multiple-button-click-in.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/1588543436320345009'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/1588543436320345009'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/02/how-to-disable-multiple-button-click-in.html' title='How to disable multiple button click in Asp.net'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_Disable_multiple_click.jpg' height='72' width='72'/><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-5798785204800174994</id><published>2010-02-07T04:06:00.000-08:00</published><updated>2010-02-07T04:06:28.569-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>How to validate Integer Decimal Double DateTime values in Asp.Net C#</title><summary type='text'>In most cases asp.net C# VB.Net developers need to check or validate user input for integer, decimal &amp; DateTime. Asp.net C# provides us an easy way to validate those user inputs from server side. Here in this small article i will show you how one can validate using Asp.Net. Basically TryParse boolean returntype method will help us to check user inputs. It Converts the specified string </summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/5798785204800174994/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/02/how-to-validate-integer-decimal-double.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/5798785204800174994'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/5798785204800174994'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/02/how-to-validate-integer-decimal-double.html' title='How to validate Integer Decimal Double DateTime values in Asp.Net C#'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_Validate_int_Datetime_decimal.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3669958512396381171.post-8486580714726626487</id><published>2010-02-05T03:22:00.000-08:00</published><updated>2010-02-05T03:22:48.006-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='javascript'/><category scheme='http://www.blogger.com/atom/ns#' term='asp.net(c#)'/><title type='text'>Javascript to check multiline textbox max length asp.net C# VB.Net</title><summary type='text'>Most of the asp.net developers knew that maxlength property of textbox will work even the multiline property set to true. But it doesnot work. To check or restrict maxlength of a multiline textbox you have to develop a javascript fucntion. In this article i will show you how you can limit or restrict multine textbox character limit using javascript.
If you are looking for textarea then click here</summary><link rel='replies' type='application/atom+xml' href='http://shawpnendu.blogspot.com/feeds/8486580714726626487/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://shawpnendu.blogspot.com/2010/02/javascript-to-check-multiline-textbox.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/8486580714726626487'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3669958512396381171/posts/default/8486580714726626487'/><link rel='alternate' type='text/html' href='http://shawpnendu.blogspot.com/2010/02/javascript-to-check-multiline-textbox.html' title='Javascript to check multiline textbox max length asp.net C# VB.Net'/><author><name>Shawpnendu</name><uri>http://www.blogger.com/profile/04469877202882577895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='http://1.bp.blogspot.com/_mXsCBD8mg94/Sl9DY88gXOI/AAAAAAAAAP0/x86JcDuUcd4/S220/Untitled-1.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i919.photobucket.com/albums/ad39/shawpnendu/MyBlog/th_Maxlenth_TextBox_multiline.jpg' height='72' width='72'/><thr:total>1</thr:total></entry></feed>
