alternate to AccessDataSource

[dorandoran]

I got this from http://www.codeproject.com/KB/aspnet...dGridView.aspx. I dont like using accessdatasource. What are my option? (what I really like is to create a class and create object in the form, my backend is sql server. Can anyone please please help?)
Thanks
<Do>

    private AccessDataSource ChildDataSource(string strCustometId, string strSort)
    {
        string strQRY = "";
        AccessDataSource dsTemp = new AccessDataSource();
        dsTemp.DataFile = "App_Data/Northwind.mdb";
        strQRY = "SELECT [Orders].[CustomerID],[Orders].[OrderID]," +
                                "[Orders].[ShipAddress],[Orders].[Freight],[Orders].[ShipName] FROM [Orders]" +
                                " WHERE [Orders].[CustomerID] = '" + strCustometId + "'" +
                                "UNION ALL " +
                                "SELECT '" + strCustometId + "','','','','' FROM [Orders] WHERE [Orders].[CustomerID] = '" + strCustometId + "'" +
                                "HAVING COUNT(*)=0 " + strSort;
 
        dsTemp.SelectCommand = strQRY;
        return dsTemp;
    }

[Frinavale]

What are you binding to?
Check out this article about binding. You can bind to any Object....

If you're using something like a GridView, it will automatically bind to any public properties of the Object that is the DataSource.

[dorandoran]

thanks frin. man, you went through so many post and answered them. it's nice of you.