p30_code
جمعه 09 اسفند 1392, 21:11 عصر
با سلام خدمت دوستان ون با استفاده از json در هنگام ثبت با مشکل مواجه شدم لطفا راهنمایی کنید. تشکر
protected void Page_Load(object sender, EventArgs e) {
}
[WebMethod]
public static string InsertData(string username, string pass)
{
string msg = string.Empty;
using (SqlConnection con = new SqlConnection(@"Data Source=SALEHI-PC\SQLEXPRESS;Initial Catalog=Jquery;Integrated Security=True"))
{
using (SqlCommand cmd = new SqlCommand("insert into person(username,pass) VALUES(@name,@pass)", con))
{
con.Open();
cmd.Parameters.AddWithValue("@name", username);
cmd.Parameters.AddWithValue("@pass", pass);
int i = cmd.ExecuteNonQuery();
con.Close();
if (i == 1)
{
msg = "true";
}
else
{
msg = "false";
}
}
}
return msg;
}
<html xmlns="http://www.w3.org/1999/xhtml"><head id="Head1"><title>jQuery Submit a form without postback</title> <script src="js/jquery-1.11.0.min.js" type="text/javascript"></script></head><body><form id="form1" runat="server"><table><tr><td>Name:</td><td><input type="text" id="txtname" /></td></tr><tr><td>Subject:</td><td> <input type="text" id="txtsubject" /></td></tr>
<tr><td></td><td><input type="button" id="btnSubmit" value="Submit" /></td></tr></table><label id="lblmsg" style="font-weight:bold; color:Red"/></form><script type="text/javascript"> $(function () { $('#btnSubmit').click(function () { var name = $('#txtname').val(); var pass = $('#txtsubject').val();
if (name != '' && pass != '' ) { $.ajax({ type: "POST", contentType: "application/json; charset=utf-8", url: "Default2.aspx/InsertData", data: "{'username':'" + name + "','pass':'" + pass + "'}", dataType: "json", success: function (data) { var obj = data.d; if (obj == 'true') { $('#txtname').val(''); $('#txtsubject').val(''); $('#lblmsg').html("Details Submitted Successfully"); } }, error: function (result) { alert("Error"); } }); } else { alert('Please enter all the fields') return false; } }) });</script></body></html>
protected void Page_Load(object sender, EventArgs e) {
}
[WebMethod]
public static string InsertData(string username, string pass)
{
string msg = string.Empty;
using (SqlConnection con = new SqlConnection(@"Data Source=SALEHI-PC\SQLEXPRESS;Initial Catalog=Jquery;Integrated Security=True"))
{
using (SqlCommand cmd = new SqlCommand("insert into person(username,pass) VALUES(@name,@pass)", con))
{
con.Open();
cmd.Parameters.AddWithValue("@name", username);
cmd.Parameters.AddWithValue("@pass", pass);
int i = cmd.ExecuteNonQuery();
con.Close();
if (i == 1)
{
msg = "true";
}
else
{
msg = "false";
}
}
}
return msg;
}
<html xmlns="http://www.w3.org/1999/xhtml"><head id="Head1"><title>jQuery Submit a form without postback</title> <script src="js/jquery-1.11.0.min.js" type="text/javascript"></script></head><body><form id="form1" runat="server"><table><tr><td>Name:</td><td><input type="text" id="txtname" /></td></tr><tr><td>Subject:</td><td> <input type="text" id="txtsubject" /></td></tr>
<tr><td></td><td><input type="button" id="btnSubmit" value="Submit" /></td></tr></table><label id="lblmsg" style="font-weight:bold; color:Red"/></form><script type="text/javascript"> $(function () { $('#btnSubmit').click(function () { var name = $('#txtname').val(); var pass = $('#txtsubject').val();
if (name != '' && pass != '' ) { $.ajax({ type: "POST", contentType: "application/json; charset=utf-8", url: "Default2.aspx/InsertData", data: "{'username':'" + name + "','pass':'" + pass + "'}", dataType: "json", success: function (data) { var obj = data.d; if (obj == 'true') { $('#txtname').val(''); $('#txtsubject').val(''); $('#lblmsg').html("Details Submitted Successfully"); } }, error: function (result) { alert("Error"); } }); } else { alert('Please enter all the fields') return false; } }) });</script></body></html>