Pass variable between windows form and DataSet TableAdapter SQL where clause

[karlhungus]

In Visual Studio 2010, I have a windows forms application frmMain.cs with a ComboBox. From the form itself I can access its value with cmbxYear.SelectedValue. I also have a DataSet.xsd file to bind to an rdlc report to a TableAdapter to present view data. The TableAdapter has a SelectCommand that takes SQL code. I need to get the value of cmbxYear.SelectedValue into the WHERE clause of the TableAdapter.
Does anyone know how I can access/pass the variable value from the form into the DataSet TableAdapter SelectCommand WHERE clause?
(I am open to other ideas of how to filter an rdlc report with a variable defined on the windows form.)

[karlhungus]

I have stumbled upon something that says you can subclass a TableAdapter to change the SQL at runtime. Can someone elaborate on this strategy?

[alykins]

Call me ignorant- but I have no clue what a TableAdapter is (have never used it)... I researching "what" it is (was looking for it's class lib) I found the MSDN overview and it seems as though it is some object GUI wizard thing....

If you are truly making and aspx page (or hell even a windows form- or for that matter anything utilizing the .net framework) why not use
the SqlDataAdapter class
and the DataSet class? I think your life would be easier... the DataSet class has methods for reading/writing both xml and xsd

[karlhungus]

I am using the OleDb provider for Oracle.
The bind variable should be a question mark ? not :DEPTCODE

The bind variable :DEPTCODE would be valid for System.Data.OracleClient

See full walk through here: http://www.fullstackbusinessdesign.c...ORA-01008.html

Many thanks to Prashant Kumar for this solution.
http://forums.asp.net/members/Prashant%20Kumar.aspx