Hi,

This is Pushan Chakraborty from Kolkata.I have complied 2 stored procedure to retrieve the names of 2 user defined tables that I have created . The stored procedures are: set



ANSI_NULLS ON set



QUOTED_IDENTIFIER ON

go

  

-- =============================================

-- Author: <Pushan Chakraborty>

-- Create date: <23rd nov>

-- Description: <retrives the name of a particular table>

-- =============================================

ALTER

PROCEDURE [dbo].[select_table1] @tablename char(50) OUTPUT AS

BEGIN



-- SET NOCOUNT ON added to prevent extra result sets from

 

-- interfering with SELECT statements.

 

SET NOCOUNT ON;

 

SELECT @tablename=name FROM sys.tables where object_id ='1275151588'

 

return (@tablename)

 

END





and

set

ANSI_NULLS ON set



QUOTED_IDENTIFIER ON

go

 

 

-- =============================================

-- Author: <Pushan Chakraborty>

-- Create date: <23rd nov 2009>

-- Description: <to retrieve the name of employee table>

-- =============================================

ALTER

PROCEDURE [dbo].[select_table2] @tablename char(50)OUTPUT AS

BEGIN



-- SET NOCOUNT ON added to prevent extra result sets from

 

-- interfering with SELECT statements.

 

SET NOCOUNT ON;

 

SELECT @tablename=name FROM sys.tables where object_id ='1259151531'

 

return(@tablename)

 

END



but the above procedures are not returning any string value but are returning int value by default. the calling code in vc#.net is:

conn.Open();

 

SqlCommand command = new SqlCommand("select_table1", conn);

command.CommandType = CommandType.StoredProcedure;  



string tab1 = command.ExecuteNonQuery(); comboBox3.Items.Add(tab1);

 



SqlCommand command1 = new SqlCommand("select_table2", conn); command1.CommandType =



CommandType.StoredProcedure;  



string tab2 = command1.ExecuteNonQuery(); comboBox3.Items.Add(tab2);

 



MessageBox.Show("comboBox populated"); conn.Close();

 

It is giving me an error message cannot implicitly convert type int to string:--Plz suggest a solution I want to get the table names by calling the stored procedure which is currently not happening

thanks

Pushan







Software/Hardware used:
visual studio 2005 , sql server 2005