public static DataTable GetStateListForDDL() { DataSet oDS = new DataSet(); DAL.DataProvider.SqlClientProvider oSqlClientProvider = new DAL.DataProvider.SqlClientProvider(); oDS = oSqlClientProvider.GetStateListForDDL(); return(oDS.Tables[0]); }