Filling a DataGridView with a dataset using parameters

[garling]

I created a dataset to my SQLite db and I set up a parameter to retrieve data from it. How do I fill by datagrid view with the dataset using a parameter?

This is what I have used before to fill with out a parameter:

Code: Select all

orderHeaderSurfaceDataGridView.DataSource = dsPendingOrders1.Tables[1];
            dsPendingOrders1.Fill();

How would I pass a parameter in?

[Shalex]

Code: Select all

orderHeaderSurfaceDataGridView.DataSource = dsPendingOrders1.Tables[1];
(dsPendingOrders1.Tables[1] as Devart.Data.SQLite.SQLiteDataTable).SelectCommand.Parameters["p"].Value = "some value";
dsPendingOrders1.Fill();

Is that what you need? If not, please send us a small test project so that we can better understand a scenario you want to implement.

[garling]

I have it working now thanks.