Wednesday, November 29, 2017

What is the difference between smalldatetime and datetime?

›
DateTime SmallDateTime Storage Size 8 Bytes 4 Bytes FORMAT YYYY-MM-DD hh:mm:ss.nnn YYYY-MM-DD hh:mm:ss MIN Value 1753...
Tuesday, November 28, 2017

C#, create folder dynamically or check folder exists

›
string subPath ="ImagesPath"; // your code goes here bool IsExists = System.IO.Directory.Exists(Server.MapPath(subPath)); if(!I...
Monday, November 6, 2017

Steps to Create twitter application

›
Steps to Create twitter application: To use Twitter counter widget and other Twitter related widgets, you need OAuth access keys. To get...

SQL Server, Connection String creation

›
Whenever we need to create a connection string for a new database or in the same database then we need to follow simple few steps listed be...
Sunday, November 5, 2017

A href open in new tab, same frame, parent frame and reuse the existing One

›
Open the linked document in a new window or tab: <a href = "xyz.html" target = "_blank" > Link </a> ...
1 comment:

Install WordPress on local machine

›
To use WordPress you must have a server (WAMP, XAMP) installed on your machine for its working environment. Without a server you won’t be...
Monday, October 2, 2017

Create a copy of database and renaming it using mdf & ldf files

›
If You want to use the same directory for your mdf\ldf files You will have to (physically) rename them. 1. Detach files from local PC 2. ...
Sunday, October 1, 2017

Difference Between String and StringBuilder

›
String are Immutable (Not Modifiable). If you try to modify the string it actually creates a new string and the old string will be then ...
Tuesday, September 22, 2015

Stored procedure slow when called from web, fast from Management Studio

›
Some time this problem occurs due to compiled query plan became corrupt, or invalid. Stored procedure slow when called from web, fast fro...
Monday, July 13, 2015

C#, Read a file

›
C#, Code to read a file  String strHtmlMessage = String .Empty; String strFilePath = HttpContext.Current.Server.MapPath("~/Mails/Co...