Saturday, 22 February 2014
Find Second Max in SQL
Find Second Max in SQL
SELECT TOP 1 * From (select Top 2 * from complaint_log ORDER BY s_no DESC)a ORDER BY s_no
clear ALL textboxes and label
clear ALL textboxes and label
For Each ctrl In Controls
If TypeOf ctrl Is TextBox Or TypeOf ctrl Is Label Then
ctrl.Text = String.Empty
End If
Next
If TypeOf ctrl Is TextBox Or TypeOf ctrl Is Label Then
ctrl.Text = String.Empty
End If
Next
Print Character using Asc value
Print Character using Asc value
For i = 97 To 122
k &= "(" & Chr(i) & ")" & vbCrLf
Label4.Text = k
Next
i += 1
k &= "(" & Chr(i) & ")" & vbCrLf
Label4.Text = k
Next
i += 1
VB.NET Generate a random string of numbers and letters
VB.NET Generate a random string of numbers and letters
Private Sub btn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn.Click
Dim s As String = "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789"
Dim r As New Random
Dim sb As New StringBuilder
For i As Integer = 1 To 4
Dim idx As Integer = r.Next(0, 35)
sb.Append(s.Substring(idx, 1))
Next
Label2.Text = sb.ToString
End Sub
Dim s As String = "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789"
Dim r As New Random
Dim sb As New StringBuilder
For i As Integer = 1 To 4
Dim idx As Integer = r.Next(0, 35)
sb.Append(s.Substring(idx, 1))
Next
Label2.Text = sb.ToString
End Sub
Create Folder In VB.net
Create Folder In VB.net
Private Sub Ok_Button_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Ok_Button.Click
' Check if folder exists, if not: create it
If Not Directory.Exists("D:\" & "SandeepKumarYadav") Then
Directory.CreateDirectory("D:\" &"SandeepKumarYadav")
' Folder created message
MessageBox.Show("Folder created!", "", MessageBoxButtons.OK, MessageBoxIcon.Information)
Else
' Folder already exists
MessageBox.Show("Folder already exists!", "", MessageBoxButtons.OK, MessageBoxIcon.Stop)
End If
End Sub
' Check if folder exists, if not: create it
If Not Directory.Exists("D:\" & "SandeepKumarYadav") Then
Directory.CreateDirectory("D:\" &"SandeepKumarYadav")
' Folder created message
MessageBox.Show("Folder created!", "", MessageBoxButtons.OK, MessageBoxIcon.Information)
Else
' Folder already exists
MessageBox.Show("Folder already exists!", "", MessageBoxButtons.OK, MessageBoxIcon.Stop)
End If
End Sub
Posted by San
Opening A URL in vb.net
Opening A URL in vb.net
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
System.Diagnostics.Process.Start("http://www.sandeepsky.blogspot.in")
End Sub
System.Diagnostics.Process.Start("http://www.sandeepsky.blogspot.in")
End Sub
Subscribe to:
Posts (Atom)