C#

Colin Angus Mackay wrote:

SELECT * FROM INFORMATION_SCHEMA.ROUTINE_COLUMNS

N a v a n e e t h wrote:

It returned blank rows

N a v a n e e t h wrote:

I doubt how this can get parameters from stored procedures ?

Colin Angus Mackay wrote:

The correct view is INFORMATION_SCHEMA.PARAMTERS

SELECT * FROM INFORMATION_SCHEMA.PARAMETERS WHERE 
specific_name = 'ProcedureName'

foreach(Control c in myPanel.Controls) {
    if (c is TextBox) tbCount++;
    if (c is ListBox) lbCount++;
    if (c is Button) btnCount++;
    ...
}

// We must intercept the WM_HOTKEY message and check lParam !
protected override void WndProc(ref Message m) {
	if(m.Msg==0x0312) {	// WM_HOTKEY (winuser.h)
		int lParam=(int)m.LParam;
		if(lParam==0x00710002) RescueCode();		// CTRL+F2
	}
	base.WndProc(ref m);
}

public string CreateSHA1PasswordHash(string inputString)
{
	SHA1 sha1 = new SHA1CryptoServiceProvider();  
	byte[] buffer = Encoding.UTF8.GetBytes(inputString); 
	byte[] cipher = sha1.ComputeHash(buffer);
	StringBuilder sb = new StringBuilder(cipher.Length * 2);  
	for (int i=0; i<cipher.Length; i++)  
           sb.Append(cipher[i].ToString("x2"));  
	return sb.ToString();
}