问题如标题所述。dataset是从adapter生成的,有架构大概信息如下:
初始化-----
Me.OleDbConnection1 = New System.Data.OleDb.OleDbConnection
Me.OleDbCommand1 = New System.Data.OleDb.OleDbCommand
Me.OleDbDataAdapter1 = New System.Data.OleDb.OleDbDataAdapter
Me.YhjyDS1 = New jsjxlibrary.yhjyDS '
'OleDbDataAdapter1
'
'Me.OleDbDataAdapter1.DeleteCommand = Me.OleDbCommand1
'Me.OleDbDataAdapter1.InsertCommand = Me.OleDbCommand1
Me.OleDbDataAdapter1.SelectCommand = Me.OleDbCommand1
Me.OleDbDataAdapter1.UpdateCommand = Me.OleDbCommand1page_lode----
Me.OleDbConnection1.ConnectionString = ConfigurationSettings.AppSettings("ConnectionString")
Me.OleDbCommand1.CommandText = "SELECT ... FROM table"
Me.OleDbCommand1.Connection = Me.OleDbConnection1
Me.OleDbConnection1.Open()
Me.OleDbDataAdapter1.SelectCommand = Me.OleDbCommand1
Me.OleDbDataAdapter1.Fill(Me.YhjyDS1)
Me.OleDbConnection1.Close()
myGrid.DataSource = Me.YhjyDS1 If Not Me.IsPostBack Then
myGrid.DataBind()
End If添加操作和更改数据库:
'蒋新添加的记录写入数据集中
Dim myDataTable As DataTable = Me.YhjyDS1.Tables(0)
Dim newrow1 As DataRow = myDataTable.NewRow() newrow1("id") = 3
newrow1("mc") = "rrr"
newrow1("cbs") = "rrr"
myDataTable.Rows.Add(newrow1)
Me.OleDbConnection1.Open() Me.OleDbDataAdapter1.Update(YhjyDS1) ---此时newrow1.rowState=added Me.OleDbConnection1.Close() --------此时newrow1.rowState=unchanged
myGrid.DataSource = Me.YhjyDS1
myGrid.DataBind()
初始化-----
Me.OleDbConnection1 = New System.Data.OleDb.OleDbConnection
Me.OleDbCommand1 = New System.Data.OleDb.OleDbCommand
Me.OleDbDataAdapter1 = New System.Data.OleDb.OleDbDataAdapter
Me.YhjyDS1 = New jsjxlibrary.yhjyDS '
'OleDbDataAdapter1
'
'Me.OleDbDataAdapter1.DeleteCommand = Me.OleDbCommand1
'Me.OleDbDataAdapter1.InsertCommand = Me.OleDbCommand1
Me.OleDbDataAdapter1.SelectCommand = Me.OleDbCommand1
Me.OleDbDataAdapter1.UpdateCommand = Me.OleDbCommand1page_lode----
Me.OleDbConnection1.ConnectionString = ConfigurationSettings.AppSettings("ConnectionString")
Me.OleDbCommand1.CommandText = "SELECT ... FROM table"
Me.OleDbCommand1.Connection = Me.OleDbConnection1
Me.OleDbConnection1.Open()
Me.OleDbDataAdapter1.SelectCommand = Me.OleDbCommand1
Me.OleDbDataAdapter1.Fill(Me.YhjyDS1)
Me.OleDbConnection1.Close()
myGrid.DataSource = Me.YhjyDS1 If Not Me.IsPostBack Then
myGrid.DataBind()
End If添加操作和更改数据库:
'蒋新添加的记录写入数据集中
Dim myDataTable As DataTable = Me.YhjyDS1.Tables(0)
Dim newrow1 As DataRow = myDataTable.NewRow() newrow1("id") = 3
newrow1("mc") = "rrr"
newrow1("cbs") = "rrr"
myDataTable.Rows.Add(newrow1)
Me.OleDbConnection1.Open() Me.OleDbDataAdapter1.Update(YhjyDS1) ---此时newrow1.rowState=added Me.OleDbConnection1.Close() --------此时newrow1.rowState=unchanged
myGrid.DataSource = Me.YhjyDS1
myGrid.DataBind()
解决方案 »
- JSON教程中的那个图
- IE8 兼容性视图下 js 的tale会错位
- rdlc报表如何每页都显示表头
- GridView的Edit(update/cancel)功能,可不可以应用在自动加载(非固定字段)的gridview上
- HTML编辑器基本功能是怎么做的
- urlencode的严重问题
- 关于验证控件的使用,如何验证文本框里的数据,开头必须是数字9,输入的数值长度不能大于5,并且全部为数字,并且不能为空
- 新闻文字和图片显示问题(100)
- 求解:gridview中字段在textbox显示乱码
- 请问存储和显示图片,是存路径好还是存图片文件好?
- asp.net/c#如何调用java程序?
- visual stdio.net 2003求助
前后,不用手工操作数据库连接,也就是不同打开和关闭数据库