After Insert the record at index.aspx page redirect to ajax

Kobinath Ram

7y1.1kAJAX

After Insert the record at index.aspx page redirect to ajax success function and show the message alert("success"); I wrote function addProject() to do the task.i didn't get any error. record is added successfully in the database. but alert("success") message is not displayed.i tried the code below

error displayed an object reference is required for non-static field,method error was displayed

this lines get error

string fname = Request.Form["fname"];

string age = Request.Form["age"]

public static string doSomething(int id)

{

string fname = Request.Form["fname"];

string age = Request.Form["age"];

string sql = "insert into record values('" + fname + "','" + age + "')";

SqlCommand cmd = new SqlCommand(sql, con);

con.Open();

cmd.ExecuteNonQuery();

con.Close();

return "Sucess";

}

Ajax

function addProject() {

$.ajax({

type: 'POST',

url: 'insert.aspx/doSomething',

dataType: 'JSON',

data: {fname: $('#fname').val(), age: $('#age').val()},

success: function (data) {

alert("success");

error: function (xhr, status, error) {

console.log(xhr.responseText);

}

});

}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kobinath Ram7y ago
public class UserClass
{
public string fname { get; set; }
public int age { get; set; }
}
[WebMethod]
public static string doSomething(UserClass obj)
{
SqlConnection con = new SqlConnection("server=.; Initial Catalog = jds; Integrated Security= true;");
string sql = "insert into record values('" + obj.fname + "','" + obj.age + "')";
SqlCommand cmd = new SqlCommand(sql, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
return "Sucess";
} i tried but reord is not added sir
Ehsan Sajjad7y ago
Request property is not a static memeber so you cannot access it inside the static method. You can add parameters in the method for the name and second argument. Try like:
public static string doSomething(string fname, string age)
{
string sql = "insert into record values('" + fname + "','" + age + "')";
SqlCommand cmd = new SqlCommand(sql, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
return "Sucess";
}