insert the data in database using gridview jquery


//GridViewDelete.aspx
<script src="Script/jquery-1.4.min.js" type="text/javascript"></script>
    <script type="text/javascript">
 $(document).ready(function () {
            $("#.addbutton").click(function () {
                //checkValidate();
                var tbUserID = $('#tbUserID').val();
                var tbUserName = $('#tbUserName').val();
                var tbFirstName = $('#tbFirstName').val();
                var tbMiddleName = $('#tbMiddleName').val();
                var tbLastName = $('#tbLastName').val();
                var tbEmailID = $('#tbEmailID').val();

               
                $.ajax({
                    type: "POST",
                    
                    //GridViewDelete.aspx is the page name and AddUse is the server side method to delete records in GridViewDelete.aspx.cs
                    url: "GridViewDelete.aspx/AddUser",

                    //Pass the parameter Id, [User_Name], First_Name, Last_Name, Middle_Name, Email_Id
                    data: "{Id: '" + tbUserID + "',User_Name: '" + tbUserName + "',First_Name: '" + tbFirstName  + "',Last_Name: '" + tbLastName+ "',Middle_Name: '" + tbMiddleName + "',Email_Id: '" + tbEmailID + "'}",
                    contentType: "application/json; charset=utf-8",
                    dataType: "json",
                    success: function () { alert("success") }

                })

            });
 });
</script>


User ID:<asp:TextBox runat="server" ID="tbUserID"></asp:TextBox><br />
        User Name:<asp:TextBox runat="server" ID="tbUserName"></asp:TextBox><br />
        First Name:<asp:TextBox runat="server" ID="tbFirstName"></asp:TextBox><br />
        Middle Name:<asp:TextBox runat="server" ID="tbMiddleName"></asp:TextBox><br />
        Last Name:<asp:TextBox runat="server" ID="tbLastName"></asp:TextBox><br />
        Email Id:<asp:TextBox runat="server" ID="tbEmailID"></asp:TextBox><br />
        <a href="#" id='add' class="addbutton">Add</a>



//GridViewDelete.aspx.cs[System.Web.Services.WebMethod]
    public static void AddUser(string Id, string User_Name, string First_Name, string Last_Name, string Middle_Name, string Email_Id)
    {

        string conString = ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString;

        SqlConnection sqlConn = new SqlConnection(conString);

        try
        {

            SqlCommand sqlCmd = new SqlCommand("AddUser", sqlConn);

            sqlCmd.CommandType = CommandType.StoredProcedure;
            //@User_Name, @First_Name, @Last_Name, @Middle_Name, @Email_Id
            sqlCmd.Parameters.AddWithValue("@id", Convert.ToInt32(Id.Trim()));
            sqlCmd.Parameters.AddWithValue("@User_Name", User_Name.Trim());
            sqlCmd.Parameters.AddWithValue("@First_Name", First_Name.Trim());
            sqlCmd.Parameters.AddWithValue("@Last_Name", Last_Name.Trim());
            sqlCmd.Parameters.AddWithValue("@Middle_Name", Middle_Name.Trim());
            sqlCmd.Parameters.AddWithValue("@Email_Id", Email_Id.Trim());

            sqlConn.Open();

            sqlCmd.ExecuteNonQuery();

        }
        catch
        {
            //Handle Error
        }
        finally
        {
            sqlConn.Close();
        }
        LoadData()
    }
//create procedure
create PROCEDURE [dbo].[AddUser]  (
@Id int,
@User_Name varchar(30),
@First_Name  varchar(30), @Last_Name  varchar(30), @Middle_Name  varchar(30),
@Email_Id   varchar(30)
)
as
begin
insert into User_Table(Id, [User_Name], First_Name, Last_Name, Middle_Name, Email_Id)
 values(@Id,@User_Name, @First_Name, @Last_Name, @Middle_Name, @Email_Id)
end

Comments

Popular posts from this blog

GROUP BY, CUBE, ROLLUP and SQL SERVER 2005

How to get content of Ckeditor & Fckeditor using Javascript

How to Fix Error- Sys.WebForms.PageRequestManagerTimeoutException - The server request timed out