Good idea, but unfortunatelly doesn't work. It seems like the name of the table (select) never comes from Stored Procedure to the DataSet.Table. This is very sad, because any time the stored procedure is changed, the code has to be recompiled. So what I did, is an additional SELECT with the names of the tables in the order it goes in the SP. This way I know how many tables I get and the names and the order :-)

use ListBox and change the SelectedIndex/SelectedValue property every time you add some record

What do you mean: "you can't"? There has to be some proper way to get tables named then counting them in the SP and then reading them like myDataSet.Tables[5]. And what if SP has been changed? Will I have to recompile the whole project? BTW, If I can't then why do I need this property "TableName" at all?

modified on Tuesday, March 3, 2009 1:55 AM

Hello, I have a little Stored Procedure (SQL Server 2005), which returns some tables. Now, I'm getting those tables in the DataSet in my code. The problem is that I'm not getting TableName of none of the tables. All I get is a default naming convention "Table", Table1", Table2" .... What is the way to get the TableName from SP? How can I basically know which table represents which select in the SP? Thanks, Maxim

If you have the same delimiter between strings, then the easiest way is to use Split() method of string class.

string str = "aaa::bbb::ccc";
string[] splittedStrings = str.Split("::");

But, if the explression is more difficult, then Regex is a good solution

1. In order to create an event in your call you should do declare two things: a. Declare public delegate b. Declare public event which is an instance of this delegate

public delegate void ClickHandler(int Param1, int Param2);
public event ClickHandler Click;

Then when you want to fire this event you just call it:

private void foo(){
...
...
Click(argument1, argument2);
...
}

2. File.Copy should work if you map the drive

Hello, I have a little Stored Procedure (SQL Server 2005), which returns some tables. Now, I'm getting those tables in the DataSet in my code. The problem is that I'm not getting TableName of none of the tables. All I get is a default naming convention "Table", Table1", Table2" .... What is the way to get the TableName from SP? How can I basically know which table represents which select in the SP? Thanks, Maxim