How to execute procedure having insert and select command

using (SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConn"].ConnectionString))

                try

                {

                    SqlCommand Command = new SqlCommand("GetLeaveDeatils", Conn);

                   Command.CommandType = CommandType.StoredProcedure;

             Command.Parameters.Add("@Code", SqlDbType.VarChar, 10).Value = code;  

                    Conn.Open();

                    SqlDataAdapter DA = new SqlDataAdapter();

                    DataSet ds = new DataSet();

                    DA.SelectCommand = Command;

                    DA.Fill(ds);

                    GridView1.DataSource = ds;

                    GridView1.DataBind();

                }

                finally

                {

                    if (Conn != null)

                        Conn.Close();

                }

Hope this code will help.

Abhishek