tag:blogger.com,1999:blog-17969165235867213752024-03-05T20:14:35.095-08:00Anil Jain Blogs* * @nil jain * *http://www.blogger.com/profile/06174438648268956122noreply@blogger.comBlogger80125tag:blogger.com,1999:blog-1796916523586721375.post-51667594306007767172017-05-16T23:49:00.001-07:002017-05-17T00:00:42.765-07:00How to change web.config without loosing session<div dir="ltr" style="text-align: left;" trbidi="on">
In application by default we have InProc session state and due to this our session is stored in application memory that's why when we change web.config, it lost session also.<br />
<br />
<sessionstate mode="InProc" timeout="30"></sessionstate>sessionState mode="InProc" timeout="30"<br />
<br />
To overcome this problem use "StateServer" session state. It stores application session in server memory where our application is hosted.<br />
<br />
<sessionstate mode="StateServer" nbsp="" stateconnectionstring="tcpip=127.0.0.1:42424" timeout="30"></sessionstate>sessionState mode="StateServer" stateConnectionString="tcpip=127.0.0.1:42424" timeout="30"<br />
<br />
Thanks<br />
Anil<br />
<br />
<br />
<br /></div>
* * @nil jain * *http://www.blogger.com/profile/06174438648268956122noreply@blogger.com0tag:blogger.com,1999:blog-1796916523586721375.post-45094910795678366632016-02-01T22:51:00.003-08:002016-02-01T22:51:52.789-08:00Steps of Keyboard to appear key on screen<div dir="ltr" style="text-align: left;" trbidi="on">
step 1: Keyboard->[sends an electrical signal]-><br />
<br />
step 2: Computer(keyboard controller)->[interprets the signal and forward scan code to]-><br />
<br />
step 3: Processor->[routes it to the program for]-><br />
<br />
step 4: Operating system->[sends a message to that current active window]-><br />
<br />
step 5: Current window->[process the signal by taking one byte of computer memory (RAM) and sends to]-><br />
<br />
step 6: Operating system->[will add it to video card]<br />
<br />
step 7: Next time when the video card refreshes your monitor the letter will appear on the screen</div>
* * @nil jain * *http://www.blogger.com/profile/06174438648268956122noreply@blogger.com0tag:blogger.com,1999:blog-1796916523586721375.post-38033662094359508952015-09-14T21:46:00.001-07:002015-09-14T21:46:07.234-07:00The Five Dysfunctions of a Team<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Dysfunction #1: Absence of Trust</b><br />
The fear of being vulnerable with team members prevents the building of trust within the team.<br />
<br />
<b>Dysfunction #2: Fear of Conflict</b><br />
The desire to preserve artificial harmony stifles the occurrence of productive ideological conflict.<br />
<br />
<b>Dysfunction #3: Lack of Commitment</b><br />
The lack of clarity or buy-in prevents team members from making decisions they will stick to.<br />
<br />
<b>Dysfunction #4: Avoidance of Accountability</b><br />
The need to avoid interpersonal discomfort prevents team members from holding one another accountable.<br />
<br />
<b>Dysfunction #5: Inattention to Results</b><br />
<div class="separator" style="clear: both; text-align: center;">
<b><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgF294_Tdw6UFVoKMsun29ujR4s7mCQK5Fje9azm2hYn19pavCSYzmKSWQH0g4REmX0RTpJW35TK7yaHtPGOJ3Lg4pstJ19f-bs6ARSnIiMAZz0udo2PHH95UEGByoRD-ANRwWSKcj0eZE/s1600/themodel.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="267" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgF294_Tdw6UFVoKMsun29ujR4s7mCQK5Fje9azm2hYn19pavCSYzmKSWQH0g4REmX0RTpJW35TK7yaHtPGOJ3Lg4pstJ19f-bs6ARSnIiMAZz0udo2PHH95UEGByoRD-ANRwWSKcj0eZE/s320/themodel.png" width="320" /></a></b></div>
<br />
The pursuit of individual goals and personal status erodes the focus on collective success.<br />
<br />
Follow the below URL<br />
<a href="http://flpbs.fmhi.usf.edu/pdfs/Five%20Dysfunctions%20of%20a%20Team.pdf">http://flpbs.fmhi.usf.edu/pdfs/Five%20Dysfunctions%20of%20a%20Team.pdf</a><br />
<br />
Please share your feedback or comments.<br />
<br />
Thanks<br />
Anil</div>
* * @nil jain * *http://www.blogger.com/profile/06174438648268956122noreply@blogger.com0tag:blogger.com,1999:blog-1796916523586721375.post-57130564727707091682015-07-30T05:48:00.006-07:002015-07-30T05:48:56.977-07:00Encryption of web.config file<div dir="ltr" style="text-align: left;" trbidi="on">
There are two ways to encrypt your web.config sections.<br />
<br />
<b>1. Using VS.NET utility "aspnet_regiis"</b><br />
<br />
Ex.<br />
<br />
C:\Windows\Microsoft.NET\Framework\v2.0.50727 aspnet_regiis -pef "appSettings" "D:\project\PP_Publish" -prov RSAProtectedConfigurationProvider<br />
<br />
Follow the URL for more info.<br />
<br />
<a href="http://blogs.msdn.com/b/mosharaf/archive/2005/11/17/protectedconfiguration.aspx">http://blogs.msdn.com/b/mosharaf/archive/2005/11/17/protectedconfiguration.aspx</a><br />
<br />
<a href="http://www.codeproject.com/Articles/877258/How-to-Encrypt-Web-config-Using-aspnet-regiis-exe">http://www.codeproject.com/Articles/877258/How-to-Encrypt-Web-config-Using-aspnet-regiis-exe</a><br />
<br />
<b>2. Programmatically encrypt your web.config file</b><br />
<br />
///////////////////////// To Encrypt /////////////////////////<br />
Configuration config;<br />
ConfigurationSection configSection;<br />
config = WebConfigurationManager.OpenWebConfiguration(Request.ApplicationPath);<br />
configSection = config.GetSection("connectionStrings");<br />
if (configSection != null)<br />
{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>if (!(configSection.SectionInformation.IsLocked))<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>configSection.SectionInformation.ProtectSection("DataProtectionConfigurationProvider");<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>config.Save();<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>}<br />
}<br />
<br />
<br />
<br />
///////////////////////// To Decrypt /////////////////////////<br />
<br />
Configuration configD;<br />
ConfigurationSection configSectionD;<br />
configD = WebConfigurationManager.OpenWebConfiguration(Request.ApplicationPath);<br />
configSectionD = configD.GetSection("connectionStrings");<br />
if (configSectionD != null)<br />
{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>if (!(configSectionD.SectionInformation.IsLocked))<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>configSectionD.SectionInformation.UnprotectSection();<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>configD.Save();<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>}<br />
}<br />
<br />
For more info, follow the below URL<br />
<br />
<a href="http://www.techrepublic.com/blog/software-engineer/encrypting-net-configuration-files-through-code/">http://www.techrepublic.com/blog/software-engineer/encrypting-net-configuration-files-through-code/</a><br /><br />
Thanks<br />
Anil<br />
</div>
* * @nil jain * *http://www.blogger.com/profile/06174438648268956122noreply@blogger.com0tag:blogger.com,1999:blog-1796916523586721375.post-39664235518575940522015-06-30T01:59:00.001-07:002015-06-30T01:59:09.781-07:00How the year, time and clock is measured?<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="background-color: white; color: #3f3f3f; font-family: georgia; font-size: 15px; line-height: 20px;">Our perception of time is based on the earth's revolution around the sun and its rotation around its own axis. One complete cycle around the sun is a year, while a complete rotation on its axis constitutes a day. </span><br />
<span style="background-color: white; color: #3f3f3f; font-family: georgia; font-size: 15px; line-height: 20px;">Based on these observations, a day has 24 hours while 365 days constitute a year. The day is further divided into hours, minutes and seconds.</span><br />
<span style="background-color: white; color: #3f3f3f; font-family: georgia; font-size: 15px; line-height: 20px;"> Time measured by the earth's rotation relative to the sun is called solar time. For any given point, there could be two values of solar time — apparent and mean. Apparent time is measured by direct observation of the sun by a sundial. Mean solar time, however, is measured by assuming that relative to the earth, the sun is at the same position after every 24 hours. Most clocks and watches are based on mean solar time. </span><br />
<span style="background-color: white; color: #3f3f3f; font-family: georgia; font-size: 15px; line-height: 20px;"><br /></span>
<strong style="background: rgb(255, 255, 255); border: 0px; color: #3f3f3f; font-family: georgia; font-size: 15px; line-height: 20px; margin: 0px; outline: 0px; padding: 0px;">What is the most accurate measure of time?</strong><br style="background-color: white; color: #3f3f3f; font-family: georgia; font-size: 15px; line-height: 20px; margin: 0px; padding: 0px;" /><span style="background-color: white; color: #3f3f3f; font-family: georgia; font-size: 15px; line-height: 20px;">Measurement of time based on the earth's rotation and revolution has its limitations and hence the unit of time defined by the International System of Units is not based on astronomical observation. </span><br />
<span style="background-color: white; color: #3f3f3f; font-family: georgia; font-size: 15px; line-height: 20px;">The length of a second is defined according to the vibrations of caesium atoms at various atomic clocks. International Atomic Time is based on a system of about 270 atomic clocks. Signals from these clocks are transmitted to the International Bureau of Weights and Measures located in Sevres, France, which uses the signals to form the International Atomic Time. Seconds measured by atomic clocks are the most accurate. These clocks are predicted to be off by less than a second in 50 million years. </span></div>
* * @nil jain * *http://www.blogger.com/profile/06174438648268956122noreply@blogger.com0tag:blogger.com,1999:blog-1796916523586721375.post-733040729699230702015-04-27T03:32:00.001-07:002015-04-27T03:32:10.736-07:00URL Routing to remove .aspx extension from URL in C#.net<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Global.asax File:</b><br />
<br />
static void RegisterRoutes()<br />
{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>System.Web.Routing.RouteTable.Routes.Add("login",new System.Web.Routing.Route("login", new RouteHandler("~/login.aspx")));<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>System.Web.Routing.RouteTable.Routes.Add("Main", new System.Web.Routing.Route("Main", new RouteHandler("~/Main.aspx")));<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>System.Web.Routing.RouteTable.Routes.Add("Message", new System.Web.Routing.Route("Message", new RouteHandler("~/Message.aspx")));<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
}<br />
<br />
public class RouteHandler : IRouteHandler<br />
{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>string _virtualPath;<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>public RouteHandler(string virtualPath)<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>_virtualPath = virtualPath;<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>}<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>public IHttpHandler GetHttpHandler(RequestContext requestContext)<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>foreach (var value in requestContext.RouteData.Values)<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>requestContext.HttpContext.Items[value.Key] = value.Value;<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>}<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>return (Page)System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(_virtualPath, typeof(Page));<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>}<br />
}<br />
<br />
<b>Web.config:</b><br />
<br />
<system .web=""></system><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><sessionstate cookieless="false" mode="InProc"></sessionstate><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><compilation debug="true"></compilation><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><assemblies></assemblies><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><add assembly="System.Web.Routing, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"></add><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><add assembly="System.Web.Abstractions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"></add><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span></div>
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><!--<pages controlRenderingCompatibilityVersion="3.5" clientIDMode="AutoID"/>--><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><pages enableeventvalidation="false" enablesessionstate="true"></pages><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><httpmodules> </httpmodules><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> <remove name="Session"></remove><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> <add name="Session" type="System.Web.SessionState.SessionStateModule"></add><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> <add name="RoutingModule" type="System.Web.Routing.UrlRoutingModule, System.Web.Routing,Version=3.5.0.0, Culture=neutral,PublicKeyToken=31bf3856ad364e35"></add><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> <add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"> </add><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><system .webserver=""></system><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><modules runallmanagedmodulesforallrequests="true"></modules><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> <remove name="ScriptModule"></remove><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> <add name="ScriptModule" precondition="managedHandler" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"></add><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> <add name="UrlRoutingModule" type="System.Web.Routing.UrlRoutingModule, System.Web.Routing, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"><span class="Apple-tab-span" style="white-space: pre;"> </span> </add><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><handlers></handlers><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><add name="UrlRoutingHandler" path="UrlRouting.axd" precondition="integratedMode" type="System.Web.HttpForbiddenHandler, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" verb="*"></add><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<system .webserver=""><span class="Apple-tab-span" style="white-space: pre;"> </span></system>* * @nil jain * *http://www.blogger.com/profile/06174438648268956122noreply@blogger.com0tag:blogger.com,1999:blog-1796916523586721375.post-2517261176081853212014-05-04T06:46:00.000-07:002014-05-04T06:46:28.524-07:00Deploy ASP.NET application on Linux for iPad/Android <div dir="ltr" style="text-align: left;" trbidi="on">
<br />
There are two option to enable .NET developers to extend their application deployment to Linux environments.<br />
<br />
<br />
<ol style="text-align: left;">
<li>MainSoft: Refer <a href="http://dev.mainsoft.com/">http://dev.mainsoft.com/</a></li>
<li>Mono Project: Refer <a href="http://www.mono-project.com/Main_Page">http://www.mono-project.com/Main_Page</a></li>
</ol>
<br />
<br />
In MainSoft there is a product, called Grasshopper allows ASP.NET, ASMX Web Services, and other server based applications to be compiled to Java bytecode and executed in a J2EE server running on Linux.<br />
<br />GrassHopper is a Visual Studio-based SDK and patented .NET to Java converter that enables you to run .NET Web and server applications to run on Linux® and other Java-enabled platforms.<div>
<br /></div>
<div>
For More Information Refer below link</div>
<div>
<br /></div>
<div>
<a href="http://go4coding.com/post/2011/04/14/Hosting-existing-ASP-Net-Web-Application-on-Linux.aspx">http://go4coding.com/post/2011/04/14/Hosting-existing-ASP-Net-Web-Application-on-Linux.aspx</a></div>
<div>
<br /></div>
<div>
Pl do comment if you want to know more.</div>
<div>
<br /></div>
<div>
Thanks<br /><br /></div>
</div>
* * @nil jain * *http://www.blogger.com/profile/06174438648268956122noreply@blogger.com0tag:blogger.com,1999:blog-1796916523586721375.post-65209612780708552222014-01-02T01:41:00.003-08:002014-01-02T01:41:56.629-08:00sql server on linux<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18px;">To install mssql in linux server follow the steps given in below link.</span><br />
<br />
<a href="http://technikq.blogspot.in/2011/09/install-mssql-in-linux-server.html">http://technikq.blogspot.in/2011/09/install-mssql-in-linux-server.html</a></div>
* * @nil jain * *http://www.blogger.com/profile/06174438648268956122noreply@blogger.com0tag:blogger.com,1999:blog-1796916523586721375.post-44276090173880526172013-07-10T02:52:00.001-07:002013-07-10T02:52:17.937-07:00Turn browser window/tab into a notepad<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
paste the following line the browsers address bar<br />
<br />
data:text/html, <html contenteditable=""></html><br />
<br />
the browser window/tab turns into a notepad</div>
* * @nil jain * *http://www.blogger.com/profile/06174438648268956122noreply@blogger.com0tag:blogger.com,1999:blog-1796916523586721375.post-51972192414601570002013-03-12T03:15:00.002-07:002013-03-12T03:15:36.596-07:00Script for creating a folder & taking a backup up in that folder<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
declare @name varchar(500)<br />
declare @q nvarchar(MAX)<br />
declare @foldername varchar(500)<br />
set @foldername = 'D:\db backup\dbbackup_' + CONVERT(varchar,getdate(),110) + ''<br />
--EXEC master.sys.xp_dirtree @DataPath<br />
EXEC master.dbo.xp_create_subdir @foldername<br />
<br />
set @name = @foldername + '\next_' + CONVERT(varchar,getdate(),110) + '.bak'<br />
set @q = ' BACKUP DATABASE [Next] TO DISK = N''' + @name + ''' WITH NOFORMAT, NOINIT,<br />
NAME = N''Next-Full Database Backup'', SKIP, NOREWIND, NOUNLOAD, STATS = 10'<br />
print @q<br />
exec sp_executesql @q<br />
<br />
set @name = @foldername + '\Mirror_test_' + CONVERT(varchar,getdate(),110) + '.bak'<br />
set @q = ' BACKUP DATABASE [Mirror_test] TO DISK = N''' + @name + ''' WITH NOFORMAT, NOINIT,<br />
NAME = N''Mirror_test-Full Database Backup'', SKIP, NOREWIND, NOUNLOAD, STATS = 10'<br />
print @q<br />
exec sp_executesql @q<br />
</div>
* * @nil jain * *http://www.blogger.com/profile/06174438648268956122noreply@blogger.com0tag:blogger.com,1999:blog-1796916523586721375.post-26503501296316739492013-02-10T22:47:00.002-08:002013-02-10T22:47:39.335-08:00Check Box in Crystal Report or MicorSoft Report.<div dir="ltr" style="text-align: left;" trbidi="on">
<br /><span id="ContentPlaceHolder1_lblDescription"><span itemprop="articleBody">The following Example shows how to <b>Place a Check Box</b> in <b>Crystal Report</b><br /></span></span><br />
<h3>
Steps to be performed :</h3>
1. Expand Field Explorer<br /><br />2. Go To Formula's-> Right Click on that And New Formula<br /><br />3. Give a Name to that Formula Editor<br /><br />4. Now Editor will be displayed<br /><br />5. In that Editor place the below Formula<br /><code><pre>
if{Table.FieldName} = true Then
Chr(254)
Else
Chr(168)</pre>
</code><br /><br />6. Close the Editor it will show save Prompt save the formula<br /><br />7. Drag and drop your formula field to your crystal report<br />Right Click to format Object for that Formula-> Select Format Object<br /><br />8. Go to Fonts Tab and Set Font as 'Wingdings' and Press Ok<br /><br />9. Now check it will display if value is true then checked check box else un-checked checkbox.</div>
* * @nil jain * *http://www.blogger.com/profile/06174438648268956122noreply@blogger.com0tag:blogger.com,1999:blog-1796916523586721375.post-25170985000091796122012-05-25T03:19:00.000-07:002012-05-25T03:19:10.394-07:00New Elements in HTML5<div dir="ltr" style="text-align: left;" trbidi="on">
The internet has changed a lot since HTML 4.01 became a standard in 1999.<br />
Today, some elements in HTML 4.01 are obsolete, never used, or not used the way they were intended to. These elements are
removed or
re-written in HTML5.<br />
To better handle today's internet use, HTML5 includes new elements for
better structure, better form handling, drawing, and for media content.<br />
<br />
http://www.w3schools.com/html5/html5_new_elements.asp </div>* * @nil jain * *http://www.blogger.com/profile/06174438648268956122noreply@blogger.com0tag:blogger.com,1999:blog-1796916523586721375.post-54170920733712278892012-05-23T06:16:00.002-07:002012-05-23T06:16:53.265-07:00Diffrence between Sql 2005 and 2008<div dir="ltr" style="text-align: left;" trbidi="on">
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=107186<br />
<br />
Main Features provided in Sql 2008: <br />
<span style="font-family: Verdana,Arial,Helvetica;"><span style="color: midnightblue; font-family: Verdana,Arial,Helvetica; font-size: x-small;"><span class="spnMessageText" id="msg"><span style="font-family: Arial;">Date and time are seperately used for date and time datatype,geospatial and timestamp with internal timezone <br /> is used.</span></span></span></span><br />
<span style="font-family: Verdana,Arial,Helvetica;"><span style="color: midnightblue; font-family: Verdana,Arial,Helvetica; font-size: x-small;"><span class="spnMessageText" id="msg"><span style="font-family: Arial;">Table datatype introduced.</span></span></span></span><br />
<span style="font-family: Verdana,Arial,Helvetica;"><span style="color: midnightblue; font-family: Verdana,Arial,Helvetica; font-size: x-small;"><span class="spnMessageText" id="msg"><span style="font-family: Arial;">Can encrypt the entire database introduced in 2008.</span></span></span></span><br />
<span style="font-family: Verdana,Arial,Helvetica;"><span style="color: midnightblue; font-family: Verdana,Arial,Helvetica; font-size: x-small;"><span class="spnMessageText" id="msg"><span style="font-family: Arial;">Central Management Server(CMS) is Introduced.</span></span></span></span><span style="font-family: Verdana,Arial,Helvetica;"><span style="color: midnightblue; font-family: Verdana,Arial,Helvetica; font-size: x-small;"><span class="spnMessageText" id="msg"><span style="font-family: Arial;"> </span></span></span></span><span style="font-family: Verdana,Arial,Helvetica;"><span style="color: midnightblue; font-family: Verdana,Arial,Helvetica; font-size: x-small;"><span class="spnMessageText" id="msg"><span style="font-family: Arial;"> </span></span></span></span><span style="font-family: Verdana,Arial,Helvetica;"><span style="color: midnightblue; font-family: Verdana,Arial,Helvetica; font-size: x-small;"><span class="spnMessageText" id="msg"><span style="font-family: Arial;"> </span></span></span></span></div>* * @nil jain * *http://www.blogger.com/profile/06174438648268956122noreply@blogger.com0tag:blogger.com,1999:blog-1796916523586721375.post-61054665239083299812012-05-23T06:14:00.002-07:002012-05-23T06:14:30.202-07:00Diffrence between 3-Tier and mvc-vs-mvp-vs-mvvm<div dir="ltr" style="text-align: left;" trbidi="on">
http://nirajrules.wordpress.com/2009/07/18/mvc-vs-mvp-vs-mvvm/<br />
<br />
<span class="postbody">A fundamental rule in a three-tier architecture
is the client tier never communicates directly with the data tier; in a
three-tier model all communication must pass through the middleware
tier. Conceptually the three-tier architecture is linear. However, the
MVC architecture is triangular: the View sends updates to the
Controller, the Controller updates the Model, and the View gets updated
directly from the Model.
</span><br />
<br /></div>* * @nil jain * *http://www.blogger.com/profile/06174438648268956122noreply@blogger.com0tag:blogger.com,1999:blog-1796916523586721375.post-48038548585129837002012-05-01T06:22:00.003-07:002012-05-01T06:22:50.759-07:00Difference between Function and Stored procedure<div dir="ltr" style="text-align: left;" trbidi="on">
The following are the differences between a User Defined Function and a Stored Procedure in SQL Server<br />
<br />
<ol>
<li>Stored Procedure support deffered name resolution where as functions do not support deffered name resolution.</li>
<li>User Defined Function can be used in a select statement where as you cannot use a stored procedure in a select statement.</li>
<li>UDF’s cannot return Image, Text where as a StoredProcedure can return any datatype.</li>
<li>In general User Defined Functions are used for computations where as Stored Procedures are used for performing business logic.</li>
<li>UDF should return a value where as Stored Procedure need not.</li>
<li>User Defined Functions accept lesser number of input parameters than
Stored Procedures. UDF can have upto 1023 input parameters where as a
Stored Procedure can have upto 21000 input parameters.</li>
<li>You cannot use non-deterministic built-in functions in UDF’s. For
example functions like GETDATE() etc can not be used in UDFs, but can be
used in Stored Procedures.</li>
<li>Temporary Tables can not be used in a UDF where as a StoredProcedure can use Temporary Tables.</li>
<li>UDF can not Execute Dynamic SQL where as a Stored Procedure can execute Dynamic SQL.</li>
<li>User Defined Function does not support error handling where as
Stored Procedure support error handling. RAISEERROR or @@ERROR are not
allowed in UDFs.</li>
</ol>
</div>* * @nil jain * *http://www.blogger.com/profile/06174438648268956122noreply@blogger.com0tag:blogger.com,1999:blog-1796916523586721375.post-84653139225719365382012-04-23T10:23:00.000-07:002012-04-23T10:23:00.713-07:00SQL Server script to rebuild all indexes for all tables and all databases<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="codediv">
<code style="font-size: 12px;"><span style="color: blue;">DECLARE </span><span style="color: #434343;">@Database </span><span style="color: blue;">VARCHAR</span><span style="color: grey;">(</span><span style="color: black;">255</span><span style="color: grey;">) </span><span style="color: blue;">DECLARE </span><span style="color: #434343;">@Table </span><span style="color: blue;">VARCHAR</span><span style="color: grey;">(</span><span style="color: black;">255</span><span style="color: grey;">) </span><span style="color: blue;">DECLARE </span><span style="color: #434343;">@cmd </span><span style="color: blue;">NVARCHAR</span><span style="color: grey;">(</span><span style="color: black;">500</span><span style="color: grey;">) </span><span style="color: blue;">DECLARE </span><span style="color: #434343;">@fillfactor </span><span style="color: blue;">INT <br /><br />SET </span><span style="color: #434343;">@fillfactor </span><span style="color: blue;">= </span><span style="color: black;">90 <br /></span><span style="color: blue;">DECLARE </span><span style="color: black;">DatabaseCursor </span><span style="color: blue;">CURSOR FOR <br />SELECT </span><span style="color: black;">name </span><span style="color: blue;">FROM MASTER</span><span style="color: black;">.dbo.sysdatabases </span><span style="color: blue;">WHERE </span><span style="color: black;">name </span><span style="color: blue;">NOT IN </span><span style="color: grey;">(</span><span style="color: red;">'master'</span><span style="color: grey;">,</span><span style="color: red;">'msdb'</span><span style="color: grey;">,</span><span style="color: red;">'tempdb'<span style="color: grey;">,</span><span style="color: red;">'model'</span><span style="color: grey;">,</span><span style="color: red;">'distribution'</span></span><span style="color: grey;">) </span><span style="color: blue;">ORDER BY </span><span style="color: black;">1 <br /></span><span style="color: blue;">OPEN </span><span style="color: black;">DatabaseCursor <br /></span><span style="color: blue;">FETCH </span><span style="color: black;">NEXT </span><span style="color: blue;">FROM </span><span style="color: black;">DatabaseCursor </span><span style="color: blue;">INTO </span><span style="color: #434343;">@Database </span><span style="color: blue;">WHILE </span><span style="color: #434343;">@@FETCH_STATUS </span><span style="color: blue;">= </span><span style="color: black;">0 </span><span style="color: blue;">BEGIN <br /><br /> SET </span><span style="color: #434343;">@cmd </span><span style="color: blue;">= </span><span style="color: red;">'DECLARE TableCursor CURSOR FOR SELECT ''['' + table_catalog + ''].['' + table_schema + ''].['' + <br /> table_name + '']'' as tableName FROM ' </span><span style="color: grey;">+ </span><span style="color: #434343;">@Database </span><span style="color: grey;">+ </span><span style="color: red;">'.INFORMATION_SCHEMA.TABLES <br /> WHERE table_type = ''BASE TABLE''' <br /><br /> </span><span style="color: green;">-- create table cursor <br /> </span><span style="color: blue;">EXEC </span><span style="color: grey;">(</span><span style="color: #434343;">@cmd</span><span style="color: grey;">) <br /> </span><span style="color: blue;">OPEN </span><span style="color: black;">TableCursor <br /><br /> </span><span style="color: blue;">FETCH </span><span style="color: black;">NEXT </span><span style="color: blue;">FROM </span><span style="color: black;">TableCursor </span><span style="color: blue;">INTO </span><span style="color: #434343;">@Table <br /> </span><span style="color: blue;">WHILE </span><span style="color: #434343;">@@FETCH_STATUS </span><span style="color: blue;">= </span><span style="color: black;">0 <br /> </span><span style="color: blue;">BEGIN <br /><br /> IF </span><span style="color: grey;">(</span><span style="color: #434343;">@@MICROSOFTVERSION </span><span style="color: grey;">/ </span><span style="color: magenta;">POWER</span><span style="color: grey;">(</span><span style="color: black;">2</span><span style="color: grey;">, </span><span style="color: black;">24</span><span style="color: grey;">) >= </span><span style="color: black;">9</span><span style="color: grey;">)<br /> </span><span style="color: blue;">BEGIN<br /> </span><span style="color: green;">-- SQL 2005 or higher command <br /> </span><span style="color: blue;">SET </span><span style="color: #434343;">@cmd </span><span style="color: blue;">= </span><span style="color: red;">'ALTER INDEX ALL ON ' </span><span style="color: grey;">+ </span><span style="color: #434343;">@Table </span><span style="color: grey;">+ </span><span style="color: red;">' REBUILD WITH (FILLFACTOR = ' </span><span style="color: grey;">+ </span><span style="color: magenta;">CONVERT</span><span style="color: grey;">(</span><span style="color: blue;">VARCHAR</span><span style="color: grey;">(</span><span style="color: black;">3</span><span style="color: grey;">),</span><span style="color: #434343;">@fillfactor</span><span style="color: grey;">) + </span><span style="color: red;">')' <br /> </span><span style="color: blue;">EXEC </span><span style="color: grey;">(</span><span style="color: #434343;">@cmd</span><span style="color: grey;">) <br /> </span><span style="color: blue;">END<br /> ELSE<br /> BEGIN<br /> </span><span style="color: green;">-- SQL 2000 command <br /> </span><span style="color: blue;">DBCC </span><span style="color: black;">DBREINDEX</span><span style="color: grey;">(</span><span style="color: #434343;">@Table</span><span style="color: grey;">,</span><span style="color: red;">' '</span><span style="color: grey;">,</span><span style="color: #434343;">@fillfactor</span><span style="color: grey;">) <br /> </span><span style="color: blue;">END<br /><br /> FETCH </span><span style="color: black;">NEXT </span><span style="color: blue;">FROM </span><span style="color: black;">TableCursor </span><span style="color: blue;">INTO </span><span style="color: #434343;">@Table <br /> </span><span style="color: blue;">END <br /><br /> CLOSE </span><span style="color: black;">TableCursor <br /> </span><span style="color: blue;">DEALLOCATE </span><span style="color: black;">TableCursor <br /><br /> </span><span style="color: blue;">FETCH </span><span style="color: black;">NEXT </span><span style="color: blue;">FROM </span><span style="color: black;">DatabaseCursor </span><span style="color: blue;">INTO </span><span style="color: #434343;">@Database </span><span style="color: blue;">END <br />CLOSE </span><span style="color: black;">DatabaseCursor </span><span style="color: blue;">DEALLOCATE </span><span style="color: black;">DatabaseCursor</span></code> </div>
</div>* * @nil jain * *http://www.blogger.com/profile/06174438648268956122noreply@blogger.com0tag:blogger.com,1999:blog-1796916523586721375.post-76600275669805144312012-04-23T10:20:00.000-07:002012-04-23T10:20:06.769-07:00Simple script to backup all SQL Server databases<div dir="ltr" style="text-align: left;" trbidi="on">
<code><span style="color: blue;">DECLARE </span><span style="color: #434343;">@name </span><span style="color: blue;">VARCHAR</span><span style="color: grey;">(</span><span style="color: black;">50</span><span style="color: grey;">) </span><span style="color: green;">-- database name </span><span style="color: blue;">DECLARE </span><span style="color: #434343;">@path </span><span style="color: blue;">VARCHAR</span><span style="color: grey;">(</span><span style="color: black;">256</span><span style="color: grey;">) </span><span style="color: green;">-- path for backup files </span><span style="color: blue;">DECLARE </span><span style="color: #434343;">@fileName </span><span style="color: blue;">VARCHAR</span><span style="color: grey;">(</span><span style="color: black;">256</span><span style="color: grey;">) </span><span style="color: green;">-- filename for backup </span><span style="color: blue;">DECLARE </span><span style="color: #434343;">@fileDate </span><span style="color: blue;">VARCHAR</span><span style="color: grey;">(</span><span style="color: black;">20</span><span style="color: grey;">) </span><span style="color: green;">-- used for file name <br /></span><span style="color: blue;">SET </span><span style="color: #434343;">@path </span><span style="color: blue;">= </span><span style="color: red;">'C:\Backup\' <br /></span><span style="color: blue;">SELECT </span><span style="color: #434343;">@fileDate </span><span style="color: blue;">= </span><span style="color: magenta;">CONVERT</span><span style="color: grey;">(</span><span style="color: blue;">VARCHAR</span><span style="color: grey;">(</span><span style="color: black;">20</span><span style="color: grey;">),</span><span style="color: magenta;">GETDATE</span><span style="color: grey;">(),</span><span style="color: black;">112</span><span style="color: grey;">) <br /></span><span style="color: blue;">DECLARE </span><span style="color: black;">db_cursor </span><span style="color: blue;">CURSOR FOR <br />SELECT </span><span style="color: black;">name </span><span style="color: blue;">FROM </span><span style="color: black;">master.dbo.sysdatabases </span><span style="color: blue;">WHERE </span><span style="color: black;">name </span><span style="color: grey;">NOT </span><span style="color: blue;">IN </span><span style="color: grey;">(</span><span style="color: red;">'master'</span><span style="color: grey;">,</span><span style="color: red;">'model'</span><span style="color: grey;">,</span><span style="color: red;">'msdb'</span><span style="color: grey;">,</span><span style="color: red;">'tempdb'</span><span style="color: grey;">) <br /></span><span style="color: blue;">OPEN </span><span style="color: black;">db_cursor </span><span style="color: blue;">FETCH </span><span style="color: black;">NEXT </span><span style="color: blue;">FROM </span><span style="color: black;">db_cursor </span><span style="color: blue;">INTO </span><span style="color: #434343;">@name <br /></span><span style="color: blue;">WHILE </span><span style="color: #434343;">@@FETCH_STATUS </span><span style="color: blue;">= </span><span style="color: black;">0 </span><span style="color: blue;">BEGIN <br /> SET </span><span style="color: #434343;">@fileName </span><span style="color: blue;">= </span><span style="color: #434343;">@path </span><span style="color: grey;">+ </span><span style="color: #434343;">@name </span><span style="color: grey;">+ </span><span style="color: red;">'_' </span><span style="color: grey;">+ </span><span style="color: #434343;">@fileDate </span><span style="color: grey;">+ </span><span style="color: red;">'.BAK' <br /> </span><span style="color: blue;">BACKUP DATABASE </span><span style="color: #434343;">@name </span><span style="color: blue;">TO DISK = </span><span style="color: #434343;">@fileName <br /><br /> </span><span style="color: blue;">FETCH </span><span style="color: black;">NEXT </span><span style="color: blue;">FROM </span><span style="color: black;">db_cursor </span><span style="color: blue;">INTO </span><span style="color: #434343;">@name </span><span style="color: blue;">END <br /><br />CLOSE </span><span style="color: black;">db_cursor </span><span style="color: blue;">DEALLOCATE </span><span style="color: black;">db_cursor</span></code></div>* * @nil jain * *http://www.blogger.com/profile/06174438648268956122noreply@blogger.com0tag:blogger.com,1999:blog-1796916523586721375.post-19238678990725156902012-02-27T10:50:00.000-08:002012-02-27T10:50:05.055-08:00Methods in Global.asax<div dir="ltr" style="text-align: left;" trbidi="on"><h3 class="post-title entry-title"> Methods in Global.asax </h3><div class="post-header"> </div>This blog is intended to spread some light on the various methods which are available in global.asax file in ASP.NET. It’s very important to understand the methods in global.asax so that we as programmers can handle some application level events very efficiently. I said application level events and reason for using application word is that global.asax is an application level file and methods in it are used to handle application level events and these methods are not at all specific to any aspx page. Some of the common methods in the order in which they are executed are listed below <br />
<ul><li>Application_Start</li>
<li>Application_BeginRequest</li>
<li>Application_AuthenticateRequest</li>
<li>Session_Start</li>
<li>Application_EndRequest</li>
<li>Session_End</li>
<li>Application_End</li>
<li>Application_Error</li>
</ul>Now let’s see what is the major difference between these methods or events. Oh I forgot to say, these are actually events not methods which get raised when a particular event gets triggered. Before we see the various methods in Global.asax I would like to tell you that Global.asax is actually derived from a class called “HttpApplication”. The above listed methods are only a few methods which I am gonna talk about. The listing of other methods can be found at the end of the blog. Now lets see the above mentioned events one by one.<br />
<br />
<span style="color: #000099;"><strong>Application_Start</strong> </span><br />
Application_Start event gets triggered only once during the life cycle of the application. This once happens when the first request for any resource in the application comes. Resource can be a page or an image in the application. When the very first request for a resource, say a web page, is made by a user “Application_Start” is triggered after which this event is not at all executed. If by any chance the server where the application is hosted is restarted then this event is fired once again i.e. when the very first request for any resource in the application is made after the server is reset. <br />
<br />
<span style="color: #000099;"><strong>Application_BeginRequest</strong> </span><br />
“Application_BeginRequest” is the second event which gets fired after “Application_Start”. Unlike the “Application_Start”, “Application_BeginRequest” is triggered for each and every request which comes to the application. Since this method is fired for any request made to the application you can use this method to keep track of what and all resources are accessed through this method. <br />
<br />
<span style="color: #000099;"><strong>Application_AuthenticateRequest</strong> </span><br />
“Application_AuthenticateRequest” is the next event in line which is triggered after “Application_BeginRequest” is triggered. “Application_AuthenticateRequest” is also fired for each and every request. This event can be used to write code in scenarios where you want to do something when the user is getting authenticated.<br />
<br />
<span style="color: #000099;"><strong>Session_Start</strong> </span><br />
The next event in line which gets triggered after “Application_AuthenticateRequest” is “Session_Start”. Session start event is fired only when a new session for a user starts. Once “Session_Start” for a user is fired then if the user makes subsequent request to any resource within the application this event is not at all triggered. The event is triggered only when the user’s session expires and then the user tries to access any resource in the application again.<br />
This event can be used when you want to do something when the user visits you site/application for the first time or when his session starts. This event doesn’t get triggered if you are not using sessions which can be disabled in the web.config.<br />
<br />
<span style="color: #000099;"><strong>Application_EndRequest</strong> </span><br />
The next event in line which gets fired once the request for the user is processed is “Applicatin_EndRequest”. This event is the closing event of “Applicatin_BeginRequest”. This event is also fired for each and every request which comes for the application. <br />
<br />
<span style="color: #000099;"><strong>Session_End</strong> </span><br />
The closing event of “Session_Start” event. Whenever a user’s session in the application expires this event gets fired. So anything you want to do when the user’s session expires you can write codes here. The session expiration time can be set in web.config file. By default session time out is set to 20 mins. <br />
<br />
<span style="color: #000099;"><strong>Application_End</strong> </span><br />
The same as “Application_Start”, “Application_End” is executed only once, when the application is unloaded. This event is the end event of “Application_Start”. This event is normally fired when the application is taken offline or when the server is stopped.<br />
<br />
<span style="color: #000099;"><strong>Application_Error</strong> </span><br />
Now we come to the last event mentioned in this blog and that is “Application_Error”. This event gets fired when any unhandled exception/error occurs anywhere in the application. Any unhandled here means exception which are not caught using try catch block. Also if you have custom errors enabled in your application i.e. in web.config file then the configuration in web.config takes precedence and all errors will be directed to the file mentioned in the tag.<br />
Lets see with an e.g. how these events get fired.<br />
Suppose “A”, “B” and “C” are users who are going to access a site named “My Site”. “A” is the very first user to visit “My Site” and he/she is accessing “productlist.aspx” page. At this time the flow of the request is as follows. The “Application_Start” event is triggered, since “A” is the very first user to visit the application, after this “Application_BeginRequest”, then “Application_AuthenticateRequest”, then “Session_Start”, “productlist.aspx” page level events are processed and then “Application_EndRequest” event is triggered. After accessing “productlist.aspx” if “A” access some other page then for those page request the flow will be first “Application_BeginRequest”, “Application_AuthenticateRequest” then the page processing (page level events) and then “Application_EndRequest”. For every subsequent request this pattern is followed.<br />
<br />
When “B” accesses some resource in the site, say “default.aspx”, then first “Applicatin_BeginRequest”, second “Application_AuthenticateRequest”, third “Session_Start” then “default.aspx” page level events are executed and after that “Application_EndRequest” is executed. After accessing “default.aspx” “B” access “productlist.aspx” then first “Application_BeginRequest”, second “Application_AuthenticateRequest” then “productlist.aspx” and then “Application_EndRequest” event is triggered. He refreshes the page the same events are executed in the same order.<br />
The above same process is repeated for “C” also. <br />
Suppose you have an unhandled exception and you don’t have custom errors enabled in web.config then when a user accesses a resource the flow will be first “Application_BeginRequest”, “Application_AuthenticateRequest”, page level event and an error occurs in the page then it goes to “Application_Error” after that “Application_EndRequest”.<br />
The order mentioned above is how the events are triggered. So with this I hope you would have got a clear idea on how these events are triggered. <br />
Some other events which are part of the HttpApplication class are as follows<br />
<ul><li>PostAuthenticateRequest</li>
<li>AuthorizeRequest</li>
<li>PostAuthorizeRequest</li>
<li>ResolveRequestCache</li>
<li>PostResolveRequestCache</li>
<li>PostMapRequestHandler</li>
<li>AcquireRequestState</li>
<li>PostAcquireRequestState</li>
<li>PreRequestHandlerExecute</li>
<li>PostRequestHandlerExecute</li>
<li>ReleaseRequestState</li>
<li>PostReleaseRequestState</li>
<li>UpdateRequestCache</li>
<li>PostUpdateRequestCache</li>
<li>LogRequest. (Supported in IIS 7.0 only.)</li>
<li>PostLogRequest (Supported in IIS 7.0 only.)</li>
</ul></div>* * @nil jain * *http://www.blogger.com/profile/06174438648268956122noreply@blogger.com0tag:blogger.com,1999:blog-1796916523586721375.post-30906963117861334742012-01-11T01:20:00.001-08:002012-01-11T01:20:12.125-08:00Select some particular rows<div dir="ltr" style="text-align: left;" trbidi="on">SELECT UPPER(Name) FROM<br />
(<br />
SELECT *, RN = row_number()<br />
OVER (ORDER BY Name)<br />
FROM Customer<br />
WHERE Name LIKE 'A%'<br />
) A<br />
WHERE RN BETWEEN 21 AND 30<br />
ORDER BY Name<br />
</div>* * @nil jain * *http://www.blogger.com/profile/06174438648268956122noreply@blogger.com0tag:blogger.com,1999:blog-1796916523586721375.post-557769975001813682011-05-05T21:46:00.000-07:002011-05-05T21:46:01.424-07:001G, 2G, 2.5G, 3G, Pre-4G and 4G<div dir="ltr" style="text-align: left;" trbidi="on"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSsPToyz-kBmCAofq7BD1eeJQ-xEGIalmr4YBqIschldM9cqtJJDja3p6MtEywum6rESi1rqbVJE66HqGVRWzc7dmJB094tl6VvJwmGOaLLym82uugFWYp7NPQds4TR0vBf0MMfAJ_qKw/s1600/3G-4G-Difference-Table.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="233" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSsPToyz-kBmCAofq7BD1eeJQ-xEGIalmr4YBqIschldM9cqtJJDja3p6MtEywum6rESi1rqbVJE66HqGVRWzc7dmJB094tl6VvJwmGOaLLym82uugFWYp7NPQds4TR0vBf0MMfAJ_qKw/s320/3G-4G-Difference-Table.png" width="320" /></a></div><br />
</div>* * @nil jain * *http://www.blogger.com/profile/06174438648268956122noreply@blogger.com0tag:blogger.com,1999:blog-1796916523586721375.post-51494536918084421752011-05-05T21:43:00.000-07:002011-05-05T21:43:10.661-07:00Difference Between Image and Picture<div dir="ltr" style="text-align: left;" trbidi="on"><span class="yiv677881678Apple-style-span"><span class="yiv677881678Apple-style-span"><span class="yiv677881678Apple-style-span"><span class="yiv677881678Apple-style-span" style="font-family: tahoma,times,serif;"><span class="yiv677881678Apple-style-span"><span class="yiv677881678Apple-style-span" style="font-family: tahoma,times,serif;"><span class="yiv677881678Apple-style-span"><span class="yiv677881678Apple-style-span"><span class="yiv677881678Apple-style-span" style="font-family: tahoma,times,serif;"><span class="yiv677881678Apple-style-span"><span class="yiv677881678Apple-style-span"><div style="font-family: tahoma,times,serif; font-size: 18pt;"><span class="yiv677881678Apple-style-span" style="color: maroon; font-size: x-small;">IMAGE - An image of your self or anyone (Usually taken through Camera)</span></div><div style="font-family: tahoma,times,serif; font-size: 18pt;"><span class="yiv677881678Apple-style-span" style="color: maroon; font-size: x-small;">PICTURE - A Picture is to draw something in the computer/real life.</span></div></span></span></span></span></span></span></span></span></span></span></span></div>* * @nil jain * *http://www.blogger.com/profile/06174438648268956122noreply@blogger.com0tag:blogger.com,1999:blog-1796916523586721375.post-85549467975871790812011-05-05T21:41:00.000-07:002011-05-05T21:41:51.894-07:00Difference Between 1G, 2G, 2.5G, 3G, Pre-4G and 4G<div dir="ltr" style="text-align: left;" trbidi="on"><div style="color: black; font-family: tahoma,times,serif; font-size: 18pt;"><span class="yiv677881678Apple-style-span" style="font-family: tahoma,times,serif;"><div style="color: black; font-family: tahoma,times,serif; font-size: 12pt; font-weight: normal; text-decoration: underline;"><div><span class="yiv677881678Apple-style-span" style="font-family: tahoma,times,serif; font-size: medium;"><b><u><span class="yiv677881678Apple-style-span" style="color: maroon;"></span></u></b></span></div></div></span></div><div><div><div><div><div><div><div><div><div><div><div><div><span class="yiv677881678Apple-style-span"><div><div><span class="yiv677881678Apple-style-span"><div><div><div><span class="yiv677881678Apple-style-span"><div style="color: black; font-family: tahoma,times,serif; font-size: medium; font-weight: bold;"><span class="yiv677881678Apple-style-span" style="color: maroon; font-size: medium;"></span></div><div><span class="yiv677881678Apple-style-span" style="font-family: tahoma,times,serif;"><span class="yiv677881678Apple-style-span"><div><span class="yiv677881678Apple-style-span" style="font-family: tahoma,times,serif;"><div><div><span class="yiv677881678Apple-style-span"><div><span class="yiv677881678Apple-style-span"><div><div><div><div><div><div><span class="yiv677881678Apple-style-span" style="font-family: tahoma,times,serif;"><div><div><span class="yiv677881678Apple-style-span"><div><span class="yiv677881678Apple-style-span"><div><div><div><div><div><div><div><div><div><div><div><b>1G</b> is the first generation celullar network that existed in 1980s. It transfer data (only voice) in analog wave, it has limitation because there are no encryption, the sound quality is poor and the speed of transfer is only at 9.6kbps. </div><div><br />
</div><div><b>2G</b> is the second one, improved by introducing the concept of digital modulation, which means converting the voice(only) into digital code(in your phone) and then into analog signals(imagine that it flys in the air). Being digital, they overcame some of the limitations of 1G, such as it omits the radio power from handsets making life more healthier, and it has enhanced privacy.</div><div><br />
</div><div><b>2.5G</b> is a transition of 2G and 3G. In 2.5G, the most popular services like SMS (short messaging service), GPRS, EDGE, High Speed Circuit switched data, and more had been introduced.</div><div><br />
</div><div><b>3G</b> is the current generation of mobile telecommunication standards. It allows simultaneous use of speech and data services and offers data rates of up to 2 Mbps, which provide servcies like video calls, mobile TV, mobile Internet and downloading. There are a bunch of technologies that fall under 3G, like WCDMA, EV-DO, and HSPA and others. </div><div><br />
</div><div>In telecommunications, <b>4G</b> is the fourth generation of cellular wireless standards. It is a successor to the 3G and 2G families of standards. In 2008, the ITU-R organization specified the IMT-Advanced (International Mobile Telecommunications Advanced) requirements for 4G standards, setting peak speed requirements for 4G service at 100 Mbit/s for high mobility communication (such as from trains and cars) and 1 Gbit/s for low mobility communication (such as pedestrians and stationary users)</div><div><br />
</div><div>A <b>4G</b> system is expected to provide a comprehensive and secure all-IP based mobile broadband solution to laptop computer wireless modems, smartphones, and other mobile devices. Facilities such as ultra-broadband Internet access, IP telephony, gaming services, and streamed multimedia may be provided to users.</div><div><br />
</div><div><b>PRE-4G</b> technologies such as mobile WiMAX and Long term evolution (LTE) have been on the market since 2006 and 2009 respectively, and are often branded as 4G. The current versions of these technologies did not fulfill the original ITU-R requirements of data rates approximately up to 1 Gbit/s for 4G systems. Marketing materials use 4G as a description for LTE and Mobile-WiMAX in their current forms.</div></div></div></div></div></div></div></div></div></div></div></span></div></span></div></div></span></div></div></div></div></div></div></span></div></span></div></div></span></div></span></span></div></span></div></div></div></span></div></div></span></div></div></div></div></div></div></div></div></div></div></div></div></div>* * @nil jain * *http://www.blogger.com/profile/06174438648268956122noreply@blogger.com0tag:blogger.com,1999:blog-1796916523586721375.post-14584436410062588682011-04-20T06:09:00.000-07:002011-04-20T06:09:13.584-07:00COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154 with Excel<div dir="ltr" style="text-align: left;" trbidi="on">http://technoblogy.net/retrieving-the-com-class-factory-for-component-with-clsid-00024500-0000-0000-c000-000000000046-failed-due-to-the-following-error-80040154/</div>* * @nil jain * *http://www.blogger.com/profile/06174438648268956122noreply@blogger.com0tag:blogger.com,1999:blog-1796916523586721375.post-40055481184711066842011-04-07T02:37:00.001-07:002011-04-07T02:37:21.145-07:00SQL SERVER CODE NAME<div dir="ltr" style="text-align: left;" trbidi="on"><ul style="text-align: justify;"><li>1993 – SQL Server 4.21 for Windows NT</li>
<li>1995 – SQL Server 6.0, codenamed SQL95</li>
<li>1996 – SQL Server 6.5, codenamed Hydra</li>
<li>1999 – SQL Server 7.0, codenamed Sphinx</li>
<li>1999 – SQL Server 7.0 OLAP, codenamed Plato</li>
<li>2000 – SQL Server 2000 32-bit, codenamed Shiloh (version 8.0)</li>
<li>2003 – SQL Server 2000 64-bit, codenamed Liberty</li>
<li>2005 – SQL Server 2005, codenamed Yukon (version 9.0)</li>
<li>2008 – SQL Server 2008, codenamed Katmai (version 10.0)</li>
<li>2010 – SQL Server 2008 R2, Codenamed Kilimanjaro (aka KJ)</li>
<li>Next – SQL Server 2011, Codenamed Denali</li>
</ul></div>* * @nil jain * *http://www.blogger.com/profile/06174438648268956122noreply@blogger.com0tag:blogger.com,1999:blog-1796916523586721375.post-41831896046968142032011-03-28T05:03:00.000-07:002011-03-28T05:03:36.629-07:00To get the Host Name and IP address in C#<div dir="ltr" style="text-align: left;" trbidi="on"><pre class="FreeTextFull">using System.Net;
string getHost = System.Net.Dns.GetHostName();
string getIP = System.Net.Dns.GetHostByName(getHost).AddressList[0].ToString();
</pre></div>* * @nil jain * *http://www.blogger.com/profile/06174438648268956122noreply@blogger.com0