Ajax modal popup to insert details in SQL table

See more:

C#

ASP.NET

SQL-Server

Ajax

Hi,
I am using the ajax popup for inserting some details. When you click on a Save button on the web page, a window pops up (ajax Modal popup) and once you enter the fields in the popup and click submit button in the popup, all the fields in the webpage and the popup window should be inserted into a sql table. I wrote a sql stored stored procedure for this.
This is the way i did but the details are not being inserted into the SQL table.

public void InsertSearchDetails()
    {
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = (ConfigurationManager.AppSettings["Gulfcoast"]);
        conn.Open();
        SqlCommand cmd = new SqlCommand("SP_InsertInvestigationSearchDetails",conn);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@rl_name", SqlDbType.NVarChar).Value = txtSearchName.Text.Trim();
        cmd.Parameters.Add("@rl_description", SqlDbType.NVarChar).Value = txtDesc.Text.Trim();
        cmd.Parameters.Add("@rl_criteria1", SqlDbType.NVarChar).Value = Criteria.Text.Trim();
        if (Criteria1.Text != "")
        {
            cmd.Parameters.Add("@rl_criteria2", SqlDbType.NVarChar).Value = Criteria1.Text.Trim();
        }
        cmd.Parameters.Add("@rl_type", SqlDbType.NVarChar).Value = Type.SelectedValue.ToString();
        cmd.Parameters.Add("@rl_reg", SqlDbType.NVarChar).Value = register.Text.Trim();
        cmd.Parameters.Add("@rl_cashier", SqlDbType.NVarChar).Value = Cashier.SelectedValue.ToString();
        cmd.Parameters.Add("rl_evenodd", SqlDbType.NVarChar).Value = AnyEven.SelectedValue.ToString();
        cmd.Parameters.Add("rl_cat1", SqlDbType.NVarChar).Value = Category1.SelectedValue.ToString();
        cmd.Parameters.Add("rl_cat2", SqlDbType.NVarChar).Value = Category2.SelectedValue.ToString();
        cmd.Parameters.Add("rl_exp", SqlDbType.NVarChar).Value = Expressions.SelectedValue.ToString();
        cmd.Parameters.Add("rl_value", SqlDbType.NVarChar).Value = Value.Text.Trim();
        cmd.Parameters.Add("rl_value1", SqlDbType.NVarChar).Value = Value1.Text.Trim();
        cmd.Parameters.Add("rl_exp1", SqlDbType.NVarChar).Value = CompareQnty.SelectedValue.ToString();
        if (((QtyValue1.Visible == true) && (QtyValue1.Text == "")) || (QtyValue1.Visible == false))
        {
            cmd.Parameters.Add("rl_qty1", SqlDbType.Int).Value = DBNull.Value;
        }
        else
        {
            cmd.Parameters.Add("rl_qty1", SqlDbType.Int).Value = Convert.ToInt32(QtyValue1.Text.Trim());
        }
        if (((QtyValue2.Visible == true) && (QtyValue2.Text == "")) || (QtyValue2.Visible == false))
        {
            cmd.Parameters.Add("rl_qty2", SqlDbType.Int).Value = DBNull.Value;
        }
        else
        {
            cmd.Parameters.Add("rl_qty2", SqlDbType.Int).Value = Convert.ToInt32(QtyValue2.Text.Trim());
        }

        cmd.Parameters.Add("@rl_createdDate", DateTime.Now);
        cmd.Parameters.Add("@rl_updatedDate", DateTime.Now);
        cmd.ExecuteNonQuery();
    }

Here is my stpored procedure:

USE [Gulfcoast]
GO
/****** Object:  StoredProcedure [dbo].[SP_InsertInvestigationSearchDetails]    Script Date: 02/25/2011 10:46:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:        <Author,,Name>
-- Create date: <Create Date,,>
-- Description:    <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[SP_InsertInvestigationSearchDetails]

    @rl_id uniqueidentifier,
    @rl_name nvarchar(250),
    @rl_description nvarchar(555),
    @rl_criteria1 nvarchar(155),
    @rl_criteria2 nvarchar(155),
    @rl_reg nvarchar(5),
    @rl_cashier nvarchar(50),
    @rl_type nvarchar(50),
    @rl_evenodd nvarchar(50),
    @rl_quantity nvarchar(50),
    @rl_cat1 nvarchar(50),
    @rl_cat2 nvarchar(50),
    @rl_exp nvarchar(10),
    @rl_value nvarchar(50),
    @rl_exp1 nvarchar(10),
    @rl_value1 nvarchar(50),
    @rl_qty1 int = 0,
    @rl_qty2 int = 0,
    @rl_rule_type nvarchar(100),
    @rl_createdDate datetime,
    @rl_updatedDate datetime

AS
BEGIN
    Declare @ruleName nvarchar(250)
    --remove extra spaces from the entered rule name string
    set @ruleName = replace(replace(replace(@rl_name,' ','<>'),'><',''),'<>',' ');

    --if record does not exists then add new record
    If NOT EXISTS (select * from ExceptionRuleDetail where rl_name = ltrim(rtrim(@ruleName)))
    begin
        -- insert statement to insert exception rule details into exception rule detalis table
        Insert into ExceptionRuleDetail(rl_id, rl_name, rl_description, rl_rule_type, rl_register, rl_type,
        rl_criteria1, rl_criteria2, rl_category1, rl_category2,rl_amount,rl_amount_comparison,rl_amount_dollar_value1,
         rl_amount_dollar_value2,rl_quantity,rl_quantity_comparison,rl_quantity_dollar_value1,rl_quantity_dollar_value2,rl_createdDate,rl_updatedDate)
        values (@rl_id, ltrim(rtrim(@ruleName)), @rl_description, @rl_rule_type,@rl_reg, @rl_type, @rl_criteria1,
        @rl_criteria2,@rl_cat1,@rl_cat2,@rl_evenodd,@rl_exp,@rl_value,@rl_value1,@rl_quantity,@rl_exp1,@rl_qty1,@rl_qty2,@rl_createdDate,@rl_updatedDate)
        --use return statement to return value from stored procedure
        return 0
    end
    else
    begin
        --use return statement to return value from stored procedure
        return 1
    end
END

Can someone please help me out with this?