Pass a table field as a parameter

passing a field to the tableadapter query wizard

Page 1 of 1

0 Replies - 839 Views - Last Post: 09 January 2009 - 04:34 AM Rate Topic: -----

#1 itig2005  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 09-January 09

Pass a table field as a parameter

Post icon  Posted 09 January 2009 - 04:34 AM

Hello, I'm working with C# .NET on Visual Studio 2005 and i'm trying to pass a value that represents a field of a table as a parameter for the tableadapter query wizard.

In the windows form:
this.ordersTableAdapter.FillByOrder(this.masterDataSet.Orders, Field, Item);

In the TableAdapter Query Configuration Wizard:
SELECT idOrder, Type, State FROM dbo.Orders where [b]@field[/b] = @item

field can be or idOrder, Type or State.
Now, the thing is the @field parameter dosn't get passed to the query and the item does.

Is it possible to do this in any way?

Is This A Good Question/Topic? 0
  • +

Page 1 of 1