how to retrieve value from table into a variable and display to textbox

Question

0.00/5 (No votes)

See more:

for example :

command : select sum(Salary) from company i.e salary total=10000

i want to store the total sum into a variable X i.e X=10000

and i want to display that 1000 to textbox

C#

try
{
SqlConnection con = new SqlConnection(con_str);
con.Open();
 
SqlCommand cmd10 = new SqlCommand("select SUM(salary_amt) company ", con);
decimal x = cmd10.ExecuteNonQuery();
Label1.text="Total"+.ToString();
 
con.Close();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}

Posted 11-Mar-15 1:57am

10923679

Updated 11-Mar-15 2:13am

manchanx

v2

Add a Solution

Comments

[no name] 11-Mar-15 8:02am

Did you try it and got stuck somewhere? Then please post the relevant parts of your code. You can use the "Improve question"-widget to edit your question.

10923679 11-Mar-15 8:06am

try
{
SqlConnection con = new SqlConnection(con_str);
con.Open();

SqlCommand cmd10 = new SqlCommand("select SUM(salary_amt) company ", con);
decimal x = cmd10.ExecuteNonQuery();
Label1.text="Total"+x.ToString();

con.Close();
}
catch (Exception ex)
{
Response.Write(ex.Message);

}

4 solutions

Solution 4

C#

     try 
	{	        
		SqlConnection con = new SqlConnection(con_str);
        SqlDataAdapter adapterDa = new SqlDataAdapter("select SUM(salary_amt) as totalSalary from company", con);
        con.Open();
        DataSet dsData = new DataSet();
        adapterDa.Fill(dsData);
        Label1.text="Total"+ dsData.Tables[0].Rows[0]["totalSalary"].ToString();
        con.Close();
	}
	catch (Exception ex)
{
Response.Write(ex.Message);
}

Try this code

Posted 11-Mar-15 2:34am

Surendra0x2

Updated 11-Mar-15 2:36am

v3

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)

manchanx · Accepted Answer · 2015-03-11T02:20:00

Solution 3

Both Solution 1 and Solution 2 provide you with links that lead you to some example code that will work for you.

As an exaplanation why your code is not working - this:

C#

cmd10.ExecuteNonQuery();

doesn't return anything but the number of rows affected by the query, hence "ExecuteNonQuery". It's usually used for Update- and Delete-Statements. To query something where you expect a query result (a Select-Query) you have to use ExecuteReader(..), as you can see in the linked examples of Solution 1 and 2.

Posted 11-Mar-15 2:20am

manchanx

Comments

Praveen Kumar Upadhyay 11-Mar-15 8:37am

He has not added the code when I replied. thanks

[no name] 11-Mar-15 8:41am

Yeah, you were probably typing while he added the code, the time difference is 1 minute :-)

10923679 11-Mar-15 8:52am

you all have help me .. thank you so much

Praveen Kumar Upadhyay 11-Mar-15 8:53am

Welcome

10923679 11-Mar-15 8:54am

i need to know abt this ...

can you please help me with this

for example :

command1 : select sum(B1) from company i.e total=10000

command2: select sum(B2) from company i.e total=6000

command3 : select sum(B3) from company i.e total=500

i want to store the total B1 into a variable X i.e X=10000

total B2 into a variable Y i.e Y=6000

total B3 into a variable Z i.e Z=5000
if(b2 and b3 =0)
{
make payment for b1
}

if(b1 and b3 =0)
{
make payment for b2
}
if(b1 and b2 =0)
{
make payment for b3
}

Jitendra Ku. Sahoo · Accepted Answer · 2015-03-11T02:05:00

Solution 1

Have look Here

Posted 11-Mar-15 2:05am

Jitendra Ku. Sahoo

Comments

10923679 11-Mar-15 8:26am

This is right.. it is working ...

Praveen Kumar Upadhyay · Accepted Answer · 2015-03-11T02:05:00

Solution 2

Below are few posts, that will help you to complete your task.

http://stackoverflow.com/questions/16565035/how-do-i-get-values-from-a-sql-database-into-textboxes-using-c[^]

http://www.c-sharpcorner.com/forums/thread/150572/retrieving-data-from-database-into-textbox-in-C-Sharp-using.aspx[^]

Posted 11-Mar-15 2:05am

Praveen Kumar Upadhyay

Comments

10923679 11-Mar-15 8:27am

thank you