IAmateur

What is the syntax to cal stored procedure from code side?

Hi,

You could write like this:

SqlConnection conn = new SqlConnection("your_sql_server_connection_string");
        SqlCommand cmd = new SqlCommand();
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.CommandText = "your sp's name";
        //add values to paramters.
        cmd.Parameters.AddWithValue("@name1", "name1");
        conn.Open();
        cmd.Connection = conn;
        cmd.ExecuteNonQuery();
        conn.Close();

Thanks.