Clientside Binding using 'late binding' method (from a dataset for instance) - example?

Glayaar — Fri, 07 May 2010 12:56:15 GMT

You could use WebService to return the filtered data. However, WebGrid will only accept LINQ object or ISDataTable object as the return value.

The provide client binding sample with WebService has shown how to use WebService and LINQ object.

Here is the WebService method snippet using ISDataTable, the snippet will convert DataTable object into ISDataTable :

[WebMethod]
public Object GetData(DataSourceSelectArguments selectArguments)
{
    SqlCommand retrieveComm = new SqlCommand();
    retrieveComm.Connection = new SqlConnection(ConfigurationManager.ConnectionStrings["SqlNorthwindConnectionString"].ConnectionString);
    retrieveComm.CommandText = "SELECT * FROM [Products]";

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

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

    ISDataTable isTable = DataTableConverter.ConvertFrom(dtTemp);
    return isTable;

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

Clientside Binding using 'late binding' method (from a dataset for instance) - example?

ashZA — Fri, 07 May 2010 10:08:50 GMT

Anyone ever tried this & have a working example?

Just to confirm... I'd like to late bind the a datasource to a webgrid (pass in parameters from a seach to funtion that returned a dataset, and bind that dataset to the grid, but at the same time taking advantage of client side binding)

Not sure of a correct way to go about this, but cant seem to get it to work. grid shows up with results, but also pops up error messages.

regards,

Ash

Intersoft Community - WebGrid Enterprise - Clientside Binding using 'late binding' method (from a dataset for instance) - example?

Clientside Binding using 'late binding' method (from a dataset for instance) - example?

Clientside Binding using 'late binding' method (from a dataset for instance) - example?