protected void AddGallery(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["Atomic_CMS"].ConnectionString);
        SqlCommand cmd = new SqlCommand("sp_AddGallery", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("@Name", txtAddGallery.Text);
        cmd.Parameters.AddWithValue("@Success", "");
        cmd.Parameters["@Success"].Direction = ParameterDirection.Output;

        try
        {
            con.Open();
            cmd.ExecuteNonQuery();
            lblSuccess.Text = cmd.Parameters["@Success"].Value.ToString();
            con.Close();

            RadGrid1.DataBind();
        }
        catch (Exception ex)
        {
            lblSuccess.Text = "Error: " + ex.Message + " Please notify Atomic Design of this error. Please try again later.";
        }
        finally
        {
            con.Dispose();
        }    
    }


ALTER PROCEDURE sp_AddGallery
	
	@Name		nvarchar(250),
	@Success	nvarchar(250) output
	
AS
	SELECT [Name] FROM  Atomic_CMS_Photo_Galleries WHERE [Name] = @Name;
	
	IF @@ROWCOUNT < 1
	
		BEGIN
	
			INSERT INTO Atomic_CMS_Photo_Galleries(Name) 
			VALUES(@Name)
			
			SET @Success = '';
			
		END
		
	ELSE
	
		SET @Success = 'Error: This Gallery Name is already in use. Please choose a different Name.';