新手一只,想用C#窗体进行增删改查的操作,在添加时应该怎么写代码?下面是代码,应该怎么改?
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.OracleClient;
namespace users_1._21
{
public partial class Form2 : Form
{
public Form2()
{
InitializeComponent();
} private void tj_baocun_Click(object sender, EventArgs e)
{
string str1 = tj_name.Text;
string str2 = tj_pwd.Text; string insert = "Insert Into Users Values({0},{1},str1,str2)";
OracleConnection conn = new OracleConnection("Data Source=orcl;User Id=scott;Password=tiger");
conn.Open();
OracleCommand cmd = new OracleCommand(insert,conn);
cmd.CommandText = insert;
cmd.ExecuteNonQuery();
MessageBox.Show("保存成功");
conn.Close();
} private void tj_tuichu_Click(object sender, EventArgs e)
{
this.Close();
}
}
}
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.OracleClient;
namespace users_1._21
{
public partial class Form2 : Form
{
public Form2()
{
InitializeComponent();
} private void tj_baocun_Click(object sender, EventArgs e)
{
string str1 = tj_name.Text;
string str2 = tj_pwd.Text; string insert = "Insert Into Users Values({0},{1},str1,str2)";
OracleConnection conn = new OracleConnection("Data Source=orcl;User Id=scott;Password=tiger");
conn.Open();
OracleCommand cmd = new OracleCommand(insert,conn);
cmd.CommandText = insert;
cmd.ExecuteNonQuery();
MessageBox.Show("保存成功");
conn.Close();
} private void tj_tuichu_Click(object sender, EventArgs e)
{
this.Close();
}
}
}
我想在想做一个界面,就是添加数据,想知道具体应该怎么写,提示cmd.ExecuteNonQuery();这行错误。