Intersoft Community - WebGrid Enterprise - Clientside Binding with WebService without LINQ - any example ?

Clientside Binding with WebService without LINQ - any example ?

Glayaar — Sun, 14 Mar 2010 23:34:08 GMT

The next build of WebGrid 7 will support this feature which will be released in a few weeks. Here is a snippet of the GetData function:

[WebMethod]
public Object GetData(DataSourceSelectArguments selectArguments)
{
    SqlCommand retrieveComm = new SqlCommand();

    retrieveComm.Connection = new SqlConnection(ConfigurationManager.ConnectionStrings["SqlNorthwindConnectionString"].ConnectionString);

    retrieveComm.CommandText = "SELECT TOP 15 * FROM [Products]";

    SqlDataAdapter da = new SqlDataAdapter();
    da.SelectCommand = retrieveComm;

    DataTable dtTemp = new DataTable();
    da.Fill(dtTemp);

    if (selectArguments.OperationType == SelectOperation.SelectData)
    {
        ISDataTable isTable = DataTableConverter.ConvertFrom(dtTemp);
        return isTable;
    }
    else if (selectArguments.OperationType == SelectOperation.SelectCount)
        return dtTemp.Rows.Count;

    throw new InvalidOperationException("Unsupported operation type!");
}

Here is the snippet of the WebGrid client binding property:

<ClientBindingSettings DataLoadMode="PagedData" DataSourceType="WebService"
    ServiceUrl="CustomService.asmx">
    <ServiceMethods SelectMethod="GetData" />
</ClientBindingSettings>

It is very similar with the snippet code you posted

Clientside Binding with WebService without LINQ - any example ?

Glayaar — Sun, 21 Feb 2010 21:42:57 GMT

I have discussed this issue with the developer, this feature has not been supported in the current build of WebGrid 7.

However, the next build of WebGrid 7 will be enchanced to include this feature.

Clientside Binding with WebService without LINQ - any example ?

ands — Wed, 17 Feb 2010 06:20:27 GMT

Hello,

I'd like to use datatable from my dataset as datasource to loading WebGrid via WebService in clientside bind mode. I don't want to use LINQ.

I've tried (but without result)

[ScriptMethod]
[WebMethod()]
public ISDataTable GetJSONHAState()
{
  DataSet1.WSS_HA_STATEDataTable dt = new DataSet1.WSS_HA_STATEDataTable();
  DataSet1TableAdapters.WSS_HA_STATETableAdapter da = new DataSet1TableAdapters.WSS_HA_STATETableAdapter();
 da.Fill(dt, 0);
 return DataTableConverter.ConvertFrom(dt);
}

Could you give me some example ?

regard

Andrzej