how to store and retrive the textbox value to sql using jquery in asp.net web application

Question

i hav a textbox and button in my aspx page
when i click the button the name enter in the textbox should save in the sql
i wan to write the jquery for this...

can any one suggest how to write the jquery for this
thank in advance,

murali murali · Answer

Hi Deepak i used the code given by you. But it is showing alert after i click the button second time. Any suggestions?

Mojisha Mohandass · Answer

Hi i stored and retrived the textbox values using jquery... Now i have a aspx gridview  in that i want to edit update delete using json/jquery (database is sql) any one know the solution how to write the jquery ????? thanks in advance

Abhijit barua · Answer

public string UpdateRecords( string name) if it's web method use in .cs page then write like below. public static string UpdateRecords( string name)

Mojisha Mohandass · Answer

Hi i got the solution but after the using the webservice only the $ajax{} in script works now got the solution.... if i use the page.aspx in url its not working after calling the webservice page asmx only it works.. function FillUserGrid() { var det = new Object(); det = $('#_name').val(); $.ajax({ type: POST url: WebService1.asmx/UpdateRecords data: { 'name': ' + det + '} contentType: application/json async: false success: function(data) { $('#message').text(data.d); }

Deepak Verma · Answer

Hi Use Debugger!!! If problem still arises start a new topic.

Mojisha Mohandass · Answer

Thanks for the reply.... In conn.open it throwing the exception!!! serverversion = 'conn.serverversion' threw an exception of type 'system.invalidoperationexception' cs page.... public string UpdateRecords( string name) { try { string str = WebConfigurationManager .ConnectionStrings[ jqueryConnectionString ].ConnectionString; using ( SqlConnection conn = new SqlConnection (str)) { // Creating insert statement string sql = string .Format( @INSERT INTO userdetail ([Uname]) VALUES ('{0}'  name); SqlCommand cmd = new SqlCommand (); cmd.Connection = conn; cmd.CommandText = sql; cmd.CommandType = CommandType .Text; conn.Open(); rowsInserted = cmd.ExecuteNonQuery(); conn.Close(); cmd = null ; } return string .Format( Thank you {0} number of rows inserted!  rowsInserted); } catch ( Exception e) { throw e; } } webconfig

Deepak Verma · Answer

You're using '#_name' directly in you script. See the page source you may find that the id of the control is changed on the client machine. So you need to access the control using it's ClientID. Use this : '# ' instead of '#_name' That's it!

Mojisha Mohandass · Answer

script type =text/javascript> function FillUserGrid() { var ActiveDirectory = new Object(); ActiveDirectory.Username = $( '#_name' ).val(); // role.BCT = $('#DropdownBusinessType').find(option:selected).text(); $.ajax({ type: POST  contentType: application/json; charset=utf-8  url: WebForm2.aspx/saverec  data: {}  dataType: json  data: JSON.stringify({ formUserVars: ActiveDirectory }) success: function (data) { } error: function (result) { alert( Error ); } }); }; form id =form1 runat =server> div style = z-index : 1; left : 10px; top : 15px; position : absolute; height : 149px; width : 933px>   asp : TextBox ID =_name runat =server style = z-index : 1; left : 248px; top : 40px; position : absolute> asp : TextBox > input id =Submit type =button value =Submit onclick =FillUserGrid() /> br /> br /> div > form > Hi i used the coding lik tis but this s not working ... this is not going in the url address ... l

Deepak Verma · Answer

Hi Mojisha Get some help from this code: $(document).ready(function () { $('# ').click(function () { var value = ' '; alert(value); }); });