Max2006
Wed Jul 23 08:39:29 CDT 2008
Hi Cor,
Thank you for reply.
I agree that we cannot configure TableAdaper code to handle multiple
resultset and we have to extend it.
However the idea of adding an overload Fill method to the partial class to
extend the table mapping is a nice workaround. Would you be agree?
Thanks again,
Max
"Cor Ligthert[MVP]" <notmyfirstname@planet.nl> wrote in message
news:04E0F32D-B571-442D-A9F2-61B4CBBC43DB@microsoft.com...
> Max,
>
> But the tableadapter handles in this case everytime single resultsets and
> therefore it is another situation then your question.
> In this case you need two SQL procedures (if it is an SP or a dynamic one
> is not so important in this case).
>
> Therefore there is in my idea only one correct answer to your question,
> and that is the one Linda gave you.
>
> (With the table adapter you don't even need mapping, Fill is always adding
> to a dataset, never creating a new one or clean it. That you have to do
> explicitily. If a new resultset with a new name is returned it created
> direct a new DataTable with the given name.
>
> Funny is that the page gives as well direct an answer to an in my idea
> completely wrong reply from another MSFT in this newsgroup today.
>
> Cor
>
>
>
> "Max2006" <alanalan1@newsgroup.nospam> schreef in bericht
> news:333CBC65-CE3A-439B-8616-ACCEECF4640F@microsoft.com...
>> Hi Linda,
>>
>> I found the TableAdapter solution here:
>>
>>
http://blogs.msdn.com/vbteam/archive/2007/03/13/tableadapter-multiple-result-sets.aspx
>>
>> Thank you for reply,
>> Max
>>
>>
>>
>> "Linda Liu[MSFT]" <v-lliu@online.microsoft.com> wrote in message
>> news:KPqv5j66IHA.5352@TK2MSFTNGHUB02.phx.gbl...
>>> Hi Max,
>>>
>>> Firstly, a TableAdapter is usually used to fill a DataTable at one time.
>>> In
>>> your scenario, you'd like to fill two TableTables with only one database
>>> call. So it's not appropriate to use a TableAdapter to do this. I
>>> suggest
>>> that you use a DataAdapter.
>>>
>>> Secondly, if the SelectCommand of a DataAdapter returns mulitple result
>>> sets at one time, the DataAdapter use table mappings to fill
>>> corresponding
>>> DataTables in a DataSet. By default, the first result set will be filled
>>> to
>>> a DataTable named "Table", and the second result set will be filled to a
>>> DataTable named "Table1" and so on.
>>>
>>> The following is a sample. It assumes that there're two tables named
>>> "Student" and "Teacher" and a store procedure called "SelectST" that
>>> retrieve all rows from the two database tables in DB. The code snippet
>>> below creates a SqlDataAdapter and fill a strong-typed DataSet
>>> containing a
>>> "Student" DataTable and a "Teacher" DataTable using the SqlDataAdapter.
>>>
>>> SqlDataAdapter sqlDa = new SqlDataAdapter();
>>> SqlCommand selectCmd = new SqlCommand();
>>> selectCmd.CommandText = "SelectST";
>>> selectCmd.CommandType = CommandType.StoredProcedure;
>>> selectCmd.Connection = this.sqlConnection1;
>>>
>>> sqlDa.SelectCommand = selectCmd;
>>> // add table mappings to the SqlDataAdapter
>>> sqlDa.TableMappings.Add("Table", "Student");
>>> sqlDa.TableMappings.Add("Table1", "Teacher");
>>>
>>> // DataSet1 is a strong-typed DataSet
>>> DataSet1 ds = new DataSet1();
>>> this.sqlConnection1.Open();
>>> // after this line code is executed, the two DataTables(Student and
>>> Teacher) are filled with the corresponding result sets
>>> sqlDa.Fill(ds);
>>> this.sqlConnection1.Close();
>>>
>>> Hope this helps.
>>> If you have any question, please feel free to let me know.
>>>
>>>
>>> Sincerely,
>>> Linda Liu
>>> Microsoft Online Community Support
>>>
>>> Delighting our customers is our #1 priority. We welcome your comments
>>> and
>>> suggestions about how we can improve the support we provide to you.
>>> Please
>>> feel free to let my manager know what you think of the level of service
>>> provided. You can send feedback directly to my manager at:
>>> msdnmg@microsoft.com.
>>>
>>> ==================================================
>>> Get notification to my posts through email? Please refer to
>>>
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
>>> ications.
>>>
>>> Note: The MSDN Managed Newsgroup support offering is for non-urgent
>>> issues
>>> where an initial response from the community or a Microsoft Support
>>> Engineer within 1 business day is acceptable. Please note that each
>>> follow
>>> up response may take approximately 2 business days as the support
>>> professional working with you may need further investigation to reach
>>> the
>>> most efficient resolution. The offering is not appropriate for
>>> situations
>>> that require urgent, real-time or phone-based interactions or complex
>>> project analysis and dump analysis issues. Issues of this nature are
>>> best
>>> handled working with a dedicated Microsoft Support Engineer by
>>> contacting
>>> Microsoft Customer Support Services (CSS) at
>>>
http://msdn.microsoft.com/subscriptions/support/default.aspx.
>>> ==================================================
>>> This posting is provided "AS IS" with no warranties, and confers no
>>> rights.
>>>
>