Stored Procedure value to asp.net page under text box

Question

I have a store procedure which show single row value like (x.CLTotalAc, x.CLTotalAmt,x.CLAc, x.CLAmt,x.CL, y.GB_CLTotalAc,y.GB_CLTotalAmt, y.GB_CLAc, y.GB_CLAmt, y.GB_CL).

I want these value to my asp.net C# page under text box (txtCLTotalAmt, txtCL, txtGB_CLTotalAmt, txtGB_CL)

Store Procedure

ALTER proc [dbo].[Cr_CL_Report] 

@ProductName text,
@BranchName text

as
begin
Select x.CLTotalAc,x.CLTotalAmt,x.CLAc, x.CLAmt,x.CL,
y.GB_CLTotalAc,y.GB_CLTotalAmt, y.GB_CLAc, y.GB_CLAmt, y.GB_CL
from 
(
SELECT COUNT(dbo.DDBranchName.BCode) AS BrCode, 
    dbo.TblTotalCL.CLProductName AS ProductName, 
    SUM(dbo.TblTotalCL.CLTotalAc) AS CLTotalAc, 
    SUM(dbo.TblTotalCL.CLTotalAmt) AS CLTotalAmt, 
    SUM(dbo.TblTotalCL.CLAc) AS CLAc, SUM(dbo.TblTotalCL.CLAmt) AS CLAmt, 
    SUM(dbo.TblTotalCL.CLAmt)/SUM(dbo.TblTotalCL.CLTotalAmt) * 100 AS CL
FROM dbo.DDBranchName INNER JOIN
dbo.TblTotalCL ON dbo.DDBranchName.BCode = dbo.TblTotalCL.CLbrCode
    WHERE (dbo.TblTotalCL.CLAsOnDate IN
        (SELECT MAX(CLAsOnDate) AS Expr1 FROM dbo.TblTotalCL AS TblTotalCL_1)) 
    AND (dbo.TblTotalCL.CLProductName LIKE @ProductName) 
    AND (dbo.DDBranchName.BCode LIKE @BranchName)
GROUP BY dbo.TblTotalCL.CLProductName
) x
inner join
(
SELECT  COUNT(dbo.DDBranchName.BCode) AS GB_BrCode, 
    dbo.TblTotalCL.CLProductName AS GB_ProductName, 
    SUM(dbo.TblTotalCL.CLTotalAc) AS GB_CLTotalAc, 
    SUM(dbo.TblTotalCL.CLTotalAmt) AS GB_CLTotalAmt, 
    SUM(dbo.TblTotalCL.CLAc) AS GB_CLAc, 
    SUM(dbo.TblTotalCL.CLAmt) AS GB_CLAmt, 
    (SUM(dbo.TblTotalCL.CLAmt) / SUM(dbo.TblTotalCL.CLTotalAmt))*100 AS GB_CL
FROM dbo.DDBranchName INNER JOIN
dbo.TblTotalCL ON dbo.DDBranchName.BCode = dbo.TblTotalCL.CLbrCode
    WHERE (dbo.TblTotalCL.CLAsOnDate IN
        (SELECT MAX(CLAsOnDate) AS Expr1 FROM dbo.TblTotalCL AS TblTotalCL_1)) 
AND (dbo.TblTotalCL.CLProductName LIKE @ProductName) 



GROUP BY dbo.TblTotalCL.CLProductName 
)  y on
x.ProductName = y.GB_ProductName

end

Blockquote

how can I solve this?

score 0 · Answer 1 · edited May 23 '17 at 12:05

Start by reading up on Ado.net. Use for instance the example here,under adonet data provider examples/sqlclient. When you have this working you have retrieved the data from the database. (imho avoid table adapters, entity framework and linqtosql if you want to grok it. instead go with manually writing for SqlCommand. or dapper to ease some of the burden.)

Now you have to get it to the web page. First decide on Webforms or Aspnetmvc. Then googlewithbing what the syntax is like.

Wash.
Rinse.
Repeat.

HTH

score 0 · Accepted Answer · edited May 23 '17 at 11:57

0

Getting return value from stored procedure in C#

In the link you can see how to get the values form a stored procedure. Then assign the value to the text box

edited May 23 '17 at 11:57

Community

1
1

answered Jun 11 '14 at 08:17

user3729078

16
1

Stored Procedure value to asp.net page under text box

2 Answers2