My Code
private void button3_Click(object sender, EventArgs e)
{
var query_05 = kn_01.Sp_prueba_00(txt_server.Text, txt_database.Text, txt_table.Text);
foreach (var item_21 in query_05)
{
dt_apellidos.Rows.Add(item_21);
}
}
//Strore Procedure
Create procedure Sp_prueba_00
(
@Servidor_source varchar(50),
@Database_Source varchar(50),
@Table_Source varchar(50)
)
as
Declare @sql varchar(max)
set @sql = 'select * ' + ' from [' + (@Servidor_source) + '].[' + (@Database_Source) + '].dbo.' + (@Table_Source)
execute (@sql)
return 0
Loading
VulpesPosted Nov 2, 2012, 5:27 PM
That in turn implies that the return type of the method kn_01.Sp_prueba_00 must also be int.
To use foreach, query_05 needs to be an enumerable collection of ints such as an array or list.
However, the code should compile without error if you simply do this: