tag:blogger.com,1999:blog-12001921021275291662024-10-24T09:34:22.037-07:00Mayank Agarwalhttp://www.blogger.com/profile/00164092452683371475noreply@blogger.comBlogger63125tag:blogger.com,1999:blog-1200192102127529166.post-39307970313167517542012-02-02T20:55:00.000-08:002012-02-02T20:55:17.947-08:00Today I had to recover a password of a Microsoft Access database (mdb) file that I created and protected couple of years ago. As the file was created couple of years ago I had no clue on what password I used to protect mdf file as well as no hints on guessing the password too. The only option I had is to search for some applications that cracks the password of the Microsoft Access file.<br /> <br /> After googling the web for couple of minutes I found a brilliant free application that cracks Access files – <a href="http://www.nirsoft.net/utils/accesspv.html">Access PassView</a>. Using the application I recovered the password in a fraction of a second. The speed at which application cracked the password is really amazing. I was expecting that application is going to use brute force mechanism to crack the password and it will take some time. But the application is so brilliant; it does its job very quickly.<br /> <br /> The official web site of the application says it is capable to recovering passwords from MS Access 95/97/2000/XP<br /> <br /> This utility reveals the database password of every password-protected mdb file that created with Microsoft Access 95/97/2000/XP or with Jet Database Engine 3.0/4.0 . It can be very useful if you forgot your Access Database password and you want to recover it.<br /> <br /> Even though there is no official word about recovering passwords from MS Access 2003 files, it recovered the password from my MS Access 2003 file. I tried the application on Windows XP, Vista and Windows 7. Another highlight of the application – there is no need to install. It comes as a ZIP file that can be extracted and start using it. What else we can ask for!. Hats off to the developer of this application.<br /> <br /> To Goto the developer site please click the link<br /> <a href="http://www.nirsoft.net/utils/accesspv.html">Download Software</a>Mayank Agarwalhttp://www.blogger.com/profile/00164092452683371475noreply@blogger.com0tag:blogger.com,1999:blog-1200192102127529166.post-20995701107581006752011-06-21T11:49:00.001-07:002011-06-21T11:49:27.671-07:001<br /> Ctrl + Shift + A<br /> AllCaps<br /> Makes the selection all capitals (toggle)<br /> <br /> 2<br /> Alt + Ctrl + 1<br /> ApplyHeading1<br /> Applies Heading 1 style to the selected text<br /> <br /> 3<br /> Alt + Ctrl + 2<br /> ApplyHeading2<br /> Applies Heading 2 style to the selected text<br /> <br /> 4<br /> Alt + Ctrl + 3<br /> ApplyHeading3<br /> Applies Heading 3 style to the selected text<br /> <br /> 5<br /> Ctrl + Shift + L<br /> ApplyListBullet<br /> Applies List Bullet style to the selected text<br /> <br /> 6<br /> Alt + F10<br /> AppMaximize<br /> Enlarges the application window to full size<br /> <br /> 7<br /> Alt + F5<br /> AppRestore<br /> Restores the application window to normal size<br /> <br /> 8<br /> Ctrl+B<br /> Bold<br /> Makes the selection bold (toggle)<br /> <br /> 9<br /> Ctrl + PgDn<br /> BrowseNext<br /> Jump to the next browse object<br /> <br /> 10<br /> Ctrl + PgUp<br /> BrowsePrev<br /> Jump to the previous browse object<br /> <br /> 11<br /> Alt + Ctrl + Home<br /> BrowseSel<br /> Select the next/prev browse object<br /> <br /> 12<br /> Esc<br /> Cancel<br /> Terminates an action<br /> <br /> 13<br /> Ctrl+E<br /> CenterPara<br /> Centers the paragraph between the indents<br /> <br /> 14<br /> Shift+F3<br /> ChangeCase<br /> Changes the case of the letters in the selection<br /> <br /> 15<br /> Left arrow<br /> CharLeft<br /> Moves the insertion point to the left one character<br /> <br /> 16<br /> Shift + Left arrow<br /> CharLeftExtend<br /> Extends the selection to the left one character<br /> <br /> 17<br /> Rt arrow<br /> CharRight<br /> Moves the insertion point to the right one character<br /> <br /> 18<br /> Shift + Rt arrow<br /> CharRightExtend<br /> Extends the selection to the right one character<br /> <br /> 19<br /> Alt + Shift + C<br /> ClosePane<br /> Closes the active window pane (if you are in Normal View and have,<br /> for example, the Footnote pane open)<br /> <br /> 20<br /> Alt+Drag (or press Ctrl + Shift + F8 and drag, but Alt + Drag is<br /> far easier!)<br /> ColumnSelect<br /> Selects a columnar block of text<br /> <br /> 21<br /> Ctrl +Shift+C<br /> CopyFormat<br /> Copies the formatting of the selection<br /> <br /> 22<br /> Shift + F2<br /> CopyText<br /> Makes a copy of the selection without using the clipboard (press<br /> Return to paste)<br /> <br /> 23<br /> Alt + F3<br /> CreateAutoText<br /> Adds an AutoText entry to the active template<br /> <br /> 24<br /> Ctrl+ Backspace<br /> DeleteBackWord<br /> Deletes the previous word without putting it on the Clipboard<br /> <br /> 25<br /> Ctrl + Del<br /> DeleteWord<br /> Deletes the next word without putting it on the Clipboard<br /> <br /> 26<br /> Ctrl+W, Ctrl+F4<br /> DocClose<br /> Prompts to save the document and then closes the active window.<br /> (But doesn't intercept the menu command)<br /> <br /> 27<br /> Ctrl + F10<br /> DocMaximize<br /> Enlarges the active window to full size<br /> <br /> 28<br /> Ctrl + F7<br /> DocMove<br /> Changes the position of the active window<br /> <br /> 29<br /> Ctrl + F5<br /> DocRestore<br /> Restores the window to normal size<br /> <br /> 30<br /> Ctrl + F8<br /> DocSize<br /> Changes the size of the active window<br /> <br /> 31<br /> Alt + Ctrl + S<br /> DocSplit<br /> Splits the active window horizontally and then adjusts the split<br /> <br /> 32<br /> Alt + Shift + F9<br /> DoFieldClick<br /> Executes the action associated with macrobutton fields<br /> <br /> 33<br /> Ctrl + Shift + D<br /> DoubleUnderline<br /> Double underlines the selection (toggle)<br /> <br /> 34<br /> Alt R, G<br /> DrawGroup<br /> Groups the selected drawing objects<br /> <br /> 35<br /> Alt R, I<br /> DrawSnapToGrid<br /> Sets up a grid for aligning drawing objects<br /> <br /> 36<br /> Alt R, U<br /> DrawUngroup<br /> Ungroups the selected group of drawing objects<br /> <br /> 37<br /> Ctrl+Shift+F5 (Or: Alt I, K)<br /> EditBookmark<br /> Brings up the bookmark dialog<br /> <br /> 38<br /> Del<br /> EditClear<br /> Performs a forward delete or removes the selection without putting<br /> it on the Clipboard<br /> <br /> 39<br /> Ctrl+C<br /> EditCopy<br /> Copies the selection and puts it on the Clipboard<br /> <br /> 40<br /> Ctrl+X<br /> EditCut<br /> Cuts the selection and puts it on the Clipboard<br /> <br /> 41<br /> Ctrl+F<br /> EditFind<br /> Finds the specified text or the specified formatting<br /> <br /> 42<br /> F5, Ctrl+G<br /> EditGoTo<br /> Jumps to a specified place in the active document<br /> <br /> 43<br /> Alt E, K<br /> EditLinks<br /> Allows links to be viewed, updated, opened, or removed<br /> <br /> 44<br /> Ctrl+V<br /> EditPaste<br /> Inserts the Clipboard contents at the insertion point<br /> <br /> 45<br /> Alt E, S<br /> EditPasteSpecial<br /> Inserts the Clipboard contents as a linked object, embedded object,<br /> or other format<br /> <br /> 46<br /> Alt + Shift + Backspc<br /> EditRedo<br /> Redoes the last action that was undone<br /> <br /> 47<br /> F4<br /> EditRedoOrRepeat<br /> Repeats the last command, or redoes the last action that was undone<br /> (unfortunately, doesn't work for as many commands in Word 2000 as in Word 97 and<br /> below, but this is still one of Word's most useful shortcuts, if not the most<br /> useful)<br /> <br /> 48<br /> Ctrl+H<br /> EditReplace<br /> Finds the specified text or the specified formatting and replaces<br /> it<br /> <br /> 49<br /> Ctrl+A<br /> EditSelectAll<br /> Selects the entire document<br /> <br /> 50<br /> Ctrl+Z<br /> EditUndo<br /> Reverses the last action<br /> <br /> 51<br /> Alt + PageDn (to select to end of column, use Alt + Shift + PgDn)<br /> EndOfColumn<br /> Moves to the last cell in the current table column<br /> <br /> 52<br /> Ctrl+Shift+End<br /> EndOfDocExtend<br /> Extends the selection to the end of the last line of the document<br /> <br /> 53<br /> Ctrl+End<br /> EndOfDocument<br /> Moves the insertion point to the end of the last line of the<br /> document<br /> <br /> 54<br /> End<br /> EndOfLine<br /> Moves the insertion point to the end of the current line<br /> <br /> 55<br /> Shift+End<br /> EndOfLineExtend<br /> Extends the selection to the end of the current line<br /> <br /> 56<br /> Alt+End<br /> EndOfRow<br /> Moves to the last cell in the current row<br /> <br /> 57<br /> Alt + Ctrl + PgDn<br /> EndOfWindow<br /> Moves the insertion point to the end of the last visible line on<br /> the screen<br /> <br /> 58<br /> Shift + Alt + Ctrl + PgDn<br /> EndOfWindowExtend<br /> Extends the selection to the end of the last visible line on the<br /> screen<br /> <br /> 59<br /> F8 (press Esc to turn off)<br /> ExtendSelection<br /> Turns on extend selection mode and then expands the selection with<br /> the direction keys<br /> <br /> 60<br /> Alt + F4 (<9>)<br /> FileCloseOrExit<br /> Closes the current document, or if no documents are open, quits<br /> Word. Horrible command, as it makes it a long winded business to quit Word. But<br /> there's a simple solution - assign Alt+F4 to FileExit instead.<br /> <br /> 61<br /> Alt + F4 (Word 97)<br /> FileExit<br /> Quits Microsoft Word and prompts to save the documents (does<br /> intercept the menu item, but not the keyboard shortcut, or the x button. An<br /> AutoExit macro is usually a better way of intercepting this).<br /> <br /> 62<br /> NOT Ctrl+N!!<br /> FileNew<br /> Creates a new document or template (brings up the dialog). Note<br /> that: Word pretends that Ctrl+N is assigned to FileNew but it isn't, it's<br /> assigned to FileNewDefault You can fix this in Word 2000 by assigning Ctrl+N to<br /> the FileNewDialog command. In Word 97 the only way to fix it is to create a<br /> macro called FileNew (to do this, press Alt + F8, type "FileNew" without the<br /> quotes and Click "Create". The macro will automatically contain the code needed<br /> to make it work).<br /> <br /> 63<br /> Ctrl+N<br /> FileNewDefault<br /> Creates a new document based on the Normal template.<br /> <br /> 64<br /> Ctrl+O<br /> FileOpen<br /> Opens an existing document or template<br /> <br /> 65<br /> Alt F, U<br /> FilePageSetup<br /> Changes the page setup of the selected sections<br /> <br /> 66<br /> Ctrl + P<br /> FilePrint<br /> Prints the active document (brings up the dialog)<br /> <br /> 67<br /> Ctrl+F2<br /> FilePrintPreview<br /> Displays full pages as they will be printed<br /> <br /> 68<br /> Alt F, I<br /> FileProperties<br /> Shows the properties of the active document<br /> <br /> 69<br /> Ctrl+S<br /> FileSave<br /> FileSave<br /> <br /> 70<br /> Alt F, A (or F12)<br /> FileSaveAs<br /> Saves a copy of the document in a separate file (brings up the<br /> dialog)<br /> <br /> 71<br /> Ctrl+Shift+F<br /> Font<br /> Activates the Fonts listbox on the formatting toolbar<br /> <br /> 72<br /> Ctrl+Shift+P<br /> FontSizeSelect<br /> Activates the Font Size drop-down on the formatting toolbar<br /> <br /> 73<br /> Alt + Ctrl + K<br /> FormatAutoFormat<br /> Automatically formats a document (or sometimes, automatically<br /> screws it up)<br /> <br /> 74<br /> Alt O, B<br /> FormatBordersAndShading<br /> Changes the borders and shading of the selected paragraphs, table<br /> cells, and pictures<br /> <br /> 75<br /> Alt O, E<br /> FormatChangeCase<br /> Changes the case of the letters in the selection<br /> <br /> 76<br /> Alt O, C<br /> FormatColumns<br /> Changes the column format of the selected sections (brings up the<br /> dialog)<br /> <br /> 77<br /> Alt O, D<br /> FormatDropCap<br /> Formats the first character of current paragraph as a dropped<br /> capital (must select it first)<br /> <br /> 78<br /> Ctrl+D<br /> FormatFont<br /> Brings up the Format + Font dialog<br /> <br /> 79<br /> Alt + Shift + R<br /> FormatHeaderFooterLink<br /> Links the current header/footer to the previous section (but does<br /> not intercept the button on the Header Footer toolbar)<br /> <br /> 80<br /> Alt O, P<br /> FormatParagraph<br /> Brings up the Format Paragraph dialog<br /> <br /> 81<br /> Alt O, S<br /> FormatStyle<br /> Applies, creates, or modifies styles<br /> <br /> 82<br /> Alt O, T<br /> FormatTabs<br /> Brings up the Format Tabs dialog<br /> <br /> 83<br /> Shift + F5<br /> GoBack<br /> Returns to the previous insertion point (goes back to up to 3<br /> points, then returns to where you started; this is one of the most useful<br /> shortcuts of them all. Also useful when opening a document, if you want to g<br /> straight to where you were last editing it)<br /> <br /> 84<br /> Ctrl + ><br /> GrowFont<br /> Increases the font size of the selection<br /> <br /> 85<br /> Ctrl + ]<br /> GrowFontOnePoint<br /> Increases the font size of the selection by one point<br /> <br /> 86<br /> Ctrl + T (or drag the ruler)<br /> HangingIndent<br /> Increases the hanging indent<br /> <br /> 87<br /> F1<br /> Help<br /> Microsoft Word Help<br /> <br /> 88<br /> Shift + F1<br /> HelpTool<br /> Lets you get help on a command or screen region or examine text<br /> properties<br /> <br /> 89<br /> Ctrl + Shift + H<br /> Hidden<br /> Makes the selection hidden text (toggle)<br /> <br /> 90<br /> Click on it<br /> HyperlinkOpen<br /> Connect to a hyperlink's address<br /> <br /> 91<br /> Ctrl + M (or drag the ruler)<br /> Indent<br /> Moves the left indent to the next tab stop<br /> <br /> 92<br /> Alt + Ctrl + M (or Alt I, M)<br /> InsertAnnotation<br /> Inserts a comment<br /> <br /> 93<br /> F3<br /> InsertAutoText<br /> Replaces the name of the AutoText entry with its contents<br /> <br /> 94<br /> Alt I, B<br /> InsertBreak<br /> Ends a page, column, or section at the insertion point<br /> <br /> 95<br /> Alt I, C<br /> InsertCaption<br /> Inserts a caption above or below a selected object<br /> <br /> 96<br /> Ctrl + Shift + Return<br /> InsertColumnBreak<br /> Inserts a column break at the insertion point<br /> <br /> 97<br /> Alt + Shift + D<br /> InsertDateField<br /> Inserts a date field<br /> <br /> 98<br /> Alt + Ctrl + D<br /> InsertEndnoteNow<br /> Inserts an endnote reference at the insertion point without<br /> displaying the dialog<br /> <br /> 99<br /> Alt I, F<br /> InsertField<br /> Inserts a field in the active document<br /> <br /> 100<br /> Ctrl+F9<br /> InsertFieldChars<br /> Inserts an empty field with the enclosing field characters<br /> <br /> 101<br /> Alt I, L<br /> InsertFile<br /> Inserts the text of another file into the active document<br /> <br /> 102<br /> Alt I, N<br /> InsertFootnote<br /> Inserts a footnote or endnote reference at the insertion point<br /> <br /> 103<br /> Alt + Ctrl + F<br /> InsertFootnoteNow<br /> Inserts a footnote reference at the insertion point without<br /> displaying the dialog<br /> <br /> 104<br /> Ctrl + K<br /> InsertHyperlink<br /> Insert Hyperlink<br /> <br /> 105<br /> Alt I, D<br /> InsertIndexAndTables<br /> Inserts an index or a table of contents, figures, or authorities<br /> into the document<br /> <br /> 106<br /> Alt + Ctrl + L<br /> InsertListNumField<br /> Inserts a ListNum Field<br /> <br /> 107<br /> Alt + Shift + F<br /> InsertMergeField<br /> Brings up a dialog to insert a mail merge field at the insertion<br /> point. (It does not intercept the button on the Mail merge. toolbar)<br /> <br /> 108<br /> Ctrl + Return<br /> InsertPageBreak<br /> Inserts a page break at the insertion point<br /> <br /> 109<br /> Alt + Shift + P<br /> InsertPageField<br /> Inserts a page number field<br /> <br /> 110<br /> Ctrl + Shift + F3<br /> InsertSpike<br /> Empties the spike AutoText entry and inserts all of its contents<br /> into the document<br /> <br /> 111<br /> Alt + Shift + T<br /> InsertTimeField<br /> Inserts a time field<br /> <br /> 112<br /> Ctrl + I<br /> Italic<br /> Makes the selection italic (toggle)<br /> <br /> 113<br /> Ctrl + J<br /> JustifyPara<br /> Aligns the paragraph at both the left and the right indent<br /> <br /> 114<br /> Ctrl + L<br /> LeftPara<br /> Aligns the paragraph at the left indent<br /> <br /> 115<br /> Down arrow<br /> LineDown<br /> Moves the insertion point down one line<br /> <br /> 116<br /> Shift + down arrow<br /> LineDownExtend<br /> Extends the selection down one line<br /> <br /> 117<br /> Up arrow<br /> LineUp<br /> Moves the insertion point up one line<br /> <br /> 118<br /> Shift + up arrow<br /> LineUpExtend<br /> Extends the selection up one line<br /> <br /> 119<br /> Ctrl + F11<br /> LockFields<br /> Locks the selected fields to prevent updating<br /> <br /> 120<br /> Alt + Shift + K<br /> MailMergeCheck<br /> Checks for errors in a mail merge<br /> <br /> 121<br /> Alt+Shift+E<br /> MailMergeEditDataSource<br /> Lets you edit a mail merge data source<br /> <br /> 122<br /> Alt + Shift + N<br /> MailMergeToDoc<br /> Collects the results of the mail merge in a document<br /> <br /> 123<br /> Alt Shift + M<br /> MailMergeToPrinter<br /> Sends the results of the mail merge to the printer<br /> <br /> 124<br /> Alt + Shift + I<br /> MarkCitation<br /> Marks the text you want to include in the table of authorities<br /> <br /> 125<br /> Alt + Shift + X<br /> MarkIndexEntry<br /> Marks the text you want to include in the index<br /> <br /> 126<br /> Alt + Shift + O<br /> MarkTableOfContentsEntry<br /> Inserts a TC field (but it is far better to use Heading Styles to<br /> generate your Table of Contents instead)<br /> <br /> 127<br /> Alt or F10<br /> MenuMode<br /> Makes the menu bar active<br /> <br /> 128<br /> Alt + Shift + F11<br /> MicrosoftScriptEditor<br /> Starts or switches to Microsoft Development Environment<br /> application, allowing you to view the HTML/XML source code that would be behind<br /> the document if it were in .htm format (or that is behind it if it already is in<br /> .htm format).<br /> <br /> 129<br /> Alt + Ctrl + F1<br /> MicrosoftSystemInfo<br /> Execute the Microsoft System Info application<br /> <br /> 130<br /> F2<br /> MoveText<br /> Moves the selection to a specified location without using the<br /> clipboard (press Return to execute the more)<br /> <br /> 131<br /> Tab<br /> NextCell<br /> Moves to the next table cell<br /> <br /> 132<br /> F11<br /> NextField<br /> Moves to the next field<br /> <br /> 133<br /> Alt + F7<br /> NextMisspelling<br /> Find next spelling error<br /> <br /> 134<br /> Alt + down arrow<br /> NextObject<br /> Moves to the next object on the page<br /> <br /> 135<br /> Ctrl + F6<br /> NextWindow<br /> Switches to the next document window, equivalent to selecting a<br /> document from the Window menu.<br /> <br /> 136<br /> Ctrl+Shift+N<br /> NormalStyle<br /> Applies the Normal style<br /> <br /> 137<br /> Ctrl + 0<br /> OpenOrCloseUpPara<br /> Sets or removes extra spacing above the selected paragraph<br /> <br /> 138<br /> F6<br /> OtherPane<br /> Switches to another window pane in Normal View (for instance, if<br /> you have if you have a Footnotes pane open in Normal view and want to switch to<br /> the main document and back without closing the pane).<br /> <br /> 139<br /> Alt + _<br /> OutlineCollapse<br /> Collapses an Outline in Outline View by one level<br /> <br /> 140<br /> Alt+Shift+rt arrow<br /> OutlineDemote<br /> Demotes the selected paragraphs one heading level<br /> <br /> 141<br /> Alt + +<br /> OutlineExpand<br /> Expands an Outline in Outline View by one level<br /> <br /> 142<br /> Alt+Shift+down arrow<br /> OutlineMoveDown<br /> Moves the selection below the next item in the outline<br /> <br /> 143<br /> Alt+Shift+up arrow<br /> OutlineMoveUp<br /> Moves the selection above the previous item in the outline<br /> <br /> 144<br /> Alt+Shift+left arrow<br /> OutlinePromote<br /> Promotes the selected paragraphs one heading level<br /> <br /> 145<br /> Alt + Shift + L<br /> OutlineShowFirstLine<br /> Toggles between showing the first line of each paragraph only or<br /> showing all of the body text in the outline<br /> <br /> 146<br /> Ins<br /> Overtype<br /> Toggles the typing mode between replacing and inserting<br /> <br /> 147<br /> PgDn<br /> PageDown<br /> Moves the insertion point and document display to the next screen<br /> of text<br /> <br /> 148<br /> Shift+ PgDn<br /> PageDownExtend<br /> Extends the selection and changes the document display to the next<br /> screen of text<br /> <br /> 149<br /> PgUp<br /> PageUp<br /> Moves the insertion point and document display to the previous<br /> screen of text<br /> <br /> 150<br /> Shift + PgUp<br /> PageUpExtend<br /> Extends the selection and changes the document display to the<br /> previous screen of text<br /> <br /> 151<br /> Ctrl + down arrow<br /> ParaDown<br /> Moves the insertion point to the beginning of the next paragraph<br /> <br /> 152<br /> Shift + Ctrl + down arrow<br /> ParaDownExtend<br /> Extends the selection to the beginning of the next paragraph<br /> <br /> 153<br /> Ctrl + up arrow<br /> ParaUp<br /> Moves the insertion point to the beginning of the previous<br /> paragraph<br /> <br /> 154<br /> Shift + Ctrl + up arrow<br /> ParaUpExtend<br /> Extends the selection to the beginning of the previous paragraph<br /> <br /> 155<br /> Ctrl+Shift+V<br /> PasteFormat<br /> Applies the previously copied formatting to selection<br /> <br /> 156<br /> Shift + Tab<br /> PrevCell<br /> Moves to the previous table cell<br /> <br /> 157<br /> Shift + F11<br /> PrevField<br /> Moves to the previous field<br /> <br /> 158<br /> Alt + up arrow<br /> PrevObject<br /> Moves to the previous object on the page<br /> <br /> 159<br /> Ctrl + Shift + F6<br /> PrevWindow<br /> Switches back to the previous document window<br /> <br /> 160<br /> Sfift+F4<br /> RepeatFind<br /> Repeats Go To or Find to find the next occurrence<br /> <br /> 161<br /> Ctrl+Spacebar<br /> ResetChar<br /> Makes the selection the default character format of the applied<br /> style<br /> <br /> 162<br /> Ctrl+Q<br /> ResetPara<br /> Makes the selection the default paragraph format of the applied<br /> style<br /> <br /> 163<br /> Ctrl +R<br /> RightPara<br /> Aligns the paragraph at the right indent<br /> <br /> 164<br /> Ctrl + *<br /> ShowAll<br /> Shows/hides all nonprinting characters<br /> <br /> 165<br /> Alt + Shift + A<br /> ShowAllHeadings<br /> Displays all of the heading levels and the body text in Outline<br /> View<br /> <br /> 166<br /> Ctrl + <<br /> ShrinkFont<br /> Decreases the font size of the selection<br /> <br /> 167<br /> Ctrl + [<br /> ShrinkFontOnePoint<br /> Decreases the font size of the selection by one point<br /> <br /> 168<br /> Ctrl + Shift + K<br /> SmallCaps<br /> Makes the selection small capitals (toggle)<br /> <br /> 169<br /> Ctrl + 1<br /> SpacePara1<br /> Sets the line spacing to single space<br /> <br /> 170<br /> Ctrl + 5<br /> SpacePara15<br /> Sets the line spacing to one-and-one-half space<br /> <br /> 171<br /> Ctrl + 2<br /> SpacePara2<br /> Sets the line spacing to double space<br /> <br /> 172<br /> Ctrl + F3<br /> Spike<br /> Deletes the selection and adds it to the "Spike" AutoText entry<br /> (which allows you to move text and graphics from nonadjacent locations)<br /> <br /> 173<br /> Alt + PgUp<br /> StartOfColumn<br /> Moves to the first cell in the current column<br /> <br /> 174<br /> Ctrl+Shift+Home<br /> StartOfDocExtend<br /> Extends the selection to the beginning of the first line of the<br /> document<br /> <br /> 175<br /> Ctrl +Home<br /> StartOfDocument<br /> Moves the insertion point to the beginning of the first line of the<br /> document<br /> <br /> 176<br /> Home<br /> StartOfLine<br /> Moves the insertion point to the beginning of the current line<br /> <br /> 177<br /> Shift+Home<br /> StartOfLineExtend<br /> Extends the selection to the beginning of the current line<br /> <br /> 178<br /> Alt+Home<br /> StartOfRow<br /> Moves to the first cell in the current row<br /> <br /> 179<br /> Alt+Ctrl+PgUp<br /> StartOfWindow<br /> Moves the insertion point to the beginning of the first visible<br /> line on the screen<br /> <br /> 180<br /> Shift+ Alt+Ctrl+PgUp<br /> StartOfWindowExtend<br /> Extends the selection to the beginning of the first visible line on<br /> the screen<br /> <br /> 181<br /> Strl + Shift + S<br /> Style<br /> Activates the Style drop-down on the Formatting toolbar<br /> <br /> 182<br /> Ctrl + =<br /> Subscript<br /> Makes the selection subscript (toggle)<br /> <br /> 183<br /> Ctrl + +<br /> Superscript<br /> Makes the selection superscript (toggle)<br /> <br /> 184<br /> Ctrl + Shift + Q<br /> SymbolFont<br /> Applies the Symbol font to the selection<br /> <br /> 185<br /> Alt A, F<br /> TableAutoFormat<br /> Applies a set of formatting to a table<br /> <br /> 186<br /> Alt A, H<br /> TableHeadings<br /> Toggles table headings attribute on and off<br /> <br /> 187<br /> Alt + click<br /> (Alt + drag to select several)<br /> TableSelectColumn<br /> Selects the current column in a table<br /> <br /> 188<br /> Click in left margin<br /> TableSelectRow<br /> Selects the current row in a table<br /> <br /> 189<br /> Alt + double-click<br /> TableSelectTable<br /> Selects an entire table<br /> <br /> 190<br /> Alt + Ctrl + U<br /> TableUpdateAutoFormat<br /> Updates the table formatting to match the applied Table Autoformat<br /> settings<br /> <br /> 191<br /> Shift + F9 (Alt + F9 toggles all field codes on or off)<br /> ToggleFieldDisplay<br /> Shows the field codes or the results for the selection (toggle)<br /> <br /> 192<br /> Alt T, C<br /> ToolsCustomize<br /> Allows you to customizes the Word user interface (menus, keyboard<br /> and toolbars) and store the customizations in a template (defaults to<br /> Normal.dot, so be careful!)<br /> <br /> 193<br /> Alt + F8<br /> ToolsMacro<br /> Runs, creates, deletes, or revises a macro<br /> <br /> 194<br /> F7<br /> ToolsProofing<br /> Checks the spelling and grammar in the active document<br /> <br /> 195<br /> Ctr.l + Shift + E<br /> ToolsRevisionMarksToggle<br /> Toggles track changes for the active document<br /> <br /> 196<br /> Shift + F7<br /> ToolsThesaurus<br /> Finds a synonym for the selected word<br /> <br /> 197<br /> Ctrl+U<br /> Underline<br /> Formats the selection with a continuous underline (toggle)<br /> <br /> 198<br /> Ctrl + Shift + T<br /> (or drag the ruler)<br /> UnHang<br /> Decreases the hanging indent<br /> <br /> 199<br /> Ctrl + Shift + M<br /> (or drag the ruler)<br /> UnIndent<br /> Moves the left indent to the previous tab stop<br /> <br /> 200<br /> Ctrl+Shift+F9<br /> UnlinkFields<br /> Permanently replaces the field codes with the results<br /> <br /> 201<br /> Ctrl + Shift + F11<br /> UnlockFields<br /> Unlocks the selected fields for updating<br /> <br /> 202<br /> F9<br /> UpdateFields<br /> Updates and displays the results of the selected fields<br /> <br /> 203<br /> Ctrl + Shiift + F7<br /> UpdateSource<br /> Copies the modified text of a linked file back to its source file<br /> <br /> 204<br /> Hover over comment<br /> ViewAnnotations<br /> Show or hide the comment pane<br /> <br /> 205<br /> Dbl-click the endnote reference<br /> ViewEndnoteArea<br /> If in Normal View, opens a pane for viewing and editing the endnote<br /> (toggle). If in Page/Print Layout View, switches from the body text to the<br /> endnote or vice versa<br /> <br /> 206<br /> At + F9<br /> ViewFieldCodes<br /> Shows the field codes or results for all fields (toggle)<br /> <br /> 207<br /> Dbl-click the footnote reference<br /> ViewFootnoteArea<br /> If in Normal View, opens a pane for viewing and editing the<br /> footnote (toggle). If in Page/Print Layout View, switches from the body text to<br /> the footnote or vice versa.<br /> <br /> 208<br /> Alt V, F<br /> ViewFootnotes<br /> If in Normal View, opens a pane for viewing and editing footnotes<br /> and endnotes (toggle). If in Page/Print Layout View, switches from the body text<br /> to the footnotes/endnotes or vice versa.<br /> <br /> 209<br /> Alt V, H<br /> ViewHeader<br /> Displays header in page layout view<br /> <br /> 210<br /> Alt V, N<br /> (or Alt + Ctrl + N)<br /> ViewNormal<br /> Changes the editing view to normal view<br /> <br /> 211<br /> Alt V, O<br /> (or Alt + Ctrl + O)<br /> ViewOutline<br /> Displays a document's outline<br /> <br /> 212<br /> Alt V, P<br /> (or Alt + Ctrl + P)<br /> ViewPage<br /> Displays the page more-or-less as it will be printed, and allows<br /> editing (In Word 2000 the menu item is called Print Layout, but fortunately the<br /> command hasn't changed.<br /> <br /> 213<br /> Alt + F11<br /> ViewVBCode<br /> Shows the VB editing environment (Tools + Macro + Visual Basic<br /> Editor)<br /> <br /> 214<br /> Alt + left arrow<br /> WebGoBack<br /> Backward hyperlink (useful if you clicked on a page number<br /> hyperlink in the table of contents and then want to return to the TOC)<br /> <br /> 215<br /> Alt + rt arrow<br /> WebGoForward<br /> Forward hyperlink<br /> <br /> 216<br /> Alt W, A<br /> WindowArrangeAll<br /> Arranges windows as non-overlapping tiles<br /> <br /> 217<br /> Ctrl + left arrow<br /> WordLeft<br /> Moves the insertion point to the left one word<br /> <br /> 218<br /> Shift + Ctrl + left arrow<br /> WordLeftExtend<br /> Extends the selection to the left one word<br /> <br /> 219<br /> Ctrl + rt arrow<br /> WordRight<br /> Moves the insertion point to the right one word<br /> <br /> 220<br /> Shift + Ctrl + rt arrow<br /> WordRightExtend<br /> Extends the selection to the right one word<br /> <br /> 221<br /> Ctrl + Shift + W<br /> WordUnderline<br /> Underlines the words but not the spaces in the selection (toggle)Mayank Agarwalhttp://www.blogger.com/profile/00164092452683371475noreply@blogger.com0tag:blogger.com,1999:blog-1200192102127529166.post-33364223268698919072011-06-21T11:39:00.001-07:002011-06-21T11:39:23.713-07:00In .aspx File declare OnRowCreated eventas follow.<br /> <asp:GridView ID="GridView1" runat="server" OnRowCreated="OnRowCreated"><br /> <br /> Following code will:<br /> Highlight Gridview which is not using alternate row color.<br /> protectedvoid OnRowCreated(object sender, GridViewRowEventArgs e)<br /> {<br /> if (e.Row.RowType == DataControlRowType.DataRow)<br /> {<br /> //On Mouse Over Highlight Row<br /> e.Row.Attributes.Add("onmouseover", "this.style.backgroundColor='#ffff00'");<br /> <br /> //On Mouse out restore default row color<br /> e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor='#FFFFFF'");<br /> }<br /> }Mayank Agarwalhttp://www.blogger.com/profile/00164092452683371475noreply@blogger.com0tag:blogger.com,1999:blog-1200192102127529166.post-82292114659869297522011-06-21T11:36:00.001-07:002011-06-21T11:37:12.550-07:00In .aspx File declare OnRowCreated eventas follow.<br /> <asp:GridView ID="GridView1" runat="server" OnRowCreated="OnRowCreated"><br /> <br /> Following code will explain: <br /> How to Highlight Gridview which uses alternate row color.<br /> <br /> protectedvoid OnRowCreated(object sender, GridViewRowEventArgs e)<br /> {<br /> if (e.Row.RowType == DataControlRowType.DataRow)<br /> {<br /> //On Mouse over highlight gridview<br /> e.Row.Attributes.Add("onmouseover", "this.style.backgroundColor='#ffff00'");<br /> <br /> //On Mouse out restore girdview row color based on alternate row color//Please change this color with your gridview alternate color.<br /> <br /> if (e.Row.RowIndex % 2 == 0)<br /> {<br /> e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor='#F7F7DE'");<br /> }<br /> else<br /> {<br /> e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor='#FFFFFF'");<br /> }<br /> }<br /> }Mayank Agarwalhttp://www.blogger.com/profile/00164092452683371475noreply@blogger.com0tag:blogger.com,1999:blog-1200192102127529166.post-83203461275076610282011-06-21T08:28:00.000-07:002011-06-21T08:38:55.272-07:00Ever wanted to add a Google Map to your site but only had 15 minutes to spare? Now you can add a map and still have time to brag to your mates and bask in the worship that (inevitably) comes afterward.<br /> <br /> Basically, the guys over at subgurim.net have already done all the hard work in writing the .Net wrapper for Google Maps. Problem is, the examples on their site are mostly in spanish & its a bit difficult to find out exactly what is needed to get everything working.<br /> <br /> But all this is cutting into your bragging time - so lets get started!<br /> <br /> 1. Get a Google Maps API key from here:<br /> http://www.google.com/apis/maps/<br /> <br /> 2. Download the SubGurim wrapper dll from here:<br /> http://en.googlemaps.subgurim.net/descargar.aspx<br /> <br /> 3. Unzip it, and put it in your \bin directory<br /> <br /> 4. Add it to your toolbox by<br /> Tools -> Choose Toolbox Items -> Browse -> Select the .dll file -> OK<br /> GMap will now be in the ‘Standard’ area of your Toolbox.<br /> <br /> 5. Add a new webpage.<br /> <br /> 6. Drag the GMap from the toolbox onto the page. A new instance of the GMap will appear on the page, with the name ‘GMap1′<br /> <br /> 7. Add the following lines to your web.config file:<br /> <br /> appsettings><br /> add key="googlemaps.subgurim.net" value="YourGoogleMapsAPIKeyHere" /><br /> /appSettings><br /> <br /> 8. Add the following code to your Page.Load sub<br /> <br /> Dim sStreetAddress As String<br /> Dim sMapKey As String = ConfigurationManager.AppSettings("googlemaps.subgurim.net")<br /> Dim GeoCode As Subgurim.Controles.GeoCode<br /> <br /> sStreetAddress = "100 Russell St. Melbourne. VIC. 3000. Australia"<br /> GeoCode = GMap1.geoCodeRequest(sStreetAddress, sMapKey)<br /> Dim gLatLng As New Subgurim.Controles.GLatLng(GeoCode.Placemark.coordinates.lat, GeoCode.Placemark.coordinates.lng)<br /> <br /> GMap1.setCenter(gLatLng, 16, Subgurim.Controles.GMapType.GTypes.Normal)<br /> Dim oMarker As New Subgurim.Controles.GMarker(gLatLng)<br /> GMap1.addGMarker(oMarker)<br /> <br /> Source:http://gathadams.com/Mayank Agarwalhttp://www.blogger.com/profile/00164092452683371475noreply@blogger.com0tag:blogger.com,1999:blog-1200192102127529166.post-72540053101240513432011-06-21T04:14:00.000-07:002011-06-21T04:14:13.905-07:00Opening a connection is a database-intensive task. It can be one of the slowest operations that you perform in an ASP.NET page. Furthermore, a database has a limited supply of connections, and each connection requires a certain amount of memory overhead (approximately 40 kilobytes per connection).<br /> <br /> If you plan to have hundreds of users hitting your Web site simultaneously, the process of opening a database connection for each user can have a severe impact on the performance of your Web site.<br /> <br /> Fortunately, you can safely ignore these bad warnings if you take advantage of connection pooling. When database connections are pooled, a set of connections is kept open so that they can be shared among multiple users. When you request a new connection, an active connection is removed from the pool. When you close the connection, the connection is placed back in the pool.<br /> <br /> Connection pooling is enabled for both OleDb and SqlClient connections by default.<br /> <br /> To take advantage of connection pooling, you must be careful to do two things in your ASP.NET pages.<br /> <br /> First, you must be careful to use the same exact connection string whenever you open a database connection. Only those connections opened with the same connection string can be placed in the same connection pool. For this reason you should place your connection string in the web.config file and retrieve it from this file whenever you need to open a connection<br /> <br /> Second, you must also be careful to explicitly close whatever connection you open as quickly as possible. If you do not explicitly close a connection with the Close() method, the connection is never added back to the connection pool.<br /> <br /> Source: www.dotnetguts.blogspot.comMayank Agarwalhttp://www.blogger.com/profile/00164092452683371475noreply@blogger.com0tag:blogger.com,1999:blog-1200192102127529166.post-1743840582671231682011-06-21T04:05:00.000-07:002011-06-21T04:05:12.940-07:00ASP stands for Active Server Pages. ASP.NET is the next generation of ASP. After the introduction of ASP.NET, old ASP is called 'Classic ASP'.<br /> <br /> Classic ASP uses vb script for server side coding. Vb Script is not supported any more in ASP.NET. Instead, ASP.NET supports more languages including C#, VB.NET, J# etc. VB.NET is very similar to vb script, so it should be easy for old Visual Basic or ASP programmers to switch to VB.NET and ASP.NET<br /> <br /> VB Script is a simple scripting language, where as VB.NET or C# are modern, very powerfull, object oriented programming languages. Just for that reason, you will be able to write much more robust and reliable programs in ASP.NET compared to ASP.<br /> <br /> In classic ASP, there was no server controls. You have to write all html tags manually. ASP.NET offers a very rich set of controls called Server Controls and Html Controls. It is very easy to drag and drop any controls to a web form. The VS.NET will automatically write the required HTML tags automatically for you.<br /> <br /> ASP is interpreted, ASP.NET is compiled<br /> <br /> <br /> Since ASP uses vb script, there is no compilation. All ASP pages are interpreted when th page is executed.<br /> <br /> ASP.NET uses modern .NET languages like C#, VB.NET etc. They can be compiled to efficient Microsoft Intermediate Language (MSIL). When you compile an ASP.NET application, the server side code is compiled to assemblies. These assemblies are loaded at run time which makes the ASP.NET pages perform better than classic ASP.<br /> <br /> ADO and ADO.NET<br /> <br /> <br /> Classic ASP uses a technology called ADO to connect and work with databases. ASP.NET uses the ADO.NET technology (which is the next generation of ADO).<br /> <br /> Event driven programming<br /> <br /> <br /> If you have written Visual Basic programs before, you would love the event driven programming approach. It is so easy to drag and drop a button control and double click on the button to write the event handler for the button click event. When you click on the button at turn time, it will execute whatever code you have written in the event handler.<br /> <br /> This type of event driven programming was not available with classic ASP. You cannot drag and drop a button and write a 'on click' event handler with ASP.<br /> <br /> With ASP.NET, this is changed. It works pretty much like your Visual Basic program. You can write event handlers for several events like button click event, text changed event etc.<br /> <br /> However, there is big difference between the way event handling works in regular Visual basic and ASP.NET. In ASP.NET, a page is loaded in the client browser. And the server may be in another location (may be in another country). When you click on the button in an ASP.NET page, the 'click event' handler has to be executed on the server, not on the client.<br /> <br /> How does the server know when you click on a button your browser? This is a tricky thing in ASP.NET. When you write an event handler for a button lick or something like that in ASP.NET, lot of things happens behind the screens. ASP.NET will produce lot of client side javascript code to handle this and embed this javascript in the html page it sends to the browser. When you click on the button in the browser, the client side javascript will get executed. This javascript will generate some information required for the server and and submit the page request to the server. There is enough information embedded in this request so that the server will understand that user has clicked a specific button in the browser and it has to execute some 'specific event handler' code in the server side. So, when the user clicks on a button, the page is submitted automatically to the server with some special information. In the server side, it will process the event handler for the button click event and send back the output page to the browser again. Similary, you can write other event handlers like text changed event for Textboxes etc.<br /> <br /> As a user of the web page, you will not even know what happened in the background. All you can see is, when you clicked the button, it executed the button click event handler in the server side and you got the result. However, you may notice a delay because the page has to be submitted to the server to execute the event handler.<br /> <br /> NOTE: The event handling we just discussed is server side event handling. In addition to that, you can handle any events in the client side using Javascript. This is supported even in classic ASP. The client side event handling is used for simpel client side validation, displaying messages to the user etc. You cannot do any server side programming in client side java script (like accessing the database etc).<br /> <br /> Source: www.dotnetspider.comMayank Agarwalhttp://www.blogger.com/profile/00164092452683371475noreply@blogger.com0tag:blogger.com,1999:blog-1200192102127529166.post-43314741691095063312011-06-21T03:52:00.001-07:002011-06-21T03:52:40.752-07:00The basic difference between Close() and Dispose() is, when a Close() method is called, any managed resource can be temporarily closed and can be opened once again. It means that, with the same object the resource can be reopened or used. Where as Dispose() method permanently removes any resource ((un)managed) from memory for cleanup and the resource no longer exists for any further processing.<br /> <br /> Example showing difference between Close() and Dispose() Method:<br /> <br /> <br /> using System;<br /> using System.Data;<br /> using System.Data.SqlClient;<br /> public class Test<br /> {<br /> private string connString = "Data Source=COMP3;Initial Catalog=Northwind;User Id=sa;Password=pass";<br /> private SqlConnection connection;<br /> public Test()<br /> {<br /> connection = new SqlConnection(connString);<br /> }<br /> private static void Main()<br /> {<br /> Test t = new Test();<br /> t.ConnectionStatus();<br /> Console.ReadLine();<br /> }<br /> public void ConnectionStatus()<br /> {<br /> try<br /> {<br /> if(connection.State == ConnectionState.Closed)<br /> {<br /> connection.Open();<br /> Console.WriteLine("Connection opened..");<br /> }<br /> <br /> if(connection.State == ConnectionState.Open)<br /> {<br /> connection.Close();<br /> Console.WriteLine("Connection closed..");<br /> }<br /> // connection.Dispose();<br /> <br /> if(connection.State == ConnectionState.Closed)<br /> {<br /> connection.Open();<br /> Console.WriteLine("Connection again opened..");<br /> }<br /> }<br /> catch(SqlException ex)<br /> {<br /> Console.WriteLine(ex.Message+"\n"+ex.StackTrace);<br /> }<br /> catch(Exception ey)<br /> {<br /> Console.WriteLine(ey.Message+"\n"+ey.StackTrace);<br /> }<br /> finally<br /> {<br /> Console.WriteLine("Connection closed and disposed..");<br /> connection.Dispose();<br /> }<br /> }<br /> }<br /> <br /> In the above example if you uncomment the "connection.Dispose()" method and execute, you will get an exception as, "The ConnectionString property has not been initialized.".This is the difference between Close() and Dispose().Mayank Agarwalhttp://www.blogger.com/profile/00164092452683371475noreply@blogger.com0tag:blogger.com,1999:blog-1200192102127529166.post-73036222733426860082011-06-20T21:46:00.001-07:002011-06-20T21:48:05.039-07:00Trick for<br /> <br /> * disabling anyone to copy screen content<br /> * disabling drag<br /> * disabling select (selection of content)<br /> <br /> body ondragstart='return false' onselectstart='return false'>Mayank Agarwalhttp://www.blogger.com/profile/00164092452683371475noreply@blogger.com0tag:blogger.com,1999:blog-1200192102127529166.post-2461772507335435742011-06-20T21:36:00.001-07:002011-06-20T21:38:38.889-07:00private void btnExportToExcel_Click(object sender,<br /> System.EventArgs e)<br /> {<br /> ExportToExcel("Report.xls",DataGrid1);<br /> }<br /> <br /> <br /> private void ExportToExcel(string strFileName,DataGrid dg)<br /> { Response.Clear();<br /> Response.Buffer = true;<br /> Response.ContentType = "application/vnd.ms-excel";<br /> Response.AddHeader("content-disposition",<br /> "attachment;filename=" + strFileName);<br /> Response.Charset = "";<br /> this.EnableViewState = false;<br /> System.IO.StringWriter sw = new StringWriter();<br /> System.Web.UI.HtmlTextWriter htw = new HtmlTextWriter(sw);<br /> dg.RenderControl(htw);<br /> Response.Write(sw.ToString());<br /> Response.End();<br /> }<br /> <br /> Source: http://dotnetguts.blogspot.comMayank Agarwalhttp://www.blogger.com/profile/00164092452683371475noreply@blogger.com0tag:blogger.com,1999:blog-1200192102127529166.post-75256799868343778902011-06-20T21:27:00.000-07:002011-06-20T21:27:08.173-07:00Working Effectively with Legacy Code<br /> Learn how to find and create seams in your application, no matter "Legacy" it may be, and over time improve application's design. Read more...<br /> <br /> private void btnImportExcelToGrid_Click(object sender,<br /> System.EventArgs e)<br /> {<br /> String strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +<br /> "Data Source=C:\\Book2.xls;" +<br /> "Extended Properties=Excel 8.0;";<br /> <br /> DataSet ds = new DataSet();<br /> //You must use the $ after the object<br /> //you reference in the spreadsheet<br /> OleDbDataAdapter da = new OleDbDataAdapter<br /> ("SELECT * FROM [Sheet1$]", strConn);<br /> <br /> //da.TableMappings.Add("Table", "ExcelTest");<br /> <br /> da.Fill(ds);<br /> DataGrid2.DataSource = ds.Tables[0].DefaultView;<br /> DataGrid2.DataBind();<br /> }<br /> <br /> Note: If you want to give client upload facility, than first upload the file to the server. Next call the excel file from the following server location.<br /> <br /> Source: http://dotnetguts.blogspot.comMayank Agarwalhttp://www.blogger.com/profile/00164092452683371475noreply@blogger.com0tag:blogger.com,1999:blog-1200192102127529166.post-632837315950375392011-06-20T21:22:00.000-07:002011-06-20T21:22:03.064-07:00What is Web Service?<br /> * Web Service is an application that is designed to interact directly with other applications over the internet. In simple sense, Web Services are means for interacting with objects over the Internet.<br /> * Web Service is<br /> o Language Independent<br /> o Protocol Independent<br /> o Platform Independent<br /> o It assumes a stateless service architecture.<br /> * We will discuss more on web service as the article proceed. Before that lets understand bit on how web service comes into picture.<br /> <br /> <br /> History of Web Service or How Web Service comes into existence?<br /> <br /> * As i have mention before that Web Service is nothing but means for Interacting with objects over the Internet.<br /> * 1. Initially Object - Oriented Language comes which allow us to interact with two object within same application.<br /> * 2. Than comes Component Object Model (COM) which allows to interact two objects on the same computer, but in different applications.<br /> * 3. Than comes Distributed Component Object Model (DCOM) which allows to interact two objects on different computers, but within same local network.<br /> * 4. And finally the web services, which allows two object to interact internet. That is it allows to interact between two object on different computers and even not within same local network.<br /> <br /> Example of Web Service<br /> <br /> * Weather Reporting: You can use Weather Reporting web service to display weather information in your personal website.<br /> * Stock Quote: You can display latest update of Share market with Stock Quote on your web site.<br /> * News Headline: You can display latest news update by using News Headline Web Service in your website.<br /> * In summary you can any use any web service which is available to use. You can make your own web service and let others use it. Example you can make Free SMS Sending Service with footer with your companies advertisement, so whosoever use this service indirectly advertise your company... You can apply your ideas in N no. of ways to take advantage of it.<br /> <br /> <br /> Web Service Communication<br /> Web Services communicate by using standard web protocols and data formats, such as<br /> <br /> * HTTP<br /> * XML<br /> * SOAP<br /> <br /> Advantages of Web Service Communication<br /> Web Service messages are formatted as XML, a standard way for communication between two incompatible system. And this message is sent via HTTP, so that they can reach to any machine on the internet without being blocked by firewall.<br /> <br /> Terms which are frequently used with web services<br /> <br /> * What is SOAP?<br /> o SOAP are remote function calls that invokes method and execute them on Remote machine and translate the object communication into XML format. In short, SOAP are way by which method calls are translate into XML format and sent via HTTP.<br /> <br /> * What is WSDL?<br /> o WSDL stands for Web Service Description Language, a standard by which a web service can tell clients what messages it accepts and which results it will return.<br /> o WSDL contains every details regarding using web service<br /> + Method and Properties provided by web service<br /> + URLs from which those method can be accessed.<br /> + Data Types used.<br /> + Communication Protocol used.<br /> <br /> * What is UDDI?<br /> o UDDI allows you to find web services by connecting to a directory.<br /> <br /> * What is Discovery or .Disco Files?<br /> o Discovery files are used to group common services together on a web server.<br /> o Discovery files .Disco and .VsDisco are XML based files that contains link in the form of URLs to resources that provides discovery information for a web service.<br /> o .Disco File (static)<br /> + .Disco File contains<br /> # URL for the WSDL<br /> # URL for the documentation<br /> # URL to which SOAP messages should be sent.<br /> + A static discovery file is an XML document that contains links to other resources that describe web services.<br /> o .VsDisco File (dynamic)<br /> + A dynamic discovery files are dynamic discovery document that are automatically generated by VS.Net during the development phase of a web service.<br /> <br /> * What is difference between Disco and UDDI?<br /> o Disco is Microsoft's Standard format for discovery documents which contains information about Web Services, while UDDI is a multi-vendor standard for discovery documents which contains information about Web Services.<br /> <br /> * What is Web Service Discovery Tool (disco.exe) ?<br /> o The Web Services Discovery Tool (disco.exe) can retrieve discovery information from a server that exposes a web service.<br /> <br /> * What is Proxy Class?<br /> o A proxy class is code that looks exactly like the class it meant to represent; however the proxy class doesn't contain any of the application logic. Instead, the proxy class contains marshalling and transport logic.<br /> o A proxy class object allows a client to access a web service as if it were a local COM object.<br /> o The Proxy must be on the computer that has the web application.<br /> <br /> * What is Web Service Description Language Tool (wsdl.exe)?<br /> o This tool can take a WSDL file and generate a corresponding proxy class that you can use to invoke the web service.<br /> o Alternate of generating Proxy class through WSDL.exe is you can use web reference. Web Reference automatically generate a proxy classes for a web service by setting a web reference to point to the web service.<br /> o Advantage of using Web Reference as compare to using WSDL.exe Tool is you can update changes done in web service class easily by updating web reference, which is more tedious task with WSDL.exe tool.<br /> <br /> * Testing a Web Service?<br /> o You can test web service without building an entire client application.<br /> + With Asp.net you can simply run the application and test the method by entering valid input paramters.<br /> + You can also use .Net Web Service Studio Tool comes from Microsoft.<br /> <br /> <br /> Example of Creating Web Service in .Net<br /> <br /> This Web Service will retrieve CustomerList Country Wise and return as dataset to client application for display.<br /> <br /> Step1: Create a Web Service Application by File > New > Web Site > Asp.net Web Services<br /> Named the web service, for example here i have choosen name "WSGetCustomerCountryWise"<br /> <br /> Step2: Rename the default Service.asmx file to proper name, you also need to switch design view and change the class name with the same name you use to rename the service.asmx.<br /> For example, "WSGetCustomerCountryWise.asmx" and switch to design view and change the class="Service" to class="WSGetCustomerCountryWise"<br /> <br /> Step3: Rename the Service.CS File to proper name, you need to change the class name and constructor name too.<br /> For example, "WSGetCustomerCountryWise.CS" and switch to code view and change the class and constructor name to "WSGetCustomerCountryWise"<br /> <br /> Step4: Create a Logic for Web Service<br /> <br /> * Create a Method "GetCustomerCountryWise"<br /> * Note: You need to specify [WebMethod] before method definition, if you want it to be accessible public, otherwise the method would not be accessible remotely.<br /> * Specify proper argument and return type for method in web service.<br /> * It is also good practise to specify the use "Description" attribute to tell what method is meant for.<br /> <br /> For example, here i need to access data of northwind customers and want to return customer list country wise, so add namespace for<br /> <br /> using System.Data;<br /> using System.Data.SqlClient;<br /> using System.Configuration;<br /> <br /> [WebMethod(Description="It will generate Customer List, Country Wise")] public System.Xml.XmlElement GetCustomerCountryWise(string sCountry)<br /> {<br /> string sConn = ConfigurationManager.ConnectionStrings["connStr"].ToString();<br /> <br /> string sSQL = "select CustomerId, CompanyName, ContactTitle, City " +<br /> " from Customers where country = '" + sCountry + "'";<br /> <br /> SqlConnection connCustomer = new SqlConnection(sConn);<br /> <br /> DataSet dsCustomer = new DataSet();<br /> <br /> SqlDataAdapter daCustomer = new SqlDataAdapter(sSQL, sConn);<br /> <br /> daCustomer.Fill(dsCustomer,"Customers");<br /> <br /> //Known bug while return "DataSet" is "Data source is an invalid type.<br /> It must be either an IListSource, IEnumerable, or IDataSource."<br /> //For more details on Error: http://support.microsoft.com/kb/317340<br /> <br /> //So to access data we need to make use of XmlElement.<br /> <br /> // Return the DataSet as an XmlElement.<br /> System.Xml.XmlDataDocument xdd = new System.Xml.XmlDataDocument(dsCustomer);<br /> System.Xml.XmlElement docElem = xdd.DocumentElement;<br /> return docElem;<br /> }<br /> <br /> Step5: Build Web Service and Run the Web Service for testing by pressing F5 function key.<br /> <br /> By pressing "Invoke" button will generate XML File.<br /> <br /> So you are done creating web service application.<br /> <br /> Example of Testing Web Service in .Net<br /> <br /> This Web Service will display the information which had been retrieved from Remote computer by accessing public method "GetCustomerCountryWise".<br /> <br /> Step1: Create a Test Web Site by File > New > Web Site > Asp.net Web Site<br /> Named the web site, for example here i have choosen name "TestGetCustomerCountryWise"<br /> <br /> Step2: Displaying data in gridview, so drag the gridview on to the form.<br /> <br /> Step3: Right Click Solution Explorer and Choose "Add Web Reference"<br /> <br /> Step4: Choose the option Web Service on the local machine or you can enter the .WSDL File address directly in URL space and press Go button.<br /> <br /> Step5: Press "Add Reference button"<br /> <br /> Step6: Writing Code for Displaying data in GridView<br /> Here note: I have Pass "USA" as parameter in Country Field.<br /> <br /> protected void Page_Load(object sender, EventArgs e)<br /> {<br /> if (!Page.IsPostBack)<br /> {<br /> //Create object of WSGetCustomerCountryWise Object<br /> localhost.WSGetCustomerCountryWise objGetCustomerCountryWise<br /> = new localhost.WSGetCustomerCountryWise();<br /> <br /> DataSet dsCustomer = new DataSet();<br /> <br /> // Get the data from Webservice.<br /> XmlElement elem = objGetCustomerCountryWise.GetCustomerCountryWise("USA");<br /> <br /> // Load the XML to the Typed DataSet that you want.<br /> XmlNodeReader nodeReader = new XmlNodeReader(elem);<br /> dsCustomer.ReadXml(nodeReader, XmlReadMode.Auto);<br /> <br /> GridView1.DataSource = dsCustomer;<br /> <br /> GridView1.DataBind();<br /> }<br /> }<br /> <br /> <br /> Few Facts about Web Service in .Net<br /> <br /> * Each Response from web service is a new object, with a new state.<br /> * Web Service are asynchronous because the request object from the client application and the response object from the web service are unique SOAP envelopes that do not require shared connection.<br /> * This allow client application and the web service to continue processing while the interaction is ongoing.<br /> * Instead of a user interface, it provides a standard defined interface called a contract.<br /> <br /> Source: http://dotnetguts.blogspot.comMayank Agarwalhttp://www.blogger.com/profile/00164092452683371475noreply@blogger.com0tag:blogger.com,1999:blog-1200192102127529166.post-19093581249255091962011-06-20T21:07:00.001-07:002011-06-20T21:07:36.033-07:00//Creating Two Instance of DateTime<br /> DateTime dt1 = new DateTime();<br /> DateTime dt2 = new DateTime();<br /> <br /> <br /> //Initializing DateTime Object<br /> dt1 = DateTime.Now.Date; //Initializing with Current Date<br /> Response.Write(dt1.ToString() + "<br>");<br /> //Output: 22-06-2007 00:00:00<br /> <br /> //Examples for DateTime Manipulation in .Net<br /> //Example 1 : Adding Minutes to Current Date.<br /> dt1 = dt1.AddMinutes(5.0);<br /> Response.Write(dt1.ToString() + "<br>");<br /> //Output: 22-06-2007 00:05:00<br /> <br /> //Example 2 : Adding Seconds to DateTime Object., similarly you can add milliseconds<br /> dt1 = dt1.AddSeconds(30.0);<br /> Response.Write(dt1.ToString() + "<br>");<br /> //Output: 22-06-2007 00:05:30<br /> <br /> //Example 3 : Adding Hours to DateTime Object in .Net.<br /> dt1 = dt1.AddHours(5.0);<br /> Response.Write(dt1.ToString() + "<br>");<br /> //Output: 22-06-2007 05:05:30<br /> <br /> //Example 4 : Adding Time to DateTime Object.<br /> //You can replace Example 1,2 and 3 by simply adding TimeSpan with your desired<br /> //TimeSpan value.<br /> //Here we are adding 5 Hours, 5 Minutes and 30 Seconds.<br /> dt1 = dt1.Add(new TimeSpan(5,5,30));<br /> Response.Write(dt1.ToString() + "<br>");<br /> //Output: 22-06-2007 10:11:00<br /> <br /> //Example 5 : Adding Days to DateTime Object in .Net<br /> dt2 = dt1.AddDays(7.0); //Initializing dt2 object with 7 days ahead from<br /> //dt1 DateTime value.<br /> Response.Write(dt2.ToString() + "<br>");<br /> //Output: 29-06-2007 10:11:00<br /> <br /> //Example 6 : Adding Month to DateTime Object<br /> dt2 = dt2.AddMonths(1);<br /> Response.Write(dt2.ToString() + "<br>");<br /> //Output: 29-07-2007 10:11:00<br /> <br /> //Example 7 : Adding Year to DateTime Object<br /> dt2 = dt2.AddYears(1);<br /> Response.Write(dt2.ToString() + "<br>");<br /> //Output: 29-07-2008 10:11:00<br /> <br /> <br /> //Examples of Retrieving DateTime object value.<br /> //Example 1 : Get Day value.<br /> int intDay = dt1.Day;<br /> Response.Write(intDay.ToString() + "<br>");<br /> //Output: 22<br /> <br /> //Example 2 : Get Day of Week.<br /> DayOfWeek dow = dt1.DayOfWeek;<br /> Response.Write(dow.ToString() + "<br>");<br /> //Output: Friday<br /> //How to find whether day of week is sunday or saturday?<br /> if(dow == DayOfWeek.Sunday dow == DayOfWeek.Saturday)<br /> {<br /> //Hurray its weekend.<br /> }<br /> <br /> //Example 3 : Get the Day of Year<br /> int intYear = dt1.DayOfYear; //Similarly you can get Year value.<br /> Response.Write(intYear.ToString() + "<br>");<br /> //Output: 173<br /> <br /> <br /> //Similarly you can get Hours, Minutes, Seconds, Milliseconds value.<br /> <br /> <br /> <br /> //Conversion of String to DateTime<br /> //Make use of Parse Method of DateTime to "Convert String to DateTime in .Net"<br /> DateTime dt4 = DateTime.Parse("08/06/2007");<br /> DateTime dt5 = DateTime.Parse("10/06/2007");<br /> <br /> //Comparing Date<br /> //How to Find whether both dates are equal or Not?<br /> //How to compare two dates in .Net?<br /> if (DateTime.Compare(dt4, dt5) == 0)<br /> {<br /> Response.Write("Both Dates are Equal" + "<br>");<br /> }<br /> else if (DateTime.Compare(dt4, dt5) < 0) { Response.Write(dt4.ToString() + " is Less than " + dt5.ToString() + "<br>");<br /> }<br /> else<br /> {<br /> Response.Write(dt4.ToString() + " is Greater than "<br /> + dt5.ToString() + "<br>");<br /> }<br /> //Output: 08-06-2007 00:00:00 is Less than 10-06-2007 00:00:00<br /> /*Note: You may recieve error: "String was not recognized as a valid<br /> DateTime." This may be occur as in India the DateTime format is followed<br /> as "dd/mm/yyyy" But let say if you are in USA than it follow "mm/dd/yyyy" so here<br /> there is crash situation and so you might recieve above error, so to avoid such<br /> error make sure that user input valid date before you Parse date. */<br /> <br /> <br /> //Difference between Date<br /> //How to Find difference between two dates in .Net?<br /> //How to Find days difference between two dates in .Net?<br /> //How to subtract one date from another?<br /> TimeSpan tsDiff = dt5.Subtract(dt4); //Note: Always subtract smaller date<br /> //value from greater date<br /> Response.Write("Difference between " + dt4.ToString() + " and " +<br /> dt5.ToString() + " is " + tsDiff.Days.ToString() + " days." + "<br>");<br /> //Output: Difference between 08-06-2007 00:00:00 and 10-06-2007 00:00:00 is 2 days.<br /> <br /> <br /> //Similarly you can also find:<br /> //How many hour difference between two dates<br /> //How many seconds difference between two dates<br /> //And so on... by changing tsDiff property value to hours, seconds....<br /> //instead of tsDiff.Days.<br /> <br /> <br /> //Compare Time<br /> //How to Find whether both Time are equal or Not?<br /> //How to compare Time in .Net?<br /> dt4 = DateTime.Parse("4:30 AM");<br /> dt5 = DateTime.Parse("7:30 PM");<br /> if (DateTime.Compare(dt4, dt5) == 0)<br /> {<br /> Response.Write("Both Times are Equal" + "<br>");<br /> }<br /> else if (DateTime.Compare(dt4, dt5) < 0) { Response.Write(dt4.ToShortTimeString() + " is Less than " + dt5.ToShortTimeString() + "<br>");<br /> }<br /> else<br /> {<br /> Response.Write(dt4.ToShortTimeString() + " is Greater than "<br /> + dt5.ToShortTimeString() + "<br>");<br /> }<br /> //Output: 04:30:00 is Less than 19:30:00<br /> <br /> <br /> //Difference between Time<br /> //How to Find difference between two Time value in .Net?<br /> //How to Find Hours difference between two Time in .Net?<br /> //How to subtract one Time from another?<br /> //How to find elapsed Time between Two Time value in .Net?<br /> tsDiff = dt5.Subtract(dt4); //Note: Always subtract smaller date<br /> //value from greater date<br /> Response.Write("Difference between " + dt4.ToString() + " and " + dt5.ToString() + " is " + tsDiff.Hours.ToString() + " Hours." + "<br>");<br /> //Output: Difference between 22-06-2007 04:30:00 and 22-06-2007 19:30:00 is 15 Hours.<br /> <br /> <br /> //More on DateTime<br /> //How many days in a given month in .Net?<br /> int intDaysInMonth = DateTime.DaysInMonth(2007, 6); //Pass valid year, and month<br /> Response.Write(intDaysInMonth.ToString() + "<br>");<br /> //Output: 30<br /> <br /> //How to find whether given year is Leap year or not in .Net?<br /> Response.Write( DateTime.IsLeapYear(2007)); //Pass valid year<br /> //Output: False<br /> <br /> //How to find current date and time?<br /> Response.Write("Current Date and Time: " + DateTime.Now + "<br>");<br /> //Output: Current Date and Time: 22-06-2007 11:31:04<br /> <br /> //How to find current date?<br /> Response.Write("Current Date: " + DateTime.Today + "<br>");<br /> //Output: Current Date: 22-06-2007 00:00:00<br /> <br /> Source: http://dotnetguts.blogspot.comMayank Agarwalhttp://www.blogger.com/profile/00164092452683371475noreply@blogger.com0tag:blogger.com,1999:blog-1200192102127529166.post-3869894228403594652011-06-20T02:30:00.001-07:002011-06-20T02:31:07.824-07:00WPF is Windows Presentation Foundation Framework that shipped as part of the .NET Framework 3.0 . First it has shipped with Windows Vista OS in built, and is re-distributable for Windows XP or Windows Server 2008.<br /> <br /> WPF is Object Oriented , XAML based.<br /> <br /> * It Uses DirectX Engine for rendering GUI<br /> * It do not use GDI 32 programming at all as opposed to Win32 applications<br /> * It do not require more time or cost for graphics, drawing or animation programming<br /> * It is Easy to change resolution unlike win32 application<br /> * It is XAML Friendly.<br /> * It has .NET API that has integrated to XAML (Xtensible Application Markup Language)<br /> * Easily select the Controls unlike Win32 Controls.<br /> * It has the ability to create 3D graphics in windows apps<br /> * It contains Separate API for graphics and animation<br /> * Most powerful Windows UI Framework<br /> <br /> It is used for the<br /> <br /> * For the better User Interface & the Design<br /> * Customization of Controls<br /> * Integrating Flash, Direct, Win32, Windows Forms<br /> * For Generic consistency professional look (Using Styles like CSS in Web)<br /> <br /> WPF Provides an unified Model for producing high end GUI easily using normal XML syntax to render output on graphics devices than using GDI components.<br /> <br /> Source: http://beyondrelational.comMayank Agarwalhttp://www.blogger.com/profile/00164092452683371475noreply@blogger.com0tag:blogger.com,1999:blog-1200192102127529166.post-92216495674152061972011-06-20T02:17:00.001-07:002011-06-20T02:18:58.745-07:00Some time we face a problem like when we click on the server side button twice or more time ,it call a button event more then one time for single calling .some time it makes problem in our logic .so we need a solution code which hold the page till the server respond the single request .<br /> Here i am placing a code which is useful in this case.<br /> <br /> script type="text/javascript"><br /> function pageLoad(sender, args) {<br /> var rm = Sys.WebForms.PageRequestManager.getInstance();<br /> rm.add_initializeRequest(initializeRequest);<br /> rm.add_endRequest(endRequest);<br /> }<br /> function initializeRequest(sender, args) {<br /> //Disable button to prevent double submit<br /> var btn = $get(args._postBackElement.id);<br /> if (btn) {<br /> btn.disabled = true;<br /> if (btn.className == 'button')<br /> btn.className = 'buttonDisabled';<br /> }<br /> }<br /> function endRequest(sender, args) {<br /> //Re-enable button<br /> <br /> var btn = $get(sender._postBackSettings.sourceElement.id);<br /> if (btn) {<br /> btn.disabled = false;<br /> if (btn.className == 'buttonDisabled')<br /> btn.className = 'button';<br /> }<br /> }<br /> /script><br /> <br /> Source: http://itneeds4u.blogspot.com/Mayank Agarwalhttp://www.blogger.com/profile/00164092452683371475noreply@blogger.com0tag:blogger.com,1999:blog-1200192102127529166.post-82942078362210290982011-06-20T02:14:00.001-07:002011-06-20T02:14:46.520-07:00Why go for Connection Pooling?<br /> <br /> Establishing connection to a database is cumbersome and resource burning, most important job in the applications, sometimes it might be slow. Most of the applications need to execute any query on the database server, a connection need to be established. Knowing about the Connection Pooling concepts and tips will definitely improves the performance while connecting to the database and the same time solves the requirement.<br /> Connection Pooling at a glance?<br /> <br /> Connection Pooling is the ability to reuse the database connection for more than one user. That connection might be SQL, OLEDB, ORACLE or whatever. This way of organizing connections in a smarter manner improves performance as the applications do not need to open and close the connection multiple times.<br /> <br /> All of us know that we declare the connection string in web.config as follows in .NET Application and make use of this in code behind while connecting to databases.<br /> view source<br /> print?<br /> 1.<connectionStrings><br /> 2. <add 3. name="sqlConnectionString" 4. connectionString="Data Source=vhimabindu;Initial Catalog=DNN;password=himavejella;Integrated Security=True; Pooling=true; Max pool size=200; Min poolsize=0" /><br /> 5.</connectionStrings><br /> <br /> When the connection is closed or disposed in ADO.NET, it is returned to the connection pool and remains idle for until a request for a new connection comes in. If none comes in within this period, the connection to the backend is closed and the connection instance is removed from the Connection Pool. If all the connections are in the pool are busy then new connection waits in the queue for the existing connections to be released .We can set max connections, connection Pool size, Connection Time out etc settings in the web.config.<br /> <br /> The following key value pairs explain the connection pooling settings.<br /> <br /> * Connection Lifetime - The time of Connection Creation will be compared to the current time. If this period exceeds the Connection Lifetime value that is set, then object pooler destroys the connection. The default value is 0; this will give the maximum timeout for connection.<br /> * Connection Reset - To reset the connection after it was take out from the Connection pool. The default value is true.<br /> * Max pool size - Maximum number of connections allowed within the Connection pool. The value is 100 by default.<br /> * Min pool size - Minimum number of connections allowed within the Connection pool. The value is 0 by default.<br /> * Pooling - To set the connection Pooling if it is true, the connection is drawn from the pool or created if no connection available from the pool. The value is true by default.<br /> * Connection Timeout - Maximum Time (in secs) to wait for a free connection from the pool. The value is 15 by default.<br /> * Incr Pool Size - Controls the number of connections which are established, when all the connections are used. The value is 5 by default<br /> * Decr Pool Size - Controls the number of connections which are closed when most of the established connections are unused. The value is 1 by default<br /> <br /> Points to Ponder<br /> <br /> * Disabling the connection pooling, infers that the connection object that is created by the user will not be re-used to any other user.<br /> * A Connection pool will be created when Open() method of connection object is called. If the same application is using multiple Connection Strings (say more than one) then multiple connection pools will be created corresponding to each connection string.<br /> * Connection Pooling is applied in ADO.Net by default.<br /> * Connections that are not explicitly closed are not added or returned to the pool. Hence The Close() or Dispose() method of Connection need to be called to close the connection.<br /> * A Connection Pool is freed from the memory when the last connection to the database is closed.<br /> * Connection Pool’s life time is ended as soon as the application domain is unloaded. For example at any time when IISRESET runs the Connection Pool gets destroyed<br /> * Connection Pools cannot be shared across application domains.<br /> <br /> The best practice Code<br /> <br /> The below code is the best practice that is recommended to use.<br /> view source<br /> print?<br /> 01.Try<br /> 02.{<br /> 03. SqlConnection _sqlConnection = new SqlConnection();<br /> 04. _sqlConnection.ConnectionString = ConfigurationManager.ConnectionStrings["sqlConnectionString"].ToString();<br /> 05. <br /> 06. if (_sqlConnection.State = ConnectionState.Closed)<br /> 07. _sqlConnection.Open();<br /> 08. <br /> 09. /*Do some Operations … */<br /> 10.}<br /> 11.catch (Exception ex)<br /> 12.{<br /> 13. /*Do something */<br /> 14.}<br /> 15.finally<br /> 16.{<br /> 17. if (_sqlConnection.State != ConnectionState.Closed) <br /> 18. _sqlConnection.Close();<br /> 19.}<br /> <br /> Connection Pooling improves the performance of the data driven B2B applications as we save some time in reusing the existing active database connections. I will be explaining it in more detail in my next article.<br /> <br /> Source: http://beyondrelational.comMayank Agarwalhttp://www.blogger.com/profile/00164092452683371475noreply@blogger.com0tag:blogger.com,1999:blog-1200192102127529166.post-35057294962606796952011-06-20T02:12:00.001-07:002011-06-20T02:12:23.950-07:00Introduction<br /> <br /> Generics in C# are an extension to C# Programming using Generic Types and Methods. I see most of the developers still get confused about generics and do not know to use them in real time projects. That made me to write this article to help understand and refer how to use them?<br /> <br /> Basic concept is similar to Templates in C++ with better extensibility and usability. The C++ Templates are compile time Feature whereas Generics is a feature of runtime.<br /> <br /> These are a type of data structure that contains code, remains the same. The data type of the parameters will change for each use. We can also call them parameterized types or parametric polymorphism. Generics allow classes, structs, interfaces, delegates, and methods to be parameterized by the types of data they store.<br /> <br /> The usage within the data structure adapts to the different data type of the passed variables. This Allows defining type-safe data structures need less committing to actual data types. We reuse data processing algorithms without duplicating type-specific code.<br /> <br /> System.Collections.Generic<br /> <br /> The System.Collections.Generic namespace contains several generic collection classes based on generics and it is recommended that we should use these collection classes in place of the earlier non-generic ones for better performance of our applications.<br /> <br /> The namespace contains a lot of generic classes, structures, and interfaces like<br /> <br /> * Dictionary<br /> * List<br /> * Queue<br /> * SortedDictionary<br /> * Stack<br /> <br /> Examples<br /> view source<br /> print?<br /> public class Gen<T><br /> {<br /> T t;<br /> public T Val<br /> {<br /> get;<br /> set;<br /> <br /> }<br /> }<br /> <br /> The class name " Gen<T” represents that the Type is generic, specifically the brackets <>containing the Type. This Type "T" is used to show that if we need to refer to the actual Type that is going to be used when we write this class".<br /> <br /> T t; Creates member of the type T<br /> <br /> The generic Type that we will specify during construction of the class will get inserted by the Common Language Runtime (CLR). The final item in the class is the public property. Again, notice that we are using the Type placeholder "T" to represent that generic type for the type of that property. Also notice that we can freely use the private variable "t" within the class.<br /> <br /> In order to use this class to hold any Type, we simply need to create a new instance of our new Type, providing the name of the Type within the "<>" brackets and then use that class in a Type-safe manner as shown below.<br /> view source<br /> print?<br /> static void Main(string[] args)<br /> {<br /> //create a string version of our generic class<br /> Gen str = new Gen();<br /> //set the value for the string type<br /> str.Val = "Beyond Relational";<br /> <br /> //output the type and value<br /> System.Console.WriteLine(str.Val);<br /> System.Console.WriteLine(str.Val.GetType());<br /> <br /> //create another instance of our generic class, using a different type<br /> Gen flt = new Gen();<br /> flt.Val = 12.34;<br /> System.Console.WriteLine(flt.Val);<br /> //output<br /> System.Console.WriteLine(flt.Val.GetType());<br /> Console.ReadLine();<br /> <br /> }<br /> <br /> }<br /> <br /> Generic Collections<br /> view source<br /> print?<br /> public class MessageElement<br /> {<br /> //some functionality<br /> }<br /> public class MessageSearchCriteria<br /> {<br /> // some functioanlity<br /> }<br /> <br /> public List ListMessageElement<br /> {<br /> get <br /> {<br /> return lstMsgElemet;<br /> }<br /> set<br /> {<br /> lstMsgElemet = value;<br /> }<br /> }<br /> <br /> MessageSearchCriteria objMsgSearch = new MessageSearchCriteria();<br /> //usage of generics<br /> objMsgSearch.ListMessageElement = new List();<br /> <br /> Advantages<br /> <br /> * Help to make the code in the software components much more reusable.<br /> * High Quality Code and Code Maintainability<br /> * No runtime Casting No Boxing hence Allows Performance Efficiency<br /> * Creates Type safe at compile time as generics specify type at runtime<br /> * Programmer has stronger and flexible control over the code<br /> * The stronger type checking associated with generics helps in finding errors easily at compile time only.<br /> * No code Duplication<br /> <br /> Generics refer to classes and methods that work consistently on values of different typesMayank Agarwalhttp://www.blogger.com/profile/00164092452683371475noreply@blogger.com0tag:blogger.com,1999:blog-1200192102127529166.post-28865069934381972142011-06-04T00:21:00.000-07:002011-06-04T00:23:47.487-07:00<p><strong>Ajax</strong></p><br /><ul><br /><li><a href="http://www.codeplex.com/AjaxControlToolkit">Ajax Control Toolkit</a> - Microsoft</li><br /><li><a href="http://www.codeplex.com/AjaxPro">AJAXNet Pro</a></li><br /><li><a href="http://awesome.codeplex.com/">ASP.NET MVC Project Awesome</a> - a rich set of helpers (controls) that you can use to build highly responsive and interactive Ajax-enabled Web applications. These helpers include Autocomplete, AjaxDropdown, Lookup, Confirm Dialog, Popup Form and Pager. Thanks <strong>Omu</strong> <em>(April 20, 2011)</em></li><br /></ul><br /><p><strong>Build Tools</strong></p><br /><ul><br /><li><a href="http://sourceforge.net/projects/dnpb/">Prebuild</a> - Generate project files for all VS version, including major IDE's and tools like SharpDevelop, MonoDevelop, NAnt and Autotools</li><br /><li><a href="http://genuilder.codeplex.com/">Genuilder</a> - Precompiler which lets you transform your source code during the build. Thanks <strong>Harry McIntyre</strong> <em>(April 13, 2011)</em></li><br /></ul><br /><p><strong>Charting/Graphics</strong></p><br /><ul><br /><li><a href="http://www.microsoft.com/downloads/details.aspx?familyid=130F7986-BF49-4FE5-9CA8-910AE6EA442C&amp;displaylang=en">Microsoft Chart Controls for ASP.NET 3.5 SP1</a></li><br /><li><a href="http://code.msdn.microsoft.com/mschart">Microsoft Chart Controls for Winforms</a></li><br /><li><a href="http://sourceforge.net/projects/zedgraph/">ZedGraph Charting</a></li><br /><li><a href="http://www.nplot.com/">NPlot</a> - Charting for ASP.NET and WinForms</li><br /><li><a href="http://graphsharp.codeplex.com/">Graph#</a> - a graph layout framework contains some layout algorithms and a GraphLayout control for WPF applications. Thanks <strong>Florian Standhartinger</strong> <em>(April 20, 2011)</em></li><br /></ul><br /><p><strong>Collections/Generics</strong></p><br /><ul><br /><li><a href="http://powercollections.codeplex.com/">PowerCollections</a> - is a library that provides generic collection classes that are not available in the .NET framework. Some of the collections included are the Deque, MultiDictionary, Bag, OrderedBag, OrderedDictionary, Set, OrderedSet, and OrderedMultiDictionary. Thanks <strong>Adam Ralph</strong> <em>(April 20, 2011)</em></li><br /></ul><br /><p><strong>Compression</strong></p><br /><ul><br /><li><a href="http://www.icsharpcode.net/OpenSource/SharpZipLib/">SharpZipLib</a></li><br /><li><a href="http://www.codeplex.com/dotnetzip">DotNetZip</a></li><br /><li><a href="http://www.codeplex.com/YUICompressor">YUI Compressor</a> (CSS and JS minification)</li><br /><li><a href="http://aspnet.codeplex.com/releases/view/40584">AjaxMinifier (in other downloads)</a> (CSS and JS minification. Also includes MSBuild task)</li><br /><li><a href="http://sevenzipsharp.codeplex.com/">SevenZipSharp</a> to pack, unpack a lot of different packages (including RAR, 7ZIP, etc).</li><br /><li><a href="http://zipstorer.codeplex.com/">ZipStorer</a> A Pure C# Class to Store Files in Zip</li><br /></ul><br /><p><strong>Controls</strong></p><br /><ul><br /><li><a href="http://www.componentfactory.com/product?id=3">Krypton</a> - Free winform controls. Link fixed <em>(April 14, 2011)</em></li><br /><li><a href="http://www.codeplex.com/sourcegrid/">Source Grid</a> - A Grid control</li><br /><li><a href="https://www.devexpress.com/Products/Free/NetOffer/">DevExpress</a> - Over 60 Free Controls from DevExpress. Thanks <strong>Florian Standhartinger</strong> <em>(April 20, 2011)</em></li><br /><li><a href="http://objectlistview.sourceforge.net/cs/index.html">ObjectListView</a> - is a C# wrapper around a .NET ListView. It makes the ListView much easier to use and provides some neat extra functionality. Thanks <strong>Florian Standhartinger</strong> <em>(April 20, 2011)</em></li><br /></ul><br /><p><strong>Data Mapper</strong></p><br /><ul><br /><li><a href="http://xmldatamapper.codeplex.com/">XmlDataMapper</a></li><br /><li><a href="http://automapper.codeplex.com/">AutoMapper</a></li><br /><li><a href="http://code.google.com/p/dapper-dot-net/">Dapper</a></li><br /><li><a href="http://blog.wekeroad.com/helpy-stuff/and-i-shall-call-it-massive">Massive</a></li><br /><li><a href="http://mapperextensions.codeplex.com/">Mapper Extensions</a> Thanks <strong>giometrix</strong> <em>(April 14, 2011)</em></li><br /><li>Data accessors from the <a href="http://msdn.microsoft.com/en-us/library/ff664742%28PandP.50%29.aspx">Data Access Application Block</a></li><br /><li><a href="http://valueinjecter.codeplex.com/">Value Injecter</a> - ets you define your own convention-based matching algorithms (ValueInjections) in order to match up (inject) source values to destination values. Thanks <strong>Omu</strong> <em>(April 20, 2011)</em></li><br /></ul><br /><p><strong>Dependency Injection/Inversion of Control</strong></p><br /><ul><br /><li><a href="http://msdn.microsoft.com/unity">Unity Framework</a> - Microsoft</li><br /><li><a href="http://sourceforge.net/projects/structuremap">StructureMap</a> - Jeremy Miller</li><br /><li><a href="http://www.castleproject.org/container/index.html">Castle Windsor</a></li><br /><li><a href="http://ninject.org/">NInject</a></li><br /><li><a href="http://www.springframework.net/">Spring Framework</a></li><br /><li><a href="http://code.google.com/p/autofac/">Autofac</a></li><br /><li><a href="http://simpleservicelocator.codeplex.com">Simple Service Locator</a></li><br /><li><a href="http://mef.codeplex.com/">Managed Extensibility Framework</a></li><br /><li><a href="http://hg.grumpydev.com/tinyioc/wiki/Home">TinyIoC</a></li><br /><li><a href="http://funq.codeplex.com/">Funq</a> - a high performance DI framework by eliminating all runtime reflection through the use of lambdas and generic functions as factories. Thanks <strong>Marcel Popescu</strong> <em>(April 20, 2011).</em></li><br /><li><a href="http://munq.codeplex.com/">Munq</a> - a very small, fast dependency injection container designed for ASP.NET applications, both Webforms and MVC. It has, by design, limited features. The main goal has been to minimize the CPU required for Resolving types from the container. Thanks <strong>Marcel Popescu</strong> <em>(April 20, 2011).</em></li><br /></ul><br /><p><strong>Design by Contract</strong></p><br /><ul><br /><li><a href="http://research.microsoft.com/en-us/projects/contracts/">Microsoft Code Contracts</a></li><br /><li><a href="http://www.codeproject.com/KB/cs/LinFu_Part5.aspx?msg=2417857">LinFu</a></li><br /><li><a href="http://conditions.codeplex.com">CuttingEdge.Conditions</a></li><br /></ul><br /><p><strong>IDE</strong></p><br /><ul><br /><li><a href="http://www.icsharpcode.net/opensource/sd/">SharpDevelop</a> - is a free IDE for C#, VB.NET and Boo projects. Thanks <strong>Florian Standhartinger</strong> <em>(April 20, 2011).</em></li><br /></ul><br /><p><strong>Logging</strong></p><br /><ul><br /><li><a href="http://msdn.microsoft.com/en-us/library/ff664569%28PandP.50%29.aspx">Logging Application Block</a> - Microsoft</li><br /><li><a href="http://logging.apache.org/log4net/">Log4Net</a> - Apache</li><br /><li><a href="http://code.google.com/p/elmah/">Error Logging Modules and Handlers(ELMAH)</a></li><br /><li><a href="http://www.nlog-project.org/">NLog</a></li><br /><li><a href="http://logging.codeplex.com">CuttingEdge.Logging</a></li><br /><li><a href="http://netcommon.sourceforge.net">Logging Abstraction Api "Common.Logging"</a></li><br /></ul><br /><p><strong>ORM</strong></p><br /><ul><br /><li><a href="http://www.hibernate.org/343.html">NHibernate</a> and <a href="http://fluentnhibernate.org/">FluentNHibernate</a></li><br /><li><a href="http://www.castleproject.org/activerecord/index.html">Castle ActiveRecord</a></li><br /><li><a href="http://subsonicproject.com/">Subsonic</a></li><br /><li><a href="http://xmldatamapper.codeplex.com/">XmlDataMapper</a></li><br /><li><a href="http://truss.codeplex.com/">Truss</a> Data binding and real time property sync library</li><br /></ul><br /><p><strong>PDF Creators/Generators</strong></p><br /><ul><br /><li><a href="http://www.pdfsharp.net/">PDFsharp</a></li><br /><li><a href="http://itextsharp.sourceforge.net/">iTextSharp</a></li><br /></ul><br /><p><strong>Automated Web Testing</strong></p><br /><ul><br /><li><a href="http://seleniumhq.org">Selenium</a></li><br /><li><a href="http://watin.sourceforge.net/">Watin</a></li><br /></ul><br /><p><strong>Misc Testing/Qualitysupport/Behavoir Driven Development (BDD)</strong></p><br /><ul><br /><li>Testdatagenerator <a href="http://nbuilder.org/">NBuilder</a></li><br /><li>BDD <a href="http://storyq.codeplex.com/">StoryQ</a></li><br /><li>BDD <a href="http://specflow.org/specflow/getting-started.aspx">specflow</a></li><br /></ul><br /><p><strong>URL Rewriting</strong></p><br /><ul><br /><li><a href="http://urlrewriter.net/">url rewriter</a></li><br /><li><a href="http://www.urlrewriting.net/">UrlRewriting.Net</a></li><br /><li><a href="http://urlrewriter.codeplex.com">Url Rewriter and Reverse Proxy</a> - Managed Fusion/Nick Berardi</li><br /></ul><br /><p><strong>MS Word/Excel Documents Manipulation</strong></p><br /><ul><br /><li><a href="http://docx.codeplex.com/">DocX</a> to create, read, manipulate formatted word documents. Easy syntax, working nicely, actively developed. No Microsoft Office necessary.</li><br /><li><a href="http://www.carlosag.net/Tools/ExcelXmlWriter/">Excel XML Writer</a> allows creation of .XLS (Excel) files. No Microsoft Office necessary. Been a while since it has been updated. It also provides <a href="http://ninject.org/">code generator</a> to create code from already created XLS file (saved as xml). Haven't tested this but looks very promising. Too bad author is long time gone.</li><br /><li><a href="http://www.carlosag.net/Tools/ExcelXmlWriter/Generator.aspx">Excel Reader</a> allows creation/reading of .XLS (Excel) files. No Microsoft Office necessary. Been a while since it has been updated.</li><br /><li><a href="http://www.codeproject.com/KB/office/ExcelReader.aspx">Excel Package</a> allows creation/reading of .XLSX (Excel 2007) files. No Microsoft Office necessary. Author is gone so it's out of date.</li><br /><li><a href="http://epplus.codeplex.com/">EPPlus</a> is based on <a href="http://excelpackage.codeplex.com/">Excel Package</a> and allows creation/reading of .XLSX (Excel 2007). It is actually the most advanced even comparing to NPOI.</li><br /><li><a href="http://npoi.codeplex.com/">NPOI</a> is the .NET version of POI Java project at <a href="http://poi.apache.org/">http://poi.apache.org/</a>. POI is an open source project which can help you read/write xls, doc, ppt files.</li><br /><li><a href="http://code.google.com/p/sharp2word/">sharp2word</a> - a Word 2003 XML Documents Generator from C# code without any components or libraries. Thanks <strong>dublicator</strong> <em>(April 20, 2011)</em></li><br /><li><a href="http://closedxml.codeplex.com/">ClosedXML</a> - an actively developed library for generating OpenXML Excel files. Thanks <strong>Joseph Robichaud</strong> <em>(April 26, 2011)</em></li><br /></ul><br /><p><strong>Serialization</strong></p><br /><ul><br /><li><a href="http://www.sharpserializer.com/en/index.html">sharpserializer</a> - xml/binary serializer for wpf, asp.net and silverlight</li><br /><li><a href="http://code.google.com/p/protobuf-net/">Protobuf.NET</a> - fastest serialization port protobuf format into .NET platform. Thanks <strong>slava pocheptsov</strong> <em>(April 26, 2011)</em></li><br /></ul><br /><p><strong>Silverlight</strong></p><br /><ul><br /><li><a href="http://silverlight.codeplex.com/">Silverlight Toolkit</a></li><br /></ul><br /><p><strong>Social Media</strong></p><br /><ul><br /><li><a href="http://linqtotwitter.codeplex.com/">LinqToTwitter</a> - Linq-based wrapper for all Twitter API functionality in C#</li><br /><li><a href="http://facebooksdk.codeplex.com/">Facebook C# SDK</a> - A toolkit for creating facebook applications / integrating websites with Facebook using the new Graph API or the old rest API.</li><br /></ul><br /><p><strong>Package managers for external libraries</strong></p><br /><ul><br /><li><a href="http://nuget.codeplex.com/">NuGet</a> (formerly known as NuPack) - Microsoft (developer-focused package management system for the .NET platform intent on simplifying the process of incorporating third party libraries into a .NET application during development)</li><br /><li><a href="http://openwrap.org">OpenWrap</a> - Sebastien Lambla - Open Source Dependency Manager for .net applications</li><br /></ul><br /><p><strong>Unit Testing/Mocking</strong></p><br /><ul><br /><li><a href="http://www.nunit.org/">NUnit</a> </li><br /><li><a href="http://ayende.com/projects/rhino-mocks.aspx">Rhino Mocks</a></li><br /><li><a href="http://code.google.com/p/moq/">Moq</a></li><br /><li><a href="http://www.typemock.com/">TypeMock.Net</a></li><br /><li><a href="http://www.codeplex.com/xunit">xUnit.net</a> </li><br /><li><a href="http://gallio.org">Gallio</a>/<a href="http://www.mbunit.com/">MbUnit</a></li><br /><li><a href="http://github.com/machine/machine.specifications">Machine.Specifications</a></li><br /><li><a href="http://code.google.com/p/fakeiteasy/">fakeiteasy</a> - a .Net dynamic fake framework for creating all types of fake objects, mocks, stubs etc. Thanks <strong>Omu</strong> <em>(April 20, 2011)</em></li><br /><li><a href="http://nsubstitute.github.com/">NSubstitute</a> - a A friendly substitute for .NET mocking frameworks. Thanks <strong> xerxesb</strong> <em>(May 10, 2011)</em></li><br /><li><a href="http://shouldly.github.com/">Shouldly</a> - How asserting should be. Thanks <strong> xerxesb</strong> <em>(May 10, 2011)</em></li><br /></ul><br /><p><strong>Validation</strong></p><br /><ul><br /><li><a href="http://msdn.microsoft.com/en-us/library/ff664356%28PandP.50%29.aspx">Validation Application Block</a> - Microsoft</li><br /><li><a href="http://xval.codeplex.com/">xVal</a></li><br /><li><a href="http://fluentvalidation.codeplex.com/">Fluent Validation</a></li><br /></ul><br /><p><strong>Threading</strong></p><br /><ul><br /><li><a href="http://www.codeproject.com/KB/threads/smartthreadpool.aspx">Smart Thread Pool</a> - Thread Pool management library</li><br /><li><a href="http://code.google.com/p/retlang/">Retlang</a> - a high performance C# threading library. Thanks <strong>MarcBot</strong> <em>(April 13, 2011)</em></li><br /><li><a href="http://code.google.com/p/bbvcommon/">bbv.Common</a> - an open source library of software components that makes building multi-threaded, event-based and loosely coupled systems easy. Thanks <strong>Urs Enzler</strong> <em>(April 14, 2011)</em></li><br /><li><a href="http://wintellect.com/PowerThreading.aspx">PowerThreading</a> - a llibrary (DLL) containing many classes to help with threading and asynchronous programming. Thanks <strong>Adam Ralph</strong> <em>(April 20, 2011)</em></li><br /></ul><br /><p><strong>Unclassified</strong></p><br /><ul><br /><li><a href="http://www.lhotka.net/">CSLA Framework</a> - Business Objects Framework</li><br /><li><a href="http://www.aforgenet.com/framework/">AForge.net</a> - AI, computer vision, genetic algorithms, machine learning</li><br /><li><a href="http://compositewpf.codeplex.com/">Prism</a> - Composit UI application block for WPF, Silverlight and WP7 - Microsoft patterns &amp; practices</li><br /><li><a href="http://msdn.microsoft.com/entlib">Enterprise Library 5.0</a> - Logging, Exception Management, Caching, Cryptography, Data Access, Validation, Security, Policy Injection - Microsoft patterns &amp; practices</li><br /><li><a href="http://filehelpers.sourceforge.net/">File helpers library</a></li><br /><li><a href="http://www.itu.dk/research/c5/">C5 Collections</a> - Collections for .NET</li><br /><li><a href="http://quartznet.sourceforge.net/">Quartz.NET</a> - Enterprise Job Scheduler for .NET Platform</li><br /><li><a href="http://www.yoda.arachsys.com/csharp/miscutil/">MiscUtil</a> - Utilities by Jon Skeet</li><br /><li><a href="http://code.google.com/p/noda-time/">Noda Time</a> - DateTime replacement (idomatic port of Joda Time from Java)</li><br /><li><a href="http://incubator.apache.org/lucene.net/">Lucene.net</a> - Text indexing and searching</li><br /><li><a href="http://www.codeplex.com/Json">Json.NET</a> - Linq over JSON</li><br /><li><a href="http://www.codeplex.com/Flee">Flee</a> - expression evaluator</li><br /><li><a href="http://www.postsharp.org/">PostSharp</a> - AOP</li><br /><li><a href="http://www.ikvm.net/">IKVM</a> - brings the extensive world of Java libraries to .NET.</li><br /><li><a href="http://webserver.codeplex.com">C# Webserver</a> - Embeddable webserver</li><br /><li><a href="http://bcl.codeplex.com/releases/view/42783">Long Path</a> - Microsoft</li><br /><li><a href="http://www.devincook.com/goldparser/engine/dot-net/index.htm">.NET Engines for the GOLD Parsing System</a></li><br /><li><a href="http://ncqrs.org/">NCQRS</a> - library for event-driven architectures (<a href="http://www.udidahan.com/2009/12/09/clarified-cqrs/">CQRS</a>).</li><br /><li><a href="http://msdn.microsoft.com/en-us/devlabs/ee794896">Reactive Extensions for .NET</a> - a library for composing asynchronous and event-based programs using observable collections. Thanks <strong>steve</strong> <em>(April 14, 2011)</em></li><br /><li><a href="https://github.com/mhutch/Mono.GameMath">Mono.GameMath</a> - a project to develop a highly-performant math library for games, based on XNA APIs. Thanks <strong>Alex R&oslash;nne Petersen</strong> <em>(April 14, 2011)</em></li><br /><li><a href="https://github.com/IgniteInteractiveStudio/SLSharp">SLSharp</a> - a runtime IL-to-GLSL translation engine, allowing people to write GLSL shaders as C# code. Thanks <strong>Alex R&oslash;nne Petersen</strong> <em>(April 14, 2011)</em></li><br /><li><a href="http://infusionsoftdotnet.codeplex.com/">InfusionSoftDotNet</a> - a dll to ease the pain for .Net developers to access the InfusionSoft API. Thanks <strong>Michael Gibbs</strong> <em>(April 20, 2011)</em></li><br /><li><a href="http://remix.codeplex.com/">re-mix</a> - provides mixins for C# and Visual Basic .NET. Thanks <strong>Stefan Papp</strong> <em>(April 20, 2011)</em></li><br /><li><a href="http://www.mono-project.com/Cecil">Mono.Cecil</a> - a library written by Jb Evain to generate and inspect programs and libraries in the ECMA CIL format. It has full support for generics, and support some debugging symbol format. Thanks <strong>Florian Standhartinger</strong> <em>(April 20, 2011)</em></li><br /></ul>Mayank Agarwalhttp://www.blogger.com/profile/00164092452683371475noreply@blogger.com0tag:blogger.com,1999:blog-1200192102127529166.post-73760082492267092402011-06-04T00:16:00.001-07:002011-06-04T00:16:36.310-07:00Hide Form from Start Bar<br />To prevent a form from appearing in the Windows Start bar, add this statement to the form’s constructor:<br /><br />this.ShowInTaskbar = false;Hide Tool Window from Alt+Tab<br />To prevent a form from appearing in the list of windows shown when the user presses Alt+Tab, you can designate the form to be a tool window. Note that you can use SizableToolWindow or FixedToolWindow, and ShowInTaskbar must be set to false:<br /><br />this.FormBorderStyle = FormBorderStyle.SizableToolWindow;<br />this.ShowInTaskbar = false;<br /><br /><br /><br />Hide Borderless Form from Alt+Tab<br />However, if you want the form to be borderless, then you need to add the following statements to the form’s constructor:<br /><br />this.FormBorderStyle = FormBorderStyle.None;<br />this.ShowInTaskbar = false;AND you must add the following method to your derived Form class:<br /><br />protected override CreateParams CreateParams<br />{<br /> get<br /> {<br /> CreateParams cp = base.CreateParams;<br /> // turn on WS_EX_TOOLWINDOW style bit<br /> cp.ExStyle |= 0x80;<br /> return cp;<br /> }<br />}Mayank Agarwalhttp://www.blogger.com/profile/00164092452683371475noreply@blogger.com0tag:blogger.com,1999:blog-1200192102127529166.post-8761652241289077842011-06-04T00:13:00.000-07:002011-06-04T00:14:02.431-07:00Reading the contents of a web page is easy in C# with the System.Net.WebClient class:<br /><br /><br />using System.Net;<br />using System.Windows.Forms;<br /><br />string url = "http://www.devtopics.com";<br />string result = null;<br /><br />try<br />{<br /> WebClient client = new WebClient();<br /> result = client.DownloadString( url );<br />}<br />catch (Exception ex)<br />{<br /> // handle error<br /> MessageBox.Show( ex.Message );<br />}The web page is read into the ‘result’ string. Note the URL you pass to the DownloadString method must have the http:// prefix, otherwise it will throw a WebException.<br /><br />A more complicated but also more flexible solution is to use the System.Net.HttpWebRequest class, which enables you to interact directly with servers using HTTP:<br /><br /><br /><br /><br />using System.Net;<br />using System.IO;<br />using System.Windows.Forms;<br /><br />string result = null;<br />string url = "http://www.devtopics.com";<br />WebResponse response = null;<br />StreamReader reader = null;<br /><br />try<br />{<br /> HttpWebRequest request = (HttpWebRequest)WebRequest.Create( url );<br /> request.Method = "GET";<br /> response = request.GetResponse();<br /> reader = new StreamReader( response.GetResponseStream(), Encoding.UTF8 );<br /> result = reader.ReadToEnd();<br />}<br />catch (Exception ex)<br />{<br /> // handle error<br /> MessageBox.Show( ex.Message );<br />}<br />finally<br />{<br /> if (reader != null)<br /> reader.Close();<br /> if (response != null)<br /> response.Close();<br />}Mayank Agarwalhttp://www.blogger.com/profile/00164092452683371475noreply@blogger.com0tag:blogger.com,1999:blog-1200192102127529166.post-89710239219778249352011-06-03T23:59:00.001-07:002011-06-03T23:59:42.170-07:00This article explains how to use C# to determine the name, edition, service pack, version and bits of the host operating system.<br />For example, the results on my PC would be:<br />Operation System Information<br />—————————-<br />Name = Windows Vista<br />Edition = Home Premium<br />Service Pack = Service Pack 1<br />Version = 6.0.6001.65536<br />Bits = 64<br />Sample Program<br />Here is a simple console program that demonstrates this:<br /><br />using System; <br /> <br />namespace CSharp411 <br />{ <br /> class Program <br /> { <br /> static void Main( string[] args ) <br /> { <br /> Console.WriteLine( "Operation System Information" ); <br /> Console.WriteLine( "----------------------------" ); <br /> Console.WriteLine( "Name = {0}", OSInfo.Name ); <br /> Console.WriteLine( "Edition = {0}", OSInfo.Edition ); <br /> Console.WriteLine( "Service Pack = {0}", OSInfo.ServicePack ); <br /> Console.WriteLine( "Version = {0}", OSInfo.VersionString ); <br /> Console.WriteLine( "Bits = {0}", OSInfo.Bits ); <br /> Console.ReadLine(); <br /> } <br /> } <br />}Mayank Agarwalhttp://www.blogger.com/profile/00164092452683371475noreply@blogger.com0tag:blogger.com,1999:blog-1200192102127529166.post-62912933766950947062011-06-03T23:56:00.001-07:002011-06-03T23:56:34.567-07:00So you’ve set the ToolTipText property of a TabPage in a TabControl. When the user moves the mouse pointer over the tab, the text you specified is supposed to show in a tooltip. <br /><br /><br />But what if the tooltip is not showing? Fortunately, this problem has an easy solution:<br /><br />Set the ShowToolTips property in the TabControl to true.Mayank Agarwalhttp://www.blogger.com/profile/00164092452683371475noreply@blogger.com0tag:blogger.com,1999:blog-1200192102127529166.post-48357268023298567052011-06-03T23:55:00.001-07:002011-06-03T23:55:18.695-07:00Cosing all forms in an application seems like it would be a simple task of using a foreach loop in the Application.OpenForms collection, such as:<br /><br />foreach (Form form in Application.OpenForms) <br />{ <br /> form.Close(); <br /><br /><br />But there are two problems.<br />First, the code above will throw an exception because the OpenForms collection changes each time you close a form, and so the enumerator in your foreach loop becomes invalid when you close a form. Instead, you need to get an array of all open forms, then loop through the array:<br />static public void CloseAllForms() <br />{ <br /> // get array because collection changes as we close forms <br /> Form[] forms = OpenForms; <br /> <br /> // close every open form <br /> foreach (Form form in forms) <br /> { <br /> CloseForm( form ); <br /> } <br />}<br /><br /><br />Second, it’s quite possible that your application opened one or more forms in a separate thread. If so, then trying to close a form from your main thread will throw an exception. So you need to close your forms in a thread-safe manner:<br /><br />delegate void CloseMethod( Form form ); <br />static private void CloseForm( Form form ) <br />{ <br /> if (!form.IsDisposed) <br /> { <br /> if (form.InvokeRequired) <br /> { <br /> CloseMethod method = new CloseMethod( CloseForm ); <br /> form.Invoke( method, new object[] { form } ); <br /> } <br /> else<br /> { <br /> form.Close(); <br /> } <br /> } <br />}Mayank Agarwalhttp://www.blogger.com/profile/00164092452683371475noreply@blogger.com0tag:blogger.com,1999:blog-1200192102127529166.post-55058539713494285472011-06-03T23:47:00.000-07:002011-06-03T23:49:12.719-07:00If you want to rename a file in C#, you’d expect there to be a File.Rename method, but instead you must use the System.IO.File.Move method. <br />You must also handle a special case when the new file name has the same letters but with difference case. For example, if you want to rename “test.doc” to “Test.doc”, the File.Move method will throw an exception. So you must rename it to a temp file, then rename it again with the desired case.<br /><br /><br />/// <summary> <br />/// Renames the specified file. <br />/// </summary> <br />/// <param name="oldPath">Full path of file to rename.</param> <br />/// <param name="newName">New file name.</param> <br />static public void RenameFile( string oldPath, string newName ) <br />{ <br /> if (String.IsNullOrEmpty( oldPath )) <br /> throw new ArgumentNullException( "oldPath" ); <br /> if (String.IsNullOrEmpty( newName )) <br /> throw new ArgumentNullException( "newName" ); <br /> <br /> string oldName = Path.GetFileName( oldPath ); <br /> <br /> // if the file name is changed <br /> if (!String.Equals( oldName, newName, StringComparison.CurrentCulture )) <br /> { <br /> string folder = Path.GetDirectoryName( oldPath ); <br /> string newPath = Path.Combine( folder, newName ); <br /> bool changeCase = String.Equals( oldName, newName, StringComparison.CurrentCultureIgnoreCase ); <br /> <br /> // if renamed file already exists and not just changing case <br /> if (File.Exists( newPath ) && !changeCase) <br /> { <br /> throw new IOException( String.Format( "File already exists:\n{0}", newPath ) ); <br /> } <br /> else if (changeCase) <br /> { <br /> // Move fails when changing case, so need to perform two moves <br /> string tempPath = Path.Combine( folder, Guid.NewGuid().ToString() ); <br /> Directory.Move( oldPath, tempPath ); <br /> Directory.Move( tempPath, newPath ); <br /> } <br /> else<br /> { <br /> Directory.Move( oldPath, newPath ); <br /> } <br /> } <br />}Mayank Agarwalhttp://www.blogger.com/profile/00164092452683371475noreply@blogger.com0tag:blogger.com,1999:blog-1200192102127529166.post-36929910416598513322011-06-02T05:48:00.000-07:002011-06-02T05:49:10.907-07:00There are a number of documented and undocumented system stored procedures in MS SQL Server that are helpful for every web developer working with databases. From the developer’s perspective, here’s a list of 5 System stored procedures that are my favorite.<br /><br /> <br /><br />1. sp_help<br /><br /> <br /><br />Purpose<br /><br /> <br /><br />sp_help gives information about database objects. If you wanted to quickly know the structure of a table but are too lazy to look for the schema diagram or to dig for the table you are interested in within the Object explorer, sp_help is here to help<br /><br /> <br /><br />Syntax<br /><br /> <br /><br />It can be used without parameters to get the information of objects in the database.<br /><br /> <br /><br />sp_help<br /><br /> <br /><br />It can be used with a parameter to get the information of a particular object<br /><br /> <br /><br />sp_help <Name of the object><br /><br /> <br /><br />Example<br /><br /> <br /><br />sp_help 'dbo.tblCompany'<br /><br /> <br /><br /> <br /><br /><br />2. sp_helptext<br /><br /> <br /><br />Purpose<br /><br /> <br /><br />sp_help gives definition information of objects such as system stored procedures, user defined stored procedures, user defined functions, triggers etc.<br /><br /> <br /><br />Syntax<br /><br /> <br /><br />sp_helptext <Name of the object><br /><br /> <br /><br />Example<br /><br /> <br /><br />sp_helptext 'dbo.sp_tblCompany'<br /><br /> <br /><br /><br />3. sp_MSforeachtable<br /><br /> <br /><br />Purpose<br /><br /> <br /><br />This is a very useful stored procedure for executing a command for ALL the tables in the database. Say you wanted to get the number of rows in all the tables in your database, you could write<br /><br /> <br /><br />Example<br /><br /> <br /><br />EXEC sp_MSforeachtable 'SELECT ''?'', COUNT(*) FROM ?'<br /><br /> <br /><br />The literal ? is used as a token to replace the table name.<br /><br /> <br /><br />4. sp_depends<br /><br /> <br /><br />Purpose<br /><br /> <br /><br />Ever wanted to make a change to a table but were not sure what other objects are dependent on this table? There could be views or stored procedures that could break due to this change. In situations like this, sp_depends come to the rescue.<br /><br /> <br /><br />Syntax<br /><br />sp_depends <Name of the object><br /><br /> <br /><br />Example<br /><br /> <br /><br />sp_depends 'dbo.tblCompany'<br /><br /> <br /><br /><br />5. sp_spaceused<br /><br /> <br /><br />Purpose<br /><br /> <br /><br />This is a simple stored procedure that gives information on the size of the database or the database objects<br /><br /> <br /><br />Syntax<br /><br /> <br /><br />If it is used without parameters, it would return the database information<br /><br /> <br /><br />sp_spaceused<br /><br /> <br /><br />If it is used with a parameter, it would return the information on the object<br /><br /> <br /><br />sp_spaceused <Name of the object><br /><br /> <br /><br />Example<br /><br /> <br /><br />sp_spaceused 'dbo.tblCompany'Mayank Agarwalhttp://www.blogger.com/profile/00164092452683371475noreply@blogger.com0