dcsimg

Search:

Type: Posts; User: Ashwin975

Page 1 of 2 1 2

Search: Search took 0.02 seconds.

  1. Row Selected automatically While sorting the columns of Datagridview

    Hi,

    When i sort the columns of the Datagridview, the first row of the datagridview is selected automatically, If i sort another column the previously selected row was displayed in the textboxes. I...
  2. Re: Search and Select the first row in Datagridview

    Thank You jmcilhinney, How can i do that, because i having n No. of search results and but i want to select the first row of the result. if click the next button it need move on the next result.
  3. Search and Select the first row in Datagridview

    Hi,

    i have wrote the code to search the field in the datagridview. Now i want to select that first row datagridview of the search result automatically, can anyone help me out to resolve this....
  4. Re: Search the Records in Multiple Fields and Multiple Tables based on selection of t

    Thank You Chris and SI the geek. The issue got resolved and here's my code, for the future reference and will be helpful for someone.




    Private Sub Search_Click(ByVal sender As System.Object,...
  5. Re: Search the Records in Multiple Fields and Multiple Tables based on selection of t

    Private Sub Search_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Search.Click
    If Not cnn.State = ConnectionState.Open Then
    'open connection
    ...
  6. Re: Search the Records in Multiple Fields and Multiple Tables based on selection of t

    I need to view the search results in the datagridview. Its not working in that way.
  7. How to Avoid Temporary Tables in ComboBOX?

    Its Hard to see that some of the Temporary Tables is loaded with User added tables, how to avoid that even after adding the restriction property.

    170181





    Private Sub Form1_Load(ByVal...
  8. Re: Search the Records in Multiple Fields and Multiple Tables based on selection of t

    This Works, But it Didn't filter out the data in Datagridview, When i click on the search button it shows like "Select * From & [Capacitor ] Where Manufacturer Like 'AVX%'", But the filtering is...
  9. VS 2010 Re: ADD,DELETE,UPDATE the records in the access database

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
    DataGridView1.EditMode = False
    txtID.ReadOnly = True
    ...
  10. Re: Search the Records in Multiple Fields and Multiple Tables based on selection of t

    bs.bindingsource = dt the error message as In this part.

    For example: I am searching in the capacitor table, once thatís is done I am switching to connector table, the again to capacitor.
  11. Re: Search the Records in Multiple Fields and Multiple Tables based on selection of t

    Private Sub Search_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Search.Click

    If ComboBox1.Text = "Capacitor" Then
    bs.Filter =...
  12. VS 2010 Re: ADD,DELETE,UPDATE the records in the access database

    I am getting the error for the update command.

    For the Capacitor the error is Syntax error in UPDATE statement. and for the Other table the error is No value given for one or more required...
  13. Display Table List in ComboBox Showing Temporary tables

    Below is the code i am using to show the tables in combobox, but even the temporary tables also listed in it. I dont Know why it happens.





    Private Sub Form1_Load(ByVal sender As...
  14. Re: Search the Records in Multiple Fields and Multiple Tables based on selection of t

    I am using Access database, With the binding source filter also i am getting below error.

    Conversion from string "Agilenumber LIKE'K05LF60013%'" to type 'Long' is not valid.




    bs.Filter =...
  15. Re: Search the Records in Multiple Fields and Multiple Tables based on selection of t

    Private Sub Search_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Search.Click


    If ComboBox1.Text = "Connector" Then

    Dim query As String =...
  16. Re: Search the Records in Multiple Fields and Multiple Tables based on selection of t

    I am not getting any error at the same time, i cannot able to find what i want? When i click the search button, it doesn't filter out what i want.
  17. Search the Records in Multiple Fields and Multiple Tables based on selection of table

    The below code, i used to search the field but it didn't worked out.




    Private Sub Search_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Search.Click
    '...
  18. VS 2010 Re: ADD,DELETE,UPDATE Search the records in the access database

    SI, that works fine. Thank you.

    The below code is for the search button, but it couldn't worked out. Running without the error.




    Private Sub Search_Click(ByVal sender As System.Object,...
  19. VS 2010 Re: ADD,DELETE,UPDATE the records in the access database

    Private Sub btnedit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnedit.Click

    DataGridView1.BeginEdit(True)
    If Me.DataGridView1.Rows.Count > 0 Then
    ...
  20. VS 2010 Re: ADD,DELETE,UPDATE the records in the access database

    I have removed all the spaces in column names. Since i haven't given the textbox for the ID, whether that causing any issue. ID is autogenarated in the access Database.



    OleDbException was...
  21. VS 2010 Re: ADD,DELETE,UPDATE the records in the access database

    Private Sub btnedit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnedit.Click
    'open connection if not already opened
    If Not cnn.State =...
  22. VS 2010 Re: ADD,DELETE,UPDATE the records in the access database

    Private Sub savedata()

    bs.EndEdit()
    da.MissingSchemaAction = MissingSchemaAction.AddWithKey
    da.Update(dt) --> dynamic sql generation for the delete command is not...
  23. VS 2010 Re: ADD,DELETE,UPDATE the records in the access database

    The primary is automatically created in the Database and also it is unique, which is my ID (unique). This problem persists even after that.
  24. 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...
  25. 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...
  26. 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...
  27. 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...
  28. 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.
  29. 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...
  30. 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 = "["
    ...
  31. 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...
  32. 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...
  33. 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.
  34. 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....
  35. 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...
  36. 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...
  37. 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)...
  38. 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...
  39. 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 39 of 42
Page 1 of 2 1 2



Featured


Click Here to Expand Forum to Full Width