public static ArrayList GetList() { DataTable dt = ZFort.DB.Execute.ExecuteString_DataTable("SELECT * FROM Barcodes"); ArrayList al = new ArrayList(); foreach (DataRow dr in dt.Rows) { DBLayer.Barcodes.Details det = new DBLayer.Barcodes.Details(); det.Name = dr["Barcode"].ToString(); al.Add(det); } return(al); }
private void LoadData() { ArrayList al = DBLayer.Barcodes.GetList(); DataTable dt = new DataTable(); dt.Columns.Add("Name"); for (int i = 0; i < al.Count; i++) { DataRow dr = dt.Rows.Add(); DBLayer.Barcodes.Details det = (DBLayer.Barcodes.Details)al[i]; dr["Name"] = det.Name; } grBarcodes.DataSource = dt; }
/*#region Check * * public static bool Check(string name, int id) * { * * Database.Service serv = new Management.Database.Service(); * * return serv.AdvertisingSource_Check(name, id); * } * #endregion*/ #region Insert public static void Insert(DBLayer.Barcodes.Details det) { ZFort.DB.Execute.ExecuteString_void("INSERT INTO Barcodes (Barcode) VALUES ('" + det.Name + "')"); }