tag:blogger.com,1999:blog-42225427241182583612024-03-12T20:51:07.974-07:00SANDEEP YADAV"Nothing is impossible, the word itself says "I'm possible"!"Sandeep Yadav 95 60 554 552http://www.blogger.com/profile/16505852171584163288noreply@blogger.comBlogger92125tag:blogger.com,1999:blog-4222542724118258361.post-37482245816652416822015-12-19T06:05:00.001-08:002015-12-19T06:05:15.684-08:00Print Screen Of Windows Form<div dir="ltr" style="text-align: left;" trbidi="on">
Declare Auto Function SendMessage Lib "user32" ( _<br />
ByVal hWnd As IntPtr, _<br />
ByVal Msg As Integer, _<br />
ByVal wParam As IntPtr, _<br />
ByVal lParam As Integer) As Integer<br />
Private Enum EDrawingOptions As Integer<br />
PRF_CHECKVISIBLE = &H1<br />
PRF_NONCLIENT = &H2<br />
PRF_CLIENT = &H4<br />
PRF_ERASEBKGND = &H8<br />
PRF_CHILDREN = &H10<br />
PRF_OWNED = &H20<br />
End Enum<br />
Private Sub Button6_Click(ByVal sender As System.Object, _<br />
ByVal e As System.EventArgs) Handles Button6.Click<br />
Const WM_PRINT As Integer = &H317<br />
Dim myBmp As Bitmap<br />
Dim myGraphics As Graphics<br />
Dim hdc As System.IntPtr<br />
myBmp = New Bitmap( _<br />
Me.DisplayRectangle.Width, _<br />
Me.DisplayRectangle.Height)<br />
myGraphics = Graphics.FromImage(myBmp)<br />
hdc = myGraphics.GetHdc<br />
Call SendMessage(Me.Handle, WM_PRINT, hdc, _<br />
EDrawingOptions.PRF_CHILDREN Or _<br />
EDrawingOptions.PRF_CLIENT Or _<br />
EDrawingOptions.PRF_NONCLIENT Or _<br />
EDrawingOptions.PRF_OWNED)<br />
myGraphics.ReleaseHdc(hdc)<br />
myBmp.Save("D:\out.bmp")<br />
myGraphics.Dispose()<br />
myGraphics = Nothing<br />
myBmp = Nothing<br />
End Sub</div>
Sandeep Yadav 95 60 554 552http://www.blogger.com/profile/16505852171584163288noreply@blogger.com0tag:blogger.com,1999:blog-4222542724118258361.post-12812883493594447152014-12-26T04:22:00.003-08:002014-12-26T04:29:01.840-08:00SQL Server Functions that helps to convert date and time values to and from string literals and other date and time formats.<div dir="ltr" style="text-align: left;" trbidi="on">
<div align="center">
<table border="1" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="background: white; border-collapse: collapse; border: none; mso-border-bottom-alt: outset windowtext .25pt; mso-border-left-alt: solid #CCCCCC .75pt; mso-border-right-alt: outset windowtext .25pt; mso-border-top-alt: solid #CCCCCC .75pt; mso-padding-alt: 0in 0in 0in 0in; mso-yfti-tbllook: 1184; width: 369px;">
<thead>
<tr style="height: 12.75pt; mso-yfti-firstrow: yes; mso-yfti-irow: 0;">
<td style="background: #EBF6FF; border-bottom: solid #CCCCCC; border-left: inset; border-right: solid #CCCCCC; border-top: inset; border-width: 1.0pt; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 80.75pt;" width="108">
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<b><span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";">Function Name<o:p></o:p></span></b></div>
</td>
<td style="background: #EBF6FF; border-bottom: solid #CCCCCC 1.0pt; border-left: none; border-right: solid #CCCCCC 1.0pt; border-top: inset 1.0pt; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 29.45pt;" width="39">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<b><span style="border: none windowtext 1.0pt; color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">2000</span></b><b><span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></b></div>
</td>
<td style="background: #EBF6FF; border-bottom: solid #CCCCCC 1.0pt; border-left: none; border-right: solid #CCCCCC 1.0pt; border-top: inset 1.0pt; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 32.1pt;" width="43">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<b><span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";">2005<o:p></o:p></span></b></div>
</td>
<td style="background: #EBF6FF; border-bottom: solid #CCCCCC 1.0pt; border-left: none; border-right: solid #CCCCCC 1.0pt; border-top: inset 1.0pt; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 32.1pt;" width="43">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<b><span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";">2008<o:p></o:p></span></b></div>
</td>
<td style="background: #EBF6FF; border-bottom: solid #CCCCCC 1.0pt; border-left: none; border-right: solid #CCCCCC 1.0pt; border-top: inset 1.0pt; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 37.6pt;" width="50">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<b><span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";">2008 R2<o:p></o:p></span></b></div>
</td>
<td style="background: #EBF6FF; border-bottom: solid #CCCCCC 1.0pt; border-left: none; border-right: solid #CCCCCC 1.0pt; border-top: inset 1.0pt; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 65.1pt;" width="87">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<b><span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";">2012<o:p></o:p></span></b></div>
</td>
</tr>
</thead>
<tbody>
<tr style="height: 12.75pt; mso-yfti-irow: 1;">
<td style="border-bottom: solid #CCCCCC 1.0pt; border-left: inset 1.0pt; border-right: solid #CCCCCC 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 80.75pt;" width="108">
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><a href="http://www.codeproject.com/Articles/576178/cast-convert-format-try-parse-date-and-time-sql#1"><span style="color: purple; mso-bidi-font-size: 11.0pt; text-decoration: none; text-underline: none;">CAST()</span></a> <o:p></o:p></span></div>
</td>
<td style="border-bottom: solid #CCCCCC 1.0pt; border-left: none; border-right: solid #CCCCCC 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 29.45pt;" width="39">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="border: none windowtext 1.0pt; color: green; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">Y</span><span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid #CCCCCC 1.0pt; border-left: none; border-right: solid #CCCCCC 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 32.1pt;" width="43">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="border: none windowtext 1.0pt; color: green; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">Y</span><span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid #CCCCCC 1.0pt; border-left: none; border-right: solid #CCCCCC 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 32.1pt;" width="43">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="border: none windowtext 1.0pt; color: green; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">Y</span><span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid #CCCCCC 1.0pt; border-left: none; border-right: solid #CCCCCC 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 37.6pt;" width="50">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="border: none windowtext 1.0pt; color: green; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">Y</span><span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid #CCCCCC 1.0pt; border-left: none; border-right: solid #CCCCCC 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 65.1pt;" width="87">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="border: none windowtext 1.0pt; color: green; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">Y</span><span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
</td>
</tr>
<tr style="height: 12.75pt; mso-yfti-irow: 2;">
<td style="border-bottom: solid #CCCCCC 1.0pt; border-left: inset 1.0pt; border-right: solid #CCCCCC 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 80.75pt;" width="108">
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><a href="http://www.codeproject.com/Articles/576178/cast-convert-format-try-parse-date-and-time-sql#2"><span style="color: purple; mso-bidi-font-size: 11.0pt; text-decoration: none; text-underline: none;">CONVERT()</span></a> <o:p></o:p></span></div>
</td>
<td style="border-bottom: solid #CCCCCC 1.0pt; border-left: none; border-right: solid #CCCCCC 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 29.45pt;" width="39">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="border: none windowtext 1.0pt; color: green; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">Y</span><span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid #CCCCCC 1.0pt; border-left: none; border-right: solid #CCCCCC 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 32.1pt;" width="43">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="border: none windowtext 1.0pt; color: green; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">Y</span><span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid #CCCCCC 1.0pt; border-left: none; border-right: solid #CCCCCC 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 32.1pt;" width="43">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="border: none windowtext 1.0pt; color: green; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">Y</span><span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid #CCCCCC 1.0pt; border-left: none; border-right: solid #CCCCCC 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 37.6pt;" width="50">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="border: none windowtext 1.0pt; color: green; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">Y</span><span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid #CCCCCC 1.0pt; border-left: none; border-right: solid #CCCCCC 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 65.1pt;" width="87">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="border: none windowtext 1.0pt; color: green; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">Y</span><span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
</td>
</tr>
<tr style="height: 12.75pt; mso-yfti-irow: 3;">
<td style="border-bottom: solid #CCCCCC 1.0pt; border-left: inset 1.0pt; border-right: solid #CCCCCC 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 80.75pt;" width="108">
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><a href="http://www.codeproject.com/Articles/576178/cast-convert-format-try-parse-date-and-time-sql#3"><span style="color: purple; mso-bidi-font-size: 11.0pt; text-decoration: none; text-underline: none;">FORMAT()</span></a><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid #CCCCCC 1.0pt; border-left: none; border-right: solid #CCCCCC 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 29.45pt;" width="39">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="border: none windowtext 1.0pt; color: red; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">N</span><span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid #CCCCCC 1.0pt; border-left: none; border-right: solid #CCCCCC 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 32.1pt;" width="43">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="border: none windowtext 1.0pt; color: red; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">N</span><span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid #CCCCCC 1.0pt; border-left: none; border-right: solid #CCCCCC 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 32.1pt;" width="43">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="border: none windowtext 1.0pt; color: red; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">N</span><span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid #CCCCCC 1.0pt; border-left: none; border-right: solid #CCCCCC 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 37.6pt;" width="50">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="border: none windowtext 1.0pt; color: red; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">N</span><span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid #CCCCCC 1.0pt; border-left: none; border-right: solid #CCCCCC 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 65.1pt;" width="87">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="border: none windowtext 1.0pt; color: green; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">Y</span><span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
</td>
</tr>
<tr style="height: 12.75pt; mso-yfti-irow: 4;">
<td style="border-bottom: solid #CCCCCC 1.0pt; border-left: inset 1.0pt; border-right: solid #CCCCCC 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 80.75pt;" width="108">
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><a href="http://www.codeproject.com/Articles/576178/cast-convert-format-try-parse-date-and-time-sql#4"><span style="color: purple; mso-bidi-font-size: 11.0pt; text-decoration: none; text-underline: none;">PARSE()</span></a><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid #CCCCCC 1.0pt; border-left: none; border-right: solid #CCCCCC 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 29.45pt;" width="39">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="border: none windowtext 1.0pt; color: red; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">N</span><span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid #CCCCCC 1.0pt; border-left: none; border-right: solid #CCCCCC 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 32.1pt;" width="43">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="border: none windowtext 1.0pt; color: red; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">N</span><span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid #CCCCCC 1.0pt; border-left: none; border-right: solid #CCCCCC 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 32.1pt;" width="43">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="border: none windowtext 1.0pt; color: red; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">N</span><span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid #CCCCCC 1.0pt; border-left: none; border-right: solid #CCCCCC 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 37.6pt;" width="50">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="border: none windowtext 1.0pt; color: red; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">N</span><span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid #CCCCCC 1.0pt; border-left: none; border-right: solid #CCCCCC 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 65.1pt;" width="87">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="border: none windowtext 1.0pt; color: green; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">Y</span><span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
</td>
</tr>
<tr style="height: 12.75pt; mso-yfti-irow: 5;">
<td style="border-bottom: solid #CCCCCC 1.0pt; border-left: inset 1.0pt; border-right: solid #CCCCCC 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 80.75pt;" width="108">
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><a href="http://www.codeproject.com/Articles/576178/cast-convert-format-try-parse-date-and-time-sql#5"><span style="color: purple; mso-bidi-font-size: 11.0pt; text-decoration: none; text-underline: none;">TRY_PARSE()</span></a> <o:p></o:p></span></div>
</td>
<td style="border-bottom: solid #CCCCCC 1.0pt; border-left: none; border-right: solid #CCCCCC 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 29.45pt;" width="39">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="border: none windowtext 1.0pt; color: red; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">N</span><span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid #CCCCCC 1.0pt; border-left: none; border-right: solid #CCCCCC 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 32.1pt;" width="43">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="border: none windowtext 1.0pt; color: red; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">N</span><span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid #CCCCCC 1.0pt; border-left: none; border-right: solid #CCCCCC 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 32.1pt;" width="43">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="border: none windowtext 1.0pt; color: red; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">N</span><span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid #CCCCCC 1.0pt; border-left: none; border-right: solid #CCCCCC 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 37.6pt;" width="50">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="border: none windowtext 1.0pt; color: red; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">N</span><span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid #CCCCCC 1.0pt; border-left: none; border-right: solid #CCCCCC 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 65.1pt;" width="87">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="border: none windowtext 1.0pt; color: green; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">Y</span><span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
</td>
</tr>
<tr style="height: 12.75pt; mso-yfti-irow: 6; mso-yfti-lastrow: yes;">
<td style="border-bottom: solid #CCCCCC 1.0pt; border-left: inset 1.0pt; border-right: solid #CCCCCC 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 80.75pt;" width="108">
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><a href="http://www.codeproject.com/Articles/576178/cast-convert-format-try-parse-date-and-time-sql#6"><span style="color: purple; mso-bidi-font-size: 11.0pt; text-decoration: none; text-underline: none;">TRY_CONVERT()</span></a><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid #CCCCCC 1.0pt; border-left: none; border-right: solid #CCCCCC 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 29.45pt;" width="39">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="border: none windowtext 1.0pt; color: red; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">N</span><span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid #CCCCCC 1.0pt; border-left: none; border-right: solid #CCCCCC 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 32.1pt;" width="43">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="border: none windowtext 1.0pt; color: red; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">N</span><span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid #CCCCCC 1.0pt; border-left: none; border-right: solid #CCCCCC 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 32.1pt;" width="43">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="border: none windowtext 1.0pt; color: red; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">N</span><span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid #CCCCCC 1.0pt; border-left: none; border-right: solid #CCCCCC 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 37.6pt;" width="50">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="border: none windowtext 1.0pt; color: red; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">N</span><span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid #CCCCCC 1.0pt; border-left: none; border-right: solid #CCCCCC 1.0pt; border-top: none; height: 12.75pt; mso-border-bottom-alt: solid #CCCCCC .75pt; mso-border-left-alt: inset windowtext .25pt; mso-border-left-alt: inset windowtext .25pt; mso-border-right-alt: solid #CCCCCC .75pt; mso-border-top-alt: inset windowtext .25pt; mso-border-top-alt: inset windowtext .25pt; padding: 3.75pt 3.75pt 3.75pt 3.75pt; width: 65.1pt;" width="87">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="border: none windowtext 1.0pt; color: green; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">Y</span><span style="color: #111111; font-family: "Segoe UI","sans-serif"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
</td>
</tr>
</tbody></table>
</div>
</div>
Sandeep Yadav 95 60 554 552http://www.blogger.com/profile/16505852171584163288noreply@blogger.com0tag:blogger.com,1999:blog-4222542724118258361.post-9661236766407438192014-08-13T22:35:00.001-07:002014-08-13T22:35:20.025-07:00CentOS 5 Installation<div dir="ltr" style="text-align: left;" trbidi="on">
http://www.slideshare.net/search/slideshow?searchfrom=header&q=centos</div>
Sandeep Yadav 95 60 554 552http://www.blogger.com/profile/16505852171584163288noreply@blogger.com0tag:blogger.com,1999:blog-4222542724118258361.post-49247811532482110832014-07-30T03:25:00.003-07:002014-07-30T03:25:54.949-07:00Scan Document using vb.net code<div dir="ltr" style="text-align: left;" trbidi="on">
Private Sub btnScanPage_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnScanPage.Click<br />
btnScanPage.Text = "Scanning Page, Please wait..."<br />
Me.Cursor = Cursors.WaitCursor<br />
If scan() = True Then<br />
btnScanPage.Text = "Scan Page"<br />
UgcDetails.lstattach.Items.Add(fileName)<br />
Me.Cursor = Cursors.Default<br />
Me.Close()<br />
Me.Dispose()<br />
End If<br />
End Sub<br />
-------------------------------------------------------------------<br />
--------------------------------Function scan-------------------<br />
Private Function scan() As Boolean<br />
Try<br />
Dim commonDialogClass As New CommonDialogClass()<br />
Dim scannerDevice As Device = commonDialogClass.ShowSelectDevice(WiaDeviceType.ScannerDeviceType, False, False)<br />
If scannerDevice IsNot Nothing Then<br />
Dim scannnerItem As Item = scannerDevice.Items(1)<br />
AdjustScannerSettings(scannnerItem, 100, 0, 0, 850, 1150, 0, 0)<br />
Dim scanResult As Object = commonDialogClass.ShowTransfer(scannnerItem, WIA.FormatID.wiaFormatPNG, False)<br />
If scanResult IsNot Nothing Then<br />
Dim image As ImageFile = DirectCast(scanResult, ImageFile)<br />
Dim path1 As String = "D:\scan\" & Me.Tag & "\"<br />
My.Computer.FileSystem.CreateDirectory(path1)<br />
fileName = path1 & Now.ToString.Replace("/", "").Replace("-", "").Replace(":", "") & ".jpg"<br />
If SaveImageToFile(image, fileName) = True Then<br />
PictureBox1.ImageLocation = fileName<br />
Return True<br />
End If<br />
End If<br />
End If<br />
Catch ex As Exception<br />
Return False<br />
End Try<br />
End Function</div>
Sandeep Yadav 95 60 554 552http://www.blogger.com/profile/16505852171584163288noreply@blogger.com0tag:blogger.com,1999:blog-4222542724118258361.post-37495119151864294642014-07-29T05:15:00.004-07:002014-07-29T05:15:58.733-07:00Add multiply Files at List box <div dir="ltr" style="text-align: left;" trbidi="on">
OpenFileDialog1.Multiselect = True<br />
OpenFileDialog1.Title = "Attach File"<br />
OpenFileDialog1.Filter = "All Files|*.*"<br />
If OpenFileDialog1.ShowDialog() = System.Windows.Forms.DialogResult.OK Then<br />
For Each fname As String In OpenFileDialog1.FileNames<br />
lstattach.Items.Add(fname)<br />
Next<br />
End If</div>
Sandeep Yadav 95 60 554 552http://www.blogger.com/profile/16505852171584163288noreply@blogger.com0tag:blogger.com,1999:blog-4222542724118258361.post-76141620630854165132014-07-17T04:14:00.002-07:002014-07-17T04:14:36.364-07:00For SMS<div dir="ltr" style="text-align: left;" trbidi="on">
If Len(smscelno) = 10 Then<br />
Dim convid As String = txtstate.Tag & "-" & Me.Tag<br />
Dim smstxt As String = "Your complaint has been successfully registered.Your complaint No is " & convid " &<br />
WebBrowsersms.Navigate("http://?uname= & pass= & send= & dest=91" & smscelno & "&msg=" & smstxt)<br />
Do Until WebBrowsersms.ReadyState = WebBrowserReadyState.Complete<br />
Application.DoEvents()<br />
Loop<br />
End If</div>
Sandeep Yadav 95 60 554 552http://www.blogger.com/profile/16505852171584163288noreply@blogger.com0tag:blogger.com,1999:blog-4222542724118258361.post-4668764817873207192014-07-04T04:42:00.002-07:002014-07-04T04:42:53.558-07:00How, can i get forms name from vb.net ?<div dir="ltr" style="text-align: left;" trbidi="on">
private sub proshowformnames()<br />
For Each FRM As Form In Application.OpenForms<br />
MsgBox(FRM.Name)<br />
Next<br />
end sub<br />
<div>
<br /></div>
</div>
Sandeep Yadav 95 60 554 552http://www.blogger.com/profile/16505852171584163288noreply@blogger.com0tag:blogger.com,1999:blog-4222542724118258361.post-65075734004615598692014-04-04T02:01:00.002-07:002014-04-04T02:01:52.803-07:00Read & Write Txt File in vb.net<div dir="ltr" style="text-align: left;" trbidi="on">
Add class form in vb.net project<br />
<br />
Imports System<br />
Imports System.IO<br />
Imports System.Text<br />
Imports System.Collections.Generic<br />
Imports Scripting<br />
Public Class Testwrite<br />
Public Sub DeleteFile(ByVal mydocpath As String, ByVal filename As String)<br />
Dim fso As FileSystemObject = New FileSystemObject<br />
If fso.FileExists(mydocpath + "\" & filename & ".set") = True Then<br />
fso.DeleteFile(mydocpath + "\" & filename & ".set", True)<br />
End If<br />
End Sub<br />
Public Sub WriteToFile(ByVal mydocpath As String, ByVal filename As String, ByVal datastring As String)<br />
Dim sb As New StringBuilder()<br />
sb.AppendLine(datastring)<br />
Using outfile As StreamWriter = New StreamWriter(mydocpath + "\" & filename & ".Txt", True)<br />
outfile.Write(sb.ToString())<br />
End Using<br />
End Sub<br />
Public Function ReadFromSetFile(ByVal mydocpath As String, ByVal filename As String, ByVal key As String) As String<br />
Dim txtbox As String = Nothing<br />
Try<br />
Using sr As StreamReader = New StreamReader(mydocpath + "\" & filename & ".set")<br />
While Not sr.EndOfStream<br />
Dim line = sr.ReadLine()<br />
Dim seppos As Integer = InStr(line, "|")<br />
If seppos > 0 Then<br />
If line Like key & "*" Then<br />
txtbox = Trim(Mid(line, seppos + 1))<br />
Exit While<br />
End If<br />
End If<br />
End While<br />
End Using<br />
Catch ex As Exception<br />
txtbox = ""<br />
End Try<br />
Return txtbox<br />
End Function<br />
Public Function ReadFromFile(ByVal mydocpath As String, ByVal title As Boolean) As String<br />
Dim line As String = Nothing<br />
Try<br />
Using sr As StreamReader = New StreamReader(mydocpath)<br />
If title = True Then<br />
line = sr.ReadLine<br />
line = Nothing<br />
End If<br />
While Not sr.EndOfStream<br />
line = sr.ReadLine()<br />
End While<br />
End Using<br />
Catch<br />
line = ""<br />
End Try<br />
Return line<br />
End Function<br />
End Class<br />
<div>
<br /></div>
</div>
Sandeep Yadav 95 60 554 552http://www.blogger.com/profile/16505852171584163288noreply@blogger.com0tag:blogger.com,1999:blog-4222542724118258361.post-48520251790415141322014-04-02T02:21:00.002-07:002014-04-02T02:21:59.326-07:00Remove Last Character From String <div dir="ltr" style="text-align: left;" trbidi="on">
Dim str As String<br />
str = TextBox1.Text<br />
str = str.Remove(str.Length - 1)<br />
MsgBox(str)</div>
Sandeep Yadav 95 60 554 552http://www.blogger.com/profile/16505852171584163288noreply@blogger.com0tag:blogger.com,1999:blog-4222542724118258361.post-80228569259855311762014-03-29T03:39:00.001-07:002014-03-29T03:39:58.439-07:00Check And Uncheck DataGridView Cell<div dir="ltr" style="text-align: left;" trbidi="on">
If DataGridView1.Rows(e.RowIndex).Cells(e.ColumnIndex).Value = "P" Then<br />
DataGridView1.Rows(e.RowIndex).Cells(e.ColumnIndex).Value = ""<br />
Else<br />
DataGridView1.Rows(e.RowIndex).Cells(e.ColumnIndex).Style.Font = New Font("Wingdings 2", 14, FontStyle.Bold)<br />
DataGridView1.Rows(e.RowIndex).Cells(e.ColumnIndex).Value = "P"<br />
End If</div>
Sandeep Yadav 95 60 554 552http://www.blogger.com/profile/16505852171584163288noreply@blogger.com0tag:blogger.com,1999:blog-4222542724118258361.post-62189790995028531232014-03-24T22:51:00.001-07:002014-03-24T22:52:54.008-07:00insert update using db class <div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr" style="text-align: left;" trbidi="on">
Frist add --- app.config<br />
and write the code under app.config------<br />
------------------------------<br />
<appsettings p=""> <add key="cont1" p="" value="server=.;trusted_connection=yes;database=stest"><appsettings></appsettings></add></appsettings>[appSettings ]<br />
[add key ="cont1" value ="server=.;trusted_connection=yes;database=stest" /]<br />
[/appSettings]<br />
<appsettings p=""><add key="cont1" p="" value="server=.;trusted_connection=yes;database=stest">
</add></appsettings> ------------------------------</div>
###############write the code under db class################<br />
Imports System.Data<br />
Imports System.Data.SqlClient<br />
Imports System.Configuration<br />
Public Class db<br />
Public cont As String = ConfigurationSettings.AppSettings("cont1")<br />
<br />
Public Function getdata(ByVal myqry As String) As DataTable 'This function use getdata from db<br />
<br />
Dim cn As New SqlConnection(cont)<br />
Dim ds As New DataSet<br />
Dim td As New DataTable<br />
Try<br />
Dim da As New SqlDataAdapter(myqry, cn)<br />
da.Fill(ds)<br />
td = ds.Tables(0)<br />
Catch ex As Exception<br />
End Try<br />
Return td<br />
End Function<br />
<br />
Public Function excute(ByVal myqry As String) As Boolean 'This function insert,update data in to db<br />
<br />
Dim cn As New SqlConnection(cont)<br />
Dim ds As New DataSet<br />
Try<br />
Dim da As New SqlDataAdapter(myqry, cn)<br />
da.Fill(ds)<br />
Catch ex As Exception<br />
MsgBox(ex.Message)<br />
Return False<br />
End Try<br />
Return True<br />
End Function<br />
End Class<br />
###############################################<br />
<br /></div>
Sandeep Yadav 95 60 554 552http://www.blogger.com/profile/16505852171584163288noreply@blogger.com0tag:blogger.com,1999:blog-4222542724118258361.post-88405543573108159342014-03-22T01:49:00.001-07:002014-03-22T01:49:04.908-07:00open image in picturebox in vb.net<div dir="ltr" style="text-align: left;" trbidi="on">
Dim open As New OpenFileDialog()<br />
open.Filter = "Image Files(*.png; *.jpg; *.bmp)|*.png; *.jpg; *.bmp"<br />
If open.ShowDialog() = DialogResult.OK Then<br />
Dim fileName As String = System.IO.Path.GetFullPath(open.FileName)<br />
PictureBox1.Image = New Bitmap(open.FileName)<br />
Me.PictureBox1.SizeMode = System.Windows.Forms.PictureBoxSizeMode.Zoom<br />
End If</div>
Sandeep Yadav 95 60 554 552http://www.blogger.com/profile/16505852171584163288noreply@blogger.com0tag:blogger.com,1999:blog-4222542724118258361.post-21626754205536436342014-03-11T02:54:00.002-07:002014-03-11T02:54:28.228-07:00click first column content in datagridview vb.net<div dir="ltr" style="text-align: left;" trbidi="on">
If gridshot.Columns(e.ColumnIndex).Name = "Select" Then<br /></div>
Sandeep Yadav 95 60 554 552http://www.blogger.com/profile/16505852171584163288noreply@blogger.com0tag:blogger.com,1999:blog-4222542724118258361.post-91732266095905844492014-03-11T02:43:00.001-07:002014-03-11T02:43:06.255-07:00Do not Allow Sorting in Data Grid View<div dir="ltr" style="text-align: left;" trbidi="on">
Private Sub gridshot_ColumnAdded(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewColumnEventArgs) Handles gridshot.ColumnAdded<br /> gridshot.Columns.Item(e.Column.Index).SortMode = DataGridViewColumnSortMode.NotSortable<br /> End Sub</div>
Sandeep Yadav 95 60 554 552http://www.blogger.com/profile/16505852171584163288noreply@blogger.com0tag:blogger.com,1999:blog-4222542724118258361.post-58293019481265711532014-02-12T04:23:00.003-08:002014-02-12T04:23:46.437-08:00Get Day of Week in SQL 2005/2008<div dir="ltr" style="text-align: left;" trbidi="on">
select DATENAME(dw,comtype) AS OrderDay from tblcom_type where s_no=6<br />
--Result Friday<br />
<div>
<br /></div>
</div>
Sandeep Yadav 95 60 554 552http://www.blogger.com/profile/16505852171584163288noreply@blogger.com0tag:blogger.com,1999:blog-4222542724118258361.post-82146753465977612052014-01-31T20:32:00.002-08:002014-01-31T20:32:30.193-08:00Not allowed special character in vb.net<div dir="ltr" style="text-align: left;" trbidi="on">
Private Sub txtto_KeyPress(ByVal sender As System.Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtto.KeyPress<br />
Dim ValidInputChar = "#$%^&*,;()[]+{}:'`<>?|~!\/"<br />
If ValidInputChar.Contains(e.KeyChar) Then<br />
e.KeyChar = Nothing<br />
End If<br />
End Sub</div>
Sandeep Yadav 95 60 554 552http://www.blogger.com/profile/16505852171584163288noreply@blogger.com0tag:blogger.com,1999:blog-4222542724118258361.post-57761751836028145002013-12-26T10:08:00.000-08:002013-12-26T10:08:12.355-08:00Get Date in SQL Function<div dir="ltr" style="text-align: left;" trbidi="on">
select day(GETDATE()-10) Result -- 16<br />
select month(GETDATE()) Result -- 12<br />
<br />
select convert(varchar(11), getdate(),100) Result -- Dec 26 2013<br />
select convert(varchar(11), getdate(),110) Result -- 12-26-2013<br />
select convert(varchar(11), getdate(),120) Result -- 2013-12-26<br />
<div>
<br /></div>
</div>
Sandeep Yadav 95 60 554 552http://www.blogger.com/profile/16505852171584163288noreply@blogger.com0tag:blogger.com,1999:blog-4222542724118258361.post-7919515764751616012013-12-20T00:27:00.001-08:002013-12-20T00:27:56.488-08:00Create Excel File in vb.net<div dir="ltr" style="text-align: left;" trbidi="on">
Private Sub cmdexcel_Click()<br />
Dim xlapp As Excel.Application<br />
Dim xlbook As Excel.Workbook<br />
Dim xlsheet As Excel.Worksheet<br />
<br />
Dim row As Long<br />
Set xlapp = New Excel.Application<br />
Set xlbook = xlapp.Workbooks.Add<br />
Set xlsheet = xlbook.Worksheets(1)<br />
row = 4<br />
With xlsheet<br />
<br />
If optdatewise.Value = True Then<br />
.Cells(1, 1) = "Report of Complaints"<br />
.Cells(2, 1) = "Date : " & Format(date1.Value, "dd/MMM/yyyy") & " To : " & Format(date2.Value, "dd/MMM/yyyy")<br />
.Rows(2).Font.Bold = True<br />
.Rows(2).Font.Size = 12<br />
Else<br />
.Cells(1, 1) = "Report of Complaints Received Till '" & Now() & "'"<br />
End If<br />
.Rows(1).Font.Bold = True<br />
.Rows(1).Font.Size = 18<br />
<br />
.Cells(3, 1) = "Total Number Of Complaints: "<br />
.Rows(3).Font.Bold = True<br />
.Rows(3).Font.Size = 18<br />
<br />
.Columns(1).ColumnWidth = 9<br />
.Columns(2).ColumnWidth = 12<br />
.Columns(3).ColumnWidth = 11<br />
.Columns(4).ColumnWidth = 11<br />
.Columns(5).ColumnWidth = 15<br />
.Columns(6).ColumnWidth = 12<br />
.Columns(7).ColumnWidth = 12<br />
.Columns(8).ColumnWidth = 15<br />
.Columns(9).ColumnWidth = 18<br />
.Columns(10).ColumnWidth = 21<br />
<br />
.Rows(row).Font.Bold = True<br />
For i = 0 To grid.Rows - 1<br />
For j = 1 To grid.Cols - 1<br />
If j = 2 And i > 0 Then<br />
.Cells(row, j).Select<br />
xlapp.ActiveSheet.Hyperlinks.Add Anchor:=xlapp.Selection, Address:=mpath & "\Log Files\" & grid.TextMatrix(i, j) & "\Log.doc", TextToDisplay:=grid.TextMatrix(i, j)<br />
Else<br />
.Cells(row, j) = grid.TextMatrix(i, j)<br />
End If<br />
.Rows.Font.Name = "Centaur"<br />
.Rows(row).WrapText = True<br />
Next<br />
row = row + 1<br />
Next<br />
.Cells(3, 1) = .Cells(3, 1) & row - 5<br />
<br />
.Rows(4).AutoFilter<br />
.Rows(5).Activate<br />
xlapp.ActiveWindow.FreezePanes = True<br />
.PageSetup.LeftMargin = 1<br />
.PageSetup.RightMargin = 1<br />
.PageSetup.PrintGridlines = True<br />
.PageSetup.Orientation = xlLandscape<br />
.PageSetup.Zoom = 90<br />
.PageSetup.PrintTitleRows = "$4:$4"<br />
.PageSetup.CenterFooter = "&P of &N"<br />
<br />
xlapp.Visible = True<br />
End With<br />
End Sub</div>
Sandeep Yadav 95 60 554 552http://www.blogger.com/profile/16505852171584163288noreply@blogger.com0tag:blogger.com,1999:blog-4222542724118258361.post-43712207434522771352013-12-19T21:23:00.000-08:002013-12-19T21:24:25.023-08:00If string was found in the RichTextBox, High Light ,Replace , Skip ..<div dir="ltr" style="text-align: left;" trbidi="on">
Dim start As Integer = 0<br />
Dim indexOfSearchText As Integer = 0<br />
'********************Replace Select Use Replace btn****************<br />
Dim startindex As Integer = 0<br />
<br />
If txt_Name_Changed.Text.Length > 0 Then<br />
startindex = FindMyText(txt_Name_Changed.Text.Trim(), start, RichTextBox1.Text.Length)<br />
End If<br />
' If string was found in the RichTextBox, highlight it<br />
If startindex >= 0 Then<br />
' Set the highlight color as red<br />
RichTextBox1.SelectionBackColor = Color.Plum<br />
RichTextBox1.SelectedText = lblpname.Text<br />
' Find the end index. End Index = number of characters in textbox<br />
Dim endindex As Integer = txt_Name_Changed.Text.Length<br />
' Highlight the search string<br />
RichTextBox1.Select(startindex, endindex)<br />
' mark the start position after the position of last search string<br />
start = startindex + endindex<br />
End If<br />
<br />
'********************Skip ^^^ Use SKIP btn**************<br />
Dim startindex As Integer = 0<br />
If txt_Name_Changed.Text.Length > 0 Then<br />
startindex = FindMyText(txt_Name_Changed.Text.Trim(), start, RichTextBox1.Text.Length)<br />
End If<br />
If startindex >= 0 Then<br />
RichTextBox1.SelectionBackColor = Color.White<br />
Dim endindex As Integer = txt_Name_Changed.Text.Length<br />
RichTextBox1.Select(startindex, endindex)<br />
start = startindex + endindex<br />
End If<br />
<br />
**************** Function For Replace And Skip ***********************<br />
Public Function FindMyText(ByVal txtToSearch As String, ByVal searchStart As Integer, ByVal searchEnd As Integer) As Integer<br />
' Unselect the previously searched string<br />
' ''If searchStart > 0 AndAlso searchEnd > 0 AndAlso indexOfSearchText >= 0 Then<br />
' '' RichTextBox1.Undo()<br />
' ''End If<br />
' Set the return value to -1 by default.<br />
Dim retVal As Integer = -1<br />
' A valid starting index should be specified.<br />
' if indexOfSearchText = -1, the end of search<br />
If searchStart >= 0 AndAlso indexOfSearchText >= 0 Then<br />
' A valid ending index<br />
If searchEnd > searchStart OrElse searchEnd = -1 Then<br />
' Find the position of search string in RichTextBox<br />
indexOfSearchText = RichTextBox1.Find(txtToSearch, searchStart, searchEnd, RichTextBoxFinds.None)<br />
' Determine whether the text was found in richTextBox1.<br />
If indexOfSearchText <> -1 Then<br />
' Return the index to the specified search text.<br />
retVal = indexOfSearchText<br />
End If<br />
End If<br />
End If<br />
Return retVal<br />
End Function<br />
<br />
**************write TextChanged Event on Matching String Txt Box*******************<br />
Private Sub txt_Name_Changed_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles txt_Name_Changed.TextChanged<br />
start = 0<br />
indexOfSearchText = 0<br />
End Sub<br />
<br />
^^^^^^^^^^^^^^^^^^^If string was found in the RichTextBox, Then High Light .^^^^^^^^^^^^^^^^^^^<br />
Sub FindTxtInRTB() ' HighLight Search txt In RTF<br />
Dim srchterm As String = txt_Name_Changed.Text<br />
Dim index As Int32 = 0<br />
While index <> -1<br />
index = RichTextBox1.Find(srchterm, index, RichTextBoxFinds.None)<br />
If index <> -1 Then<br />
<br />
RichTextBox1.SelectionBackColor = Color.Orange<br />
index += 1<br />
End If<br />
End While<br />
RichTextBox1.DeselectAll()<br />
End Sub<br />
<br /></div>
Sandeep Yadav 95 60 554 552http://www.blogger.com/profile/16505852171584163288noreply@blogger.com0tag:blogger.com,1999:blog-4222542724118258361.post-34725482477019159642013-12-11T09:48:00.001-08:002013-12-11T09:48:16.341-08:00Find integer from string <div dir="ltr" style="text-align: left;" trbidi="on">
Dim Res As String<br />
Dim str As String = "Sandeep123Kumar"<br />
For Each c As Char In str<br />
If IsNumeric(c) Then<br />
Res = Res & c<br />
End If<br />
Next<br />
MessageBox.Show(Res)</div>
Sandeep Yadav 95 60 554 552http://www.blogger.com/profile/16505852171584163288noreply@blogger.com0tag:blogger.com,1999:blog-4222542724118258361.post-14133781846537594052013-12-04T01:04:00.001-08:002013-12-04T01:04:46.983-08:00Retrieve the ValueMember of the DisplayMember items in checklistbox<div dir="ltr" style="text-align: left;" trbidi="on">
Public Sub chklistbox()<br />
<br />
Dim dr As DataTable = objdb.getdata("select district_name,district_id from district_master where state_id='" & "9" & "'")<br />
If dr.Rows.Count > 0 Then<br />
CheckedListBox1.DataSource = dr<br />
CheckedListBox1.DisplayMember = "district_name"<br />
CheckedListBox1.ValueMember = "district_id"<br />
CheckedListBox1.Text = Nothing<br />
dr = Nothing<br />
Else<br />
CheckedListBox1.DataSource = Nothing<br />
CheckedListBox1.Text = Nothing<br />
End If<br />
End Sub<br />
<br />
<strong style="background-color: white; color: #505050; font-family: 'Segoe UI'; font-size: 13px;">when you assign properties value member and display member you can retrieve its value using :</strong><br />
<br />
Label9.Text = CheckBoxList1.SelectedItem.ToString()<br />
Label8.Text = CheckedListBox1.SelectedValue.ToString()</div>
Sandeep Yadav 95 60 554 552http://www.blogger.com/profile/16505852171584163288noreply@blogger.com0tag:blogger.com,1999:blog-4222542724118258361.post-44346862962832266622013-12-02T20:57:00.001-08:002013-12-04T03:37:06.030-08:00Select/UnSelect all items in checkboxlist in vb.net<div dir="ltr" style="text-align: left;" trbidi="on">
Private Sub chk_crimeName_ItemCheck(ByVal sender As System.Object, ByVal e As System.Windows.Forms.ItemCheckEventArgs) Handles chk_crimeName.ItemCheck<br />
<br />
<br />
If e.Index = 0 Then<br />
If e.NewValue = CheckState.Checked Then<br />
For i As Integer = 1 To chk_crimeName.Items.Count - 1<br />
chk_crimeName.SetItemCheckState(i, CheckState.Checked)<br />
Next<br />
ElseIf e.NewValue = CheckState.Unchecked Then<br />
For i As Integer = 1 To chk_crimeName.Items.Count - 1<br />
chk_crimeName.SetItemCheckState(i, CheckState.Unchecked)<br />
Next<br />
End If<br />
End If<br />
<br />
End Sub<br />
<br />
Select/UnSelect item of Listbox select On checkboxlist<br />
Dim item1 As String = chk_district.SelectedIndex<br />
If e.NewValue = CheckState.Checked Then<br />
ListBox1.SelectedIndex = e.Index<br />
Else<br />
ListBox1.SetSelected(e.Index, False)<br />
End If</div>
Sandeep Yadav 95 60 554 552http://www.blogger.com/profile/16505852171584163288noreply@blogger.com0tag:blogger.com,1999:blog-4222542724118258361.post-66774969154523590092013-11-28T03:59:00.001-08:002013-11-28T03:59:35.105-08:00Validate TxtBox For Mobile Number<div dir="ltr" style="text-align: left;" trbidi="on">
Private Sub TxtNo_KeyPress(ByVal sender As System.Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TxtNo.KeyPress<br />
If Asc(e.KeyChar) <> 8 Then<br />
If Asc(e.KeyChar) < 48 Or Asc(e.KeyChar) > 57 Or TxtNo.Text.Length > 9 Then<br />
e.Handled = True<br />
End If<br />
End If<br />
End Sub</div>
Sandeep Yadav 95 60 554 552http://www.blogger.com/profile/16505852171584163288noreply@blogger.com0tag:blogger.com,1999:blog-4222542724118258361.post-70118951975134562222013-11-26T04:34:00.000-08:002013-11-26T04:34:23.042-08:00Reset Identity Column Value to 1 in SQL Database<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div>
To reset identity column value and start value from “1” during insert new records we need to write query to reset identity column value. Check below Query</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<div>
DBCC CHECKIDENT (Table_Name, RESEED, New_Reseed_Value)</div>
<div>
<br /></div>
<div>
Table_Name is name of your identity column table</div>
<div>
<br /></div>
<div>
RESEED specifies that the current identity value should be changed.</div>
<div>
<br /></div>
<div>
New_Reseed_Value is the new value to use as the current value of the identity column. </div>
<div>
</div>
<div>
<br /></div>
<div>
EX: DBCC CHECKIDENT ('UserDetails', RESEED, 0)</div>
<div>
<br /></div>
<div>
Once we run the above query it will reset the identity column in UserDetails table and starts identity column value from “1”</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
</div>
</div>
Sandeep Yadav 95 60 554 552http://www.blogger.com/profile/16505852171584163288noreply@blogger.com0tag:blogger.com,1999:blog-4222542724118258361.post-37356079486439244562013-11-25T04:32:00.004-08:002013-11-25T04:32:55.645-08:00Create Word File in vb.net<div dir="ltr" style="text-align: left;" trbidi="on">
First Import NameSpace<br />
******************************************<br />
Imports Microsoft.Office.Interop.Word<br />
Imports Microsoft.Office.Interop<br />
*******************************************<br />
Public Sub createlog()<br />
Dim comtype1 As String<br />
Dim wrd As Word.Application<br />
Dim Doc As Word.Document<br />
wrd = CreateObject("Word.Application") 'Create Object<br />
Doc = wrd.Documents.Add()<br />
comtype1 = "-----BASIC COMPLAINT DETAILS-----"<br />
Dim strconnection As String = ConfigurationManager.ConnectionStrings("MyDb").ConnectionString<br />
cn = New SqlConnection(strconnection)<br />
da = New SqlDataAdapter("select * from call_description order by s_id desc", cn)<br />
ds = New DataSet<br />
da.Fill(ds)<br />
If ds.Tables(0).Rows.Count - 1 Then<br />
With Doc.Application<br />
.Selection.Font.Size = "10"<br />
.Selection.Font.Name = "Verdana"<br />
.Selection.Font.Color = &H4696F7 'Orange Color<br />
.Selection.Font.Bold = True<br />
.Selection.TypeText(Text:=comtype1 & vbCrLf)<br />
.Selection.ParagraphFormat.Alignment = WdParagraphAlignment.wdAlignParagraphJustify<br />
.Selection.Font.Bold = False<br />
.Selection.Font.Color = WdColor.wdColorBlack<br />
.Selection.TypeText(Text:="COMPLAINT REGISTERED THROUGH PHONE " & vbCrLf)<br />
.Selection.TypeText(Text:="SERIOUSNESS OF COMPLAINT: " & vbCrLf)<br />
.Selection.TypeText(Text:=ds.Tables(0).Rows(0).Item("call_type") & vbCrLf)<br />
.Selection.TypeText(Text:="COMPLAINT DATE: ")<br />
.Selection.TypeText(Text:=ds.Tables(0).Rows(0).Item("date_time") & vbCrLf)<br />
.Selection.TypeText(Text:="NAME OF VICTIM: ")<br />
.Selection.TypeText(Text:=ds.Tables(0).Rows(0).Item("VICTIM_NAME") & vbCrLf)<br />
.Selection.TypeText(Text:="STATE: ")<br />
.Selection.TypeText(Text:=ds.Tables(0).Rows(0).Item("State") & vbCrLf)<br />
.Selection.TypeText(Text:="COMPLAINT DETAILS: " & vbCrLf)<br />
.Selection.TypeText(Text:=Trim(removeextras(CStr(ds.Tables(0).Rows(0).Item("Call_descrip")), vbCrLf)))<br />
End With<br />
wrd.ActiveDocument.Protect(WdProtectionType.wdAllowOnlyFormFields, , "admin")<br />
wrd.ActiveDocument.SaveAs("C:\Documents and Settings\CLIENT4\My Documents\word\Log.doc")<br />
wrd.ActiveDocument.Close()<br />
wrd.Quit()<br />
' Doc = Nothing<br />
' wrd = Nothing<br />
End If<br />
End Sub<br />
**************************<br />
Function removeextras(ByVal sstring As String, ByVal delim As String) As String<br />
While (sstring Like "*" & delim & delim & "*")<br />
sstring = Replace(sstring, delim & delim, delim)<br />
End While<br />
removeextras = sstring<br />
End Function</div>
Sandeep Yadav 95 60 554 552http://www.blogger.com/profile/16505852171584163288noreply@blogger.com0