C#

SqlCommand _myProcedure = new System.Data.SqlClient.SqlCommand();

System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(@"Data Source=MyMachine\SQLEXPRESS;Initial Catalog=VersatileData;User ID=sa");<br />
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("vsp_RetrieveEventDetails", con);<br />
cmd.CommandType = CommandType.StoredProcedure;<br />
con.Open();<br />
cmd.Prepare();<br />
MessageBox.Show(cmd.Parameters.Count.ToString());<br />
foreach (System.Data.SqlClient.SqlParameter sqlParam in cmd.Parameters)<br />
{<br />
    MessageBox.Show(sqlParam.ParameterName.ToString());<br />
}<br />
cmd.ExecuteNonQuery();<br />
con.Close();

M. J. Jaya Chitra wrote:

It is giving the parameter count as Zero(0).

M. J. Jaya Chitra wrote:

Can you please tell me the way to get the parameter name and the datatype of the same for a stored procedure?

SELECT * FROM INFORMATION_SCHEMA.PARAMETERS ROUTINE_COLUMNS

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();
}