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
Display the result of stored procedure in to table tag
Loading
Raja TPosted Dec 20, 2015, 5:56 AM
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="
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();