This is what I have used before to fill with out a parameter:
Code: Select all
orderHeaderSurfaceDataGridView.DataSource = dsPendingOrders1.Tables[1];
dsPendingOrders1.Fill();
Code: Select all
orderHeaderSurfaceDataGridView.DataSource = dsPendingOrders1.Tables[1];
dsPendingOrders1.Fill();
Code: Select all
orderHeaderSurfaceDataGridView.DataSource = dsPendingOrders1.Tables[1];
(dsPendingOrders1.Tables[1] as Devart.Data.SQLite.SQLiteDataTable).SelectCommand.Parameters["p"].Value = "some value";
dsPendingOrders1.Fill();