public bool add(Bill_DTO bill_dto) { try { SqlCommand _cmd = new SqlCommand('INSERT INTO BILL('ID_BILL,TIMECOMING') VALUES(@ID_BILL,@TIMECOMING)') _cmd.Parameters.Add("ID_BILL", SqlDbType.NVarChar).Value = bill_dto.ID_Bill; _cmd.Parameters.Add("TIMECOMING", SqlDbType.Datetime).Value = bill_dto.TimeComing; dp = new DataProvider(); return dp.ExecuteNonQuery(_cmd) > 0; } catch (Exception ex) { throw ex; } finally { dp.CloseConn(); }
Bill_DTO bill_dto = new Bill_DTO(); Bill_DATA bill_data = new Bill_DATA(); bill_dto.TimeComing= DateTime.now; bill_data.add(bill_dto);
INSERT INTO BILL('ID_BILL,TIMECOMING') VALUES(@ID_BILL,GETDATE())
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)