regarding TableData Adapters?

Hi,
As recommended by MS, i use the Designer to create Optimistic concurrency enabled DAL.
In it we have to create a Table Adapter, i can understand up to "Choose methods to Generate" where i give name for method that fills the Data table and Name the method that returns the DataTable. by default thsi is set to Fill() and GetData().
I use stored "use existing stored procedures" in the "chose command type" dialog. After click to finish it added the
following line in the designer table "Fill" and "GetData( )".
I have few question regarding the table that is created:
When i use the stored procedure the table name of the designed table (the table like Icon that displays on the .XSD), the table name is assigned with the name of the stored procedure. the method i create in the designer GetData() assigned values to select, update, Insert and delete commands. THis GetData() will return all the rows of the table.
Assume i need to create a search method that will search an item by index and i want to name it as GetItemsByIndex(Index), i have to right click on the
TableDataAdapter --> add Query --> select from existing Stored Procedure à Select the new stored procedure that search from index à select tabular data à named the fill and Getdata methodsà finish
When I click Finish it throws this error : "The new command text returns data with schema different from schema of the main query, check your queries command text is this is not desired ",
ERROR:
When I do preview of the data of the data returned by GetItemsByIndex() by right click à preview data it doesn't display the data properly.
But when I create a new DataTable in the .XSD with a new TableDataAdapter then I create a new method to fetch data then only it works.
I don't understand why I can only add one method (a GetData method) with Optimistic concurrency and if I need to add another (assume GetItemByIndex(index)) I need to create a another table with a new TableDataAdapter,

How do I add more than one method that will return table data with optimistic concurrency under on TableDataAdapter?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

jinge17y ago
You get the warning is because, the returned schema is different from your main query. But it will not influence the result of the query, please check out if your filter condition is right. For example, is your where clause set correct.
In my sample, I don't need to create extra datatable to get right data.