All pastes #479099 Raw Edit

joejoe

public text v1 · immutable
·published 2007-05-09 15:13 UTC
rendered paste body
private void loadData()
{
     DataTable dt = new DataTable();

     Database db = DatabaseFactory.CreateDatabase("ConnString");
     DbCommand dbCommand = db.GetStoredProcCommand("usp_GetSECUserRegistrations");
     DataSet objDS = db.ExecuteDataSet(dbCommand);
     dbCommand.Dispose();

     dt = objDS.Tables[0];
     dt.DefaultView.Sort = "Registered DESC";
            
     this.gvUserReg.DataSource = dt;
     this.gvUserReg.DataBind();
}