Mysql command in asp.net c#

Question

I have this code on my page

private object getJobID()
        {
            try
            {
                conn.Open();

                String latestJobID = @"SELECT MAX(jobId) + 1 FROM joborder";

                MySqlCommand cmd = new MySqlCommand(latestJobID, conn);
                MySqlDataReader DR = cmd.ExecuteReader();

                while (DR.Read())
                {
                    return DR[0].ToString();
                }
            }
            catch (MySqlException ex)
            {
                System.Diagnostics.Debug.WriteLine("ERROR: " + ex.ToString());
            }
            finally
            {
                conn.Close();
            }
            return "";
        }

the @"SELECT MAX(jobId) + 1 FROM joborder" do not add + 1 if my table is empty, how can i Add + 1 to my jobId if my table is null, thanks

juharr · Accepted Answer · 2015-11-04 19:22:01Z

1

You can test for null in your query

select COALESCE(MAX(jobId), 0) + 1 FROM joborder

edited Nov 4, 2015 at 19:22

answered Nov 4, 2015 at 19:16

juharr

32.4k4 gold badges60 silver badges95 bronze badges

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

2 Comments

John Paul Cirilos Over a year ago

the query is invalid it directs to catch

juharr Over a year ago

@JohnPaulCirilos Sorry, didn't notice the MySQL tag. In that case use COALESCE instead of ISNULL.

Collectives™ on Stack Overflow

Mysql command in asp.net c#

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related