Go Back   SmartClient Forums > Smart GWT Technical Q&A
Wiki Register Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 9th Nov 2010, 23:41
RonaldN RonaldN is offline
Registered Developer
 
Join Date: Nov 2010
Posts: 22
Default 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 ;)
Reply With Quote
  #2  
Old 10th Nov 2010, 05:20
Isomorphic Isomorphic is offline
Administrator
 
Join Date: May 2006
Posts: 38,393
Default

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>
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search


© 2010,2011 Isomorphic Software. All Rights Reserved