I modified my codes based on your example. I get no errors but the inserted fields do now show up in the gridview2
Code:Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim iconn As New Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\HP_Owner\My Documents\Visual Studio 2005\MyFinalWebSite/db1.mdb") Dim SQL As String = "" SQL = ("INSERT INTO [Table1] Set [LName] = '" & TextBox1.Text & "',[FName] = '" & TextBox2.Text & "', [Known] = '" & TextBox3.Text & "' ") Dim xcmd As New Data.OleDb.OleDbCommand(SQL, iconn) Dim ida As New Data.OleDb.OleDbDataAdapter(SQL, iconn) Dim ds As New Data.DataSet iconn.Open() ida.InsertCommand = xcmd GridView2.DataSource = ds.Tables("Table1") GridView2.DataBind() End Sub




Reply With Quote