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自动数据源也不能新增,
{
//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自动数据源也不能新增,
解决方案 »
- 对calendar组建了解的吗?
- 我有一个string str1="aa"; string str2="aabbcc";我要得到str1是否在str2中,就是相似的意思的。
- 如何将string[]类型强制转换为dataRow[]类型。 不能转换,该如何处理?就是将string[]中的数据添加到dataRow[] dr; 中。
- 在Console应用程序中,如何获取当前运行的本应用程序的可执行文件的路径?
- C#是不是不能动态分配内存
- C#.net 2005 如何判断用户输入的公式是否正确?
- c# 如何实现点击按钮在文本框中显示代码
- 压缩文件加密问题?
- 急:请教C#中用DLL封装MDI子窗体的方法以及主窗体是如何调用?
- 键盘事件的判断
- 按钮text属性的问题
- C# 邮件
// Connection.Open();
SqlCommand cmd = new SqlCommand("delete from DEPORT WHERE [DE-ID]='2'",Connection);
//cmd.ExecuteNonQuery();
// Connection.Close();
Ds.Update();
DataAdapter.Update 方法
从名为“Table”的 DataTable 为指定的 DataSet 中每个已插入、已更新或已删除的行调用相应的 INSERT、UPDATE 或 DELETE 语句。 更新的是 数据源 还是数据库哦...
DataAdapter = new OleDbDataAdapter("select * from [DEPORT]", Connection); 这里选择的数据包含主键