存储过程:
private void button5_Click(object sender, EventArgs e)
{
string connectionString;
string queryString = "UnFreeze";C#
connectionString = @"Data Source=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)" +
"(CONNECT_DATA=(SID=orcl)));User Id=system;Password=740104;";//这个也可以放到Web.Config中。
OracleConnection myConnection = new OracleConnection(connectionString);
OracleCommand cmd = new OracleCommand(queryString, myConnection);
cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("v_student_id", value); cmd.Parameters.Add("v_flag", "0");
try
{ myConnection.Open(); cmd.ExecuteNonQuery();
MessageBox.Show("此卡已经成功解冻"); myConnection.Close(); } catch (OracleException ex)
{ MessageBox.Show("系统错误解冻失败"); }
}
private void button5_Click(object sender, EventArgs e)
{
string connectionString;
string queryString = "UnFreeze";C#
connectionString = @"Data Source=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)" +
"(CONNECT_DATA=(SID=orcl)));User Id=system;Password=740104;";//这个也可以放到Web.Config中。
OracleConnection myConnection = new OracleConnection(connectionString);
OracleCommand cmd = new OracleCommand(queryString, myConnection);
cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("v_student_id", value); cmd.Parameters.Add("v_flag", "0");
try
{ myConnection.Open(); cmd.ExecuteNonQuery();
MessageBox.Show("此卡已经成功解冻"); myConnection.Close(); } catch (OracleException ex)
{ MessageBox.Show("系统错误解冻失败"); }
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货