Learning Curve…

Archive for the ‘Quick Technical Facts’ Category

Style Code

Style

Format

Example

0 or 100 Default. Equivalent to not specifying a style code. mon dd yyyy hh:mmAM Sep 8 2007 9:00PM
1 USA date. mm/dd/yy 09-08-2007
2 ANSI date. yy.mm.dd 07-09-2008
3 UK / French date. dd/mm/yy 08-09-2007
4 German date. dd.mm.yy 08.09.07
5 Italian date. dd-mm-yy 08-09-2007
6 Abbreviated month. dd mmm yy 08-Sep-07
7 Abbreviated month. mmm dd, yy Sep 08, 07
8 or 108 24 hour time. HH:mm:ss 21:00:00
9 or 109 Default formatting with seconds and milliseconds appended. mon dd yyyy hh:mm:ss:fffAM Sep 8 2007 9:00:00:000PM
10 USA date with hyphen separators. mm-dd-yy 09-08-2007
11 Japanese date. yy/mm/dd 07-09-2008
12 ISO date. yymmdd 70908
13 or 113 European default with seconds and milliseconds. dd mon yyyy HH:mm:ss:fff 08 Sep 2007 21:00:00:000
14 or 114 24 hour time with milliseconds. HH:mm:ss:fff 21:00:00:000
20 or 120 ODBC canonical date and time. yyyy-mm-dd HH:mm:ss 08-09-2007 21:00
21 or 121 ODBC canonical date and time with milliseconds. yyyy-mm-dd HH:mm:ss.fff 00:00.0
101 USA date with century. mm/dd/yyyy 09-08-2007
102 ANSI date with century. yyyy.mm.dd 08-09-2007
103 UK / French date with century. dd/mm/yyyy 08-09-2007
104 German date with century. dd.mm.yyyy 08.09.2007
105 Italian date with century. dd-mm-yyyy 08-09-2007
106 Abbreviated month with century. dd mmm yyyy 08-Sep-07
107 Abbreviated month with century. mmm dd, yyyy Sep 08, 2007
110 USA date with hyphen separators and century. mm-dd-yyyy 09-08-2007
111 Japanese date with century. yyyy/mm/dd 08-09-2007
112 ISO date with century. yymmdd 20070908
126 ISO8601, for use in XML. yyy-mm-ddThh:mm:ss 2007-09-08T21:00:00

 

Just add these lines before your SP Statements. :-

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


Exp :-

Use YourDatabaseName

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE …

Tags: ,

Lets say , you have added a class with a different namespace folder or project  and then calling this class in your aspx.cs page where you have not added class’s namespace.Notice how you immediately get an error when you type class name because it’s defined in a namespace that is not in scope. You can fix the proble in two ways.

1. You can type Imports class’s namespace if you’re using VB.NET or using class’s namespace; if you’re using C# at the top of the code file.

2.You can click the word class name in your calling page once and then press Ctrl+. (Ctrl+Dot) to bring up a dialog that lets you choose the fix for the problem. Choose the appropriate item and .net will adds the necessary Imports/using statement for you.

In ASP.NET 4 FormView and on a few of the Login controls having RenderOuterTable property . When you set this property to True (it defaults to False so you need to set it explicitly) the control doesn’t generate a wrapping HTML <table> element. This in turn results in less code and cleaner HTML.

In ASP.NET 4, list controls have been extended with a ClientIDRowSuffix property that enables you to indicate the column whose value is used to create unique client-side IDs based on data in the database. For this to work, you need to set the ClientIDMode property.

tinyint  :- Used to store integer numbers ranging from 0 to 255.
smallint :- Used to store integer numbers ranging from –32,768 to 32,767.
int :- Used to store integer numbers ranging from –2,147,483,648 to 2,147,483,647.
bigint :- Used to store large integer numbers ranging from –9,223,372,036,854,775,808 to 9,223,372,036,854,775,807.

char / nchar  :- It Contains fixed-length text. When you store text shorter than the defined length, the text is padded with spaces. The nchar stores the data in Unicode format, which enables you to store data for many foreign languages.

text / ntext :- Used to store large amounts of text.

varchar / nvarchar :- Used to store text with a variable length. The nvarchar stores the data in Unicode format, which enables you to store data for many foreign languages.


Author

Learning days (Calendar)

June 2017
M T W T F S S
« Jun    
 1234
567891011
12131415161718
19202122232425
2627282930  

Knowledge Bank (Archives)

I am on Twitter

Blog Stats

  • 498,681 hits

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 43 other followers

%d bloggers like this: