November 29, 2012

What is Connection Pooling in ADO.NET? — How It Works, Benefits & Code Example


Explain about Connection Pooling?

  • Connection pooling is a concept which deals with database connection. A Connection Pool maintain last database connection active state when connection is ideal. Whenever you want to make a transaction with database once again you have to open connection when it is ideal, instead of that connection pooling will maintain open and reusable connections. A Connection Pool is released from the buffer or memory when the last connection to the database is closed.
  • By default Connection Pooling turned on in ado.net; whenever you want to change it off, you have to specify Pooling = false in the connection string .
  • We can specify limit to connection pooling by default the maximum limit is 100.
  • You will specify in connection string.
  • It will improves the performance and scalability of the application
It is managed by a program in ado.net that we called as Pool Manager. This program will maintain different connection request by comparing with maximum limit connection pool ,if number of connection are equal to max limit It will wait for new connection till another connection ideal or time out. If  connection is not in use then manager returns one, else it will create new connection and add to the pool.
Connection pool is managed with different parameters which are specified in connection string those are

   Connect Timeout
Min Pool Size
Max Pool Size
Pooling

Tomorrow will be with  Object Pooling?

November 20, 2012

dotnet Regular Expressions list for validations


dotnet Regular Expressions 



Character
Description
\
Marks the next character as either a special character or escapes a literal. For example, "n" matches the character "n". "\n" matches a newline character. The sequence "\\" matches "\" and "\(" matches "(".
Note: double quotes may be escaped by doubling them: "<a href=""...>"
^Depending on whether the MultiLine option is set, matches the position before the first character in a line, or the first character in the string.
$Depending on whether the MultiLine option is set, matches the position after the last character in a line, or the last character in the string.
*Matches the preceding character zero or more times. For example, "zo*" matches either "z" or "zoo".
+Matches the preceding character one or more times. For example, "zo+" matches "zoo" but not "z".
?Matches the preceding character zero or one time. For example, "a?ve?" matches the "ve" in "never".
.Matches any single character except a newline character.
(pattern)Matches pattern and remembers the match. The matched substring can be retrieved from the resulting Matchescollection, using Item [0]...[n]. To match parentheses characters ( ), use "\(" or "\)".
(?<name>pattern)Matches pattern and gives the match a name.
(?:pattern)A non-capturing group
(?=...)A positive lookahead
(?!...)A negative lookahead
(?<=...)A positive lookbehind .
(?<!...)A negative lookbehind .
x|yMatches either x or y. For example, "z|wood" matches "z" or "wood". "(z|w)oo" matches "zoo" or "wood".
{n}n is a non-negative integer. Matches exactly n times. For example, "o{2}" does not match the "o" in "Bob," but matches the first two o's in "foooood".
{n,}n is a non-negative integer. Matches at least n times. For example, "o{2,}" does not match the "o" in "Bob" and matches all the o's in "foooood." "o{1,}" is equivalent to "o+". "o{0,}" is equivalent to "o*".
{n,m}m and n are non-negative integers. Matches at least n and at most m times. For example, "o{1,3}" matches the first three o's in "fooooood." "o{0,1}" is equivalent to "o?".
[xyz]A character set. Matches any one of the enclosed characters. For example, "[abc]" matches the "a" in "plain".
[^xyz]A negative character set. Matches any character not enclosed. For example, "[^abc]" matches the "p" in "plain".
[a-z]A range of characters. Matches any character in the specified range. For example, "[a-z]" matches any lowercase alphabetic character in the range "a" through "z".
[^m-z]A negative range characters. Matches any character not in the specified range. For example, "[m-z]" matches any character not in the range "m" through "z".
\bMatches a word boundary, that is, the position between a word and a space. For example, "er\b" matches the "er" in "never" but not the "er" in "verb".
\BMatches a non-word boundary. "ea*r\B" matches the "ear" in "never early".
\dMatches a digit character. Equivalent to [0-9].
\DMatches a non-digit character. Equivalent to [^0-9].
\fMatches a form-feed character.
\kA back-reference to a named group.
\nMatches a newline character.
\rMatches a carriage return character.
\sMatches any white space including space, tab, form-feed, etc. Equivalent to "[ \f\n\r\t\v]".
\SMatches any nonwhite space character. Equivalent to "[^ \f\n\r\t\v]".
\tMatches a tab character.
\vMatches a vertical tab character.
\wMatches any word character including underscore. Equivalent to "[A-Za-z0-9_]".
\WMatches any non-word character. Equivalent to "[^A-Za-z0-9_]".
\numMatches num, where num is a positive integer. A reference back to remembered matches. For example, "(.)\1" matches two consecutive identical characters.
\nMatches n, where n is an octal escape value. Octal escape values must be 1, 2, or 3 digits long. For example, "\11" and "\011" both match a tab character. "\0011" is the equivalent of "\001" & "1". Octal escape values must not exceed 256. If they do, only the first two digits comprise the expression. Allows ASCII codes to be used in regular expressions.
\xnMatches n, where n is a hexadecimal escape value. Hexadecimal escape values must be exactly two digits long. For example, "\x41" matches "A". "\x041" is equivalent to "\x04" & "1". Allows ASCII codes to be used in regular expressions.
\unMatches a Unicode character expressed in hexadecimal notation with exactly four numeric digits. "\u0200" matches a space character.
\AMatches the position before the first character in a string. Not affected by the MultiLine setting
\ZMatches the position after the last character of a string. Not affected by the MultiLine setting.
\GSpecifies that the matches must be consecutive, without any intervening non-matching characters.





Further studies just check website:
http://www.regular-expressions.info/numericranges.html

November 19, 2012

Visual Studio Keyboard Shortcuts Every .NET Developer Must Know (2026 Updated)


when ever we want work with MS.net we have to learn about some keys which can help to improve our work force in development area .i  got some shortcut key in msdn ,You can view all of the keyboard shortcuts for Visual Web Developer.
we can create our own shortcuts by doing the following:
 on the Tools --> Options;
it will open dialog box  of the Options,
 select Environment and then Keyboard.
we have to select the Show all settings check box in order to view the Keyboard setting.

Shortcut
Description
CTRL+B
Switches the selected text between bold and normal.
CTRL+I
Switches the font style of the selected text between italic and roman.
CTRL+U
Switches the font style of the selected text between underline and roman.
CTRL+SHIFT+L
Displays the Bookmark dialog box.
CTRL+L
When text is selected, displays the Hyperlink dialog box.
CTRL+SHIFT+W
Displays your Web page in the default browser.
CTRL+ALT+UP ARROW
Inserts one row above the selected row in the table.
CTRL+ALT+DOWN ARROW
Inserts one row below the selected row in the table.
CTRL+ALT+LEFT ARROW
Inserts one column to the left of the selected column in the table.
CTRL+ALT+RIGHT ARROW
Inserts one column to the right of the selected column in the table.
CTRL+SHIFT+Q
Switches the display of marker icons for HTML elements that do not have a visual representation, such as comments, scripts, and anchors for absolutely positioned elements.
CTRL+PAGE DOWN
CTRL+PAGE UP
Switches from Design view to Source view and vice versa.
CTRL+Q
Displays a 1-pixel border around HTML elements that support a border attribute and have it set to zero, such as tables, table cells, and divisions.
CTRL+K, CTRL+X
Inserts a snippet.

thank you 
blnreddy




November 2, 2012

DATASET

in dotnet if you want do something related with database, we have to concentrate  on ADO.NET.we have two core component in ADO.NET one is data providers and data set in msdn we have good information checkit dataset
have a nice day