Thursday, 12 December 2013
jQuery Ajax Submit Form without Page Refresh using JSON in Asp.Net
jQuery Submit a form without postback
After completion of aspx page design add the following namespaces in code behind
C# Code
using System;using System.Data;using System.Data.SqlClient;using System.Web.Services;
After that write the following code in code behind
protected void Page_Load(object sender, EventArgs e){}[WebMethod]public static string InsertData(string username, string subj, string desc){string msg = string.Empty;using (SqlConnection con = new SqlConnection("Data Source=SureshDasari;Integrated Security=true;Initial Catalog=MySampleDB")){using (SqlCommand cmd = new SqlCommand("insert into TEMP_User(Name,Subject,Description) VALUES(@name,@subject,@desc)", con)){con.Open();cmd.Parameters.AddWithValue("@name", username);cmd.Parameters.AddWithValue("@subject", subj);cmd.Parameters.AddWithValue("@desc", desc);int i= cmd.ExecuteNonQuery();con.Close();if (i == 1){msg = "true";}else{msg = "false";}}}return msg;}
Thursday, 5 December 2013
All process for client side processor in Json File
filename.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ajaxform.aspx.cs" Inherits="ajaxform" %>
:: Ajax Form ::
filename.aspx.cs file
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.Services;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;
public partial class ajaxform : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
[WebMethod]
public static string GetName(string Username)
{
string xml;
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ToString());
DataTable dt = new DataTable();
conn.Open();
SqlCommand cmd = new SqlCommand("json_process", conn);
cmd.Parameters.AddWithValue("@name", Username);
cmd.CommandType = CommandType.StoredProcedure;
//cmd.ExecuteNonQuery();
//conn.Close();
//return code;
//}
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
if (dt.Rows.Count > 0)
{
xml = "";
// xml += "
";
}
else
{
xml = "No records";
}
conn.Close();
return xml;
}
}
| Name : | "; foreach (DataRow row in dt.Rows) { xml += "|
| " + row["Names"] + " | " + row["Mobile"] + " |
Classic ASP Page and Database connection String
<%
//DECLARATION
Dim strcon,sqry,StrGender,cmd
//connection string
strcon = "Provider=SQLOLEDB;Data Source=ServerName;User Id=DatabaseName;Password=Databasepassword"
//Establish Connection
set conn = server.CreateObject("ADODB.Connection")
conn.ConnectionString = strcon
conn.Open()
%>
Test Page
Subscribe to:
Posts (Atom)