btn.BackColor =Color .FromArgb (192,192,0)
Wednesday, October 30, 2013
Monday, October 28, 2013
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
Friday, October 25, 2013
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
Wednesday, October 23, 2013
CONVERT function gets date from SQL Server DateTime Column
SELECT CONVERT(CHAR(10), (field name), 101) FROM (table name)
Friday, October 18, 2013
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
Subscribe to:
Posts (Atom)