首先在这里谢谢大神啦!![](http://tb2.bdstatic.com/tb/editor/images/face/i_f02.png?t=20140803)
存储过程:
CREATE OR REPLACE PROCEDURE xiugaichaxun(sCLIENT_ID IN NUMBER)IS
sCLIENT_NAME CHAR(20);
sCLIENT_TYPE CHAR(5);
sCLIENT_ADDRESS VARCHAR2(50);
sCLIENT_REST NUMBER;
sEQU_ID NUMBER;
sLATE_QFMONEY NUMBER;
sRE_YINGSHOU NUMBER;
BEGIN
SELECT CLIENT_NAME,CLIENT_TYPE,CLIENT_ADDRESS,
CLIENT_REST,EQU_ID,LATE_QFMONEY,RE_YINGSHOU INTO sCLIENT_NAME,
sCLIENT_TYPE,sCLIENT_ADDRESS,sCLIENT_REST,sEQU_ID,sLATE_QFMONEY,sRE_YINGSHOU
FROM CHAXUN
where CLIENT_ID=sCLIENT_ID;
COMMIT;
dbms_output.put_line(sCLIENT_ID||sCLIENT_NAME||sCLIENT_TYPE||sCLIENT_ADDRESS
||sCLIENT_REST||sEQU_ID||sLATE_QFMONEY||sRE_YINGSHOU);
END;
![](http://imgsrc.baidu.com/forum/w%3D580/sign=fad8c5a0daf9d72a17641015e42b282a/7a8b8d1001e93901c1ab2ca178ec54e737d19652.jpg)
问题描述:我想调用上面的内个存储过程,输入客户号,返回数据在下面的TEXTBOX中显示,并且可以修改,点击“确认修改”,将修改的内容存储到数据库中!
下面是我写的代码,现在不会写了!
private void button1_Click(object sender, EventArgs e)
//“点击查询的按钮”
{
if (textBox1.Text == "")
{
MessageBox.Show("请输入客户号!");
}
else
{
String ConnectionString = "Provider=MSDAORA;Data Source=oracle;User ID=scott;Password=123456";
OleDbConnection conn1 = new OleDbConnection(ConnectionString);
conn1.Open();
OleDbCommand cmd = conn1.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "xiugaichaxun";
cmd.Parameters.Add("sCLIENT_ID", OleDbType.Numeric).Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
this.textBox1.Text = cmd.Parameters["sCLIENT_ID"].Value.ToString();
}
}
private void button2_Click(object sender, EventArgs e)
//确认修改的按钮
{
if (textBox2.Text == "")
{
MessageBox.Show("客户号必须写!");
}
else if (textBox3.Text == "")
{
MessageBox.Show("姓名必须写!");
}
else if (textBox4.Text == "")
{
MessageBox.Show("客户类型必须写!");
}
else
{
DialogResult result = MessageBox.Show(this,"确认修改客户信息吗?","修改提示",MessageBoxButtons.OKCancel,MessageBoxIcon.Question);
if (result == DialogResult.OK)
{
}
}
}
![](http://tb2.bdstatic.com/tb/editor/images/face/i_f02.png?t=20140803)
存储过程:
CREATE OR REPLACE PROCEDURE xiugaichaxun(sCLIENT_ID IN NUMBER)IS
sCLIENT_NAME CHAR(20);
sCLIENT_TYPE CHAR(5);
sCLIENT_ADDRESS VARCHAR2(50);
sCLIENT_REST NUMBER;
sEQU_ID NUMBER;
sLATE_QFMONEY NUMBER;
sRE_YINGSHOU NUMBER;
BEGIN
SELECT CLIENT_NAME,CLIENT_TYPE,CLIENT_ADDRESS,
CLIENT_REST,EQU_ID,LATE_QFMONEY,RE_YINGSHOU INTO sCLIENT_NAME,
sCLIENT_TYPE,sCLIENT_ADDRESS,sCLIENT_REST,sEQU_ID,sLATE_QFMONEY,sRE_YINGSHOU
FROM CHAXUN
where CLIENT_ID=sCLIENT_ID;
COMMIT;
dbms_output.put_line(sCLIENT_ID||sCLIENT_NAME||sCLIENT_TYPE||sCLIENT_ADDRESS
||sCLIENT_REST||sEQU_ID||sLATE_QFMONEY||sRE_YINGSHOU);
END;
![](http://imgsrc.baidu.com/forum/w%3D580/sign=fad8c5a0daf9d72a17641015e42b282a/7a8b8d1001e93901c1ab2ca178ec54e737d19652.jpg)
问题描述:我想调用上面的内个存储过程,输入客户号,返回数据在下面的TEXTBOX中显示,并且可以修改,点击“确认修改”,将修改的内容存储到数据库中!
下面是我写的代码,现在不会写了!
private void button1_Click(object sender, EventArgs e)
//“点击查询的按钮”
{
if (textBox1.Text == "")
{
MessageBox.Show("请输入客户号!");
}
else
{
String ConnectionString = "Provider=MSDAORA;Data Source=oracle;User ID=scott;Password=123456";
OleDbConnection conn1 = new OleDbConnection(ConnectionString);
conn1.Open();
OleDbCommand cmd = conn1.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "xiugaichaxun";
cmd.Parameters.Add("sCLIENT_ID", OleDbType.Numeric).Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
this.textBox1.Text = cmd.Parameters["sCLIENT_ID"].Value.ToString();
}
}
private void button2_Click(object sender, EventArgs e)
//确认修改的按钮
{
if (textBox2.Text == "")
{
MessageBox.Show("客户号必须写!");
}
else if (textBox3.Text == "")
{
MessageBox.Show("姓名必须写!");
}
else if (textBox4.Text == "")
{
MessageBox.Show("客户类型必须写!");
}
else
{
DialogResult result = MessageBox.Show(this,"确认修改客户信息吗?","修改提示",MessageBoxButtons.OKCancel,MessageBoxIcon.Question);
if (result == DialogResult.OK)
{
}
}
}