public static void PrescriptionList(PrescList preitem) { string g1Query = string.Format(@"INSERT INTO PRESCRIPTION_LIST (PRE_ID,PET_ID,ORDER_DATE) VALUES(PREID_SEQ.NEXTVAL,{0},SYSDATE)", Convert.ToInt64(preitem.PetID)); // Convert.ToInt64 주의 string hQuery = string.Format(@"select PREID_SEQ.CURRVAL FROM DUAL"); cmdString = new OracleCommand(g1Query, cntString); cmeString = new OracleCommand(hQuery, cntString); try { cntString.Open(); cmdString.ExecuteNonQuery(); cmeString.ExecuteNonQuery(); OracleDataAdapter da = new OracleDataAdapter(cmeString); DataTable dt = new DataTable(); DataSet ds = new DataSet(); da.Fill(dt); ds.Tables.Add(dt); preitem.PrescID = dt.Rows[0]["CURRVAL"].ToString(); } finally { cntString.Close(); } }
protected void StartIssue_Click(object sender, EventArgs e) { PetID = PetIDList.SelectedValue.ToString(); PrescList newPresc = new PrescList(PrescID, PetID, PrescOrderDate); try { ConnectionClass.PrescriptionList(newPresc); ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert(' Success! ');</script>"); displayPetID.Text = PetID; displayPrescID.Text = newPresc.PrescID; // This goes to prescriptionID and array } catch { ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('failed');</script>"); } finally { } }