PDA

View Full Version : How to save data from data store in the MSSQL server?



sumon86
3 Jun 2011, 2:24 AM
I develop the program using MSSQL. I create session store

Ext.regStore('Cart', {
model: 'Product',
//autoLoad: true,
proxy: {
type: 'sessionstorage',
id: 'shoppingcart'
}
});

and add the data in this store

var store=Ext.getStore('Cart');
store.add(record.data);
store.sync();

The problem is how the save data from session store into the MSSQL Server 2008 and another problem is how to look if someone reply my post. Please help me

hyperionab
3 Jun 2011, 7:16 AM
You'll probably need a file of some kind on your web server (in your case probably ASP.NET) in order to actually load the data off of your MSSQL backend. This is Ext JS, but it gives you an idea of what you would have to do in the case of MySQL and PHP: http://www.sencha.com/forum/showthread.php?10002-Example-of-editor-grid-using-php-and-mysql-to-save-data. Basically, your ASP.NET page would take the JSONP request and then make the changes to the database.