I want to change the date format in the database storage firebird.
code
- public int Save(Pegawai PG)
- {
- using (FbCommand cmd = conn.CreateCommand())
- {
- cmd.CommandText = "Simpanpegawai";
- cmd.CommandType = System.Data.CommandType.StoredProcedure;
- cmd.Parameters.AddWithValue("KodePelanggan", FbDbType.VarChar).Value = PG.KodePegawai;
- cmd.Parameters.AddWithValue("Nama", FbDbType.VarChar).Value = PG.Nama;
- cmd.Parameters.AddWithValue("TempatLahir", FbDbType.VarChar).Value = PG.TempatLahir;
- cmd.Parameters.AddWithValue("TanggalLahir", FbDbType.Date).Value = PG.TanggalLahir; //Masukkan Dengan Format Tanggal "dd/mm/yyyy"
- cmd.Parameters.AddWithValue("JenisKelamin", FbDbType.VarChar).Value = PG.JenisKelamin;
- cmd.Parameters.AddWithValue("Alamat", FbDbType.VarChar).Value = PG.Alamat;
- cmd.Parameters.AddWithValue("Telp", FbDbType.Numeric).Value = PG.Telp;
- cmd.Parameters.AddWithValue("HP", FbDbType.Numeric).Value = PG.HP;
- cmd.Parameters.AddWithValue("Pendidikan", FbDbType.VarChar).Value = PG.Pendidikan;
- cmd.Parameters.AddWithValue("IDJabatan", FbDbType.Integer).Value = PG.IDJabatan;
- cmd.Parameters.AddWithValue("NoRek", FbDbType.Numeric).Value = PG.NoRek;
- cmd.Parameters.AddWithValue("TanggalMasuk", FbDbType.Date).Value = PG.TanggalMasuk; //Masukkan Dengan Format Tanggal "dd/mm/yyyy"
- cmd.Parameters.AddWithValue("TanggalKeluar", FbDbType.Date).Value = PG.TanggalKeluar; //Masukkan Dengan Format Tanggal "dd/mm/yyyy"
- cmd.Parameters.AddWithValue("Foto", FbDbType.VarChar).Value = PG.Foto;
- cmd.Parameters.AddWithValue("Keterangan", FbDbType.VarChar).Value = PG.Keterangan;
- return cmd.ExecuteNonQuery();
- }
- }
error:
An unhandled exception of type 'System.FormatException' occurred in FirebirdSql.Data.FirebirdClient.dll Additional information: String was not recognized as a valid DateTime.Help Please
Nishant MittalPosted May 4, 2016, 1:43 AM
Purba AnggaraPosted May 4, 2016, 1:39 AM
Nishant MittalPosted May 3, 2016, 11:26 PM