Return value of sql query to textbox in C#

Question

I want to access the last value in database column increment it by 1 and show on a textbox I used this code but nothing is displayed on text box what's wrong with this code?

SqlCommand cmd = new SqlCommand("SELECT (MAX[Account_No]  FROM addcustomer ", my);

int result = ((int)cmd.ExecuteScalar());
textBox1.Text = result.ToString();

Is there any kind of exception? Frankly I can't see a way by now how this could go wrong without an error. (By the way, you're not incrementing result in this code. Did you spare it out for brevity or forget?) — Matthias Meid
– Matthias Meid, Commented Sep 4, 2013 at 8:39
i try it likeSqlCommand cmd = new SqlCommand("SELECT (MAX[Account_No]+1) FROM addcustomer ", my); but every time nothing displayed on textbox — user1577711
– user1577711, Commented Sep 4, 2013 at 8:45
SELECT MAX(Account_No) + 1 FROM addcustomer might work better. This does not solve your first problem though, so may I ask for an exception detail again? You might need to configure Visual Studio to notify you about exceptions, even if wrapped in try/catch blocks: Try Debug, Exceptions and check Thrown for Common Language Runtime Exceptions. This might show you additional information. — Matthias Meid
– Matthias Meid, Commented Sep 4, 2013 at 8:49
@user1577711 please add the code from before this block: what are you setting the value of my to? — iabbott
– iabbott, Commented Sep 4, 2013 at 9:17

Soner Gönül · Accepted Answer · 2013-09-04 08:52:51Z

2

SqlCommand cmd = new SqlCommand("SELECT MAX(Account_No)  FROM addcustomer ", my);
int result = ((int)cmd.ExecuteScalar()) + 1;
textBox1.Text = result.ToString();

edited Sep 4, 2013 at 8:52

answered Sep 4, 2013 at 8:29

Soner Gönül

99.1k103 gold badges224 silver badges375 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

user1577711 Over a year ago

still no working.i also try with [] brackets. no working.is some thing wrong with select query.

Soner Gönül Over a year ago

@user1577711 Wait a second.. What do you mean with access last value ? ExecuteScalar gets first column value of first row. Please clarify your question.

iabbott Over a year ago

The select code you have posted should return the highest account number in your database and display that number in the text box

user1577711 Over a year ago

i want to access last record no increment it by one and show on textbox. how i can do this

Damith Over a year ago

@user1577711 is your last record having max Account_No ? or how you going to identify last record?

gregjer · Accepted Answer · 2013-09-04 08:30:13Z

1

You have wrongly placed bracket. Change this

SqlCommand cmd = new SqlCommand("SELECT (MAX[Account_No]  FROM addcustomer ", my);

into that

SqlCommand cmd = new SqlCommand("SELECT MAX(Account_No)  FROM addcustomer ", my);

answered Sep 4, 2013 at 8:30

gregjer

2,8432 gold badges20 silver badges18 bronze badges

Comments

Damith · Accepted Answer · 2013-09-04 08:59:37Z

0

you can change the sql statement as below

SELECT MAX(Account_No) + 1 FROM addcustomer

or increment after selecting value by code

SqlCommand cmd = new SqlCommand("SELECT MAX(Account_No)  FROM addcustomer ", my);
int result = ((int)cmd.ExecuteScalar()) +1;

Final Code would be :

try
{
    using (SqlConnection con = new SqlConnection(connectionString))
    using (SqlCommand cmd = new SqlCommand("SELECT MAX(Account_No) + 1 FROM addcustomer", con))
    {
        con.Open();
        int result = (int)cmd.ExecuteScalar();
        textBox1.Text = result.ToString();
    }
}
catch (SqlException ex)
{
    MessageBox.Show(ex.ToString()); // do you get any Exception here?
}

edited Sep 4, 2013 at 8:59

answered Sep 4, 2013 at 8:51

Damith

63.2k13 gold badges106 silver badges154 bronze badges

3 Comments

user1577711 Over a year ago

both are not displaying any this. is there any way to check that sql qurry is returning somthing or not.

Damith Over a year ago

do you have number for Account_No column?

user1577711 Over a year ago

yes after all at least display some thing on textbox. thank you dear. i am searching it for a long time

iabbott · Accepted Answer · 2013-09-04 08:28:34Z

0

Looks like you're missing a bracket:

SqlCommand cmd = new SqlCommand("SELECT (MAX[Account_No]  FROM addcustomer ", my);

should be

SqlCommand cmd = new SqlCommand("SELECT MAX(Account_No)  FROM addcustomer", my);

answered Sep 4, 2013 at 8:28

iabbott

8911 gold badge8 silver badges24 bronze badges

Comments

Hamlet Hakobyan · Accepted Answer · 2013-09-04 08:29:44Z

0

SqlCommand cmd = new SqlCommand("SELECT MAX(Account_No)  FROM addcustomer ", my);

answered Sep 4, 2013 at 8:29

Hamlet Hakobyan

33.5k6 gold badges55 silver badges70 bronze badges

1 Comment

user1577711 Over a year ago

this code is not workinh.i want to access last record no increment it by one and show on textbox. how i can do this

Collectives™ on Stack Overflow

Return value of sql query to textbox in C#

5 Answers 5

5 Comments

Comments

3 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

5 Comments

Comments

3 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related