Coding Stuffs

Export Gridview to PDF

2011-03-28T10:35:00.002+01:00

we have seen how to export the data from gridview to Excel file, today this post will helps you to export the gridview data to PDF, if you want protect you data being edit/ cut/ delete then Export to PDF will be a better option for you.there is a open source project for iTextShart. you can download the dll from them and you can use it.

only you need to add this content on your page

Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment; filename= SampleExport.pdf");
Response.End();

Even you can format the text also,if you want to set the page with A4 or any other even you can also do the same.you can also specify the font size, style color all the basic things you can do with it.

you can download the code from the below link. you can try that it will helps you.

download Source

how to add related posts on Blogger

2010-07-18T10:43:00.005+01:00

we have seen on most of the blogger site , "Related post" section is there after every post now you want to add this Related post / Similar post on your blog ? follow the below easy steps and configure you blogger accordingly.

Open blogger.com site

Go to Design section under that you will get Edit Html Tab just click on it.

now before making any changes on your xml file just take abackup for safty

just click on "Expand widget templates "

Add the below code above the </head > section or better way is search the keyword </head>

<script src='https://www.opendrive.com/files/6673148_cnSMd/RelatedPosts_Blogger.js' type='text/javascript'/>

now search for code <data:post.body/>

After this paste the below code line

<b:if cond='data:blog.pageType == "item"'>
<div id='related-posts'>
<font face='Arial' size='3'><b>Related Posts: </b></font><font color='#000000'><b:loop values='data:post.labels' var='label'><data:label.name/><b:if cond='data:label.isLast != "true"'>,</b:if><b:if cond='data:blog.pageType == "item"'>
<script expr:src='"/feeds/posts/default/-/" + data:label.name + "?alt=json-in-script&callback=related_results_labels&max-results=5"' type='text/javascript'/></b:if></b:loop> </font>
<script type='text/javascript'> removeRelatedDuplicates(); printRelatedLabels();
</script></div></b:if>

now on the above code you will see the red section line "max-results=xx" here you can enter no of post you want to see on your page
accordingly you can mention it.

now save you template and see the magic on your post

you will see the number of post after each article , before that you need to add label on your post. hope you like it

How strong name assemblies keep you out of DLL Hell

2010-06-11T06:49:00.002+01:00

while using Microsoft .NET framework for creating any application we are previously facing same problem with the DLL Hell. it arises a problem while updating a components so it breaks the other application which are depend on it. to overcome such a issues developer needs to implement the concept of Strong name .In this article you can through with how and why to use strong name .

Strong Name :
what is strong name? A Strong name is of information used to identify the assembly which may consist of Text-name , four part of version number , culture information , public key and the digital signature which may stored in a assembly manifest that get embedded on the file of the assembly.

By using the Strong name the CLR can assured that two assembly can be there with the same name. by the way strong name is basically provided the unique identification of the assembly. there are two scenarios in which the strong name can included in the assembly
1.Shared Assemblies
2. Serviced Components.

on the first case the shared assemblies can be used in the multiple application which may running on the same machine on GAC. and you may get the benefit ares:
1. Single Development
2. Bypass verification
3. Centralized update

yes as your getting such a good benefits then surely there is also a some issues on it that is
1.calling a private assemblies : if the shared assemblies can load with the type of private assembly then CRL will throw an Error because it reference only shared assemblies.
2. Trusting assemblies :
3. Installation issues :

How to create "Strong Name".
To create strong name for assembly you need a (al.exe) tool which is a assembly generation tool .now to create a key pair in the file you can use Strong name utility (Sn.exe) like this way.
Sn.exe -k filename.dat

The key file could be used on Al.exe to generate the strong name.
Al.exe /out:Input.dll /Keyfile:output.dat

Like this way you can design your strong name with the key. hope you get something from this
if you have any query on it plz post the reply.

my oracle interview experience

2010-04-25T06:08:00.002+01:00

hi friends,

last week i was attended "ORACLE financial services" interview for the .NET Developer post. Here i am sharing my experience on interview hope so it will help you while going for an Oracle Interview. i was disqualify from 3rd Round (Final Technical Round).

Interview Process:
There was 4 Round 1 st Online Test ( 47 Question 1 hrs ) but be careful there is also a negative marking as well as there is also a cutoff (if u select more than 1 answer and answer is wrong ) then again some deduction on your marks . Quite tough mostly Question on Assembly , Framework , C# , then hardly question on Datalist,Datagrid, Gridview and all basic. we totally 3 people get selected in first round out of 10.

Second Round is Technical Round. it was ok only basic question get ask during the interview , but in most of them are in-depth question just like on DataGrid DataBind() wht happen exactly , which function get executed at first onRowDataBound() or DataBind(). how .net life cycle will work on this process and all . i also got selected on this round .

now There was a Final Round on again Technical . There was 2 panelist in front of me and asking question on most of the SDLC (Software Development Life Cycle) and Question on backed on Pl-sql / SQL2005 . i thing around 15+ question get ask during the interview process i have answer most of them . but interview was cool .

at last there was an only final Round Remaining which is HR Round. but sorry to say friends i was disqualified from this process (2nd Technical Round). hope my this experience will help you to get it in ORACLE or any other software farm .because most of the time same process is there every where .

hope i will get good company out of this. better luck next time .but one thing is sure i am getting very good experience from this.

Jquery 1.4.1 released

2010-04-18T05:41:00.004+01:00

very good news to all the Jquery users and jquery lovers. the latest version of Jquery ( which is 1.4.1 has been released).it has lot of improvement on bases of performance , new additonal features and many new functions are added to make
jquery very popular. i really enjoy with the same. as you can see the execution time of realease version is very less in time as compare with the previous one.
here are the Minified and Regular version .

jQuery Minified (23kb minified version.)

jQuery Regular (154kb regular version)

You can download the js frem the above link.or you can take a advantage of Google CDN on : http://ajax.googleapis.com/ajax/libs/jquery/1.4/jquery.min.js
while using CDN one is very good idea , because if anything get change on current realease then it will automatically updated on your application ,. if your using Google CDN features , Microsoft is also providing the same kind of feature of CDN you can also take the help form there also.

on new release they have added methds like , Setter , Getter and many more ajax features. the Whole API Documentation you
can get it from here. http://api.jquery.com/category/version/1.4/

now guys why your waiting , just use latest version of Jquery on your application and make your application very cool and attractive .

Tips on Google Buzz

2010-03-17T10:41:00.002+01:00

on my previous post i was discuss on what is Google buzz , how you can add Google Buzz button on your Blogger / Wordpress. now on this article i am just discussing tips on Google Buzz , hope u enjoy this

1.Quick open Google Buzz
yes there are some keyboards shortkuts on gmail for opening google Buzz quickly, type g b from gmail view and Google Buzz will get open.
here are few more shortcuts.
m - mute
r- add comments
p/n - Go to new conversation
o -expand conversation
and so on.

2. Hide buzz Counter.
Now some time we dont want to view that google buzz counter on mail panal , now in this time you can remove that or hide that. Google has not given any facility to do so , but here is tricks to do this,
simple drag your lable (Buzz(3)) and and put this into More section . look at this image you will come to know

3. Subscribe Buzz feed

yes google posts each scrap to there user profile page. and you can open that by using orange icon display in your browser to subscribe a feed. it will looks this way
http://buzz.googleapis.com/feeds//public/posted

4.Add rich text

again this is a cool tricks on adding a rich text on your buzz message.
*bold message*
_italic message_
-deleted message-

5.View Photos in SlideShow Effects.

when ever you upload the images to the Google buzz , they basically added on Picasa albums, and when ever you clikc on that image it get open from there with the Light box effects , google has give that option that you can organize that photos according to your view and select the Slideshow option on it , then it get export those pics on picasa.

6.View Public Buzz message:

yes now you can search the public messages also with the help of google buzz. even though you can also restrict the
social connection on the buzz, that means you can protect your buzz while viewing to anyone else.
now how you can search it
author:@gmail.com : that means it will return all the buzz result with this email id. like this way
you can search it.
commenter:@gmail.com : this will search all the user that have given a comments .
has:photo, has:video, has:link : now here you can restrict the search just like if you enter has:photo that means only those result get sort out , those are hainvg photo in this buzz just like the videos and link and other

7 .Save searches

now not last but main useful feature is saving the search. what ever you have been search till time that get save automatically so later on also you can search it whtever search result your getting on previous search.

hope it will help you to make your buzz perfect , enjoy it happy buzzingg..

Add Google Buzz Button on Blogger

2010-03-08T10:02:00.004+01:00

now you can use google Buzz buttons to share your ideas , pics, videos, and many more just like the twitter does,here is my post on how to add twitter button on your site or blog.the same you can add it for your google buzz basically if u search on google you get the lots of search on how to add google buzz button on Word-press blog, its very easy to do so you need to download the plugin and install it on your server that's it. but now u can use same on blogger too ,
Please follow the steps to add the Google buzz button

1.Sign in on your blogger account
2.Go to Dashboard section - Layout and click on Edit HTML
3.and it will show you HTML code , now try to search the keyword
<div class='post-header-line-1'>
on it,

4.now below that you can paste this code , google buzz provides you two button one is bigger one
just like this and smaller one too , here is code for large button

<a href='javascript:var%20b=document.body;var%20GR________bookmarklet_domain="http://www.google.com";if(b&&!document.xmlVersion){void(z=document.createElement("script"));void(z.src="http://www.google.com/reader/ui/link-bookmarklet.js");void(b.appendChild(z));}else{}'> <img alt='Buzz this' src='http://img2.pict.com/15/da/3e/2809374/0/googlebuzz.png'/> </a>

which will looks like

5.and here is compact button code
<a href='javascript:var%20b=document.body;var%20GR________bookmarklet_domain="http://www.google.com";if(b&&!document.xmlVersion){void(z=document.createElement("script"));void(z.src="http://www.google.com/reader/ui/link-bookmarklet.js");void(b.appendChild(z));}else{}'> <img alt='Buzz this' src='http://img2.pict.com/9c/09/57/2854010/0/buzzthis.gif'/> </a>
which will looks like

6.now save the template and see how exactly it appering on blog.

hope this article is helpful for you , thank you. if you have any problem while adding plz leave a comment we will help you.

Microsoft AJAX CDN

2010-02-28T10:56:00.003+01:00

hi guys , on my last blog you have seen how microsoft ajax minifer get work and how its useful while developing a application. fine now one more great feature today i will discuss with you . that is ajax CDN (Content Delivery Network ), yes as the name suggested content get deliver on network, no need of updation of code and all auto m atically it get updated all over the world,

some time back google get introduce this in terms of Jquery and all , now microsoft is also take a part on same while using ajax cdn. at first is service is free, does not require king of registration or anything ,and one thing is you can use it in both commercial and non-commercial purposes.

What does a CDN ?
it get composed of "edge cache" servers which are highly strategically placed in all over the world at Internet network points. These "edge cache" servers can be used to cache and deliver all types of content – which get including images, CSS and JavaScript files ,videos and many more.

How to use
now for example if you want to use jQuery from the Microsoft AJAX CDN you can simply add a standard script tag to your page, that you can put in you <Head > section

now whenever the script get required the browser get send the request to the microsoft cdn for functiuon and from there automatically updation get happen
one better advantage is it get cache automatically so no need to send request and make http page heavier. so from the SEO (search engine optimization ) point of view also its too good .

now how you can use that on Visual Studio on your application,
now a days The ASP.NET 4.0 control includes a new property named EnableCdn. that means When you assign the value true to this property, your application will use the Microsoft CDN to request JavaScript files automatically:
that means script get generate automatically so no need of write a code for same , this again useful for SEO purpose for JS minfication . this problem get solve ones you check you application in terms of Google page speed issue.

you need to simply set EnableCDn="true" automatically it get work look at below how exactly it get work

now hope u got the idea clear how exatly it get work and how its useful
thanx , if u want more on same plz add a comment on this post

microsoft ajax minifier

2010-02-14T06:00:00.003+01:00

hi all , yes long time while posting a article on my blog, now i m back , hei i have seen
most of the people are uses Microsoft ajax control in there web application , its also working fine
and also good looking in projects ,

but at a time testing of web site performance then so many issues get arises , they may be all related with speed , performance , ratio and all , now i also face this problem on my applicatin
and while searching i found good article on how to minify the ajax control auto generated (runtime) script there are two ways
either u can compress them or u can use ajax CDN facility to handle them , yes ajax introduces the CDN faliclity for ther JQUERY, AJAX tools , yes its really good while use them in out application.

now u can see how its very important in terms of project implementation.
you can refer this Scott 's blog post ,you wil come to know how its useful . announcing-microsoft-ajax-library

hope u like this

SQL Database compare software

2009-12-18T07:31:00.003+01:00

Here is free databse compare software for Access / MY SQL / Sql Serve , Compare application will allow you to compare the structure of two SQL server databases and display all the differences between them.. The structure viewer is included on same , you can find the comparison and acoording to that you can choose to exclude that comparioson of given fields , constraints .This is a lightweight version compared to version 2.0, it very small and portable.

>Download Here

Find Maximum Connections for SQL Server.

2009-12-09T12:44:00.001+01:00

- If you want to know how many connection get happen with your database then you can easily get those number using this technique.


   Select @@MAX_Connections as MaxConn

Using this you will get the Max number of connection get allowed on an instance of sql server.

- now if you want to know how many attempted connection are then


    Select @@Connections as TotalNumberOfLogin

It will gives you all the number of connection was happen when the sql server get started , that may be a successful or unsuccessful connections also.

- You can also check this all using this system store procedure call


    Exec sp_monitor

This will gives you result on when server get running , cpu time , usage , amount of data sending receiving , total number of read write operation done plus is there any error on connection like that .

Format DateTime in Gridview.

2009-12-04T10:55:00.005+01:00

Gridview is using mostly , now i have come up with some small but very important task on how to display Proper date time on Gridview , Basically we are defining standard date time option (date + time) , but some time we only want to display date in this case you can follow the below format.Format Date on Bound Column in Grid View

Suppose you want DOB in short date format without time , then you can simply use DataFormatString ="{0:d}" for Short Date
like this


<asp:BoundField DataField="DOB" HeaderText="DOB" DataFormatString = "{0:d}"   />

if you are using above this setting then also it will not work ,coz by default the html encode is turned ON to prevent the Cross site Scripting attack , so for that you need to add one more property as HtmlEncode ="false".


<asp:BoundField DataField="DOB" HtmlEnclode="False" HeaderText="DOB" DataFormatString = "{0:d}"   />

if You want Logn Date you can use - DataFormatString = "{0:D}"
if You want Logn Time you can use - DataFormatString = "{0:T}"

If you are using Template comlumn and you want to make your date string in short format then also you can use this suppose your item templates is


<ItemTemplate >
<asp:Label ID="DOB" runat="server" Text='<%# Bind("DOB") % >'> </asp:Label >
</ItemTemplate >

Then also you can use like this way:


<asp:Label ID="DOB" runat="server" Text='<%# Bind("DOB","{0:D}") % >'> </asp:Label >

Following table will show some date formating ways in Gridview column.

Format Pattern	Name	Example
d	Short date	11/8/2008
D	Long date	Sunday, August 11, 2008
t	Short time	3:32 PM
T	Long time	3:32:00 PM
f	Full date/time (short time)	Sunday, August 11, 2008 3:32 PM
F	Full date/time (long time)	Sunday, August 11, 2008 3:32:00 PM
g	General date/time (short time)	8/11/2008 3:32 PM
G	General date/time (long time)	8/11/2008 3:32:00 PM
m or M	Month day	August 11
r or R	RFC 1123	Sun, 11 Aug 2008 8:32:00 GMT
s	Sortable date/time	2008-08-11T15:32:00
u	Universable sortable date/time	2008-08-11 15:32:00z
U	Universable sortable date/time	Sunday, August 11, 2008 11:32:00 PM
y or Y	Year month	August, 2008

thanx you,

How to know SQL Server version and Edition

2009-11-25T06:44:00.003+01:00

some time we just install the sql server , but still we don't know which type of version it is and edition also , basically we need that when we are upgrating current version of new version. Current there is sql server 2008 is there in market,

now how to determine which version of sql 2008 is running out machine,
- run the following T-SQL statement,

SELECT SERVERPROPERTY ('productlevel') ,SERVERPROPERTY('productversion'),  SERVERPROPERTY ('edition')

you will get the result like :
RTM | 10.0.1600.22 | Enterprise Edition

RTM is product level which means - 'Release To Manufacturing'.
but what is means of RTM - is a stage on which the distribution of process begins CD of
that product get created and retial packs and then product will get shipp , this is very
long process and because of that RTM date is mostly ahead of the final release date.

10.0.1600.22 means product version.

Enterprise Edition means its a Edition there are some other editions are also there like
Developer,standard ,web,Express ,Workgroup , 64- bit Edition .

The following table lists the Sqlservr.exe version number.

Release	Sqlservr.exe
RTM	2007.100.1600.0
SQL Server 2008 Service Pack 1	2007.100.2531.0

Check for valid Internet Connection using C#

2009-11-18T07:53:00.001+01:00

on many application we need internet connectio , such as smart client to send receive the data, now in this case below code will help you to make sure that you have proper internet connection or not , the conecpt is like very simple, at first we simply check that if the user has network connection and according to that it will return Success / Fail message.

Now i just ping the two website (www.google.com ,www.yahoo.com) which will ping that site and return fail or success message.


C#
public bool GetIsConnAvail()
{
   var success = false;
   string StatusMsg; 
   if (NetworkInterface.GetIsNetworkAvailable() == false)
   {
      return success;
   }
   string[] Mysite = { "www.google.com", "www.yahoo.com"}; 
   try
   {
      using (var ping = new Ping())
      {
         foreach (var url in Mysite)
         {
            var replyMsg = ping.Send(url, 300); 
            if (replyMsg.Status == IPStatus.Success)
            {
               success = true;
               StatusMsg = "Connection Found..."
               break;
            }
            else
            {
               StatusMsg = "Internet Connection not Found on your machine..." 
            }

         }
      }
   }

   catch (Exception ex)
   {
      Trace.WriteLine(ex.Message);
   }
   return success;
}

i thing this code will surely help you to search your connection faster than other ways.

video on web2.0

2009-11-10T12:51:00.001+01:00

hi , i just found very nice vodeo on web2.0

another video on web2.0 , its really very informative

Generate Sitemap using ASP

2009-11-04T11:26:00.004+01:00

Sitemap is very important factor of web site , you can say its a list of pages of web site accessible to user. it Organize in hierarchical fashion. basically it helps the visitors and mostly on search engine bots to find the perticular page on you site. it improve seo of site , it works just like the dynamic access to site. basically sitemap in xml format.

Here i have created one sample application that can read xsl file and according to that it generate sitemap of your site.
on my Excel file i have place all the links of my sites.
now how to get this ,
1 .open your site say www.google.com
2. now on your web developer toolbar (Mozilla addon) on Information section > click view link information it will open open page and in that you can find all the site links
3. copy that on excel file and save it ,

now write application that read a data from excel and generate sitemap



< %

Const adOpenStatic = 3 
Const adLockPessimistic = 2  
Dim cnnExcel 
Dim rstExcel 
Dim I 
Dim iCols  

Set cnnExcel = Server.CreateObject("ADODB.Connection") 
cnnExcel.Open "Driver={Microsoft Excel Driver  (*.xls)};DriverId=790;Dbq="&Server.MapPath("1.xls")&";DefaultDir="&Server.MapPath(".")&";" Set rstExcel = Server.CreateObject("ADODB.Recordset") 
rstExcel.Open "SELECT * FROM [Sheet1$]", cnnExcel  
iCols = rstExcel.Fields.Count     
rstExcel.MoveFirst     
xmlData =  ""
   xmlData =  xmlData&""
   Do While Not rstExcel.EOF
           xmlData =  xmlData& ""
           xmlData =  xmlData& ""& rstExcel.Fields.Item(0).Value & "" & vbCrLf
   xmlData =  xmlData& ""
       rstExcel.MoveNext
   Loop
xmlData =  xmlData& " "
   Response.Write(xmlData)
rstExcel.Close
Set rstExcel = Nothing

cnnExcel.Close
Set cnnExcel = Nothing
% >

Run this file and view source code of this file , save view source file as a "Sitemap.xml"

Jquery Shake Effect

2009-10-28T11:01:00.008+01:00

yesterday i try with the Jquery Shake Effects , it was really nice i was trying this Effect on login page . Ones the user enter wrong information (userid or password ) the box get shake , so its really eye catching and looking also great , there are so many ways , you can integrate the Shake effect on your application, like showing perticular box every time when user get scroll down or scroll up , at a time of loding image, loading page, and so on.

here i have some collection of that effects , hope u like it

1. Jquery Shake



$("div").click(function () {
     $(this).effect("shake", { times:3 }, 300); //specify the effect with how much time u want to shake Effects
});

2.Right side Shake


#shaker  { position:fixed; top:10px; right:10px; width:299px; height:253px; display:none; }

define your shake box according to your location.

3.Buzzing Login form


  <script type="text/javascript" src="jquery-1.3.2.min.js" > </script>
   <script type="text/javascript" src="vibrate.js" > </script>

add this js on your application . view Source

4. Shaking Menu Options
with this coole Effects
1. OthersFade()
2. OthersJump()
3. OthersBlink()
4. OthersRollUp()
5. OthersRollDown()
6. OthersVibrate()

5.Flash ShakingEffects

6.basiceffects

hope you like it .
if you know more plz add on comments

File comparison tool free download.

2009-10-16T10:18:00.002+01:00

sometime we need to compare two file ,like comparing coding or some text like that , in that time if the document is too long then Comparing this will be very difficult .

here i found very nice file comparison tool call Turtoise SVN .
Turtoise SVN is Free and it can provide file comparison facility same as popular beyond compare tool.

steps
1. Download the SVN

2.select the two file you want to make the comparison. here i have created two files test1 &test2

3. now select two file right click on mouse , and select "Diff" option on same ,

4. It will show you the difference between two files.

that's it falk,

Check Page.IsValid at Client Side using C#

2009-10-14T13:22:00.001+01:00

when i was designing a registration form i run into this case, what i want is if user press register
button, then that button get disable to avoid multiple click on registration button.

now if error occurred on the client side never call any server-side function so in this case the disable button will remain disable as it is, now to overcome

such problem we have to identify whether Page is error free on the client-side.

To find out this simply check on Disable Submit Button.


if(Page_IsValid)
{
  //write your code here.
}



function DisableClick() {
var obj = 'btnUpd';
if (Page_IsValid) {
document.getElementById(obj).disabled = true;
txt = txt + 1;
message = 'Please Wait......(' + txt + ')!';
document.getElementById(obj).value = message;
var t = setTimeout('DisableClick()', 600);
}
else 
{
document.getElementById(obj).disabled = false;
document.getElementById('PleaseWait').style.display = 'none';
document.getElementById(obj).value = "Register";
}
}

hope it will work you,

Twitter API from C# .Net

2009-10-08T06:49:00.001+01:00

Twitter is one of the Great and friendly site ,Twitter has an API implementation that is very simple to understand and use. if you want to friends friends timelie of user you can use that from here

- http://twitter.com/statuses/friends_timeline.rss

Ones you find the RSS of friends , you can get the 3 Keywords
1 . Statuses - what are you working on ?
2. friends_timeline - what do you need ?
3. RSS - in which format you need Rss
API supoorting in xml , json, rss, atom you can choose one of that .

Methods supported: See Twitter API

There are many objects supported, but the above format applies for only a few like Statuses, User, Direct Messages. there rest all other are mostly similar.

right now i am working on complete set of wrappers using this api, so it will be easy ,plz leave a comment if you want any help

Google Maps Api

2009-10-03T11:07:00.002+01:00

There are lot many service provided by Google ,

Google map

is one of that , which can be used to discover the world through your application , you can used this for many other purpose just like bookmarking you city,state, your Company and many more.

here is Google api you can integrate with you .net application, below is code how you can do that but The first thing if you wanted a google map Api key for Local server testing you may download here.

"ABQIAAAA5HHs8lZl18SY-r1Jm1qy-hQpDmmpk8q921mRIPG4qgOvy0T09hTGvwPs_FnHiEq78dTl61JP9JQQtw" this is test key for yout local server and IIS

Google.zip (701.00 bytes)

ASP.NET AJAX and the MS Virtual Earth Control

2009-10-01T07:00:00.003+01:00

i was just refering some site regarding on

Microsoft Virtual Earth Control

.so i just found very nice and simple article on "Master/Detail with ASP.NET AJAX and the MS Virtual Earth Control" written by matt berseth , its really nice

This application allows users to browse zip-codes using the Virtual Earth Map Control , on below pics you can see how to accomplish this , The example uses PageMethods to fetch the latitude and longitudes for the zip-codes , if you want more about PageMethods
just google it out or else refer it here

Live Demo | Download

Captcha ASP.NET 2.0 Server Control

2009-09-28T08:16:00.004+01:00

Captcha control is used to validate user in terms of avoiding spamming on message or comments or registration or so on . implement Captcha on your application , below are the steps how u can do that

Installation instruction:

1. Unzip the downloaded file.
2. Copy MSCaptcha.dll and MSCaptcha.xml files to your /bin application directory.
3. add reference to mscaptcha.dll file.
4. Modify your web.config file, by adding this line to &l;httphandlers> section:
<add verb="GET" path="CaptchaImage.axd" type="MSCaptcha.CaptchaImageHandler, MSCaptcha"/>

5.Add MSCaptcha control to your Visual Studio toolbox (optional)

how to use on Page

1. Add line to your .aspx file:
<%@ Register Assembly="MSCaptcha" Namespace="MSCaptcha" TagPrefix="cc1" % >

2. add the control whenever you want:


 <cc1:CaptchaControl ID="ccJoin" runat="server" CaptchaBackgroundNoise="none" CaptchaLength="5" CaptchaHeight="60" CaptchaWidth="200" CaptchaLineNoise="None" CaptchaMinTimeout="5" CaptchaMaxTimeout="240" / >

3. Add this on your CS file to check or Validate enter captcha is right or wrong


  
 ccJoin.ValidateCaptcha(txtCap.Text);
if (!ccJoin.UserValidated)
{
  //Inform user that his input was wrong ...
  return;
}

now its look like this way :

Download Here..

Captcha ASP.NET 2.0

css techniques

2009-09-25T13:10:00.004+01:00

on web application CSS is playing very important role . And it is being used more and more often. Cascading Style Sheets has many advantages
like layout, design of the page,presented on the page and so on

here i have some collections of stuffs on CSS technique .

1.

Drop Cap – Capital Letters with CSS

Define Image Opacity with CSS

How to Create a Block Hover Effect for a List of Links

CSS Image Replacement for Buttons
10.

Link Thumbnail

11.

CSS Map Pop

12.

PHP-based CSS Style Switcher

13.

CSS Unordered List Calender
14.

CSS-Based Tables: Techniques

15.

Printing Web-Documents and CSS

look at here more

System.IndexOutOfRangeException was unhandled (Message="Index was outside the bounds of the array.")

2009-09-25T11:38:00.001+01:00

on C# or vb.net we are using array,Array is one of the best way to mentain collection of data together and proper way ,

here is one Error which get call whenever some problem with size and all

The exception that is thrown when an attempt is made to access an element of an array with an index that is outside the bounds of the array. This class cannot be
inherited.

.NET arrays have base 0 and should be kept in mind when coding.

ones you got this error you have to resize your array size, accroding to your requirements

CSV to XML Conversion using LINQ

2009-09-23T07:09:00.002+01:00

on C#, if we want to Convert CSV to XML then you can use Language Integrated Query (LINQ) can be used to convert a CSV file to XML. Here is the sample CSV file that needs to be converted

below example code reads the CSV file to an array. LINQ is used to loop through the array and the contents are written as XML using XElement (System.XML.Linq).


public void ConvCSVToXML()

{

String[] FileContent = File.ReadAllLines(@"D:\Proj\jquery.csv");

String XMLNS = "";

XElement Inv = new XElement("type", from 

items in FileContent 

let fields = items.Split(',')

select new XElement("fadein",

new XElement("Tab", fields[0]),

new XElement("ProgressBar", fields[1]),

new XElement("ToolTip", fields[2]),

new XElement("Menu", fields[3]),

)
);

File.WriteAllText(@"D:\Proj\jquery.xml", XMLNS + Inv.ToString() );
}

using this you can convert your CSV file xml using C# and C# Convert CSV To XML, .NET CSV To XML

How to get the Upper Bound of an Array in C#

2009-09-22T09:19:00.000+01:00

hi, if you'r using asp, vbscript and all then you have option call UBound
which will return a UpperBound value of Array. but on C#, you dont have that option call Ubound ,for that you can use GetUpperBound() option - Gets the upper bound of the specified dimension in the Array.

here is an Example which can show how to use GetUpperBound()


 For i = MyArray.GetLowerBound(0) To MyArray.GetUpperBound(0)
            
  Next i

like this way you can use both option call GetLowerBound & GetUpperBound ,
GetLowerBound will return lower bound value.here you have to pass (int value)
0 - 1st arrayvalue, 1- 2ndarrayvalue like that,

thank you.

Download data using FTP or HTTP with C#

2009-09-19T06:37:00.001+01:00

If you want to download data via FTP or HTTP then you can use this solution. you can Use the System.Net.WebClient to achieve this. The URI determines whether a file (file://) , FTP (FTP://) or HTTP (HTTP:// or HTTPS://) scheme is to be used.

On .Net2.0 there is an Async Version get added which will allows you download data asynchronously as a background task using its own thread from the thread pool. WebClient object can handle one async download at a time. its not useful for downloading many files concurrently , but if you want to do this then you can use multiple WebClient objects. if you want to Cancel the current download using CancelAsync.

There are Several Methods:

1. OpenRead - returns a System.IO.Stream
OpenReadAsync - async downloading use the handler OpenReadCompleted

2. DownloadData - returns a ByteArray
DownloadDataAsync - use handler DownloadDataCompleted

3. DownloadFile - Saves to a local file
DownloadFileAsync - use handler DownloadFileCompleted

4. DownloadString - returns a String ( introduced in .net 2.0)
DownloadStringAsync - use handler DownloadStringCompleted

Here is Sample code:


using System.IO;
using System.Net;
using System.Text.RegularExpressions;

string remoteUri = "http://www.entersitenamehere.com";
WebClient client = new WebClient();
string str = client.DownloadString(remoteUri);

** if you are using proxy then you need extra code to code around it.
on my next post i will tell you how you can download data using Proxy.
Downloading data over FTP, Downloading data over HTTP, FTP, HTTP, Net.WebClient

JQuery Plugins and Demos for Developers.

2009-09-18T07:22:00.006+01:00

hello ,i have again come up with some collection of jquery plugins with Demos , hope u like it.

1. jGoogle
jGoogle will wrap google AJAX search APIs in a single jQuery plugin to extract usable data.
on the first version they have included GImageSearch option
- View demo
- View Source

2. Virtual jQuery Keyboard
jquery Virtual Keyboard is one of the good feature for preventing keystrokes , it will very dangerous when you enter some bank account and password like information , virtual keyboard will play very imp role here, you can't get the stoke on your log ,
-View Demo

3. Scrolling with Load Effects.
when we have lots of content then its not looking good when we are showing them in one and too long panel, instead of that we can show loading effects the it also look beautiful and cool
- View demo

4. Tablesorter 2.0
When we showing the records on table then sorting is one of the basic option , to show the records like date wise , increasing decrease order and so on like this feature you can add here
- View demo

5. jQuery Right-click Plugin
This plugin enable you to detect the event when user get click right button of mouse . so as per the click you can do your operation like disable the right click and so on or adding any information to drop down when clicking right click
-View demo

6. Jquery: Progress Bar
Progress bar is one of the cool feature that use can use anywhere where you are data get retrieve from database and if it will take too much time to load that page , in this case you can show loading like Effects so user can understand that page is being lead
- view Demo

7. jQuery Feed Menus
Feed is used for bookmarking and all other purpose , you can show multiple feed under one category , so you can use your space and its also look nice
- view Demo

8. gShuffle
The plugin animation is triggered every time the Shuffle button is clicked. Each time, the code will choose two squares to switch positions with one another.
- view Demo

9 -Mark It Up
MarkItUp, you can convert text areas into powerful HTML, BBCode or Wiki editor.

----
hope you like it ,
will add more on it, if you found anything could be related with this plz add on comments

Jquery ToolTip

2009-09-11T13:48:00.002+01:00

Tooltip is one of the Cool & useful feature in Jquery , its mostly used for showing
Additional information for that records , you can use that anywhere like showing Customer information, Suggestion for form fillup , for zoom image and many more

here are some collection of tooltips .

1. Bottom slide tooltip

2. jQuery Tooltip Plugin

3.jTip

4.SimpleTip

5.BoxOver Tooltip

6.qTip

7.EZPZ jQuery Tooltip

8. CSS Globe jQuery Tooltip plugin

hope u like it

SQL : Count String Occurrence

2009-09-10T06:35:00.001+01:00

in SQl server, we dont have any function which can return the number of words in a perticular string .but from small tricks we can do that . now Consider here we can separating the character on space basis

example :


  declare @Str VARCHAR(2000)
  SET @Str = 'Hi this is Test line which count no of spaces.'
  select LEN(@Str) - LEN(Replace(@Str,' ', '')) + 1

Above query will return value 10 , but if the words are separate by more than one space then it will aslo count that space. but its wrong as per the answer.
in that case Create one function which can keep multiple spaces as a single space and return proper result

Below is a Function which can remove white space and all and retrun peoper result.


 CREATE FUNCTION [dbo].[WordCount] ( @inStr VARCHAR(4000) ) 
 RETURNS INT
 AS
 BEGIN

 DECLARE @Index          INT
 DECLARE @Char           CHAR(1)
 DECLARE @PrevChar       CHAR(1)
 DECLARE @WordCount      INT

 SET @Index = 1
 SET @WordCount = 0

 WHILE @Index <= LEN(@InStr)
 BEGIN
    SET @Char     = SUBSTRING(@InStr, @Index, 1)
    SET @PrevChar = CASE WHEN @Index = 1 THEN ' '
                         ELSE SUBSTRING(@InStr, @Index - 1, 1)
                    END

    IF @PrevChar = ' ' AND @Char != ' '
        SET @WordCount = @WordCount + 1

    SET @Index = @Index + 1
END

RETURN @WordCount
END
GO

now you can use that WordCount Function


 DECLARE @String VARCHAR(4000)
 SET @String = 'Hi this is Test line which count             no of spaces.'
 SELECT [dbo].[WordCount] ( @String )

Above Query will return Result 10 not any other,
hope you like this ,

SQL : how to sort ip Address.

2009-09-08T07:05:00.001+01:00

ip address, is one of the key point to identify the user. now if your storing ip address on your database with the VARCHAR datatype with length of 25. guess you have 1 lakh's of records of different ip address and you want to sort that.

Then your sorting query will be


   select [ipadd] as IpAddress from ip order by [ipadd]

now in this case it will return a result something like this


 ipAddress
------------------------
10.0.0.1
192.165.20.2
255.205.2.3
255.145.53.6
64.35.88.9
68.4.5.99
69.65.236.235
98.125.85.36.0

something like that but actually its not your answer , it get sorted on first no. so becasue of that your result get warry.on actual basic the result should come in this format



 ipAddress
------------------------
10.0.0.1
64.35.88.9
68.4.5.99
69.65.236.235
98.125.85.36.0
192.165.20.2
255.205.2.3
255.145.53.6

now how to achieve this use some technique here


 select [IPAdd] from ip 
 order by CAST(PARSENAME([IPAdd], 4) AS INT),
CAST(PARSENAME([IPAdd], 3) AS INT),
CAST(PARSENAME([IPAdd], 2) AS INT),
CAST(PARSENAME([IPAdd], 1) AS INT),

now check this you get above result
thank you.

publish multiple websites using one solution.

2009-09-07T12:07:00.001+01:00

on Visual Studio you can publish only one website at a time otherwise there is a clash between one website with multiple website.if you want to do that means on startup of one website other website also publish . for that you need to do some setting on Solutional Level.

follow the steps :
1- on proejct Solution just right click it & select Product Dependencies.
2- select Dependencies tab.
3- select your main website(startup one) from Dropdown.
4- now check all the web service on "Depends on" section
that you can decide how many site you want to publish at a time of this main site.
5- click ok

now whenever you publish that main site , then it will prompt publish window for all other depended site ,then all other mention site will also get publish , if you dont want to publish that you do the same above procedure to deactivated that ,

that's all...

About XmlPreloadedResolver

2009-09-03T08:23:00.000+01:00

when using Silverlight then XmlPreloadedResolver meaning is very useful, its a new type which can be useful when your working with XML . on XmlPreloadedResolver it has the Ability to load the DTD without call to network. This type manually maintain the DTD cache and all other with xml streams. XmlPreloadedResolver includes RSS1.0 and XHTML1.0 Defination of DTD.

sample code on how to work with XmlPreloadedResolver


String strDtd = "";
XmlPreloadedResolver resolver = new XmlPreloadedResolver();
resolver.Add(resolver.ResolveUri(null, "nameofDTD.dtd"), strDtd);
XmlReaderSettings rs = new XmlReaderSettings();
rs.XmlResolver = resolver;
rs.DtdProcessing = DtdProcessing.Parse;
XmlReader reader = XmlReader.Create("samplexml.xml", rs);

now you can also set the DTD sets Enable using XmlKnownDtds enumeration.
XmlKnownDtds is used with the XmlPreloadedResolver to identify the well-known DTD

the following example shos preloading Xhtml1.0 DTd into the XmlReaderSettings object
here there is no need of network call to parse the Xhtml file.it will done automatically.


  XmlReaderSettings settings = new XmlReaderSettings();
   //define the Setting object to parsing DTD
  settings.DtdProcessing = DtdProcessing.Parse; 
   // Define preloading Xhtml10 DTD
  settings.XmlResolver = new XmlPreloadedResolver(XmlKnownDtds.Xhtml10);
  //suppose read the sample.html file using XmlReader
  XmlReader reader = XmlReader.Create("sample.html", settings);
  // and load using XDocument object
  XDocument document = XDocument.Load(reader);

for more refer to : http://msdn.microsoft.com/en-us/library/cc189059(VS.95).aspx

Highlight Gridview's Row on mouseHover

2009-09-02T12:41:00.004+01:00

in Gridview we have seen most of the time we one we take move hover to any row , size of that row or background color or any animation get happen you can do that using css, or java script also.

here i have do that using java script


function gvHigh(tRow,showAct)
  {
   if (showAct)
     {
       tRow.style.backgroundColor = '#ff32ss';
     }
      else
     {
tRow.style.backgroundColor = '#ffffff';
     }
   }

function urlloca(Url)
{
 document.location.href = Url;
}

and Define onrowCreated function like this and put your code behind here


protected void gv1_onRowCreated(object sender, EventArgs e)
{
foreach (GridViewRow gvRow in gv1.Rows)
{
  gvRow.Attributes["onmouseover"] = "highlight(this, true);";
  gvRow.Attributes["onmouseout"] = "highlight(this, false);";
  HttpResponse myHttpResponse = Response;
  HtmlTextWriter myHtmlTextWriter = new HtmlTextWriter(myHttpResponse.Output);
  gvRow.Attributes.AddAttributes(myHtmlTextWriter);
}

}

that's it it will help you.
thank you.

set meta tags to master page from Child Page

2009-08-31T09:55:00.002+01:00

Meta tag ,title, keywords ,Description and all are very assential on each page , if your using asp.net with Master page then also its possible some people think that how it can be? master page means one page and it get call on each child page creation.but you can also add the keyword , title and all with each pertucular page if you'r using master page then also.

Below are the Steps you need to follow

1-

Create oen Content place holder on your master page with in HEAD section


<head id="Head_Demo" runat="server">
    <asp:ContentPlaceHolder runat="server" id="Contentplace_Demo"> </asp:ContentPlaceHolder>
</head >

2 -

on Your Child page put this code :

<asp:Content runat="server" ContentPlaceHolderID="ContentHeaders" ID="Content_Demo" >
<META name="keywords" content="<%=pgKeywords%>">
<TITLE><%=pgTitle%></TITLE>
<META name="description" content="<%=pgDescription%>">
</asp:Content>

3 -

on content page's(Child page) open CodeBehind and Declare this :
Declare variables as below in the global declaration section

Protected pgKeywords As String = ""
Protected pgTitle As String = ""
Protected pgDescription As String = ""

4-
Now set the New title, Desc and all as per the your req. copy that code on page_load Event

pgKeywords = "keywords Content Goes here "
pgTitle = "title Content Goes here"
pgDescription = "Description Content Goes here"

or you can also refer this set mata tags

that's it
hope it will helps you

How to get Mouse Cursor Position

2009-08-28T10:49:00.000+01:00

There is no Certain way to find the Cursor position of mouse within the Browser.
W3c standards say that you can get the position when event is triggered by event.clientX and same for clientY. to find out the Distance between left n Top

side.

Its works fine on IE6 , Netsacape , Firefox , Opera 7+ and all othe browser.
in IE uses two Different ways to scroll the position of pages they are using Document.body.ScrollLeft and same for the ScrollTop. this is in Before version

of 6
Some of the Browser used PageXOffset & PageYOffset.

Here is Function call MouseX() and MouseY() which can calculate the X and Y Co-ordinates of same,



function mXbar(action) {
if (action.pageX) return action.pageX;
else if (action.clientX)
   return action.clientX + (document.documentElement.scrollLeft ?document.documentElement.scrollLeft :document.body.scrollLeft);
else return null;
}
function mYbar(action) {
if (action.pageY) return action.pageY;
else if (action.clientY)
   return action.clientY + (document.documentElement.scrollTop ?document.documentElement.scrollTop :document.body.scrollTop);
  else return null;
}

there are few more ways to calculate the cursor position event.ScrenX or event.screenY
these feature are not thee in Netscape4 and IE old version, but in new version of ie 7 + they have all such feature,

Best Ajax , Jquery ,Css Calendar collections

2009-08-18T08:15:00.005+01:00

Calendar is one of the requirement while taking a input from user in terms of
Data of Birth , Start Journey , Admission Date and so many .its a Essential Control in terms of all the Application Development.

here are the some cool and nice collections of calendar most of them are in ajax, css , and Jquery . hope you like it .

1. VLA Calendar

2. ASP.Net calendar

3. Date Input Calendar

4. using Prototype date picker

5. Jquery Calendar

6. Date and Time Picker

hope u like this collection , will keep on updating ,
if u know any one in this plz send a comment on it,

Handle Master page Click Event on Content Page

2009-08-13T08:12:00.001+01:00

In ASP.net2.5 there a new concept knowns as Master Page , with the help of that you can
customize you'r repeteative work. Create a one Master page and use that page on all the other pages. Its really very good tech to crear your coding and clear your logic also.

now sometime we have a LinkButton define on Master page which can be work as a "Link to the Customer information " and this can be change depend on customer role. and that LinkButton action we want in the Contenet page.

Supoose we have LinkButton call "linkFromMasterPage" on Master Page. Here is small code which can helps you to do same .

C#--


  Public LinkButton linkFromMasterPage(){

        Get {

            Return linkFromMasterPage;

        }

    }

Now next Process is reference the Master Page as a casted object in the Content page.
here CusMasterPg is a Class of Maste Page.


   CusMasterPg cm = ((CusMasterPg) (Master));

Now you can easily access the all the methods, public properties of Master page class.
so next stpe is handle the button Event on your content page


    protected void Page_Load(object sender, EventArgs e)
    {
      If (!(IsNothing(cm))) { 

        cm.linkFromMasterPage.Click += New EventHandler(linkFromMasterPage_Click);

      }
    }

next thing is define actual method handle on your page.



  Protected void linkFromMasterPage_Click(Object sender, System.EventArgs e){

        // write Perform Business Logic Here
    }

thats all , you can do same thing for User Controls also for Handle Master page Click Event on Content Page.

ASP.NET Cross Site Scripting Toolkit

2009-08-12T14:07:00.001+01:00

hi i have found some very much useful related with the Cross site Scripting.
cross site scripting is very common method to hack a site, most of the hacker get hack the site with the some basic scripting techniques.

now Microsoft get Introduce the Toolkit to Prevent the Cross-site Scripting not exactly preventing but you can say some basic level of Prevention. this toolkit is supposed to be offer some extra good efforts against the type if attack.

Cross Site Scripting may be done using -
1. via QueryString
2. via Text box entry
and so many

download Microsoft Anti-Cross Site Scripting Library toolkit here

Silverlight-based Local Impact Map

2009-08-12T06:20:00.000+01:00

It is one of the Great and very Interestig web application devlope by Microsoft ,
there are some reason to devlop this.

The Local Impact Map are conatin around 400+ Stories about the Program of Microsoft around the world.In that you can see it includes the Photos videos and more and more Visual Effects.

It is very interesting and easy to use , i like the one of that feature of Deep Zooming of Map, its really cool and very fast , Its not a ' free mouse-wheelin ' where you can zoom the Preticular location , they are taking advantage of Deep Zooming of image along with zoomo for Controlled Transition.

Microsoft’s Silverlight-based Local Impact Map

plz have a look at this cool Local Imapct of Map

ASP Format Date and Time

2009-08-05T08:16:00.001+01:00

while coding on ASP we required date and time most of the time, how to get this is very basic and well known to the most of the Programmers, but how to get the only specific date , time in required format is a main task ,

for that we have inbuild function call FormatDateTime() .

now we very well knows if we want to get current date and time then we can use now()


  <%dim TodayDnT
    TodayDnT = now()
  %>

if you want the Result of same then use <% Response.write(TodayDnT) %>
so it will return result as : - 8/5/2009 12:11 PM

now we have the option to format that
1. Using 0


 <% 
 Response.write FormatDateTime(TodayDnT,0)  
 %>

Result : - 8/5/2009 12:11:10 PM

2. Using 1


 <% 
 Response.write FormatDateTime(TodayDnT,1)  
 %>

Result :- Wednesday, August 12, 2009 (long date )

3. Using 2


 <% 
 Response.write FormatDateTime(TodayDnT,2)  
 %>

Result: - 8/5/2009 (short date)

4. using 3


 <% 
 Response.write FormatDateTime(TodayDnT,3)  
 %>

Result : - 12:11:10 PM (long time)

5. using 4


 <% 
 Response.write FormatDateTime(TodayDnT,4)  
 %>

Result : - 11:10 (current time in 24 format (hh:mm)

If you want to change the Date and Time according to international location then
use session.lcid property

Ex : - <% session.lcid=1036 %>
which will set the Date n Time in French Format

here is the List of all the
International Location

Debugging for ASP.NET Applications

2009-08-03T07:02:00.002+01:00

If you are using Visual Studio2005 and if you want to enable debugging in the project properties Then Follow the Stpes
In VS 2005, use the <Project> Property Pages to set project properties :
here is the way to do
- Right click on Solution Explore of Project,Then Open the Property Pages by and selecting Property Pages.
- Select Start Option tab
- Under Debuggers, make sure the ASP.NET box is selected.

You can also enable the debugging using web.config file

- Inside the <compilation> tag, you will create the debug attribute.
- specify attribute as a "debug", not "Debug" or "DEBUG" because the are very Case-Sensitive so please take care of that.
- Set debug option as a true.

Here is a sample Web.config file



<configuration>
<system.web>
<compilation defaultLanguage="VB" debug="true" numRecompilesBeforeAppRestart="15">

<compilers>
<compiler language="C#;Csharp" extension=".cs" type="Microsoft.CSharp.CSharpCodeProvider,system, Version=1.0.5000.0, Culture=neutral, 

PublicKeyToken=b77a5c561934e089" />
<compiler language="VB;VBScript" extension=".cls" type="Microsoft.VisualBasic.VBCodeProvider,system, Version=1.0.5000.0, Culture=neutral, 

PublicKeyToken=b77a5c561934e089" />
</compilers>

<assemblies>
<add assembly="ADODB" />
<add assembly="*" />
</assemblies>

<namespaces>
<add namespace="System.Web.UI" />
<add namespace="System.Web" />
<add namespace="System.Web.UI.WebControls" />
<add namespace="System.Web.UI.HtmlControls" />
</namespaces>
</compilation>
</system.web>
</configuration>

Like that you can set the Debugging option using web.config file also and using GUI also.

Loop through Session ,Application ,form Variable

2009-08-01T07:29:00.001+01:00

In Classic asp sometime we need to retrieve all the Session Application and Request object variable, in this case we can use Loop through technique which will generate all the Session variable , application variable , and Request variable are used in current page do this need to simply put this line on your page

1.


 <%
 dim i
 For Each i in Session.Contents
  Response.Write(i & "<br />")
 Next

 dim i
 For Each i in Session.StaticObjects
  Response.Write(i & "<br />")
 Next 
 %>

it will Display all the Session Contents / session staticobjets are used in current page .

2.



<%
dim i
For Each i in Application.Contents
  Response.Write(i & "<br />")
Next
%>

this will iterate all the Application content are being used in current page.

3.


<%
for each x in Request.form
Response.Write("<br>" & x & " = " & Request.form(x)) 
next
%>

this will generate all the Request variable

4.


<%
 for each name in Request.ServerVariables 
  Response.write ""&name &"-------------"& Request.ServerVariables(name) &"<br>"
 Next 
%>

it will loop with the all the Server Variable.

Export XML from SQL using a Stored Procedure.

2009-07-30T10:53:00.000+01:00

1) Generate a file with the text-editor like:

<%begindetail%>
<%insert_data_here%>
<%enddetail%>

Save it as c:\temp\template.tpl

2) Open Query Analyzer and type:

sp_makewebtask @outputfile = 'c:\temp\myxmlfile.xml',
@query = 'select * from sysobjects for xml auto',
@templatefile = 'c:\temp\template.tpl'

The result is a XML-File!

More ^

Move Seleted Records using Checkbox in GridView

2009-07-29T07:17:00.000+01:00

Hi ,

here is nice tutorial or you can say very simple example on how you can
delete or move the records from the Gridview

Move/Delete content From GridView

hope u like it ,

Hide Show Div

2009-07-27T12:40:00.000+01:00

hi this is cool and simple javascript stuffs which HIDE and Show Details
using Div


<script language="javascript"> 
function toggle() {
 var ele = document.getElementById("togText");
 var text = document.getElementById("ShowText");
 if(ele.style.display == "block") {
      ele.style.display = "none";
  text.innerHTML = "Click Me";
   }
 else {
  ele.style.display = "block";
  text.innerHTML = "Hide It";
 }
} 
</script>
 
 Click Here to View Details
<a id="ShowText" href="javascript:toggle();">
 Click Me </a> 
<div id="togText" style="display: none">
  < h1 > Hi, Kiran hows you? Hope u like this Cool stuff. < /h1 >
</div>

hope you like it ,

Set Favicon in different Browser

2009-07-24T07:45:00.000+01:00

we have seen most of the site has Fevicon which describe the addtional information
about the site , Addtion in the sence it could be logo,company Profile, company production,web site application, and so many .

here are the top most Example of the fevicon sites

now how u can do this

its very simple to do , just u need to add some line's of code and be ready with small icon image, u can also add animated image in fevicon

add this part in between <head> </head> Section


 <link rel="shortcut icon" href="images/favicon.ico">

now some time this code will not work on most of the Browser like IE old version
in this case u can add this line

 
 <link rel="shortcut icon" href="images/favicon.ico" type="image/vnd.microsoft.icon"  *gt;

any other query plz comment on it.

Mini-URL on CodePlex using C#

2009-07-23T10:55:00.001+01:00

if u want to minimize / Shrink / Shorten URL , then its a very good technique to do this then. its also useful as per the security and many others aspects.

its very useful for the developer to create a simple URL for there web application / url redirection services like tinyurl
,is.gd,sn.url

- you can download that sample ASP.Net MVC Application from here

- Project Description

hope u like that .

Eliminate Duplicate records from the Grid View

2009-07-22T10:46:00.000+01:00

Most of the time we need to delete duplicate entries from GridView, in this case we can delete it manually also or using onRowcreate also we can remove that .

Example
suppose Mr.Xyz has has more than 2 Account in Blogspot.com site and we want to show
in GridView Person and RelatedBlogs like this

and in this case we dont want to repeat Person name on each row.
- I have a data source


  DataTable dtsource = new DataTable();

  //Adding columns to datatable        
  dtsource.Columns.Add("Person");        
dtsource.Columns.Add("Related Blog");        

 //Adding records to the datatable
 dtsource.Rows.Add("kiran", "kirank.blog.com");
 dtsource.Rows.Add("kiran", "webdevlopmenthelp");
 dtsource.Rows.Add("kiran", "www.kiran.com");
 dtsource.Rows.Add("mark", "mark.blog.com");
 dtsource.Rows.Add("mark", "asp-net.blogspot.com");

put the below code in codebehind


 private void GenerateUniqueData(int cellno)
    {
        //Logic for unique names

        //Step 1:

        string initialnamevalue = grdUniqueNames.Rows[0].Cells[cellno].Text;

        //Step 2:        

        for (int i = 1; i < grdUniqueNames.Rows.Count; i++)
        {

            if (grdUniqueNames.Rows[i].Cells[cellno].Text == initialnamevalue)
                grdUniqueNames.Rows[i].Cells[cellno].Text = string.Empty;
            else
                initialnamevalue = grdUniqueNames.Rows[i].Cells[cellno].Text;
        }
    }

on GridView define property OnRowCreated="GenerateUniqueData" it will search the record via cell and set the Person name as a empty or person name

Caching in ASP.NET

2009-07-22T07:45:00.000+01:00

Caching

is one of the best technique of persisting the data in memory for immediate access to requesting program calls.Caching is about storing data in memory the first time it is requested and then re-using it for the following requests for a specified period of time.

Why Caching is important ?

Every time we have to querying database for each request is not cost-effective in terms of server resources, hence is lot better to cache or persist the data to avoid this costly loss of resources.so in this case we are imporve the system performance and avoid the consistancy.

ASP.Net Provides the flexibility in terms of caching at different levels.

Fragment Caching


<script runat="server">
private int _Departmentid=0;
public int DepartMentId
{
get{return _Departmentid;}
set{_Departmentid =value;}
}
//Load event of control
void Page_Load(Object sender, EventArgs e)
{
lblText.Text = "Time is " + DateTime.Now.ToString() + " for Department id = "
+ _Departmentid + "\n";
}
</script>
<asp:Label id="lblText" runat="server"></asp:Label>

Add the following to an *.aspx file. Please note the way "Register" tag is used;



<%@ Page Language="C#" Trace="true" %>
<%@ Register TagPrefix="CacheSample" TagName="Text" Src="CachingControl.ascx" %>
<script runat=server>
void Page_Load(Object sender, EventArgs e)
{
this.lbltime.Text ="Base form time is " + DateTime.Now.ToString() + "\n";
}
</script>
<html><head><title></title><body>
<asp:Label id="lbltime" runat="server"></asp:Label>
<CACHESAMPLE:TEXT id="instance1" runat="Server" DepartMentId="0">
</CACHESAMPLE:TEXT>
<CACHESAMPLE:TEXT id="instance2" runat="Server" DepartMentId="1">
</CACHESAMPLE:TEXT>
</body>
</html>

Application Level Caching


With Page level Output caching one cannot cache objects between pages within an application. Fragment caching is great in that sense but has limitations by using user controls as means to do. We can use the Cache object programmatically to take advantage of caching objects and share the same between pages. Further the availability of different overloaded methods gives a greater flexibility for our Cache policy like Timespan, Absolute expiration etc. But one of the biggest takes is the CacheDependancy. This means that one can create a cache and associate with it a dependency that is either another cache key or a file. 

Find below the snippet that uses CacheDependancy. Here what I have done is to provide a list view of existing employees. You need to create a Database in Sql Server, setup some data before you can continue. The schema scripts are enclosed in the article.

Add database connection value in Web.Config and change the value as per your setup.


<appSettings>
<add key="conn" value="Data Source=vishnu;trusted_connection=yes;Initial Catalog=Users"/>
</appSettings>


First I get the dataset into which I fill the user list. But before this I check for the cache initially if it exists I directly cast it to a dataset, if not create a cache again.
daUsers.Fill(dsUsers,"tblUsers");

 Page Level Output Caching

This is at the page level and one of the easiest means for caching pages. This requires one to specify Duration of cache and Attribute of caching.


Syntax: <%@ OutputCache Duration="60" VaryByParam="none" %>

The above syntax specifies that the page be cached for duration of 60 seconds and the value "none" for VaryByParam* attribute makes sure that there is a single cached page available for this duration specified.

so at last Caching is a technique that definitely improves the performance of web applications if one is careful to have a balance in terms of which data needs to be cached and parameter values for expiration policy.

hope this article helps you to imporve your applicaiton performance and best result ever

- you can find more information  here 
- how to perform Cache Optimization



IsPostBack property
2009-07-21T07:55:00.000+01:00
IsPostBack-Gets a value indicating whether the page is being loaded in response to a client postback, or if it is being loaded and accessed for the first time.

  when the page is loaded in order to determine whether the page is being rendered for the first time or is responding to a postback. If the page is being rendered for the first time, the code calls the Page..::.Validate method. 

 Syntax: 

  
  private void Page_Load()
{
    if (!IsPostBack)
    {
        // Validate initially to force asterisks
        // to appear before the first roundtrip.
        Validate();
    }
}
 

  Example 

 
 protected void Page_Load(object sender, EventArgs e)
{
 if (!Page.IsPostBack)
 {
   PageDataBind();
 }
 else
 {
    Response.write("2nd Time Visisted..");
 }
}

protected void PageDataBind(string SearchProduct)
{ 
  SqlDataAdapter SDA ;
  DataSet ds = new DataSet();
  String sql = "select * from Emp where  ID ='"+ DropDownList.SelectedItem.Text +"'";
  SDA.Fill(ds, "productDetails");
  ShowId.DataSource = ds;
  ShowId.DataBind();
}
 

when loading of the page, the control doesn't go through the redundant action of re-loading the control. It loads it only once, at the initial page load. Once the page is loaded, the click event from the button (or however you post back) is considered to be a postback. Yes, the page gets reloaded, but, by surrounding your data population with this statement, the page knows that the initial data loading was already done, so it doesn't happen any more, and it gets maintained throughout any subsequent post back. The second, and most rewarding thing that happens is that the selection which was made by the end user is maintained throughout the post back. This is the pay-off - by doing it with the If/Then Page.IsPostBack statement, your selection carries through to your query and the query returns the results you wanted in the first place.


Filter User via IP
2009-07-20T12:16:00.000+01:00
its a good technique to Restrict user to view your website , this task can be done with the help of checking of user's IP Address and match with our database and if user get found under 
 that IP then you can set Denied Access to them .

 But in this case you need a Live IP Address database,
 there are so many website are there they are provides free IP Address database range .
 
 and with the help of that u can Denied user.
 
 here are the List of free IP address database sites 

 
 http://www.ipinfodb.com/ip_database.php 

 http://www.ip-db.com/

 

 Simply download that.

 1. Create one IP check function 
 2. take user Ip address
  
    in ASP : - Ip =Request.Servervariables("REMOTE_HOST")
    in C#  : - String ipAddress = (Request.ServerVariables["REMOTE_ADDR"]);

 3. then check if user's Ip address is there in you'r database , depend on that 
    you can prevent user.

 
 hope it will helps you,


open new window in GridView using OnRowCreated
2009-07-20T07:34:00.000+01:00
In GridView using "OnRowCreated" function we can add onClick function.

  here is the sample code 
 
  html code

  
    <asp:TemplateField HeaderText="Header 3">  
         <ItemTemplate>  
             <asp:Label ID="Label1" runat="server" Text="Click Me"></asp:Label>  
         </ItemTemplate>  
     </asp:TemplateField>  
  

  and CodeBehind is 
  

   protected void Gridview1_RowCreated(object sender, GridViewRowEventArgs e)  
   {  
     if (e.Row.RowType == DataControlRowType.DataRow)  
     {  
         Label l = (Label)e.Row.FindControl("Label1");  
         if (l != null)  
         {  
             string script = "window.open('Default.aspx');";  
             l.Attributes.Add("onclick", script);  
         }  
     }  
 } 
 

  run the Application and click "Click Me" it will open new window , indirectly we are adding 
  OnClick Event in That Row.


import contact list from gmail,yahoo,rediffmail
2009-07-18T10:16:00.001+01:00
yes , use can retrieve the contact list from mail server like Gmail, Rediff , Hotmail , AOL and all others They are providing free API to do this, u simply download the Application at your end and pass the parameter like (ID,Password) .

Gmail  : 
google code API 


Yahoo / Live / Rediff
Yahoo / Live / Rediff


Rediff API 
Rediff API 


Zip application
opencontactsnet OpenContact.NET 1.0 file released: OpenContactsNet-1.0.zip 
  

 AOL API 
 AOL Guide to Integrating OpenAuth 
happy coding.......


CountDown Timer
2009-07-18T06:43:00.000+01:00
Hi , here is cool triks of CountDown timer, mostly its useful in website while validating time like online exam, date time , game countdown , and so many

Below is the code needed to display count down in HTML page using javascript.
 
You define container for the count down (either <span> or <div> tag) and the initial value, and the code updates the time automaticlly in the format HH:MM:SS

You can also control the style of the container using standard CSS, as demonstrated in the below and attached code.

To activate the count down in one of your existing pages you
have to follow two steps:

1. include the attached CountDown.js file with:

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

2. have such javascript in the  section:

 

<script type="text/javascript">
window.onload=WindowLoad;
function WindowLoad(event) {
 ActivateCountDown("CountDownPanel", 100);
}
</script>


where "CountDownPanel" is the ID of the container 
(i.e. you should have <span> or <div> with this ID) and 100 is the time in seconds to be counted.

here is CountDown.js file -------------------------------

var _countDowncontainer=0;
var _currentSeconds=0;

function ActivateCountDown(strContainerID, initialValue) {
 _countDowncontainer = document.getElementById(strContainerID);
 
 if (!_countDowncontainer) {
  alert("count down error: container does not exist: "+strContainerID+
   "\nmake sure html element with this ID exists");
  return;
 }
 
 SetCountdownText(initialValue);
 window.setTimeout("CountDownTick()", 1000);
}

function CountDownTick() {
 if (_currentSeconds <= 0) {
  alert("your time has expired!");
  return;
 }
 
 SetCountdownText(_currentSeconds-1);
 window.setTimeout("CountDownTick()", 1000);
}

function SetCountdownText(seconds) {
 //store:
 _currentSeconds = seconds;
 
 //get minutes:
 var minutes=parseInt(seconds/60);
 
 //shrink:
 seconds = (seconds%60);
 
 //get hours:
 var hours=parseInt(minutes/60);
 
 //shrink:
 minutes = (minutes%60);
 
 //build text:
 var strText = AddZero(hours) + ":" + AddZero(minutes) + ":" + AddZero(seconds);
 
 //apply:
 _countDowncontainer.innerHTML = strText;
}

function AddZero(num) {
 return ((num >= 0)&&(num < 10))?"0"+num:num+"";
}




Twitter API in C#
2009-07-17T06:17:00.002+01:00
I used C# and WCF, but I could have just as easily used an ASMX web service.  This code is fairly simple. 

Note: This code will not run as listed.  You have to have a password.  This code has that as a shared variable, but I'm not showing that to you, seriously.  I hope that this is of some help to you.



        [OperationContract]
        public void SubmitUserStatus(string username, string tweet)
        {
            // encode the username/password
            string user = Convert.ToBase64String(System.Text.Encoding.UTF8.GetBytes(username + ":" + password));
            // determine what we want to upload as a status
            byte[] bytes = System.Text.Encoding.ASCII.GetBytes("status=" + tweet);
            // connect with the update page
            HttpWebRequest request = (HttpWebRequest)WebRequest.Create("http://twitter.com/statuses/update.xml");
            // set the method to POST
            request.Method = "POST";
            // thanks to argodev for this recent change!
            request.ServicePoint.Expect100Continue = false;
            // set the authorisation levels
            request.Headers.Add("Authorization", "Basic " + user);
            request.ContentType = "application/x-www-form-urlencoded";
            // set the length of the content
            request.ContentLength = bytes.Length;
            // set up the stream
            Stream reqStream = request.GetRequestStream();
            // write to the stream
            reqStream.Write(bytes, 0, bytes.Length);
            // close the stream
            reqStream.Close();
        } 




for more information on Twitter API  
Link : http://twitter.com/twitterapi
Orignally posted from this Article


Use XMLHTTP Object in C#
2009-07-15T14:20:00.001+01:00
The XMLHttpRequest  object can be used by scripts to programmatically connect to their originating server via HTTP. you can use this XMLHTTP object in C#.
  
 follow the steps to do thi.

 Steps
 1. Add New Refrence to the Microsoft,Ver3.0 (Msxml 3/4) in your project.
    
    how to add new Refrence 

 2. import the Namespace   Using MSXML2;

 3. now add this code in codebehind 

 

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using MSXML2;

public partial class MSXML : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        // to get page data (using msxml4)
        XMLHTTP40 http = new XMLHTTP40();
        http.open("GET", "http://www.xyz.xom/sendResult.aspx"+TextBox1.Text+"", false, null, null);
        http.send();
        string value = http.responseText;
        Response.Write(value.ToString());
    }
}





 4.Add this code in Html

 

  <form id="form2" runat="server">
   <div>
       <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
       <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" /></div>
   </form>
 


Pass multiple parameter using HyperLink field in GridView
2009-07-14T11:36:00.000+01:00
While using Hyperlink field u can send multiple parameter in Gridview , and then u can retrive it using QueryString Parameter.
 
 here in this Example when user will click on username then it will redirect to 
  http://xyz.com/ShowUser.aspx?id={0}&city={1} this page 
 and it will pass customer id and city .

 
 
 
 

<asp:SqlDataSource id="datasource1" runat="server"  SelectCommand="SELECT CustomerID, CompanyName, City FROM Customers"
/>
 
<asp:GridView id="gridview1" DataSourceID="datasource1" runat="server"
              AutoGenerateColumns="False">
  <Columns>
 
    <asp:BoundField DataField="CustomerID" HeaderText="BoundField" />
 
    <asp:HyperLinkField 
         DataTextField="CustomerName" 
         DataNavigateUrlFields="CustomerID,City"
         DataNavigateUrlFormatString=
           "http://xyz.com/ShowUser.aspx?id={0}&city={1}" />
 
  </Columns>
</asp:GridView>

 


Detecting Client IP address
2009-07-14T10:55:00.000+01:00
To keep track of Visitor's Record such as IP address and all 
 then u can use this way , 
 it will display the Client proxy ip address , if the client is using Proxy server.



if (Context.Request.ServerVariables["HTTP_VIA"] != null) 
            {
                IP = Context.Request.ServerVariables["HTTP_X_FORWARDED_FOR"].ToString();
            }
            else
            {
               IP = Context.Request.ServerVariables["REMOTE_ADDR"].ToString();
            }




Paging with DataList Control
2009-07-13T07:50:00.001+01:00
DataList is a data bound list control that displays items using certain templates defined at the design time.The content of the DataList control is manipulated by using templates sections such as  FooterTemplate, HeaderTemplate, ItemTemplate, SelectedItemTemplate ,AlternatingItemTemplate, EditItemTemplate and SeparatorTemplate 

PagedDataSource, is a class that encapsulates the paging related properties for data-bound controls such as DataGrid, GridView, DataList, DetailsView.

Now lets take an Example of Displaying Country on Datalist with Paging

Steps.


1. Create Datalist for Country 

<asp:DataList ID="dlCountry" runat="server"> 
 <ItemTemplate>
   <asp:Label ID="Label1" runat="server" Text='<%# Eval("Country_Code") %>'></asp:Label>     
   <asp:Label ID="Label2" runat="server" Text='<%# Eval("Country_Name") %>'></asp:Label>
 </ItemTemplate>
</asp:DataList>


<asp:DataList ID=" dlPaging" runat="server" OnItemCommand="dlPaging _ItemCommand">
<ItemTemplate>
  <asp:LinkButton ID="lnkbtnPaging" runat="server" CommandArgument='<%# Eval("PageIndex") %>' CommandName="lnkbtnPaging" Text='<%# Eval("PageText") %>'></asp:LinkButton>
</ItemTemplate>
</asp:DataList>



2. now on Code Behind write a method to fetch data from the Country’s table.

private void BindGrid()
{ 
  string sql = "Select * from Country Order By Country_Name"; 
  SqlDataAdapter da = new SqlDataAdapter(sql, “Yourconnectionstring”); 
  DataTable dt = new DataTable(); 
  da.Fill(dt); 

  pds.DataSource = dt.DefaultView;
  pds.AllowPaging = true;
  pds.PageSize = Convert.ToInt16(ddlPageSize.SelectedValue);
  pds.CurrentPageIndex = CurrentPage;
  lnkbtnNext.Enabled = !pds.IsLastPage;
  lnkbtnPrevious.Enabled = !pds.IsFirstPage; 

  dlCountry.DataSource = pds;
  dlCountry.DataBind();

  doPaging();
} 



3.Call this BindGrid method in the Page load event. 

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


4.Declare a PagedDataSource object at page scope.
 PagedDataSource pds = new PagedDataSource();

5. create new property call CurrentPage to maintain the latest selected page index.
and pu this code on it.

public int CurrentPage
{

  get 
  { 
    if (this.ViewState["CurrentPage"] == null) 
      return 0; 
    else 
      return Convert.ToInt16(this.ViewState["CurrentPage"].ToString()); 
  }

 set
 { 
  this.ViewState["CurrentPage"] = value;
 }

}


6.write a method ‘doPaging’ to create a list of page numbers.

private void doPaging()
{
 DataTable dt = new DataTable();
 dt.Columns.Add("PageIndex");
 dt.Columns.Add("PageText");
 for (int i = 0; i < pds.PageCount; i++)
 {
  DataRow dr = dt.NewRow(); 
  dr[0] = i; 
  dr[1] = i + 1; 
  dt.Rows.Add(dr);
 }

 dlPaging.DataSource = dt;
 dlPaging.DataBind();
}


7. create new paging event 


protected void dlPaging_ItemCommand(object source, DataListCommandEventArgs e)
{
 if (e.CommandName.Equals("lnkbtnPaging"))
 {
   CurrentPage = Convert.ToInt16(e.CommandArgument.ToString());
   BindGrid();
 }
}


8. Previous And Next Button Events
 

protected void lnkbtnPrevious_Click(object sender, EventArgs e)
{
  CurrentPage -= 1;
  BindGrid();
}

protected void lnkbtnNext_Click(object sender, EventArgs e)
{
  CurrentPage += 1;
  BindGrid();
}


9.Change PageSize Dynamically

protected void ddlPageSize_SelectedIndexChanged(object sender, EventArgs e)
{
  CurrentPage = 0;
  BindGrid();
}



10.HighLight Selected Page Number


protected void dlPaging_ItemDataBound(object sender, DataListItemEventArgs e)
{
  LinkButton lnkbtnPage = (LinkButton)e.Item.FindControl("lnkbtnPaging"); 
  if (lnkbtnPage.CommandArgument.ToString() == CurrentPage.ToString()) 
  { 
    lnkbtnPage.Enabled = false; 
    lnkbtnPage.Font.Bold = true; 
  }
}



view Demo here



Javascript Calendar.
2009-07-13T06:37:00.003+01:00
Calendar 
is a one of Gread fucntion while retriveing date from user end , there are lot many  use of calendar ex- date of Brith , Order date , Shipping Date  and lot many..
 
 in this case selecting proepr date is very imp , in term's of DD/MM/YYYY, some where using YYYY/MM/DD or MM/DD/YYYY , so in this case its its not undustable for the End user to Write Proper date in Text Box , but if you use Drop down in term of (DD/MM/YY  or MM/DD/YY ) then its useful for the user ,

 here i found some great Javascript code to do same , 
 
1.Ajax enabled  DatePicker v4 :
  

2.  VLA Calendar version 2 

3.Customizable calendar component 

4.jQuery:time/datePicker 


5. Fancy moo tools date picker 

6. Clean Calendar 

7. Date picker Widget 

8. Yet another JQuery Calendar 

9.Simple one 

hope this collection likes you.


Simple File Uploads in ASP.NET
2009-07-10T08:06:00.000+01:00
uploading a single file from the client machine to your server.

  watch live video here How to Upload 


automation for microsoft application using C#
2009-07-09T12:20:00.000+01:00
Automation client for Microsoft Excel by using C#.
 its a very basic requirement in Client side automation for Microsoft Application like 
 Excel / Word / OutLook / Powerpoint and all.
 
 To Automate Excel application using C# have a look on this Article 
  
 Known Issues with Automation 

Because the CLR uses a garbage collector for memory management, and because your RCW is itself a managed object, the lifetime of your Automation object is not guaranteed to end.you can get the actual help from here

317109 : Office Application Does Not Quit After Automation from Visual Studio .NET Client


Use of "IDENT_CURRENT"
2009-07-09T09:51:00.001+01:00
in sql if we declare column as a Identity columen,as if we want to retrieve the last inserted value then use this
    "IDENT_CURRENT" 


All SQL Server functions that retrieve the last inserted value into the Identity column of a table - @@IDENTITY, SCOPE_IDENTITY, IDENT_CURRENT are similar functions in that they return the last value inserted into the IDENTITY column of a table. 


 Use SCOPE_IDENTITY() , if you are not sure, if some triggers are going to be written or not on a table. Or, even better, use IDENT_CURRENT(tablename) to be more specific.

for more  details  


Export Gridview to xls
2009-07-08T13:38:00.000+01:00
Now you can Export content from GridView to Excel file 

 1. Create one Button "Export"

 <asp:Button id="Export" Text="Export" onClick="Export_Click"> </asp:Button>

 2. Add this on Export Event 
    
    protected void Export_Click(object sender, EventArgs e)
    {
        Response.AddHeader("content-disposition", "attachment;filename=ExportData.xls");
        Response.Charset = String.Empty;
        Response.ContentType = "application/vnd.xls";
        System.IO.StringWriter SWrite = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter htmWr = new HtmlTextWriter(SWrite);
        GridView1.RenderControl(htmWr);
        Response.Write(SWrite.ToString());
        Response.End();
    }
   
 
 that's it


Limiting Data from GridView
2009-07-07T08:05:00.001+01:00
while Desinging GridView we want some special effets like (coloring , bold, Setting width , height )
and so many , you can do this by handling event like RowCreated and implementing event handler for it OnRowCreated.


<asp:GridView ID="ctlGridView" runat="server" OnRowCreated="OnRowCreated" />


And in your code behind you can add


protected void OnRowCreated(object sender, GridViewRowEventArgs e)
{
   if (e.Row.RowType == DataControlRowType.DataRow)
   {
     string Comments = (String)DataBinder.Eval(e.Row.DataItem, "Comment");
           if (Comments != null)
           {
               if (Comments.Length > 30)
               {
                   Comments = Comments.Substring(0, 40) + "...";
                   e.Row.ForeColor = System.Drawing.Color.red;
                  
               }
           }
   }
}


 in that on "Comment" filed , i just simply minimize the string uptp 40 character and make it  as a  "RED" color.
 like that you can add more feature as u want.


How To Access Content From MasterPage in ASP.NET
2009-07-07T07:15:00.001+01:00
hi , some time we required some content from master page.
 lets say we have created menu bar in Master page and i want to use that menu bar in some page 
 consider(Details.aspx) and my master page is ("MasterPanel.master) , now how to access master page content 
 to display the Menu.

 MasterPanel.master
 
 <%@ Master Language="C#" AutoEventWireup="true" CodeFile="MasterPanel.master.cs" Inherits="MasterPanel" %> 
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 <html xmlns="http://www.w3.org/1999/xhtml">
 <head id="Head1" runat="server">
    <title>: Master Demo: </title>
 </head>
 <body>
    <form id="form1" runat="server">
     <table border="0" style="width: 100%">
                        <tr>
                            <td style="width: 100%">
                                <ul>
      <li>File</li> 
      <ul> 
      <li>Open </li> 
      <li>Save </li>
      </ul>
     <li>Logout</li>
     </ul>
        </td>
    </tr>
 </table>
    </form>
 </body>
 </html>
 
 

 Details.aspx 
 
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Details.aspx.cs"
    Inherits="Details" <b><font color=red>MasterPageFile="~/MasterPanel.master"</font></b> %>
<asp:Content ID="Det"  runat="Server" ContentPlaceHolderID="ContentPlaceHolder1">

  //Menu source will come
 
</asp:Content>
 
 in Details.aspx we have add MasterPageFile as "~/MasterPanel.master" so it will inclue all the 
 content from master page . by using <asp:Content> you can place that menu where you want in 
 Details.aspx page 

 That's it 
 
 Happy coding ......


How to Access Outlook Emails with ASP.NET ,C#
2009-07-06T13:27:00.001+01:00
Hi,
on my first post, i have covered how to add Refrences 
 on you'r .net application 
 now we require same thing to Send / Receive Mail via outlook using ASP.NET.
 To acquire these, all you need is Interop.Outlook.dll. 

 Stpes :
 1. Create one Project as "OutlookSendReceive" .
 2. include "Bin" folder on same , right click on it , select Add refrence 
    then click tab "COM " and select " Microsoft Outlook 11.0 " click ok 

 3. it will add assemblies on you'r web.config page 
    like 

     <assemblies>
       <add assembly="Microsoft.Office.Interop.Outlook, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e29c34"/>
     </assemblies>

 4. Define 
 "using Microsoft.Office.Interop.Outlook;
  using System.Text;" 

 5. copy that code on Page_load() event 

  
 Microsoft.Office.Interop.Outlook.Application nOutlook;
         Microsoft.Office.Interop.Outlook.NameSpace oNs;
         Microsoft.Office.Interop.Outlook.MAPIFolder oFldr;         

         try
         {
             nOutlook = new Microsoft.Office.Interop.Outlook.Application();
             oNs = nOutlook.GetNamespace("MAPI");

             //getting mail folder from inbox
             oFldr = oNs.GetDefaultFolder(OlDefaultFolders.olFolderInbox);
             Response.Write("Total Mail in Inbox :" + oFldr.Items.Count + "
");
             Response.Write("Total Unread items = " + oFldr.UnReadItemCount);
             foreach (Microsoft.Office.Interop.Outlook.MailItem oMessage in oFldr.Items)
             {
                 StringBuilder str = new StringBuilder();
                 str.Append("<table><tr><td><b>Sender :</b></td><td>");
                 str.Append(oMessage.SenderEmailAddress.ToString() + "</td></tr>");
                 
                 //Define Additional Information of Message
                 str.Append("<tr><td><b>Date :</b></td><td>" + oMessage.SentOn.ToShortDateString() + "</td></tr>");
                 if (oMessage.Subject != null)
                 {
                     str.Append("<tr><td><b>Subject :</b></td><td>" + oMessage.Subject.ToString() + "</td></tr>");
                 }
                 
                 str.Append("</table><br>");
                 Response.Write(str.ToString());
             }

         }
         catch (System.Exception ex)
         {
             Response.Write("Execption generated:" + ex.Message);
         }
         finally
         {
             GC.Collect();
             oFldr = null;
             oNs = null;
             nOutlook = null;
         }




 like this way you can access Outlooks mail , 
 thank you, 
 will come up more on how to access gmail /yahoo mail directly


Using Parameters with the SqlDataSource Control
2009-07-06T08:14:00.000+01:00
When using the SqlDataSource control, you can specify SQL queries and statements that use parameters. This helps make your data-binding scenarios more flexible by 
reading and writing database information based on values




how to Specifying Parameters in Commands 
When you use the SqlDataSource control, you can set the control's command properties to parameterized SQL statements or to the name of a stored procedure. 
The SqlDataSource control adds the value of the ParameterPrefix property to the beginning of all parameter names. (The default prefix is "@".) 


Using Parameters with the SqlClient Provider:
By default, the SqlDataSource control uses the System.Data.SqlClient data provider to work with SQL Server as the data source. The System.Data.SqlClient provider supports named parameters as placeholders, as shown in the following example: 


SELECT * FROM Stud WHERE Rollno = @Rno
  AND Name = @Name


The following example shows how to use parameters in an SQL command for a SqlDataSource control that uses the System.Data.SqlClient provider 

[C# code]

<asp:sqlDataSource ID="StudInfo" 
  SelectCommand="SELECT Marks,Rollno,ID  FROM Stud WHERE Rollno = @Rno"
  ConnectionString="<%$ ConnectionStrings:Stud %>" RunAt="server">
  <SelectParameters>
    <asp:Parameter Name="Rno" Type="Int32" DefaultValue="0" />
  </SelectParameters>

   //Suppose for insert query
 <InsertParameters>
         <asp:Parameter Name="abc"  Type="String" />
         <asp:Parameter Name="xyz"  Type="String" />
 </InsertParameters>

  // for update 
 <UpdateParameters>
   <asp:Parameter Name="abc"  Type="String" />
 </UpdateParameters>

 //you can also use Seesion Parameter 

 <SelectParameters>
              <asp:SessionParameter
                Name="Rollno"
                SessionField="Rno"
                DefaultValue="1" />
          </SelectParameters>

 // also pass via querystring  
 <SelectParameters>

  <asp:QueryStringParameter Name="Rollno" QueryStringField="rno" Type="int" />

</SelectParameters>


like this u can access Parameters with the SqlDataSource Control
also refer This Article


SQL Date Functions
2009-06-30T11:27:00.000+01:00
here are some sql DATE related functions :

 1. SET DATEFIRST 1 // set first day of the week as Monday

 2. SELECT (datepart(ww,@tDate)) + 1- datepart(ww,dateadd(dd,-datepart(dd,@tDate),@tDate)) nWeek //Week number in a month for a specific date

 3. SELECT DATEADD(mm, DATEDIFF(mm,0,@Month), 0)   //First Day of the Month

 4. SELECT DATEPART(WK, @Month) //Week Number of the Year

 5. Select Current_Timestamp;  // return current Select Current_Timestamp; 

 6. By using any of the following date functions it is possible to breakdown timestamps 

   
  SELECT MONTH(CURRENT_TIMESTAMP);- Return a Month(6)

SELECT DAY(CURRENT_TIMESTAMP);-Return a Day:(22)

SELECT DATE(CURRENT_TIMESTAMP); - returns a date (2004-06-22)

SELECT TIME(CURRENT_TIMESTAMP); - returns the time (10:33:11.840)

SELECT DAYOFWEEK(CURRENT_TIMESTAMP); - returns a numeric value (1-7)

SELECT DAYOFMONTH(CURRENT_TIMESTAMP); - returns a day of month (1-31)

SELECT DAYOFYEAR(CURRENT_TIMESTAMP); - returns the day of the year (1-365)

SELECT MONTHNAME(CURRENT_TIMESTAMP); - returns the month name (January - December)

SELECT DAYNAME(CURRENT_TIMESTAMP); - returns the name of the day (Sunday - Saturday)

SELECT WEEK(CURRENT_TIMESTAMP); - returns number of the week (1-53)
 


The LINQ Project
2009-06-30T10:07:00.000+01:00
The LINQ Project is a codename for a set of extensions to the .NET Framework that encompass language-integrated query, set, and transform operations. 


It extends C# and Visual Basic with native language syntax for queries and provides class libraries to take advantage of these capabilities


LINQ Project


Textbox Validation Summary C#
2009-06-30T05:37:00.002+01:00
A ValidationSummary control is displayed when the IsValid property of the page is false. It "polls" each of the validation controls on the page and aggregates the text messages exposed by each. The following sample illustrates displaying errors with a ValidationSummary. 
  

   Get Tex box Validation Summery 


Delete File in ASP
2009-06-29T13:54:00.000+01:00
Yes, you can delete a file by using FileSystem Object in ASP
 
 
 <%
// delete file
var FSO = Server.CreateObject("Scripting.FileSystemObject");
// get path to file 
PathFile = Server.MapPath("/path/folder/deletefilename);
// if file exists, delete it 
if(FSO.FileExists(PathFile)) FSO.DeleteFile(sPathToFile)
// file deleted

%>


  like this way we can create , delete folder using FSO (file system object)
  to know more about FSO system


Printing using C#
2009-06-23T06:34:00.000+01:00
Hi , printing is very easy case in all the task ,but when using ASP.NET, printing of web form is not that easy.
 if we're building a UI we usually do so by painting controls on the screen and allowing whoever developed them to worry about the whys and wherefores about how that control should look. 
  
 If you want to print on server side, then you can use System.Drawing.Printing classes just like when you work with .Net Windows Forms application.
 but if you are using client side then you need to consider more constraints and different possible solutions, depending of your specific needs.

 For printing, you use the System.Drawing.Printing namespace. The main class in this namespace is the PrintDocument  class, which represents an object that sends output to the printer. The role of this class is so central that you can achieve simple and complex printing tasks by using this class alone. However, as we shall see, other classes in this and other namespaces help make coding easier. 
 o print text or graphics, you call the Print method of the System.Drawing.Printing.PrintDocument class. One of the events the Print method invokes is the PrintPage event. You need to wire an event handler to the PrintPage event and write the code to send output to the printer. The event handler will receive an argument of type
 
 Here are way to print the Document / Form.
 Using PrintDialog 
 
 private void filePrintMenuItem_Click(Object sender , EventArgs e) 
    {
      PrintDialog dlg = new PrintDialog();
      dlg.Document = printDoc;
      if (dlg.ShowDialog() == DialogResult.OK) 
      {
        printDoc.Print();
      }
    }
 
 

 The filePrintMenuItem_Click event handler sends output to the printer if the user clicks the Print dialog box's OK button.

 Page Setup
 while priting adds the feature to set up the page that is used for printing.
  
 
 1. private PageSettings pgSettings = new PageSettings();
 2. Set pgSettings to the DefaultPageSettings property of printDoc before printing.
    
 private void filePrintMenuItem_Click(Object sender , EventArgs e) 
    {
      printDoc.DefaultPageSettings = pgSettings;
      PrintDialog dlg = new PrintDialog();
      dlg.Document = printDoc;
      if (dlg.ShowDialog() == DialogResult.OK) 
      {
        printDoc.Print();
      }
    }
 
 3. Allow the user to change the setting of the page..
  
 private void filePageSetupMenuItem_Click(Object sender , EventArgs e) 
    {
      PageSetupDialog pageSetupDialog = new PageSetupDialog();
      pageSetupDialog.PageSettings = pgSettings;
      pageSetupDialog.AllowOrientation = true;
      pageSetupDialog.AllowMargins = true;
      pageSetupDialog.ShowDialog();
    }
 

 4.Set the printDoc_PrintPage event handler to take into account the top and left margins.
 private void printDoc_PrintPage(Object sender , PrintPageEventArgs e)
    {
      String textToPrint = ".NET Printing is easy";
      Font printFont = new Font("Courier New", 12);
      int leftMargin = e.MarginBounds.Left;
      int topMargin = e.MarginBounds.Top;
      e.Graphics.DrawString(textToPrint, printFont, Brushes.Black, 
        leftMargin, topMargin);
    }
  

  

 Print Preview
 In a Windows application, before the user prints, they can normally view a preview of how the printout will like on paper. You can also provide this feature by adding the following code to the filePrintPreviewMenuItem_Click event handler. 
 
 private void filePrintPreviewMenuItem_Click(Object sender , EventArgs e) 
    {
      PrintPreviewDialog dlg = new PrintPreviewDialog();
      dlg.Document = printDoc;
      dlg.ShowDialog();
    }



 

 here you can get best printing 
example  
 Hope it will helpful for you,plz comment on it.
 
 Thank You,


Open other website content on my asp.net Page
2009-06-20T10:29:00.000+01:00
here is an Tips for displaying an Otherpage content on you'r own asp.net web page

follow this steps .

Add new Panel

 
  <asp:panel id="ViewPanel runat="server" Width="100%" > 
  </asp:panel>
 

 Add Namespan 

  
   using System.Text;using System.Net;using System.IO; 
 
 add this namespace on your page declaration part.

 now on Page_load() paste this code


 
 protected void Page_Load(object sender, EventArgs e)
 {
  Uri weburi = new Uri(http://www.gmail.com/);
  StringBuilder str = new StringBuilder();
  string temp = "";
  HttpWebRequest webrequest = (HttpWebRequest)WebRequest.Create(weburi);
  HttpWebResponse webresponse = (HttpWebResponse)webrequest.GetResponse();
  StreamReader webstream = new StreamReader(webresponse.GetResponseStream(), Encoding.ASCII);
  while ((temp = webstream.ReadLine()) != null)
  str.Append(temp + "\r\n");
  webstream.Close();
  mainpanel.Controls.Add(new System.Web.UI.LiteralControl(str.ToString()));
 }
 
 
 


Plz write full path on you'r URI.
that's it


ways of using hyperlink control in data controls.
2009-06-20T07:58:00.000+01:00
Here are some different ways of using hyperlink control in data controls.

What is a  Hyperlink control:
A hyperlink control is used to navigate from the client to another page.Here is a example for a hyperlink control

 <asp:HyperLink ID="hyp1" runat="server" Text="test" ></asp:HyperLink>


In data controls like datagrid and gridview we have hyperlink column and hyperlink field.
We will have a gridview containing hyperlinkfield  as shown below  where DataNavigateUrlFields and  DataNavigateUrlFormatString are used to get
Fields from datasource and construct the url for navigation to next page.In the datagrid hyperlink column we have the same fields and you can follow the same procedure.


<asp:GridView ID="gdview" runat="server" AutoGenerateColumns="False" >
<Columns>
<asp:HyperLinkField HeaderText="Category"  DataTextField="CategoryName" DataNavigateUrlFields="CategoryID"   DataNavigateUrlFormatString="~/page.aspx?id={0}" />
</Columns>
</asp:GridView>

in code behind:
protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            BindGrid();
        }
    }

    public void BindGrid()
    {
        SqlConnection conn = new SqlConnection("Data Source='localhost';Initial Catalog='Northwind';Persist Security Info=False ");
        SqlDataAdapter da = new SqlDataAdapter("", conn);
        da.SelectCommand = new SqlCommand("select * from emp", conn);
        DataSet ds = new DataSet();
        da.Fill(ds, "data");
        gdview.DataSource = ds.Tables[0].DefaultView;
        gdview.DataBind();   

    }


Using Mutliple dataitems
If you want to send mutliple items to next page you have to do like this



<asp:GridView ID="gdview" runat="server" AutoGenerateColumns="False" >
<Columns>
<asp:HyperLinkField HeaderText="Category"  DataTextField="CategoryName" DataNavigateUrlFields="CategoryID,CategoryName"   DataNavigateUrlFormatString="~/page.aspx?id={0}&name={1}" />
</Columns>
</asp:GridView>



In runtime
Inorder to access the hyperlinkfield in code behind we have to follow the below 
Procedure

In design view:



<asp:GridView ID="gdview" runat="server" AutoGenerateColumns="False"  OnRowDataBound="gdview_RowDataBound" >
<Columns>
<asp:HyperLinkField HeaderText="Category"  DataTextField="CategoryName"  runat="server"  />
</Columns>
</asp:GridView>



In code behind:

protected void gdview_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        HyperLinkField hyp = (HyperLinkField)gdview.Columns[0];
        string[] items = new string[2];
        items[0] = "CategoryName";
        items[1] = "CategoryID";
        hyp.DataNavigateUrlFields = items;
        hyp.DataNavigateUrlFormatString ="~/page.aspx?id={0}&name={1}";
    }



Using Hyperlink control

In the case of repeater and datalist  we don’t have hyperlink column.In that scenario we have to use hyperlink control in itemtemplate.

.


In design view:
<asp:Repeater ID="rp1" runat="server">
<ItemTemplate>
<table>
<tr>
<td>
<asp:HyperLink ID="hyp1" runat="server" Text='<%#Eval("CategoryName")%>' NavigateUrl='<%#"page.aspx?id=" + DataBinder.Eval(Container.DataItem," CategoryID") + "&name=" + DataBinder.Eval(Container.DataItem,"CategoryName")%>'  ></asp:HyperLink>
</td> 
</tr>
</table>
</ItemTemplate>
</asp:Repeater>



in code behind:


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

    public void BindRep()
    {
        SqlConnection conn = new SqlConnection("Data Source='localhost';Initial Catalog='Northwind';Integrated Security=SSPI;Persist Security Info=False ");
        SqlDataAdapter da = new SqlDataAdapter("", conn);
        da.SelectCommand = new SqlCommand("select CategoryName,CategoryID from Categories", conn);
        DataSet ds = new DataSet();
        da.Fill(ds, "data");
        rp1.DataSource = ds.Tables[0].DefaultView;
        rp1.DataBind();
    }


Here in this example we have passed multiple data items to page.aspx.In the same way you can create hyperlink control in datalist.


prevent multiple form submit at client side
2009-06-19T10:31:00.001+01:00
In Html  tag Button one issue is that they can be clicked more than once, and under certain circumstances this can cause issues. because of that may be data may get inserted multiple time, wrong information can be get added and so on. To ensure that the button can only be pressed once you can do the following.

Actually there may way to do this 
1. Disable button

 javascript:this.disabled=true;this.value='Submitting....';doSubmit('SUBMIT');

Simply add this in you button onClick method 

<INPUT TYPE="Button" VALUE="Submit" onClick="if(this.value == 'Submit') this.form.submit(); this.value = 'Please Wait.';this.disabled=true;">

2. Count click

 Second one is count how many times user get click on it 

  
   <script language="javascript">
   var NoOfClick=0;
   function chksubmit()
   {
       if NoOfClick >0)
       {
  alert("Wait! Request is in Process...");
 return false;
       }
     NoOfClick ++;
    document.creditcardinfo.action="xyz.asp";
    document.creditcardinfo.submit(); 
   }
 
<html>
<itle> button Ex <title>
<body> <form>
<input type="button" value="Submit" onClick="chksubmit();">
</form></body>
</html>


3.  Hide button 
 
 in this section simply define one Div and in javascript hide or show that div section , so when user click on submit that div(consider loding images) will appear on Submit button and user will not able to view that submit button.like that way also you can stop user to clicking more than ones time.

hope you like my tricks 
any query plz let me know?


how to compress files using asp
2009-05-16T06:13:00.000+01:00
how to compress files using asp

most of the time we require to compress file and save it to perticular localtion , or you can
use the for any purpose as u want .

for this we requires Server supporting WScript.Shell - most hosts won't allow this.

here u can get the download link , here u can specify either relative path or absolute path

before that please download this file, click here to download

-zipfile.asp
< % 

'---------------------------------------------------------
'CreateZipFile: function to create zip file at perticular location
'ZipPath - full path for the zip file, including the zip file name.
'arrFilesPath - array of the files to be zipped, 
  e.g. Array("C:\*.exe", "C:\foldername\*.*")
'NOTE: this code requires ZIP.EXE utility in the same location
' as this file.
'---------------------------------------------------------
Sub CreateZipFile(ZipPath, arrFilesPath)
 Const PKZIP_FILE_NAME="zip.exe"
 Dim strCommand, objShell, objFSO
 Dim x

'first check zip.exe file is exists:
 Set objFSO=Server.CreateObject("Scripting.FileSystemObject")
 If Not(objFSO.FileExists(Server.MapPath(ZIP_FILE_NAME) )) Then
 Set objFSO=Nothing
 Err.Raise 20000, "Zip File Creator", "zip utility not found:  "&Server.MapPath(ZIP_FILE_NAME)
 End If

 'delete current file:
 If objFSO.FileExists(ZipPath) Then
  objFSO.DeleteFile(ZipPath)
 End If
 Set objFSO=Nothing
 
 'batch command:

 strCommand=Server.MapPath(ZIP_FILE_NAME)&" -add "&ZipPath&" "
 For x=0 To UBound(arrFilesPath)
  strCommand=strCommand&arrFilesPath(x)
  If x < UBound(arrFilesPath) Then strCommand=strCommand&" "
 Next

 'execute:
 Set objShell=Server.CreateObject("WScript.Shell")
 objShell.Run strCommand, 0, True 'wait!
 
 'done.
 Set objShell=Nothing
 End Sub
%>

now u can call your CreateZipFile() function 
-checkZipFile.asp


< % 

Call checkZipFile()

Sub checkZipFile()
 'create zip and give link:
 Call CreateZipFile(Server.MapPath("Testzip.zip"), Array(Server.MapPath("images")&"\*.*"))
 Response.Write("click here download zip")
End Sub
%>
here u can get the download link , here u can specify either relative path or absoutate path


how to display records from an excel file
2009-05-16T06:00:00.000+01:00
hi this is my first blog in this blogspot ,  hope it may help you ..
 
i have seen most of the time software people require to display records from an Microsoft Excel in an ASP. We could use  SQL command while retreving data from an excel sheet. for the we know how to connect with sql

here is the sql connection string :

strConnection = "DBQ=" & Server.MapPath("nameofexcelfile.xls") & "; DRIVER={Microsoft Excel Driver (*.xls)};"

We will use a specific driver to connect to Excel files.
so for that we can use ODBC

An Example :

strConnection = "DBQ=" & Server.MapPath("nameofexcelfile.xls") & "; DRIVER={Microsoft Excel Driver (*.xls)};"

Set conn = Server.CreateObject("ADODB.Connection")
Set rss = Server.CreateObject("ADODB.Recordset")
cn.open strConnection


sql="select * from tablename;"

rss.Open sql, conn, adOpenStatic, adLockPessimistic


do while not rss.eof
response.write rss("Fieldname")
rss.movenext
loop

rss.close
Set rss = nothing
conn.close
Set conn = nothing


and now u can access you excel content in you are asp coding

thank you.