C# (CSharp) Signature.Data MySQL.GetDataTable Beispiele

Beispiel #1

 public DataTable GetActiveUsers()
 {
     return(oMySql.GetDataTable("SELECT User,  DateTime, Now(), (TIME_TO_SEC(NOW()) - TIME_TO_SEC(DateTime))/60 FROM `user` Where DateTime is not null and (TIME_TO_SEC(NOW()) - TIME_TO_SEC(DateTime))/60 <10"));
 }

Beispiel #2

Datei: Teacher.cs Projekt: SublateTech/Sales-Packing-Pooling-Ordering-Invoicing-ICR

 public DataTable GetAll()
 {
     return(oMySql.GetDataTable(String.Format("Select * from Teacher Where CompanyID='{0}' And CustomerID='{1}'", this.CompanyID, this.CustomerID)));
 }