OracleConnection con = new OracleConnection(conStr);
string sqlStr = "UPDATE ANKETAR SET CREDIT=':CREDIT', DATECREDIT=':DATECREDIT', TIMELIMIT=':DATECREDIT', NOMER=':NOMER', DELAYCREDIT=':DELAYCREDIT', COST=':COST', STATUS='3' WHERE UIZ=':UIZ'";
con.Open();
OracleCommand cmd = new OracleCommand(sqlStr);
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(":CREDIT", OracleDbType.Char, 10);
cmd.Parameters.Add(":NOMER", OracleDbType.Char, 20);
cmd.Parameters.Add(":DELAYCREDIT", OracleDbType.Char, 10);
cmd.Parameters.Add(":UIZ", OracleDbType.Char, 40);
cmd.Parameters.Add(":COST", OracleDbType.Int32, 20);
cmd.Parameters.Add(":DATECREDIT", OracleDbType.Date, 8);
cmd.Parameters[":CREDIT"].Value=SumCredit.ToString();
string Nomer = Session["Nomer"].ToString();
cmd.Parameters[":NOMER"].Value=Nomer;
cmd.Parameters[":DELAYCREDIT"].Value=delay.ToString();
string UIZ = Session["selectedUIZ"].ToString();
cmd.Parameters[":UIZ"].Value=UIZ;
DateTime DateCredit = Convert.ToDateTime(Session["DateCredit"]);
cmd.Parameters[":DATECREDIT"].Value=DateCredit;
cmd.Parameters[":COST"].Value=Cost;
int raff = cmd.ExecuteNonQuery();
con.Close();
lblError.Text = "сохранено в БД"+raff;
|