Display employer id

Banishah · August 6th, 2009, 11:13 AM

hi....how to display the last data(Employer ID) from employer table?

selectStr = "Select Employer_Id from Employer";
cmdSelect = newSqlCommand(selectStr, con);
dtrEmp = cmdSelect.ExecuteReader();
if (dtrEmp.HasRows){
while (dtrEmp.Read())
{
Label2.Text = Convert.ToString(dtrEmp["Employer_Id"]);

}
}
dtrEmp.Close();
i have tried....but still could get the last Employer_Id...can anybody correct it?

Lee Dumond · August 6th, 2009, 03:02 PM

You should be able to do that by using the Read method as you have.

This should work:

Code:

 
using (SqlConnection connection = new SqlConnection("your_connection_string"))
{
   string cmdText = "SELECT Employer_Id FROM Employer";
   SqlCommand command = new SqlCommand(cmdText, connection);
   connection.Open();
   SqlDataReader reader = command.ExecuteReader();
   if (reader != null)
      while (reader.Read())
      {
         Label2.Text = reader["Employer_Id"].ToString();
      }
}

gbianchi · August 6th, 2009, 03:16 PM

Sorry Lee, But I see no difference between you code and OP's code. Maybe he need to clarify what is he looking for??? I think he is looking for a max function or a min one or something like httat. Anyway he will still show always the last ID of the table, with no particular order.

Lee Dumond · August 6th, 2009, 03:45 PM

Quote:

Originally Posted by gbianchi

Sorry Lee, But I see no difference between you code and OP's code.

Maybe you should look closer.

His code never calls the Open method to open the connection.

gbianchi · August 6th, 2009, 03:57 PM

Yep that right, but he doesn't instanciate the connection either, so he could easily has open it before all this...

Anyway, I was just asking because it's not clear what the porpuose of his code.. Maybe Banishah can tell us what he is looking for to do???

Banishah · August 7th, 2009, 11:52 PM

Actually i need the last employerID(e.g EM000003) to add 1 to it and become EM000004 because i want it to be autogenerated once a new employer is added....

gbianchi · August 8th, 2009, 02:02 PM

So in your ID field you have a combo of letters and numbers??

well this just complicate things. Several things you can do is split the field, get the max of the numbers and add one (all in one query).

Banishah · August 9th, 2009, 01:05 AM

But how to split it?

Imar · August 9th, 2009, 04:23 AM

Isn't this simply a matter of presentation and formatting?

I would create an identity field that automatically increases on each new record. Then either in your presentation layer or in a calculated field you combine the EM0000* stuff with the employee id...

Just my 2 cents.

Imar