public partial class AddInfo : UserControl
{
//public DataTable DTable;
//public OleDbDataAdapter ad;
//private SqlConnection Connection;
//private SqlDataAdapter DataAdapter;
//private SqlCommandBuilder Builder;
private DataSet Ds;
private OleDbConnection Connection;
private OleDbDataAdapter DataAdapter;
private OleDbCommandBuilder Builder;
public AddInfo()
{
InitializeComponent();
this.BackColor = Color.White;
//Connection = new SqlConnection(MyDepot.Properties.Settings.Default.MydeConnectionString);
Connection = new OleDbConnection(MyDepot.Properties.Settings.Default.MydeportConnectionString);
Connection.Open();
//MessageBox.Show(MyDepot.Properties.Settings.Default.MydeConnectionString);
//DataAdapter = new SqlDataAdapter("select * from [DEPORT]", Connection);
DataAdapter = new OleDbDataAdapter("select * from [DEPORT]", Connection);
DataAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
//Builder = new SqlCommandBuilder(DataAdapter);
Builder = new OleDbCommandBuilder(DataAdapter);
Builder.QuotePrefix = "[";
Builder.QuoteSuffix = "]";
Ds = new DataSet();
DataAdapter.Fill(Ds, "DEPORT");
this.dataGridView1.DataSource = Ds.Tables[0];
Connection.Close();
} private void AddInfo_Load(object sender, EventArgs e)
{
}
// public DataTable ShowTable
//{
//get { return DTable; }
//set
// {
// DTable=value;
// }
// } private void button1_Click(object sender, EventArgs e)
{
DataRow dr = Ds.Tables[0].NewRow();
dr[0] = mytextBox1.TextBoxString;
dr[1] = mytextBox2.TextBoxString;
dr[2] = mytextBox3.TextBoxString;
dr[3] = mytextBox4.TextBoxString;
dr[4] = mytextBox5.TextBoxString;
dr[5] = mytextBox6.TextBoxString;
dr[6] = mytextBox7.TextBoxString;
dr[7] = mytextBox8.TextBoxString;
dr[8] = mytextBox9.TextBoxString;
Ds.Tables[0].Rows.Add(dr);
Ds.Tables[0].AcceptChanges();
} private void button2_Click(object sender, EventArgs e)
{
DataAdapter.Update(Ds.Tables["DEPORT"]);
//OleDbConnection Connection = new OleDbConnection(MyDepot.Properties.Settings.Default.MydeportConnectionString);
// Connection.Open();
// SqlCommand cmd = new SqlCommand("delete from DEPORT WHERE [DE-ID]='2'",Connection);
//cmd.ExecuteNonQuery();
// Connection.Close();
}
}
我把dataGridView等都放在一个用户控件里,mytextBox是自己重新绘制的TEXTBOX,TextBoxString是个属性
public string TextBoxString
{
get { return textBox1.Text.Trim(); }
set { textBox1.Text = value; }
}
我分别试了两种数据库ACCESS和SQLEXPRESS但就是不能更新,DataAdapter.Update(Ds.Tables["DEPORT"])执行了也没用数据库的数据不变,ACC我用VS生成数据源可以新增数据,但SQLEXPRESS自动数据源也不能新增,
我编程方面是不是没错啊??那我哪可能有问题啊?ACCESS数据库老被我搞的字段显示“#错误”。
{
//public DataTable DTable;
//public OleDbDataAdapter ad;
//private SqlConnection Connection;
//private SqlDataAdapter DataAdapter;
//private SqlCommandBuilder Builder;
private DataSet Ds;
private OleDbConnection Connection;
private OleDbDataAdapter DataAdapter;
private OleDbCommandBuilder Builder;
public AddInfo()
{
InitializeComponent();
this.BackColor = Color.White;
//Connection = new SqlConnection(MyDepot.Properties.Settings.Default.MydeConnectionString);
Connection = new OleDbConnection(MyDepot.Properties.Settings.Default.MydeportConnectionString);
Connection.Open();
//MessageBox.Show(MyDepot.Properties.Settings.Default.MydeConnectionString);
//DataAdapter = new SqlDataAdapter("select * from [DEPORT]", Connection);
DataAdapter = new OleDbDataAdapter("select * from [DEPORT]", Connection);
DataAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
//Builder = new SqlCommandBuilder(DataAdapter);
Builder = new OleDbCommandBuilder(DataAdapter);
Builder.QuotePrefix = "[";
Builder.QuoteSuffix = "]";
Ds = new DataSet();
DataAdapter.Fill(Ds, "DEPORT");
this.dataGridView1.DataSource = Ds.Tables[0];
Connection.Close();
} private void AddInfo_Load(object sender, EventArgs e)
{
}
// public DataTable ShowTable
//{
//get { return DTable; }
//set
// {
// DTable=value;
// }
// } private void button1_Click(object sender, EventArgs e)
{
DataRow dr = Ds.Tables[0].NewRow();
dr[0] = mytextBox1.TextBoxString;
dr[1] = mytextBox2.TextBoxString;
dr[2] = mytextBox3.TextBoxString;
dr[3] = mytextBox4.TextBoxString;
dr[4] = mytextBox5.TextBoxString;
dr[5] = mytextBox6.TextBoxString;
dr[6] = mytextBox7.TextBoxString;
dr[7] = mytextBox8.TextBoxString;
dr[8] = mytextBox9.TextBoxString;
Ds.Tables[0].Rows.Add(dr);
Ds.Tables[0].AcceptChanges();
} private void button2_Click(object sender, EventArgs e)
{
DataAdapter.Update(Ds.Tables["DEPORT"]);
//OleDbConnection Connection = new OleDbConnection(MyDepot.Properties.Settings.Default.MydeportConnectionString);
// Connection.Open();
// SqlCommand cmd = new SqlCommand("delete from DEPORT WHERE [DE-ID]='2'",Connection);
//cmd.ExecuteNonQuery();
// Connection.Close();
}
}
我把dataGridView等都放在一个用户控件里,mytextBox是自己重新绘制的TEXTBOX,TextBoxString是个属性
public string TextBoxString
{
get { return textBox1.Text.Trim(); }
set { textBox1.Text = value; }
}
我分别试了两种数据库ACCESS和SQLEXPRESS但就是不能更新,DataAdapter.Update(Ds.Tables["DEPORT"])执行了也没用数据库的数据不变,ACC我用VS生成数据源可以新增数据,但SQLEXPRESS自动数据源也不能新增,
我编程方面是不是没错啊??那我哪可能有问题啊?ACCESS数据库老被我搞的字段显示“#错误”。
解决方案 »
- 点击datagridview的某一列,直接编程文本框可以输入?
- 数据库连接弄到配置文件中出现的问题,跪求高手解答
- 求助!!dataGridView直接更新到Dataset的方法
- 请教正则表达式,(如何替换单引号)
- 如何用1个6L的水杯和一个5L的水杯,精确的打3L水?
- 怎要把程序中的错误信息写到.txt文本中去哦??
- 有没有什么方法可以通用的操作xml,读写查询替换等。而不管xml的格式是什么样(有命名空间或没有的)?
- SqlCommandBuilder产生的UpdateCommand莫名其妙
- 请问,什么时候应该使用结构而不是类?
- 使用delegate 的时候出现的问题,请高手帮我看看
- 问一下 这个项目 用什么环境编好呢?C#.......
- [ALL]泛型 问题
http://topic.csdn.net/t/20060104/23/4498738.html
如果.update不行的话就别的方式进行更新吧,别用.update这种方式了