I'm assuming that you are using SQL DB..
public int CountEmpID()
{
string SelStr = "select EMPID from Employee";
SqlDataAdapter da = new SqlDataAdapter(SelStr, con);
DataTable dt = new DataTable();
da.Fill(dt);
return dt.Rows.Count;
}
int e_id = CountEmpID();
EmpIDTxt.Text = e_id.ToString();