OracleConnection conn = new OracleConnection("Data Source=sxlzwdb;User ID=sxlzwuser;Password=3043221");
conn.Open();
OracleDataAdapter dataadapter1 = new OracleDataAdapter("Select * From User_Info", conn);
DataSet dataset1 = new DataSet();
dataadapter1.Fill(dataset1, "User_Info");
DataRow datarow1;
datarow1 = dataset1.Tables["User_Info"].NewRow();
//datarow1["User_Id"] = default();
datarow1["User_Name"] = this.TextBox_Name.Text;
datarow1["User_Password"] = this.TextBox_Password.Text;
dataset1.Tables["User_Info"].Rows.Add(datarow1);
OracleCommandBuilder cb = new OracleCommandBuilder(dataadapter1);
dataadapter1.Update(dataset1, "User_Info");
conn.Close();
conn.Open();
OracleDataAdapter dataadapter1 = new OracleDataAdapter("Select * From User_Info", conn);
DataSet dataset1 = new DataSet();
dataadapter1.Fill(dataset1, "User_Info");
DataRow datarow1;
datarow1 = dataset1.Tables["User_Info"].NewRow();
//datarow1["User_Id"] = default();
datarow1["User_Name"] = this.TextBox_Name.Text;
datarow1["User_Password"] = this.TextBox_Password.Text;
dataset1.Tables["User_Info"].Rows.Add(datarow1);
OracleCommandBuilder cb = new OracleCommandBuilder(dataadapter1);
dataadapter1.Update(dataset1, "User_Info");
conn.Close();
行 27: OracleConnection conn = new OracleConnection("Data Source=sxlzwdb;User ID=sxlzwuser;Password=3043221");
行 28: conn.Open();
行 29: OracleDataAdapter dataadapter1 = new OracleDataAdapter("Select * From User_Info", conn);
行 30:
OracleCommand cmd = new OracleCommand("select ....",conn);
OracleDataAdapter dataadapter1= new OracleDataAdapter(cmd);
DataSet dataset1 = new DataSet();
dataadapter1.Fill(dataset1, "User_Info");
try catch 一下,看看信息,看看sql 连接串对不对,看看是不是允许了sxlzwuser 登录
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.SqlClient;
/*
* 具体说明:
*1.只能更新一个表,不能更新两个或两个以上相关联的表
*2.表中必须有主键 这点要注意,没有主键的话,会抛异常的。
*3.更新的表中字段不能有image类型的
*-----------------------------
*你把sqlConnection换成 oracleConnection 还有命名空间 ,数据库换一下应该就可以了吧。
*/
namespace WindowsFormsApplication5
{
public partial class Form2 : Form
{
SqlDataAdapter adapter;
DataTable dt;
DataSet ds;
public Form2()
{
InitializeComponent();
} private void button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=28678E561BFF4F2\\JINZHIYUAN;Initial Catalog=master;uid=sa;pwd=sql");
SqlCommand cmd = new SqlCommand("select * from city", con);
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = cmd;
SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
dt = new DataTable();
adapter.Update(ds,"city");
dataGridView1.DataSource = ds.Tables[0];
}
/// <summary>
/// 数据的原始绑定;
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Form2_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=28678E561BFF4F2\\JINZHIYUAN;Initial Catalog=master;uid=sa;pwd=sql");
SqlCommand cmd = new SqlCommand("select * from city",con);
adapter = new SqlDataAdapter(cmd);
dt = new DataTable();
ds = new DataSet(); adapter.Fill(ds);
dt = ds.Tables[0];
ds.Tables[0].TableName = "city";
dataGridView1.DataSource = dt; }
}
}
祝你好运。上述代码我都已经测试通过。
你这个conn根本是无效的 当然后面Fill有错
连接字符串这样写
"
DataSource=服务器名字(或IP);
Initial Catalog=数据库名字;
UserID=sxlzwuser;
Password=3043221
"
DataSouce 要分开写 Data Source
UserID 也要分开写 User ID