tag:blogger.com,1999:blog-3050754948529411091Wed, 04 Jan 2012 06:33:44 +0000Data Controls and Data Source In Asp.netRemotingonline Books for javaC# .net libraryCursor In SqlserverEvent and DelegtesDOTNET 3.0dotnet 2.0JavascriptTriggers In SqlServerDataTypes in Sqlserver and C#.netSQL Basic QuestionsOOPS(Object Oriented Programming)SharePointIndex In Sqlserveronline Library for Asp.net 1.1Articles and Forumdotnet 3.5XMLSql Server CommandsAdo.net libraryonline Library for Asp.net 2.0Web ServiceDesign Patternshttp://center4code.blogspot.com/noreply@blogger.com (Sameer Khan)Blogger32125tag:blogger.com,1999:blog-3050754948529411091.post-1040668405413696930Thu, 27 May 2010 09:30:00 +00002010-05-27T02:33:37.220-07:00Design Patterns <!-- /* Font Definitions */ @font-face {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0; mso-font-charset:2; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:0 268435456 0 0 -2147483648 0;} @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:http://feedproxy.google.com/~r/Center4code/~3/T6kf0OpZyWc/adapter.htmlnoreply@blogger.com (Sameer Khan)<p><a href="http://feedads.g.doubleclick.net/~a/apyG_Aes8LCn2SVh86LcB4R8zhg/0/da"><img src="http://feedads.g.doubleclick.net/~a/apyG_Aes8LCn2SVh86LcB4R8zhg/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/apyG_Aes8LCn2SVh86LcB4R8zhg/1/da"><img src="http://feedads.g.doubleclick.net/~a/apyG_Aes8LCn2SVh86LcB4R8zhg/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Center4code?a=T6kf0OpZyWc:VLoroytOxFc:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Center4code?d=yIl2AUoC8zA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Center4code/~4/T6kf0OpZyWc" height="1" width="1"/>http://center4code.blogspot.com/2010/05/adapter.htmltag:blogger.com,1999:blog-3050754948529411091.post-9222329337881201207Thu, 27 May 2010 09:18:00 +00002010-05-27T02:19:39.654-07:00Design PatternsDOTNET 3.0 <!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:-1610611985 1107304683 0 0 159 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; http://feedproxy.google.com/~r/Center4code/~3/OX76rrrObwE/design-patterns.htmlnoreply@blogger.com (Sameer Khan)<p><a href="http://feedads.g.doubleclick.net/~a/q-wWhp6THiA3-rAZoCuvnoY3ZT8/0/da"><img src="http://feedads.g.doubleclick.net/~a/q-wWhp6THiA3-rAZoCuvnoY3ZT8/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/q-wWhp6THiA3-rAZoCuvnoY3ZT8/1/da"><img src="http://feedads.g.doubleclick.net/~a/q-wWhp6THiA3-rAZoCuvnoY3ZT8/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Center4code?a=OX76rrrObwE:NIWa3yWnVs4:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Center4code?d=yIl2AUoC8zA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Center4code/~4/OX76rrrObwE" height="1" width="1"/>http://center4code.blogspot.com/2010/05/design-patterns.htmltag:blogger.com,1999:blog-3050754948529411091.post-1327746576736726366Wed, 25 Nov 2009 09:30:00 +00002009-11-25T01:48:52.514-08:00Javascript    <script type="text/javascript" charset="utf-8">        function filter (term, _id, cellNr){     var suche = term.value.toLowerCase();     var table = document.getElementById(_id);     var ele;     for (var r = 1; r < table.rows.length; r++){         ele = table.rows[r].cells[cellNr].innerHTML.replace(/<[^>]+>/g,"");         if (ele.toLowerCase().indexOf(suche)>=0 )             table.rows[r].http://feedproxy.google.com/~r/Center4code/~3/69npAX8bAo8/filter-gridview-on-keypress-of.htmlnoreply@blogger.com (Sameer Khan)<p><a href="http://feedads.g.doubleclick.net/~a/7bvpRholswphlzApavAF0x18emY/0/da"><img src="http://feedads.g.doubleclick.net/~a/7bvpRholswphlzApavAF0x18emY/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/7bvpRholswphlzApavAF0x18emY/1/da"><img src="http://feedads.g.doubleclick.net/~a/7bvpRholswphlzApavAF0x18emY/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Center4code?a=69npAX8bAo8:Ss_Nu8lnwf4:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Center4code?d=yIl2AUoC8zA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Center4code/~4/69npAX8bAo8" height="1" width="1"/>http://center4code.blogspot.com/2009/11/filter-gridview-on-keypress-of.htmltag:blogger.com,1999:blog-3050754948529411091.post-7739138652709077709Sat, 08 Nov 2008 08:50:00 +00002008-11-08T00:53:01.673-08:00All you want to know about a mobile website got to the below mention linkhttp://www.codeproject.com/KB/mobile/All-about-a-mobile-websit.aspxandhttp://worldofasp.net/tut/XHTM_L-MP/Basics_of_XHTML-MP_178.aspxhttp://feedproxy.google.com/~r/Center4code/~3/WrrrQ1WfVAo/want-to-know-about-mobile-website.htmlnoreply@blogger.com (Sameer Khan)<p><a href="http://feedads.g.doubleclick.net/~a/-Y3JdRGVzX76LGRfefQrEqUAV8c/0/da"><img src="http://feedads.g.doubleclick.net/~a/-Y3JdRGVzX76LGRfefQrEqUAV8c/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/-Y3JdRGVzX76LGRfefQrEqUAV8c/1/da"><img src="http://feedads.g.doubleclick.net/~a/-Y3JdRGVzX76LGRfefQrEqUAV8c/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Center4code?a=WrrrQ1WfVAo:NXnlZlqnx_0:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Center4code?d=yIl2AUoC8zA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Center4code/~4/WrrrQ1WfVAo" height="1" width="1"/>http://center4code.blogspot.com/2008/11/want-to-know-about-mobile-website.htmltag:blogger.com,1999:blog-3050754948529411091.post-1862899161365333466Wed, 09 Jul 2008 12:20:00 +00002008-07-09T05:20:57.663-07:00ViewstateSession VariablesApplication VariablesCacheCookies Now the question arises that when to use what? 1- Viewstate Viewstate is a hidden fields in an ASP.NET page, contains state of those controls on a page whose “EnableViewstate” property is “true”. You can also explicitly add values in it, on an ASP.NET page like: Viewstate.Add( “TotalStudents”, “87″ ); Viewstate should be used when you http://feedproxy.google.com/~r/Center4code/~3/CL3piQ7bhu8/state-managment.htmlnoreply@blogger.com (Sameer Khan)<p><a href="http://feedads.g.doubleclick.net/~a/0OIyZS-j8roXGvmEvL_wyEq2WW0/0/da"><img src="http://feedads.g.doubleclick.net/~a/0OIyZS-j8roXGvmEvL_wyEq2WW0/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/0OIyZS-j8roXGvmEvL_wyEq2WW0/1/da"><img src="http://feedads.g.doubleclick.net/~a/0OIyZS-j8roXGvmEvL_wyEq2WW0/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Center4code?a=CL3piQ7bhu8:GJNxkinXcFk:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Center4code?d=yIl2AUoC8zA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Center4code/~4/CL3piQ7bhu8" height="1" width="1"/>http://center4code.blogspot.com/2008/07/state-managment.htmltag:blogger.com,1999:blog-3050754948529411091.post-2128206818279775030Tue, 22 Apr 2008 04:26:00 +00002008-04-21T21:27:41.264-07:00SharePointhttp://www.microsoft.com/education/slk.mspxhttp://sfportal.sfusd.edu/sites/LearningSharepoint/default.aspxhttp://office.microsoft.com/en-us/sharepointserver/HA101756051033.aspxhttp://feedproxy.google.com/~r/Center4code/~3/Tkzxo6LYa-A/sharepoint-gallary.htmlnoreply@blogger.com (Sameer Khan)<p><a href="http://feedads.g.doubleclick.net/~a/klwCXcbigpXpF8Z7xYZQ2UEH2BM/0/da"><img src="http://feedads.g.doubleclick.net/~a/klwCXcbigpXpF8Z7xYZQ2UEH2BM/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/klwCXcbigpXpF8Z7xYZQ2UEH2BM/1/da"><img src="http://feedads.g.doubleclick.net/~a/klwCXcbigpXpF8Z7xYZQ2UEH2BM/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Center4code?a=Tkzxo6LYa-A:pTRHGYeXFyQ:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Center4code?d=yIl2AUoC8zA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Center4code/~4/Tkzxo6LYa-A" height="1" width="1"/>http://center4code.blogspot.com/2008/04/sharepoint-gallary.htmltag:blogger.com,1999:blog-3050754948529411091.post-2579546647702147591Tue, 22 Apr 2008 04:18:00 +00002008-04-21T21:45:37.722-07:00Javascript<!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><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /><title>Untitled Document</title><script language="javascript" type="text/javascript"><!--function dropdown_menu_hack(el){ if(http://feedproxy.google.com/~r/Center4code/~3/C_yk9QdNSSc/dropdownlist-constant-widthchange.htmlnoreply@blogger.com (Sameer Khan)<p><a href="http://feedads.g.doubleclick.net/~a/0kvjSG-DVhppmykPe2QOyRQXsSY/0/da"><img src="http://feedads.g.doubleclick.net/~a/0kvjSG-DVhppmykPe2QOyRQXsSY/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/0kvjSG-DVhppmykPe2QOyRQXsSY/1/da"><img src="http://feedads.g.doubleclick.net/~a/0kvjSG-DVhppmykPe2QOyRQXsSY/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Center4code?a=C_yk9QdNSSc:vOhgU811KSg:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Center4code?d=yIl2AUoC8zA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Center4code/~4/C_yk9QdNSSc" height="1" width="1"/>http://center4code.blogspot.com/2008/04/dropdownlist-constant-widthchange.htmltag:blogger.com,1999:blog-3050754948529411091.post-4295929764020890528Sat, 29 Dec 2007 11:24:00 +00002007-12-29T03:26:25.624-08:00Sql Server CommandsAggregate - CREATE AGGREGATE - DROP AGGREGATE Application Role - CREATE APPLICATION ROLE - ALTER APPLICATION ROLE - DROP APPLICATION ROLEAssembly - CREATE ASSEMBLY - ALTER ASSEMBLY - DROP ASSEMBLYALTER AUTHORIZATION BACKUPBACKUP CERTIFICATEBEGIN [DIALOG [CONVERSATION]] Certificate - ALTER CERTIFICATE - CREATE CERTIFICATEhttp://feedproxy.google.com/~r/Center4code/~3/FXASFeqibLE/sql-server-2005-commands.htmlnoreply@blogger.com (Sameer Khan)<p><a href="http://feedads.g.doubleclick.net/~a/oyGpJuC7yfQ89sff_Tyfs9gT75A/0/da"><img src="http://feedads.g.doubleclick.net/~a/oyGpJuC7yfQ89sff_Tyfs9gT75A/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/oyGpJuC7yfQ89sff_Tyfs9gT75A/1/da"><img src="http://feedads.g.doubleclick.net/~a/oyGpJuC7yfQ89sff_Tyfs9gT75A/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Center4code?a=FXASFeqibLE:3qqirnhty8s:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Center4code?d=yIl2AUoC8zA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Center4code/~4/FXASFeqibLE" height="1" width="1"/>http://center4code.blogspot.com/2007/12/sql-server-2005-commands.htmltag:blogger.com,1999:blog-3050754948529411091.post-2835748522713841137Sat, 29 Dec 2007 11:22:00 +00002007-12-29T03:26:04.631-08:00XMLXML [1] is a very handy format for storing and communicating your data between disparate systems in a platform-independent fashion. XML is more than just a format for computers -- a guiding principle in its creation was that it should be Human Readable and easy to create.XML allows UNIX [2] systems written in C to communicate with Web Services that, for example, run on the Microsoft .NET [3] http://feedproxy.google.com/~r/Center4code/~3/lfniqpjqfoY/xml-dtds-vs-xml-schema.htmlnoreply@blogger.com (Sameer Khan)<p><a href="http://feedads.g.doubleclick.net/~a/XHW4TuLDcNXW6CtMdKL4HxrTH1I/0/da"><img src="http://feedads.g.doubleclick.net/~a/XHW4TuLDcNXW6CtMdKL4HxrTH1I/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/XHW4TuLDcNXW6CtMdKL4HxrTH1I/1/da"><img src="http://feedads.g.doubleclick.net/~a/XHW4TuLDcNXW6CtMdKL4HxrTH1I/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Center4code?a=lfniqpjqfoY:PAV8CKQnxE0:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Center4code?d=yIl2AUoC8zA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Center4code/~4/lfniqpjqfoY" height="1" width="1"/>http://center4code.blogspot.com/2007/12/xml-dtds-vs-xml-schema.htmltag:blogger.com,1999:blog-3050754948529411091.post-805307624665044702Tue, 18 Dec 2007 11:20:00 +00002007-12-18T03:21:38.640-08:00Web ServiceA Web Service exposes a number of methods to provide functions that can be used by one or more applications, regardless of the programming languages, operating systems, and hardware platforms used to develop them. The methods that provide such function are called Web Methods. The functions used by a Web Service can be accesses by applications using Internet standards, such as Simple Object Accesshttp://feedproxy.google.com/~r/Center4code/~3/SknxweWuPys/web-service.htmlnoreply@blogger.com (Sameer Khan)<p><a href="http://feedads.g.doubleclick.net/~a/FACrcVPrGqZ1JU2AJ_s-hws5j9s/0/da"><img src="http://feedads.g.doubleclick.net/~a/FACrcVPrGqZ1JU2AJ_s-hws5j9s/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/FACrcVPrGqZ1JU2AJ_s-hws5j9s/1/da"><img src="http://feedads.g.doubleclick.net/~a/FACrcVPrGqZ1JU2AJ_s-hws5j9s/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Center4code?a=SknxweWuPys:59oE6mAmn3A:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Center4code?d=yIl2AUoC8zA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Center4code/~4/SknxweWuPys" height="1" width="1"/>http://center4code.blogspot.com/2007/12/web-service.htmltag:blogger.com,1999:blog-3050754948529411091.post-3806749010537786277Tue, 18 Dec 2007 11:19:00 +00002007-12-18T03:21:57.503-08:00RemotingRemoting .NET remoting is a technology that allows you to invoke or accessing objects on remote server. For those who are familiar with Java technology, it is called RMI (Remote Method Invocation) in java world..NET remoting supports accessing your objects by using HTTP,TCP and IPC channels. Similar with Web Services, .NET remoting also support calling your objects via HTTP protocol. However http://feedproxy.google.com/~r/Center4code/~3/Mun8cglYJ6I/remoting.htmlnoreply@blogger.com (Sameer Khan)<p><a href="http://feedads.g.doubleclick.net/~a/iw-npnViuDa0awolFOT-M17xn_A/0/da"><img src="http://feedads.g.doubleclick.net/~a/iw-npnViuDa0awolFOT-M17xn_A/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/iw-npnViuDa0awolFOT-M17xn_A/1/da"><img src="http://feedads.g.doubleclick.net/~a/iw-npnViuDa0awolFOT-M17xn_A/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Center4code?a=Mun8cglYJ6I:rEUUlTtkBV8:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Center4code?d=yIl2AUoC8zA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Center4code/~4/Mun8cglYJ6I" height="1" width="1"/>http://center4code.blogspot.com/2007/12/remoting.htmltag:blogger.com,1999:blog-3050754948529411091.post-2231045389232849650Tue, 18 Dec 2007 04:32:00 +00002007-12-17T20:33:47.426-08:00OOPS(Object Oriented Programming)Class A user-defined data structure that groups properties and methods. Class doesn’t occupies memory. Object Instance of Class is called object. An object is created in memory using keyword “new”. Difference between Struct and Class Struct are Value type and are stored on stack, while Class are Reference type and are stored on heap. Struct “do not support” inheritance, while class http://feedproxy.google.com/~r/Center4code/~3/-Yydy9mbRrg/oops-in-cnet.htmlnoreply@blogger.com (Sameer Khan)<p><a href="http://feedads.g.doubleclick.net/~a/mqOiELOczXsWTPMQHl5i04XTK74/0/da"><img src="http://feedads.g.doubleclick.net/~a/mqOiELOczXsWTPMQHl5i04XTK74/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/mqOiELOczXsWTPMQHl5i04XTK74/1/da"><img src="http://feedads.g.doubleclick.net/~a/mqOiELOczXsWTPMQHl5i04XTK74/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Center4code?a=-Yydy9mbRrg:NylmkI853s8:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Center4code?d=yIl2AUoC8zA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Center4code/~4/-Yydy9mbRrg" height="1" width="1"/>http://center4code.blogspot.com/2007/12/oops-in-cnet.htmltag:blogger.com,1999:blog-3050754948529411091.post-4315038437551570151Tue, 18 Dec 2007 04:32:00 +00002007-12-17T20:34:08.125-08:00SQL Basic QuestionsWhat is RDBMS? Relational Data Base Management Systems (RDBMS) are database management systems that maintain data records and indices in tables. Relationships may be created and maintained across and among the data and tables. In a relational database, relationships between data items are expressed by means of tables. Interdependencies among these tables are expressed by data values rather thanhttp://feedproxy.google.com/~r/Center4code/~3/twjy4gMfgAs/sql-basic-question-1.htmlnoreply@blogger.com (Sameer Khan)<p><a href="http://feedads.g.doubleclick.net/~a/yGNMfUGldHVYnn0FW64qLEEYwko/0/da"><img src="http://feedads.g.doubleclick.net/~a/yGNMfUGldHVYnn0FW64qLEEYwko/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/yGNMfUGldHVYnn0FW64qLEEYwko/1/da"><img src="http://feedads.g.doubleclick.net/~a/yGNMfUGldHVYnn0FW64qLEEYwko/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Center4code?a=twjy4gMfgAs:MZfIrVFYxgs:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Center4code?d=yIl2AUoC8zA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Center4code/~4/twjy4gMfgAs" height="1" width="1"/>http://center4code.blogspot.com/2007/12/sql-basic-question-1.htmltag:blogger.com,1999:blog-3050754948529411091.post-6215385280029174282Tue, 18 Dec 2007 04:30:00 +00002007-12-17T20:37:41.251-08:00Data Controls and Data Source In Asp.netDifference between Grid View, Data List, repeater, Details View and Form View 1) Control - Capabilities GridView - Read/Edit DataList - Read/Edit Repeater - Read Only DetailsView - Read/Edit/Create FormView - Read/Edit/Create 2)Feature Repeater DataList GridView Table layout No No Yes Flow layouthttp://feedproxy.google.com/~r/Center4code/~3/CMkds7k4WcY/gridview-datalistrepeaterdetailsviewfor.htmlnoreply@blogger.com (Sameer Khan)<p><a href="http://feedads.g.doubleclick.net/~a/NF_53faAk0RanRSrcNHKrEPwvD8/0/da"><img src="http://feedads.g.doubleclick.net/~a/NF_53faAk0RanRSrcNHKrEPwvD8/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/NF_53faAk0RanRSrcNHKrEPwvD8/1/da"><img src="http://feedads.g.doubleclick.net/~a/NF_53faAk0RanRSrcNHKrEPwvD8/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Center4code?a=CMkds7k4WcY:hgwXV0DXInk:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Center4code?d=yIl2AUoC8zA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Center4code/~4/CMkds7k4WcY" height="1" width="1"/>http://center4code.blogspot.com/2007/12/gridview-datalistrepeaterdetailsviewfor.htmltag:blogger.com,1999:blog-3050754948529411091.post-3545306068015678421Tue, 18 Dec 2007 04:30:00 +00002007-12-17T20:34:48.856-08:00Triggers In SqlServerTrigger Triggers are special types of Stored Procedures that are defined to execute automatically in place of or after data modifications. They can be executed automatically on the INSERT, DELETE and UPDATE triggering actions. There are two different types of triggers in Microsoft SQL Server 2000. They are INSTEAD OF triggers and AFTER triggers. These triggers differ from each other in terms ofhttp://feedproxy.google.com/~r/Center4code/~3/hG7IOqJFhdM/trigger-in-sqlserver.htmlnoreply@blogger.com (Sameer Khan)<p><a href="http://feedads.g.doubleclick.net/~a/D7AiHp0Ch3SgPSsbC9_ljGkUaaY/0/da"><img src="http://feedads.g.doubleclick.net/~a/D7AiHp0Ch3SgPSsbC9_ljGkUaaY/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/D7AiHp0Ch3SgPSsbC9_ljGkUaaY/1/da"><img src="http://feedads.g.doubleclick.net/~a/D7AiHp0Ch3SgPSsbC9_ljGkUaaY/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Center4code?a=hG7IOqJFhdM:mmC0UUsaW04:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Center4code?d=yIl2AUoC8zA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Center4code/~4/hG7IOqJFhdM" height="1" width="1"/>http://center4code.blogspot.com/2007/12/trigger-in-sqlserver.htmltag:blogger.com,1999:blog-3050754948529411091.post-8619092893904295439Tue, 18 Dec 2007 04:30:00 +00002007-12-17T20:35:06.217-08:00Index In SqlserverIndexes in Sql Server A database index is similar to an index in a book – it is comprised of a lookup value, and a number identifier that corresponds to the row number in a table. In SQL Server, there are two kinds of indexes – clustered and non-clustered. Clustered Indexes require that the data in the table is physically sorted in the order of the index. Because the data in a table can be http://feedproxy.google.com/~r/Center4code/~3/YBL3k8i8IhQ/indexing-in-sqlserver.htmlnoreply@blogger.com (Sameer Khan)<p><a href="http://feedads.g.doubleclick.net/~a/1aGESKOORU3mSG9oltStHZgzeUM/0/da"><img src="http://feedads.g.doubleclick.net/~a/1aGESKOORU3mSG9oltStHZgzeUM/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/1aGESKOORU3mSG9oltStHZgzeUM/1/da"><img src="http://feedads.g.doubleclick.net/~a/1aGESKOORU3mSG9oltStHZgzeUM/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Center4code?a=YBL3k8i8IhQ:gpNbJO3g9z0:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Center4code?d=yIl2AUoC8zA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Center4code/~4/YBL3k8i8IhQ" height="1" width="1"/>http://center4code.blogspot.com/2007/12/indexing-in-sqlserver.htmltag:blogger.com,1999:blog-3050754948529411091.post-7740273911457337066Tue, 18 Dec 2007 04:29:00 +00002007-12-17T21:01:26.961-08:00Event and DelegtesDelegate:-A delegate in C# is similar to a function pointer in C or C++. Using a delegate allows the programmer to encapsulate a reference to a method inside a delegate object. The delegate object can then be passed to code which can call the referenced method, without having to know at compile time which method will be invoked.An interesting and useful property of a delegate is that it does not http://feedproxy.google.com/~r/Center4code/~3/Eub-vxNowGI/event-and-delegtes.htmlnoreply@blogger.com (Sameer Khan)<p><a href="http://feedads.g.doubleclick.net/~a/xhWq3mbxRRENS9yU1yxPo3ajcjE/0/da"><img src="http://feedads.g.doubleclick.net/~a/xhWq3mbxRRENS9yU1yxPo3ajcjE/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/xhWq3mbxRRENS9yU1yxPo3ajcjE/1/da"><img src="http://feedads.g.doubleclick.net/~a/xhWq3mbxRRENS9yU1yxPo3ajcjE/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Center4code?a=Eub-vxNowGI:vmwgK41eNLw:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Center4code?d=yIl2AUoC8zA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Center4code/~4/Eub-vxNowGI" height="1" width="1"/>http://center4code.blogspot.com/2007/12/event-and-delegtes.htmltag:blogger.com,1999:blog-3050754948529411091.post-1149361009362486463Tue, 18 Dec 2007 04:28:00 +00002007-12-17T20:47:14.720-08:00DataTypes in Sqlserver and C#.netData Type of SQL Server Exact numeric Type From To bigint -9,223,372,036,854,775,808 9,223,372,036,854,775,807 int -2,147,483,648 2,147,483,647 smallint -32,768 32,767 tinyint 0 255 bit 0 1 decimal -10^38 +1http://feedproxy.google.com/~r/Center4code/~3/V8wJ_35EuQQ/datatype-in-sql-server-and-cnet.htmlnoreply@blogger.com (Sameer Khan)<p><a href="http://feedads.g.doubleclick.net/~a/l1yxelDjTpnVZkSfmLNPSeGkjVM/0/da"><img src="http://feedads.g.doubleclick.net/~a/l1yxelDjTpnVZkSfmLNPSeGkjVM/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/l1yxelDjTpnVZkSfmLNPSeGkjVM/1/da"><img src="http://feedads.g.doubleclick.net/~a/l1yxelDjTpnVZkSfmLNPSeGkjVM/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Center4code?a=V8wJ_35EuQQ:red40TPn_WA:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Center4code?d=yIl2AUoC8zA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Center4code/~4/V8wJ_35EuQQ" height="1" width="1"/>http://center4code.blogspot.com/2007/12/datatype-in-sql-server-and-cnet.htmltag:blogger.com,1999:blog-3050754948529411091.post-6138583520428618560Tue, 18 Dec 2007 04:27:00 +00002007-12-17T20:36:02.883-08:00Cursor In SqlserverCursor Cursor is a database object used by applications to manipulate data in a set on a row-by-row basis, instead of the typical SQL commands that operate on all the rows in the set at one time. For example, you can use cursor to include a list of all user databases and make multiple operations against each database by passing each database name as a variable. Before using cursor, you firsthttp://feedproxy.google.com/~r/Center4code/~3/G8CJf0a1k7Q/cursor.htmlnoreply@blogger.com (Sameer Khan)<p><a href="http://feedads.g.doubleclick.net/~a/0RQXIPH-tiy8gPiminAlzjrg81c/0/da"><img src="http://feedads.g.doubleclick.net/~a/0RQXIPH-tiy8gPiminAlzjrg81c/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/0RQXIPH-tiy8gPiminAlzjrg81c/1/da"><img src="http://feedads.g.doubleclick.net/~a/0RQXIPH-tiy8gPiminAlzjrg81c/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Center4code?a=G8CJf0a1k7Q:fVJO85m6Hmk:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Center4code?d=yIl2AUoC8zA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Center4code/~4/G8CJf0a1k7Q" height="1" width="1"/>http://center4code.blogspot.com/2007/12/cursor.htmltag:blogger.com,1999:blog-3050754948529411091.post-8592341274011279619Tue, 18 Dec 2007 04:25:00 +00002007-12-17T20:34:08.125-08:00SQL Basic QuestionsDelete duplicate records: - Following code is useful to delete duplicate records. The table must have identity column, which will be used to identify the duplicate records. Table in example is has ID as Identity Column and Columns which have duplicate data are DuplicateValueColumn1, DuplicateValueColumn2 and DuplicateValueColumn3. DELETEFROM MyTableWHERE ID NOT IN (SELECThttp://feedproxy.google.com/~r/Center4code/~3/-kw2uPzNAK8/sql-basic-question.htmlnoreply@blogger.com (Sameer Khan)<p><a href="http://feedads.g.doubleclick.net/~a/ha3EmkPJBu8d5fTyPOLBmqHNOeM/0/da"><img src="http://feedads.g.doubleclick.net/~a/ha3EmkPJBu8d5fTyPOLBmqHNOeM/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/ha3EmkPJBu8d5fTyPOLBmqHNOeM/1/da"><img src="http://feedads.g.doubleclick.net/~a/ha3EmkPJBu8d5fTyPOLBmqHNOeM/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Center4code?a=-kw2uPzNAK8:UfWtL1QQxlo:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Center4code?d=yIl2AUoC8zA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Center4code/~4/-kw2uPzNAK8" height="1" width="1"/>http://center4code.blogspot.com/2007/12/sql-basic-question.htmltag:blogger.com,1999:blog-3050754948529411091.post-6398034660629383679Fri, 14 Dec 2007 09:50:00 +00002007-12-14T01:51:45.863-08:00DOTNET 3.0 After a long beta period Microsoft pushed Visual Studio .NET 2008 (code named “Orcas”) out to MSDN in November - keeping their promise to deliver it by the end of the year. DevelopMentor has been using Orcas in many of our .NET classes for a while now and I for one, am pretty excited that it’s finally here. There are a ton of new features and enhancements in this release that make it almost a http://feedproxy.google.com/~r/Center4code/~3/P4EyJ0OnFLE/code-named-orcas.htmlnoreply@blogger.com (Sameer Khan)<p><a href="http://feedads.g.doubleclick.net/~a/ruvubZ1MOcLh83Q7LjAWfdUNDGg/0/da"><img src="http://feedads.g.doubleclick.net/~a/ruvubZ1MOcLh83Q7LjAWfdUNDGg/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/ruvubZ1MOcLh83Q7LjAWfdUNDGg/1/da"><img src="http://feedads.g.doubleclick.net/~a/ruvubZ1MOcLh83Q7LjAWfdUNDGg/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Center4code?a=P4EyJ0OnFLE:fQEY_RbbkKM:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Center4code?d=yIl2AUoC8zA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Center4code/~4/P4EyJ0OnFLE" height="1" width="1"/>http://center4code.blogspot.com/2007/12/code-named-orcas.htmltag:blogger.com,1999:blog-3050754948529411091.post-7816666114133959423Thu, 13 Dec 2007 12:20:00 +00002007-12-13T04:21:32.791-08:00DOTNET 3.0On the heels of the Visual Studio 2005 and C# 2.0 releases, Microsoft has given a sneak preview of what to expect in the version after the next: C# 3.0. Even though C# 3.0 is not even standardized yet, Microsoft provided a preview release at its Professional Developers Conference (PDC) in September so eager developers could try out some of the expected features. This article discusses the http://feedproxy.google.com/~r/Center4code/~3/FLmF_BJN028/new-in-cnet-30.htmlnoreply@blogger.com (Sameer Khan)<p><a href="http://feedads.g.doubleclick.net/~a/JaJAWPk51d8mVT7b79kQfmhZAU4/0/da"><img src="http://feedads.g.doubleclick.net/~a/JaJAWPk51d8mVT7b79kQfmhZAU4/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/JaJAWPk51d8mVT7b79kQfmhZAU4/1/da"><img src="http://feedads.g.doubleclick.net/~a/JaJAWPk51d8mVT7b79kQfmhZAU4/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Center4code?a=FLmF_BJN028:4K6zwNOMTyA:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Center4code?d=yIl2AUoC8zA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Center4code/~4/FLmF_BJN028" height="1" width="1"/>http://center4code.blogspot.com/2007/12/new-in-cnet-30.htmltag:blogger.com,1999:blog-3050754948529411091.post-2684385512430531694Thu, 13 Dec 2007 11:57:00 +00002007-12-13T03:58:42.217-08:00DOTNET 3.0There are tons of new features in Visual Studio 2008. If you have been paying attention, you know it comes out this month. Of the many new features, I would put the following at the top: Multi-Targeting SupportJavascript DebuggingJavascript IntelligenceWeb Design and CSS SupportPerformance ImprovementsAccess to .NET Framework Source Code Multi-Targeting Support As with many of the http://feedproxy.google.com/~r/Center4code/~3/B4lebJuNCrk/visual-studio-2008-new-features-worth.htmlnoreply@blogger.com (Sameer Khan)<p><a href="http://feedads.g.doubleclick.net/~a/G-fYGnh6E87aflbXSxtBcBAe-Y0/0/da"><img src="http://feedads.g.doubleclick.net/~a/G-fYGnh6E87aflbXSxtBcBAe-Y0/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/G-fYGnh6E87aflbXSxtBcBAe-Y0/1/da"><img src="http://feedads.g.doubleclick.net/~a/G-fYGnh6E87aflbXSxtBcBAe-Y0/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Center4code?a=B4lebJuNCrk:t_OkvT4H4Ok:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Center4code?d=yIl2AUoC8zA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Center4code/~4/B4lebJuNCrk" height="1" width="1"/>http://center4code.blogspot.com/2007/12/visual-studio-2008-new-features-worth.htmltag:blogger.com,1999:blog-3050754948529411091.post-922716952985165156Wed, 12 Dec 2007 09:51:00 +00002007-12-13T03:58:42.217-08:00DOTNET 3.0 1. LINQ Support LINQ essentially is the composition of many standard query operators that allow you to work with data in a more intuitive way regardless. The benefits of using LINQ are significant – Compile time checking C# language queries, and the ability to debug step by step through queries. 2. Expression Blend Support Expression blend is XAML generator tool for http://feedproxy.google.com/~r/Center4code/~3/HvXuie4dn3s/22-new-features-of-visual-studio-2008_12.htmlnoreply@blogger.com (Sameer Khan)<p><a href="http://feedads.g.doubleclick.net/~a/w-gbvN4lEvYy6Q4dfM76-p71kFc/0/da"><img src="http://feedads.g.doubleclick.net/~a/w-gbvN4lEvYy6Q4dfM76-p71kFc/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/w-gbvN4lEvYy6Q4dfM76-p71kFc/1/da"><img src="http://feedads.g.doubleclick.net/~a/w-gbvN4lEvYy6Q4dfM76-p71kFc/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Center4code?a=HvXuie4dn3s:N2sK7U_shmo:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Center4code?d=yIl2AUoC8zA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Center4code/~4/HvXuie4dn3s" height="1" width="1"/>http://center4code.blogspot.com/2007/12/22-new-features-of-visual-studio-2008_12.htmltag:blogger.com,1999:blog-3050754948529411091.post-4239664991120213444Wed, 12 Dec 2007 09:43:00 +00002007-12-13T04:00:27.576-08:00dotnet 3.5 ASP.NET AJAX The ASP.NET AJAX SiteASP.NET AJAX Overview New ListView and DataPager Controls Using the ASP.NET 3.5 ListView ControlListView Web Server Control LINQ and other .NET Framework 3.5 Improvements LinqDataSource Technology Overview WCF Support for RSS, JSON, POX and Partial Trust Using ASP.NET Web http://feedproxy.google.com/~r/Center4code/~3/tUNG5WOHf5g/new-in-aspnet-35.htmlnoreply@blogger.com (Sameer Khan)<p><a href="http://feedads.g.doubleclick.net/~a/sovcCrdxKDgBdI0_xzHK354yfsM/0/da"><img src="http://feedads.g.doubleclick.net/~a/sovcCrdxKDgBdI0_xzHK354yfsM/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/sovcCrdxKDgBdI0_xzHK354yfsM/1/da"><img src="http://feedads.g.doubleclick.net/~a/sovcCrdxKDgBdI0_xzHK354yfsM/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Center4code?a=tUNG5WOHf5g:Cn-CjndVOEU:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Center4code?d=yIl2AUoC8zA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Center4code/~4/tUNG5WOHf5g" height="1" width="1"/>http://center4code.blogspot.com/2007/12/new-in-aspnet-35.html