Call TableAdapter methods

Call TableAdapter methods

Postby Mi7chVB » Thu 22 Sep 2011 14:04

I have a problem. In my Visual Studio 2010 project I have added a new DataSet ( using the wizard ) from our database.

When I go to the Dataset I have created, I see all of my tables and stored procedures. On one of my table I have added a new sql query to the TableAdapters.

Now is my question how do you call that specific method?

For example I have a Table called 'Countries' and in my TableAdapter ( CountriesTableAdapter ) I have created FillCountriesByEurope and GetCountriesByEurope methods.

When using SQL Server you can call the TableAdapters from the DataSet created by DataSetNameTableAdapters. When using dotConnect for mysql you don't have this option ???
Mi7chVB
 
Posts: 2
Joined: Thu 22 Sep 2011 13:55

Postby Mi7chVB » Mon 26 Sep 2011 08:06

Found the solution...

It was in the properties of the devart DataSet. Custom Tool must be set as MSDataSetGenerator.
Mi7chVB
 
Posts: 2
Joined: Thu 22 Sep 2011 13:55

Re: Call TableAdapter methods

Postby Shalex » Tue 27 Sep 2011 14:09

Mi7chVB wrote:When using SQL Server you can call the TableAdapters from the DataSet created by DataSetNameTableAdapters. When using dotConnect for mysql you don't have this option ???

dotConnect for MySQL generates datasets basing on MySqlDataTable which replaces Devart.Data.MySql.MySqlConnection, MySqlCommand, MySqlDataAdapter, and MySqlCommandBuilder classes with all-in-one class:
http://www.devart.com/dotconnect/mysql/docs/?Devart.Data.MySql~Devart.Data.MySql.MySqlDataTable.html.
That's why there are no TableAdapters in our code generation.
Shalex
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for MySQL