Related Links

Save Data faster using xml and javascript ajax or jquery

Does anyone has clues, infos, samples, or had done this Save Data using xml and javascript ajax or jquery??? currently, save process is not fast enough. some way saving data to database faster, using wcsf and Linq and VS 2008 (asp.net 3.5)...

Re: Save Data faster using xml and javascript ajax or jquery

We are using Linq to get, insert, update and delete data...Now, it seems this is not fast enough, So, my boss asked us to search for a way to parse data to xml and save it to database??? So, I am searching for javascript ajax, jquery, json or other client-side
way to do this, to improve speed of saving data much faster....

Re: Save Data faster using xml and javascript ajax or jquery

You also don't need SQL Server 2005 to do this - it's been supported at least since 2000, although it's done in a slightly different way.

Although I don't have a reference to hand I believe the procedure you call is something like sp_preparedocument or sp_preparexmldocument - you can load a fragment into this and then query it using xpath.

SQL Server 2005 supports the same thing and doesn't require use of xml params, although obviously by using those you get to check whether the XML being passed in is valid.

Re: Save Data faster using xml and javascript ajax or jquery

we are using sql server 2005, I need samples what are you suggesting...

mudassarkhan,

thanks for link, this is incomplete, this shows parsing xml inside a stored procedure...

Here is somewhat clarification, data is being displayed in repeaters and multiple hierarchical display of textboxes, now current approach is not fast enough to save these data into database using linq, what I think he wants is how to get these data, create
an xml for this data, and then somehow passed this xml data to the database (parse it there and then insert or update records)....What is missing is how do you get data from the rendered page and create xml and how to passed xml to database (thru webservice??)??
I am searching for sample codes to do all these...There are still missing info on this approach and still not complete...

Re: Save Data faster using xml and javascript ajax or jquery

den2005

we are using sql server 2005, I need samples what are you suggesting...

mudassarkhan,

thanks for link, this is incomplete, this shows parsing xml inside a stored procedure...

Here is somewhat clarification, data is being displayed in repeaters and multiple hierarchical display of textboxes, now current approach is not fast enough to save these data into database using linq, what I think he wants is how to get these data, create
an xml for this data, and then somehow passed this xml data to the database (parse it there and then insert or update records)....What is missing is how do you get data from the rendered page and create xml and how to passed xml to database (thru webservice??)??
I am searching for sample codes to do all these...There are still missing info on this approach and still not complete...

Thanks to all for providing some info on part of this approach...

If you Google these topics you should find everything you need - you have the methods you need to use.

http://msdn.microsoft.com/library is also a starting resource I would suggest for examples and an API reference.

If you're not sure how to read data from a repeater I would suggest that you request help from a more senior member of your team if you have one, as it sounds like you have really been thrown in at the deep end with a topic with which you are apparently
unfamiliar. No offence intended here btw.