foreach statement cannot operate on variables of type 'int' because 'int' does not contain a public definition for 'GetEnumerator'

Question

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

Vulpes · Answer

All I can tell you is that query_05 must be a scalar variable of type int to get that error. 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: int item_21 = kn_01.Sp_prueba_00(txt_server.Text txt_database.Text txt_table.Text); dt_apellidos.Rows.Add(item_21);