Connecting to MSSQL 2005/2008

[RonaldN]

I'm new to SmartGWT and i am researching which platform we should use (GXT or Smart).

I have a connection class in java that connects to our server so thats not really a problem. What we would like to do is execute a stored procedure that returns an XML string, load that into a grid an when an operation is done on the grid return the data in a xml string to the server so that it can be processed.

1. Is this the best way to connect to an sql server or should i use something like the basic connecter?

2. Is there an example that comes close to what i want? With GXT i was really struggeling with loading the data into a store.

My first questions on the forum, lets hope only a few will follow ;)

[Isomorphic]

Start by reading the QuickStart Guide, paying close attention to the sections on SQL Templating. You'll find an extremely simple example of connecting to stored procedures:

<operationBinding operationType="remove">
   <customSQL>call deleteOrder($criteria.orderNo)</customSQL>
</operationBinding>