zarrin_306
پنج شنبه 08 اسفند 1387, 20:36 عصر
سلام من برای ذخیره دیکسری داده در دیتابیس اکسس به شیوه زیر عمل کردم:
Imports System.Data
Imports System.Data.OleDb
Dim ds As New DataSet()
Dim strsql As String
Dim strcon As String
Dim da As OleDbDataAdapter
Dim con As OleDbConnection
Dim newrow As DataRow
Dim cb As OleDbCommandBuilder
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Put user code to initialize the page here
strcon = "Provider=microsoft.jet.OLEDB.4.0;DataSource=/inetpub/wwwroot/db/db1.mdb"
strsql = "select * from StTable"
con = New OleDbConnection(strcon)
con.Open()
da = New OleDbDataAdapter(strsql, con)
da.Fill(ds, "StTable")
'Me.OleDbDataAdapter1.Fill(Me.DataSet11, "StTable")
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
newrow = ds.Tables("StTable").NewRow
newrow("StNo") = Val(StNo.Text)
newrow("Name") = (Me.FirseName.Text)
newrow("Course") = (Me.Course.Text)
newrow("Ave") = Val(Me.Ave.Text)
newrow("NumUnit") = Val(Me.NumUnit.Text)
ds.Tables("StTable").Rows.Add(newrow)
cb = New OleDbCommandBuilder(da)
da.InsertCommand = cb.GetInsertCommand
da.Update(ds, "stTable")
con.Close()
StNo.Text = ""
Me.FirseName.Text = ""
Me.Course.Text = ""
Me.Ave.Text = ""
Me.NumUnit.Text = ""
End Sub
اما موقع اجرا با مشکل زیر مواجه میشه :
Imports System.Data
Imports System.Data.OleDb
Dim ds As New DataSet()
Dim strsql As String
Dim strcon As String
Dim da As OleDbDataAdapter
Dim con As OleDbConnection
Dim newrow As DataRow
Dim cb As OleDbCommandBuilder
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Put user code to initialize the page here
strcon = "Provider=microsoft.jet.OLEDB.4.0;DataSource=/inetpub/wwwroot/db/db1.mdb"
strsql = "select * from StTable"
con = New OleDbConnection(strcon)
con.Open()
da = New OleDbDataAdapter(strsql, con)
da.Fill(ds, "StTable")
'Me.OleDbDataAdapter1.Fill(Me.DataSet11, "StTable")
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
newrow = ds.Tables("StTable").NewRow
newrow("StNo") = Val(StNo.Text)
newrow("Name") = (Me.FirseName.Text)
newrow("Course") = (Me.Course.Text)
newrow("Ave") = Val(Me.Ave.Text)
newrow("NumUnit") = Val(Me.NumUnit.Text)
ds.Tables("StTable").Rows.Add(newrow)
cb = New OleDbCommandBuilder(da)
da.InsertCommand = cb.GetInsertCommand
da.Update(ds, "stTable")
con.Close()
StNo.Text = ""
Me.FirseName.Text = ""
Me.Course.Text = ""
Me.Ave.Text = ""
Me.NumUnit.Text = ""
End Sub
اما موقع اجرا با مشکل زیر مواجه میشه :