Dropdownlist With Stored Procedure Problem

Hi Everyone,

I am trying to load the data into the dropdownlist using stored procedure. But when I run the code, the dropdownlist is empty. The code is shown below. Please help! Thanks.


public DataSet getProvince()
    {
        DataSet ds = new DataSet();
        SqlParameter myParam;

        string conString;
        SqlConnection myConnection;

        conString = ConfigurationManager.AppSettings["connectionString"];
        myConnection = new SqlConnection(conString);

        SqlCommand cmd = new SqlCommand("stored_procedure_GetProvinces", myConnection);

        SqlDataAdapter adpt = new SqlDataAdapter(cmd);

        try
        {

            cmd.CommandType = CommandType.StoredProcedure;
            myParam = cmd.Parameters.Add("@province_key", SqlDbType.Int);
            myParam.Direction = ParameterDirection.Output;

            myParam = cmd.Parameters.Add("@province_name", SqlDbType.NVarChar, 200);
            myParam.Direction = ParameterDirection.Output;
           
            adpt.Fill(ds, "Provinces");
           
            myConnection.Close();

        }
        catch (SqlException ex)
        {
            Response.Write("Error: " + ex.Message);
        }
        return ds;
    }

----------------------------------

 create procedure stored_procedure_GetProvinces
(
@province_key int output,
@province_name nvarchar (200) output
)
As
Select @province_key=province_key, @province_name=province_name From province
GO

-------------------------

 <asp:DropDownList id="Dropdownlist_Province" DataValueField="province_key" DataTextField="province_name" DataSource='<%# getProvince() %>' Runat="server" >
    </asp:DropDownList>


--------------------------------

 if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[province]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[province]
GO

CREATE TABLE province (
province_key     int           IDENTITY PRIMARY KEY,
province_name nvarchar (200)  NULL
)
GO

INSERT INTO province(province_name) VALUES
  ('- Select -');
GO
INSERT INTO province (province_name) VALUES
  ('Ontario');
GO
INSERT INTO province (province_name) VALUES
  ('Alberta');
GO
INSERT INTO province (province_name) VALUES
  ('British Columbia');
GO
INSERT INTO province (province_name) VALUES
  ('Manitoba');
GO
INSERT INTO province(province_name) VALUES
  ('New Brunswick');
GO
INSERT INTO province (province_name) VALUES
  ('Newfoundland');
GO
INSERT INTO province (province_name) VALUES
  ('Northwest Territories');
GO
INSERT INTO province (province_name) VALUES
  ('Nova Scotia');
GO
INSERT INTO province (province_name) VALUES
  ('Nunavut');
GO
INSERT INTO province (province_name) VALUES
  ('Prince Edward Island');
GO
INSERT INTO province (province_name) VALUES
  ('Quebec');
GO
INSERT INTO province (province_name) VALUES
  ('Saskatchewan');
GO
INSERT INTO province (province_name) VALUES
  ('Yukon Territory');
GO