110,502
社区成员
发帖
与我相关
我的任务
分享
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OracleClient ;
namespace sql_test
{
public partial class Form1 : Form
{
DataSet ds = new DataSet();
public Form1()
{
InitializeComponent();
}
private void btn_Select_Click(object sender, EventArgs e)
{
Sql mysql = new Sql (this);
mysql.CreateQuery(mysql.Insert_TBL_STUDENT(), ds);
}
}
}
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OracleClient;
namespace sql_test
{
class Sql
{
//Form1 myform = new Form1();
public Form1 myfrm;
public Sql (Form1 frm)
{
myfrm = frm;
}
# region CreateQuery
public void CreateQuery(OracleCommand mycmd, DataSet ds)
{
//连接字符串
string connstring = " Data Source = mytemp; User ID = CC; Password = 1;";
OracleConnection conn = new OracleConnection(connstring);
mycmd.Connection = conn;
ds.Clear();
//尝试连接数据库
try
{
conn.Open();
//使用Dataset
OracleDataAdapter da = new OracleDataAdapter(mycmd );
da.Fill(ds);
}
catch (Exception ee)
{
//Response.Write(ee.Message);//如果有错误,输出错误信息
}
finally
{
conn.Close(); //关闭连接
}
}
# endregion
# region Insert_TBL_STUDENT
public OracleCommand Insert_TBL_STUDENT()
{
OracleCommand cmd = new OracleCommand() ;
cmd.CommandText = " Insert into TBL_STUDENT values ";
cmd.CommandText += " (";
cmd.CommandText += " :NAME";
cmd.CommandText += " ,:STUDENT_ID";
cmd.CommandText += " ,:GENDER";
cmd.CommandText += " ,:CLASS";
cmd.CommandText += " )";
cmd.Parameters.Add("NAME", OracleType.VarChar, 20).Value = myfrm.txt_Name.Text.ToString();
cmd.Parameters.Add("STUDENT_ID", OracleType.VarChar, 20).Value = myfrm.txt_Student_Id.Text.ToString();
cmd.Parameters.Add("GENDER", OracleType.VarChar, 10).Value = myfrm.txt_Gender.Text.ToString();
cmd.Parameters.Add("CLASS", OracleType.VarChar, 10).Value = myfrm.txt_Class.Text.ToString();
return cmd ;
}
# endregion
}
}
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OracleClient ;
namespace sql_test
{
public partial class Form1 : Form
{
DataSet ds = new DataSet();
public Form1()
{
InitializeComponent();
}
private void btn_Select_Click(object sender, EventArgs e)
{
Sql mysql = new Sql (this);
mysql.CreateQuery(mysql.Insert_TBL_STUDENT(), ds);
}
}
}
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OracleClient;
namespace sql_test
{
class Sql
{
//Form1 myform = new Form1();
public Form1 myfrm;
public Sql (Form1 frm)
{
myfrm = frm;
}
# region CreateQuery
public void CreateQuery(OracleCommand mycmd, DataSet ds)
{
//连接字符串
string connstring = " Data Source = mytemp; User ID = CC; Password = 1;";
OracleConnection conn = new OracleConnection(connstring);
OracleCommand cmd = conn.CreateCommand ();
ds.Clear();
//尝试连接数据库
try
{
conn.Open();
cmd = mycmd;
//使用Dataset
OracleDataAdapter da = new OracleDataAdapter(cmd );
da.Fill(ds);
}
catch (Exception ee)
{
//Response.Write(ee.Message);//如果有错误,输出错误信息
}
finally
{
conn.Close(); //关闭连接
}
}
# endregion
# region Insert_TBL_STUDENT
public OracleCommand Insert_TBL_STUDENT()
{
OracleCommand cmd = new OracleCommand() ;
cmd.CommandText = " Insert into TBL_STUDENT values ";
cmd.CommandText += " (";
cmd.CommandText += " :NAME";
cmd.CommandText += " ,:STUDENT_ID";
cmd.CommandText += " ,:GENDER";
cmd.CommandText += " ,:CLASS";
cmd.CommandText += " )";
cmd.Parameters.Add("NAME", OracleType.VarChar, 20).Value = myfrm.txt_Name.Text.ToString();
cmd.Parameters.Add("STUDENT_ID", OracleType.VarChar, 20).Value = myfrm.txt_Student_Id.Text.ToString();
cmd.Parameters.Add("GENDER", OracleType.VarChar, 10).Value = myfrm.txt_Gender.Text.ToString();
cmd.Parameters.Add("CLASS", OracleType.VarChar, 10).Value = myfrm.txt_Class.Text.ToString();
return cmd ;
}
# endregion
}
}
OracleCommand cmd = new OracleCommand() ;
cmd.CommandText = " Insert into TBL_STUDENT values ";
cmd.CommandText += " (";
cmd.CommandText += " :NAME";
cmd.CommandText += " ,:STUDENT_ID";
cmd.CommandText += " ,:GENDER";
cmd.CommandText += " ,:CLASS";
cmd.CommandText += " ):;
cmd.Parameters.Add("NAME", OracleType.VarChar, 20).Value = myfrm.txt_Name.Text.ToString();
cmd.Parameters.Add("STUDENT_ID", OracleType.VarChar, 20).Value = myfrm.txt_Student_Id.Text.ToString();
cmd.Parameters.Add("GENDER", OracleType.VarChar, 10).Value = myfrm.txt_Gender.Text.ToString();
cmd.Parameters.Add("CLASS", OracleType.VarChar, 10).Value = myfrm.txt_Class.Text.ToString();
return cmd ;
//先
cmd.Parameters.Add("@NAME", OracleType.VarChar, 20);
//再
cmd.Parameters["@NAME"].Value = myfrm.txt_Name.Text.ToString();
//想直接就
cmd.Parameters.Add("@NAME",myfrm.txt_Name.Text.ToString());