C#

kibromg wrote:

hence i would like to incorporate a client side script or a java script.

Can any one assist me with the code?

kibromg wrote:

as a server side script.
Hence icant use messagebox.show method in my code in C sharp

kibromg wrote:

i didnt see colins message?

kibromg wrote:

Could you please give me a tip of the script please as i havenot used java script??

class CMessageBox
{
    public static void Show(Page _page,string Message)
    {
         _page.Response.Write("<script language='javascript'>alert('" + Message + "')</script");
    }
}

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++;
    ...
}