or
sqlSelectCommand1
.CommandText = "Exec GetStorsPayroll " + _storeid.ToString() + " , '" + strtdte.ToString() + "' , '" + enddte.AddDays(1).ToString() + "'";
sqlSelectCommand1.Connection = sqlConnection1;
sqlDataAdapter1.SelectCommand = sqlSelectCommand1;
this.DataSource = sqlDataAdapter1;
which returns the data in order of last name then first name. But when the report is displayed it is shows the data in order of the empID group. Is there a way to correct this?