This is default featured slide 4 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured slide 1 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured slide 2 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured slide 4 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

Me And My Respected Teacher Mr Kamal Sheel Mishra

Mr. K.S. Mishra is HOD of Computer Science from SMS Varanasi where I have completed my MCA

Me And My Respected Teacher Mr Udayan Maiti

Mr. Udayan Maiti is a senior .Net Expert and has guided many professionals of multi national Companies(MNC)

Me And My Best Friend Mr Ravinder Goel

Mr. Ravinder Goel is a senior Software Engineer and now he is working Wipro Technology

Saturday, 21 March 2015

How to save data in Sql Server using $("#form1").serialize() with Ajax and Jquery in Asp.Net

How to save data in Sql Server using  $("#form1").serialize()  with Ajax and Jquery in Asp.Net

Note:  here we will discuss about how to save in Sql Server without [WebMethod] means here we are using  $("#form1").serialize concept to passing data to server  and after passing we get the passed  data with query string
-- Sql Server.....
use test
create table Student
(
Id int primary key,
Name varchar(50),
Age int,
PhoneNo varchar(50)
)
Source Code for Default.aspx…………………………….

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="WebApplication3.WebForm1" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>

<script src="Scripts/jquery-1.4.1.js" type="text/javascript"></script>
<script type="text/javascript">

$(function ()
{

$("[type='button']").not("#Button1").bind("click", function ()
{
//  $(".a").bind("click", function () {
$("#txtid").val($($(this).closest("tr").find("td")[0]).text().trim());
$("#txtname").val($($(this).closest("tr").find("td")[1]).text().trim());
$("#txtage").val($($(this).closest("tr").find("td")[2]).text().trim());
$("#txtphoneno").val($($(this).closest("tr").find("td")[3]).text().trim());

});

$("#Button1").click(function ()
{
debugger;
var data = $("#form1").serialize();
$.ajax({ data: data,
url: "Webform1.aspx",
success: function (response) {
var row = "<tr><td>" + $("#txtid").val() + "</td><td>" + $("#txtname").val() + "</td><td>" + $("#txtage").val() + "</td><td>" + $("#txtphoneno").val() + "</td><td>  <input type='button' class='a' value='select' /></td></tr>";
$("#GridView1").find("tbody").append(row);
},
error: function (response)
{
alert(response);
}
});
});
});
</script>
</head>
<body>
<form id="form1" runat="server">
<div name="abc">
<table width="50%">
<tr><td colspan="2"><b>How to save data in Sql  Server using  $("#form1").serialize()  with Ajax and Jquery in Asp.Net</b></td></tr>
<tr><td>Id</td><td>  <input id="txtid" name="Text1" type="text" /></td></tr>
<tr><td>Name</td><td> <input id="txtname" name="Text2" type="text" /></td></tr>
<tr><td>Age</td><td><input id="txtage" name="Text3" type="text" /></td></tr>
<tr><td>PhoneNo</td><td><input id="txtphoneno" name="Text4" type="text" /></td></tr>
<tr><td><input id="Button1" type="button" value="Save"  /></td></tr>
<tr><td colspan="2">
<center>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">
<Columns>
<asp:TemplateField>
<HeaderTemplate>
ID
</HeaderTemplate>
<ItemTemplate>
<%#Eval("id") %>
</ItemTemplate>
</asp:TemplateField>

<asp:TemplateField>
<HeaderTemplate>
Name
</HeaderTemplate>
<ItemTemplate>
<%#Eval("Name") %>
</ItemTemplate>
</asp:TemplateField>

<asp:TemplateField>
<HeaderTemplate>
Age
</HeaderTemplate>
<ItemTemplate>
<%#Eval("Age") %>
</ItemTemplate>
</asp:TemplateField>
            
<asp:TemplateField>
<HeaderTemplate>
Phone No
</HeaderTemplate>
<ItemTemplate>
<%#Eval("phoneno") %>
</ItemTemplate>
</asp:TemplateField>

<asp:TemplateField>
<HeaderTemplate>
Button
</HeaderTemplate>
<ItemTemplate>
<input type="button" class="a" value="select" />
</ItemTemplate>
</asp:TemplateField>

</Columns>
</asp:GridView>
</center>
</td></tr>
</table>
 </div>
</form>
</body>
</html>

Source Code for Default.aspx.cs…………………………….
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;


namespace WebApplication3
{
public partial class WebForm1 : System.Web.UI.Page
{
SqlConnection con = new SqlConnection("data source=CETPA1;database=test;integrated security=true;");
SqlCommand cmd;
protected void Page_Load(object sender, EventArgs e)
{
if (this.Request.QueryString["Text1"] != null)
{
try
{
int id = Convert.ToInt32(this.Request.QueryString["Text1"].ToString());
string name = this.Request.QueryString["Text2"].ToString();
int age = Convert.ToInt32(this.Request.QueryString["Text3"].ToString());
string phno = this.Request.QueryString["Text4"].ToString();
cmd = new SqlCommand("insert into Student values(" + id + ",'" + name + "'," + age + ",'" + phno + "')", con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
showalldata();
}
catch (Exception ex)
{
throw new Exception("Error in Insertion.");
}
}
else
{
}
showalldata();
}
private void showalldata()
{
cmd = new SqlCommand("select * from Student", con);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}
}
}

Result