HI all
    now are two days, 20 hours of work that i'm on this problem without a solution!!!
I think i'll become mad!!!

Here is the problem:

I Use C# 2.0 (VS .Net 2005) with thyped dataset
I Make my connection and the connection generates the DataTables and the TableAdapters
All ok really beautifull
I can add other queries at design time adding other TableAdapters

But my problem is:
I would like to make a query at runtime, the users choose something in the windows form and click on a button.
Then i whant to generate the query.
How to add a method to the tableadapter or is it an other whay?

Plesa if you whant to help me write down a bit of code because i'm really new in the oop and in c# too

thanks all
Gian Paolo

Hi
I think TableAdapter is a design-time feature of Visual Studio 2005. It
generates a lot of code for you when you creating new query.

You can use directly SqlCommand & SqlConnection and get the data.

Best Regards,
A.Hadi

Spooke,

Using the designtime Data wizards you probably cannot. Althouth the way can be to use the DataView, which has in version 2.0 very extended filter mechanismes.

Cor
  HI all
      now are two days, 20 hours of work that i'm on this problem without a solution!!!
  I think i'll become mad!!!

  Here is the problem:

  I Use C# 2.0 (VS .Net 2005) with thyped dataset
  I Make my connection and the connection generates the DataTables and the TableAdapters
  All ok really beautifull
  I can add other queries at design time adding other TableAdapters

  But my problem is:
  I would like to make a query at runtime, the users choose something in the windows form and click on a button.
  Then i whant to generate the query.
  How to add a method to the tableadapter or is it an other whay?

  Plesa if you whant to help me write down a bit of code because i'm really new in the oop and in c# too

  thanks all
  Gian Paolo

SqlCommand slow on INSERT
Q: Whitespaces in WHERE
Connections in pool not being reused
Cascading Deletes in ADO.NET (Please Help!!!)
How to use bind variables effectively for Sql performance?