how to get sum of values from data base to textbox.i was used below code but it shows an error

Question

1.33/5 (2 votes)

See more:

var connectionString = ConfigurationManager.ConnectionStrings["newproject"].ConnectionString;
SqlConnection cn = new SqlConnection(connectionString);
cn.Open();
string commandString = "select SUM(termfee ) from newstd_termfee where admin_no='" + txtadmin .Text + "'";

SqlCommand sqlCmd = new SqlCommand(commandString, cn);
SqlDataReader read = sqlCmd.ExecuteReader();
while (read.Read())
{
textBox2.Text = read["termfee"].ToString();
}
cn.Close();

Posted 22-Sep-14 19:34pm

Member 11065510

Updated 22-Sep-14 19:36pm

v2

Add a Solution

Comments

KaushalJB 23-Sep-14 1:53am

What error does it shows ?

3 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)

aarif moh shaikh · Accepted Answer · 2014-09-22T20:01:00

Solution 2

Please Replace this Query to your Query.. Defiantly it will Work..

SQL

select SUM(termfee) as termfee from newstd_termfee where admin_no='" + txtadmin .Text + "'"

Posted 22-Sep-14 20:01pm

aarif moh shaikh

Gihan Liyanage · Accepted Answer · 2014-09-22T20:03:00

C#

var connectionString = ConfigurationManager.ConnectionStrings["newproject"].ConnectionString;
SqlConnection cn = new SqlConnection(connectionString);
cn.Open();
string commandString = "select SUM(termfee ) as Total from newstd_termfee where admin_no='" + txtadmin .Text + "'";
 
SqlCommand sqlCmd = new SqlCommand(commandString, cn);
SqlDataReader read = sqlCmd.ExecuteReader();
while (read.Read())
{
textBox2.Text = read["Total"].ToString();
}
cn.Close();

KALYANI BIBIN · Accepted Answer · 2014-09-22T19:53:00

Solution 1

Do like this.

TextBox2.Text = read[0].ToString();

Posted 22-Sep-14 19:53pm

KALYANI BIBIN

Comments

Member 11065510 23-Sep-14 2:10am

thank u so much kalyani bibin..........its working........

KALYANI BIBIN 23-Sep-14 2:21am

k welcome..

KALYANI BIBIN 23-Sep-14 2:46am

Please accept one of the solutions so that the qustion is marked answered. Thank you.

Sinisa Hajnal 23-Sep-14 2:16am

Solution 2 is better, you will not have problems when changing / adding new fields.

Also, never trust user input, clean the text before concatenating to your command. Consider this:
What will happen if someone enters in txtAdmin following text (without brackets) ['; DROP TABLE newstd_termfee; --]
Single quote will close your query, semicollon will mark the end of the command, drop table will delete your table and double minus will comment out the rest of your command.

Read about SQL Injection attacks. Use parametrized query or better yet, stored procedure. Even then, do Server.HtmlEncode and / or replace critical characters (such as single quotes and double minus)