To implement this first design table in your database like below to save values in database.
| Column Name | Data Type | Allow Null |
|---|---|---|
| Name | varchar(50) | Yes |
| Address | varchar(200) | Yes |
| Mobileno | varchar(50) | Yes |
Default.aspx
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1">
<title>jQuery Submit a form without postback</title>
<script type="text/javascript" src="http://code.jquery.com/jquery-1.8.2.js"></script>
</head>
<body>
<form id="form1" runat="server">
<table>
<tr>
<td>
Name:
</td>
<td>
<input type="text" id="txtname" />
</td>
</tr>
<tr>
<td>
Address:
</td>
<td>
<input type="text" id="txtaddress" />
</td>
</tr>
<tr>
<td>
Mobileno:
</td>
<td>
<textarea id="txtmobileno"></textarea>
</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 addr = $('#txtaddress').val();
var mobno = $('#txtmobileno').val();
if (name != '' && subject != '' && body) {
$.ajax({
type: "POST",
contentType: "application/json; charset=utf-8",
url: "Default.aspx/InsertData",
data: "{'username':'" + name + "','address':'" + addr + "','mobileno':'" + mobno + "'}",
dataType: "json",
success: function (data) {
var obj = data.d;
if (obj == 'true') {
$('#txtname').val('');
$('#txtaddress').val('');
$('#txtmobileno').val('');
$('#lblmsg').html("Details Submitted Successfully");
}
},
error: function (result) {
alert("Error");
}
});
}
else {
alert('Please enter all the fields')
return false;
}
})
});
</script>
</body>
</html>
Default.aspx.cs
using System.Data;
using System.Data.SqlClient;
using System.Web.Services;
[WebMethod]
public static string InsertData(string username, string address, string mobileno)
{
string msg = string.Empty;
using (SqlConnection con = new SqlConnection("Data Source=Nikhilsangani;Integrated Security=true;Initial Catalog=DataDB"))
{
using (SqlCommand cmd = new SqlCommand("insert into UserDetails(Name,Address,MobileNo) VALUES(@name,@address,@mobileno)", con))
{
con.Open();
cmd.Parameters.AddWithValue("@name", username);
cmd.Parameters.AddWithValue("@address", address);
cmd.Parameters.AddWithValue("@mobileno", mobileno);
int i = cmd.ExecuteNonQuery();
con.Close();
if (i == 1)
{
msg = "true";
}
else
{
msg = "false";
}
}
}
return msg;
}
Comments
Post a Comment