how to display total cash from sql table to label ?

Question

2.50/5 (2 votes)

See more:

SQL-Server-2005

, +

hi
in my sql table tblCash contains cCash and cDate
so while adding am saving with + for positive value and - for negative value
and am getting total sum like Select SUM(cCash) from tblCash
so am getting total cash..this cash i want to display in Label..whenver i add + or - value it should refresh and shw the current sum..
can any one suggest me.??

or suggest me in ur way.like total cash i want to disply in label o textbox..

thanks

i tried like this
in cash.aspx.cs

private void GetSum()
    {
        string Sum;
        Sum = tbCash.Text;
        con.Open();

        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.CommandText = "usp_SumCash";     
        SqlParameter pSum = new SqlParameter("@Sum", SqlDbType.Int);
        pSum.Direction = ParameterDirection.Output;

        cmd.Parameters.Add(pSum);
        lblTotalCash.Text = pSum.Value.ToString();

        cmd.ExecuteNonQuery();

        con.Close();
    }

and this is my sp

SQL

alter PROCEDURE usp_SumCash
@Sum int Output


AS
BEGIN
set  @Sum=(Select SUM(cCash) from tblCash
where cCash=@Sum)


SET NOCOUNT ON;


END

and am getting error..'
object refernce is not set to an object of an instance..

Posted 24-May-12 5:36am

ythisbug

Updated 24-May-12 6:51am

v3

Add a Solution

Comments

[no name] 24-May-12 15:35pm

You are not getting any error, you are getting an exception. Can you tell me, in which line, you faced the exception. The line should be highlighted in yellow.

ythisbug 25-May-12 0:34am

lblTotalCash.Text = pSum.Value.ToString();

THIS LINE AM GETTING ERROR

Technoses 26-May-12 6:35am

you should use
cmd.ExecuteNonQuery();
before below line

lblTotalCash.Text = pSum.Value.ToString();

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Not Active · Answer 1 · 2012-05-24T06:11:00

Solution 1

Assuming you are using DataBinding

<asp:Label runat="server" Text='<%# DataBinder.Eval(DataItem.Container, "total", "{0:C"} %>'/>

otherwise use string.format the same way.

Posted 24-May-12 6:11am

Not Active

Comments

Maciej Los 24-May-12 12:14pm

My 5!

ythisbug 24-May-12 12:18pm

here total contains??column name??

Prosan · Answer 2 · 2012-05-25T21:46:00

Solution 2

SQL

alter PROCEDURE usp_SumCash
@Sum int Output


AS
BEGIN
set  @Sum=(Select SUM(cCash) from tblCash)
if (len(@Sum)=0) set @Sum=0

SET NOCOUNT ON;


END

remove this line
where cCash=@Sum -- it is out put parameter

Posted 25-May-12 21:46pm

Prosan

Updated 25-May-12 22:00pm

v2