Add new employee again

Hi,

Sorry for delayed reply. You can return last inserted value in SQL Server using simple query. As required by you, there is a requirement of simple Increment operator to display next ID.

SQL command using Output keyword.

string txtQuery = "INSERT into student OUTPUT INSERTED.* values (@RollNo,@FirstName,@LastName,@HomeAdd)";

For complete reference view article at http://www.dotnetspider.com/resources/44397-Get-Last-Inserted-Record-SQL.aspx

Hope this will help you.

You'll need to keep track of the last saved employee number in your application.

You could do so by adding the following static fields to your Form class:

  private static bool firstOpening = true;
  private static int lastEmpId = 0;

As these are static fields, the previous values will be persisted if you close the form and then open it again:

When you save a record you can then update the lastEmpId field. So in John's code you'd have:

 if(successful)
 { 
   lblSuccessMessage.Text = "Record Added Succesfully!";
   lastEmpId++; // increment last emp ID saved

   // get ready to add next record
   ClearFields();
   lblEmpId.Text = (lastEmpId + 1).ToString();
   txtEmpFName.Focus();      
 }

When you open the form, you could check whether this is the first opening. If it is, then you can get the number of records in your database and initialize lastEmpId accordingly:

if (firstOpening)
{
   // do database query to count records in the table
   // set up and open connection and create command object
   // ...
   cmd.CommandText = "SELECT COUNT(*) FROM Employees"; 
   lastEmpId = (int)cmd.ExecuteScalar();
   firstOpening = false;
}

first of all thanks for the reply 
 I think you didn't get it clearly i already know what you coded but i just want to add new record again without closing the form then it should be clear all fields and show the next exp id

Hi,

You can create a method to clear all fields.

Navigate to backend and write a simple function as below.

void ClearFields()
{
  txtEmpFName.Text ="";
  txtEmpLName.Text ="";
  txtEmpAddress.Text ="";
  txtEmpEmail.Text ="";
  txtEmpDOB.Text ="";
  BindAddressSelectionDropdown()
  lblErrorMessage="";
}

And call this method at Button_Click even of submit button only after record submitted successfully.

.......
{
 //Code to submit data.
 if( //Submit is success)
 {
   ClearFields();
   lblSuccessMessage.Text = "Record Added Succesfully!";
 }

}

All the Best.