dcsimg

Search:

Type: Posts; User: Ashwin975

Search: Search took 0.00 seconds.

  1. VS 2010 Re: ADD,DELETE,UPDATE the records in the access database

    Imports System.Data.OleDb

    Public Class Form1

    'To get the tables in the combobox


    Dim cnn As System.Data.OleDb.OleDbConnection = New System.Data.OleDb.OleDbConnection()
    Private...
  2. VS 2010 Re: ADD,DELETE,UPDATE the records in the access database

    Imports System.Data.OleDb

    Public Class Form1

    'To get the tables in the combobox


    Dim cnn As System.Data.OleDb.OleDbConnection = New System.Data.OleDb.OleDbConnection()
    Private...
  3. VS 2010 Re: ADD,DELETE,UPDATE the records in the access database

    Private Sub btndelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btndelete.Click

    bs.RemoveCurrent()
    savedata()
    End Sub

    Private Sub...
  4. VS 2010 Re: ADD,DELETE,UPDATE the records in the access database

    jim, even if i changed the primary key in the tables. i'm end up with the error. I don't know what add schema you mean it. can Please edit in the code, if possible.
  5. VS 2010 Re: ADD,DELETE,UPDATE the records in the access database

    yeah right now i can able to the add data. for the deleting i facing this error,


    Private Sub savedata()

    bs.EndEdit()
    da.Update(dt) --> Dynamic SQL generation for the...
  6. VS 2010 Re: ADD,DELETE,UPDATE the records in the access database

    Thank you very much, it works now. i have added the commandbuilder prefix and suffix and it got worked now.

    Dim cb As New OleDb.OleDbCommandBuilder(da)
    cb.QuotePrefix = "["
    ...
  7. VS 2010 Re: ADD,DELETE,UPDATE the records in the access database

    I have changed them without the spaces, still i am getting the same error.

    Also if i add the data and clicked the save button, the data didn't saved.


    Private Sub btnadd_Click(ByVal sender...
  8. VS 2010 Re: ADD,DELETE,UPDATE the records in the access database

    Error in this statement, I dont know what would be the issue is.

    Private Sub btnadd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnadd.Click

    Dim cmdbldr As...
  9. VS 2010 Re: ADD,DELETE,UPDATE the records in the access database

    imcilhinney, i have removed the unwanted code from the post and made code readable. Thank you for sorting out the mistake.
  10. VS 2010 Re: ADD,DELETE,UPDATE the records in the access database

    HI wes4dbt,

    The code doesn't work. Because i have already get the tables and listed through the bindgrid function. I am ending with the error, can you please modify in the same code if possible....
  11. VS 2010 ADD,DELETE,UPDATE the records in the access database

    Hi All,

    I have 7 tables in my access database. i wrote a code to select the data table using the combobox and to display the selected table in the datagridview.

    Now i need to add,edit or...
  12. Re: Display Tables in Datagridview By selecting any table from combobox in vb2010 acc

    Thank you very much. It works now. But one more concern is i am getting unwanted tables other than the user tables, how to avoid that. Even though i have used the restrictions. i have attached the...
  13. Re: Display Tables in Datagridview By selecting any table from combobox in vb2010 acc

    In the below line it shows like,

    Dim con As New OleDb.OleDbConnection
    Dim sSql As String = "Select * From " & ComboBox1.Text
    Dim cmd As New OleDb.OleDbCommand(sSql, connection)...
  14. Re: Display Tables in Datagridview By selecting any table from combobox in vb2010 acc

    I have attached the image

    Me.ComboBox1.DisplayMember = "TABLE_NAME"
    Me.ComboBox1.DataSource = connection.GetSchema("Tables") --> Invalid operation. The connection is closed.

    in the above...
  15. Display Tables in Datagridview By selecting any table from combobox in vb2010 access

    Hi All,

    I am New to VB, i am trying to display the tables which i select in the combobox. I am using the access database. Below is the code i am using for the, Please help me to resolve this.

    ...
Results 1 to 15 of 18



Featured


Click Here to Expand Forum to Full Width