//This Example
Will Allow You To Send Request On The Server Using Javascript
//Step01:JS code
will help you to send the request on HTTP Handler.
var var01 = document.getElementById(elementID1);var var02 = document.getElementById(elementID2);
var var03 = document.getElementById(
elementID3);
var dataString = ' var01='
+ var01 + '&var02='
+ var02 + '&var03='
+ var03;
$.ajax({
type: "POST",
url: "HandlerName.ashx",
data: dataString
})
.done(function (msg) { alert("Done: " + msg);})
.fail(function (msg) { alert("NotDone: " + msg); })
.always(function () { alert("Complete"); });
//Step02:Handler
Performing the Insert Query Into DataBase.(You can also Update, delete the
record into the database or etc…)
public void ProcessRequest (HttpContext context)
public class manageaddress : IHttpHandler,
IRequiresSessionState {
public void ProcessRequest (HttpContext context)
{
context.Response.ContentType = "text/html";
try
{
if (context.Request.Form["var01"] != null && context.Request.Form["var02"] != null &&
context.Request.Form["var03"] != null)
{
SqlConnection cn = new SqlConnection();
cn.ConnectionString =ConfigurationManager.ConnectionStrings["ConnectinStringName"].ConnectionString;
cn.Open();
string strSql = "INSERT INTO
<Table_Name> (column01, column02, column03) values (@var01, @var02,
@var03)";
SqlCommand command = new SqlCommand(strSql, cn);
SqlCommand command = new SqlCommand(strSql, cn);
command.Parameters.AddWithValue("@var02", context.Request.Form["var02"].ToString());
command.Parameters.AddWithValue("@var03", context.Request.Form["var03"].ToString());
command.ExecuteNonQuery();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
No comments:
Post a Comment