Change SQL from DataSetDesinger during Code
Change SQL from DataSetDesinger during Code
Hey
I do use mySQLDirect.NET Version 3.50.15
I create my DataSet with the DataSet Designer. This works fine.
But, is there a possibility to change the Select Statement, because for finding some specific data in the DataBase? - Like Name
Example:
I create the DataBase with my whole data from the table person. - The table person has a relation to the table article. - The problem is, that there is so much data in both tables, that the communication to the server uses a too long time.
Now I want to specify my Select statement. - Like "Select * from person where ID=IDNumber"
Is this possible to do?
Hope you understand my problem. - THX
I do use mySQLDirect.NET Version 3.50.15
I create my DataSet with the DataSet Designer. This works fine.
But, is there a possibility to change the Select Statement, because for finding some specific data in the DataBase? - Like Name
Example:
I create the DataBase with my whole data from the table person. - The table person has a relation to the table article. - The problem is, that there is so much data in both tables, that the communication to the server uses a too long time.
Now I want to specify my Select statement. - Like "Select * from person where ID=IDNumber"
Is this possible to do?
Hope you understand my problem. - THX
I am sorry, but the help did not help enough...
Example, what I have to do:
I do use List & Label as well in my project. - L&L is a programm, similar to Crystal. - To use the tool, I have to hand over a DataSet with the specific data. - When I want to hand over a special Customer with a special ID, I have to add the ID into the select Statement during runtime.
Such a sample I want to see, how this can work. - Also how to work with the Update/Delete Command in such a situation.
Hope this explains better, what I need to do.
Yours faithfully
Example, what I have to do:
I do use List & Label as well in my project. - L&L is a programm, similar to Crystal. - To use the tool, I have to hand over a DataSet with the specific data. - When I want to hand over a special Customer with a special ID, I have to add the ID into the select Statement during runtime.
Such a sample I want to see, how this can work. - Also how to work with the Update/Delete Command in such a situation.
Hope this explains better, what I need to do.
Yours faithfully