Display the result of stored procedure in to table tag

Question

I need to display the results of a stored procedure in to table tag in asp.net c#. I do not know how to use reasonable control in this case. You help me with. The data returned as shown below

Raja T · Answer

Helo Cao If you need results of SP in to table tag? Try like below points 1) In ASPX page create table tag with some id. Ex 2) You can create SP in Database. EX: CREATE PROCEDURE Sp_TableRes AS BEGIN DECLARE @TR SET @TR= NAME CITY RAJ HYD CHARAN CHENNAI  RETRUN @TR END 3) Finally goto .cs file add below code like Ex: SqlCommand cmd=new SqlCommand(Sp_TableRes yourconenction); cmd.CommandType=CommandType.StoreProcedure; //open your conection con.Open(); string table_Rowdata=cmd.ExecuteNonQuery(); con.Close(); table_res.Rows.Add( table_Rowdata);