//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
Post a Comment