Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
Clear All
new posts

    Connecting to MSSQL 2005/2008

    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 ;)

    #2
    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:

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

    Comment

    Working...
    X