Search:

Type: Posts; User: Mark@SF

Page 1 of 10 1 2 3 4

Search: Search took 0.12 seconds.

  1. Replies
    8
    Views
    234

    VS 2019 Re: Excel chart line weight format error

    @frabuator -

    Is your "chartPage" an embedded chart in a WorkSheet or is in its own ChartSheet (my chart is in a ChartSheet).

    Are you using early or late binding (I am using early binding)?
  2. Replies
    8
    Views
    234

    VS 2019 Re: Excel chart line weight format error

    @frabulator -

    I am using Excel 2019.

    Here is the result from the Excel Macro Recorder.


    ActiveChart.FullSeriesCollection(1).Select
    ActiveChart.PlotArea.Select
    With Selection.Format.Line
  3. Replies
    8
    Views
    234

    VS 2019 Re: Excel chart line weight format error

    @frabulator -

    Yes, single stepping through the code shows that it is just the highlighted line that raises the error.

    When I comment out the highlighted line, then the code runs without any...
  4. Replies
    8
    Views
    234

    VS 2019 Excel chart line weight format error

    I am trying to set the line weight in an Excel chart. Here is my code.


    With CType(xlsApp.ActiveChart.SeriesCollection(1), Excel.Series)
    .Border.Weight = Excel.XlBorderWeight.xlThin
    ...
  5. VS 2019 Re: DataGridView DataError with DataGridViewComboBox

    @jmc -

    Thank you for your response. I'll try to address your suggestions below.



    I generally try to avoid using the designer for multi-step configuration of controls. I think it is easier...
  6. VS 2019 Re: DataGridView DataError with DataGridViewComboBox

    @frabulator -

    Thanks for your help with this issue.

    I don't think unbind/bind the DataSource will be useful to debug this issue. That is essentially explicitly doing what is happening...
  7. VS 2019 Re: DataGridView DataError with DataGridViewComboBox

    @wes4dbt -

    Yes, the code for doing that is in post #2.


    i = daProviders.Update(dsMain.Tables("Providers"))

    I'm really stumped about this :(
  8. VS 2019 Re: DataGridView DataError with DataGridViewComboBox

    I noticed that after adding a new Provider, the DataSource property of the DataGridViewComboBoxColumn for the dgvFuel DataGridView has been changed to Nothing and the ValueMember has been changed to...
  9. VS 2019 DataGridView DataError with DataGridViewComboBox

    I need some help to understand why my application is raising DataError errors for a DataGridViewComboBoxColumn of a DataGridView. The error does not always occur, it seems to only happen in a...
  10. Re: SQLite date field as String to DateTime in DataGridView TextBox

    zvoni -

    Thanks for your help with this question.

    I am storing dates as ISO 8601 formatted strings so that they are more human-readable. I realized that for the date field in question, I didn't...
  11. Re: SQLite date field as String to DateTime in DataGridView TextBox

    zvoni -



    Not sure that I understand how to do this. For example, this Select query returns a String data type as the RecDate.


    Dim selectData As New SQLite.SQLiteCommand("SELECT AddDate,...
  12. [RESOLVED] SQLite date field as String to DateTime in DataGridView TextBox

    I have a SQLite database and I store dates as ISO 8601 formatted strings ("yyyy-MM-dd HH:mm:ss").

    I have bound one of the tables from this database to a DataGridView control (dgvFuel) using a...
  13. Re: Converting application from MS Access to SQLite database

    Olaf, et.al. -

    Thank you (everyone) for your help and suggestions. I have gotten the SQLiteDataAdapter.Update method to work. I can now claim to have “crossed the Rubicon” from MS Access to...
  14. Re: Converting application from MS Access to SQLite database

    Here's how I think I should create a DataAdapter.


    Sub InitializeCategoriesDataAdapter()

    'https://support.microsoft.com/en-us/kb/320435

    '...SQLite database table "Categories" field...
  15. Re: Converting application from MS Access to SQLite database

    Olaf -

    Thanks for all you're trying to help me with. I think maybe I'm missing something more fundamental here.



    The reference to PeterST's post #21 seems to indicate that the way forward...
  16. Re: Converting application from MS Access to SQLite database

    Here is something from Microsoft.

    https://docs.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqldataadapter.updatecommand?view=dotnet-plat-ext-5.0


    // Create the UpdateCommand.
    ...
  17. Re: Converting application from MS Access to SQLite database

    Olaf -

    You wrote...



    As you can see from my posts in this thread, I'm on the learning curve here and have a lot to learn. Is there an example or link you can share with me that might help...
  18. Re: Converting application from MS Access to SQLite database

    Here is a working example for how to use a SQLiteCommand object and ExecuteNonQuery method to update a single record in the SQLite database.


    Dim strSQL As String = String.Empty
    Dim format As...
  19. Re: Converting application from MS Access to SQLite database

    peterst -

    Thanks for jumping into this discussion. You wrote...



    In post #4 of this thread, I show that I am using parameters. and also that I am formatting the dates in ISO format (as was...
  20. Re: Converting application from MS Access to SQLite database

    I am watching and learning a lot from the responses to my original post. Thank you to everybody that has taken the time to answer.

    Post #4 in this thread shows how I have created the SQLite...
  21. Re: SQLite equivalent for OleDb.OleDbRowUpdatedEventArgs

    jmc -

    Thank you again for you help.
  22. Re: SQLite equivalent for OleDb.OleDbRowUpdatedEventArgs

    I am feeling really stupid right now. The reason why the RowUpdating and RowUpdated events were not firing was that I wasn't calling the DataAdapter.Update method.

    Problem solved.
  23. Re: SQLite equivalent for OleDb.OleDbRowUpdatedEventArgs

    I've added the following.


    Imports System.Data.Common

    And changed the Row_Updated and Row_Updating method's signatures.


    Sub Row_Updating(ByVal sender As Object, ByVal e As...
  24. Re: SQLite equivalent for OleDb.OleDbRowUpdatedEventArgs

    One observation with the above Row_Updating method is that it does not "fire"...


    Sub Row_Updated(ByVal sender As Object, ByVal e As OleDb.OleDbRowUpdatedEventArgs)

    Even with the wrong event...
  25. Re: SQLite equivalent for OleDb.OleDbRowUpdatedEventArgs

    I installed...

    system.data.sqlite.core.1.0.113.7.nupkg

    It looked to be the latest version (...113.7).

    My DataAdaper has a RowUpdated event.


    AddHandler daCategories.RowUpdated, AddressOf...
  26. Re: SQLite equivalent for OleDb.OleDbRowUpdatedEventArgs

    jmc -



    I am using a SQLiteDataAdapter. I'm updating an application to use SQLite instead of MS Access. I've changed all the "OleDb" references to "SQLite" throughout my code.

    Everything...
  27. [RESOLVED] SQLite equivalent for OleDb.OleDbRowUpdatedEventArgs

    I have used the following to retrieve the AUTONUMBER value when adding rows (MS Access database):


    Sub Row_Updated(ByVal sender As Object, ByVal e As OleDb.OleDbRowUpdatedEventArgs)

    Dim...
  28. Replies
    2
    Views
    245

    VS 2019 Re: How to trace implicit method calls

    jmc -

    My mistake calling it a BindingNavigator...

    I'll take a look at the .NET Framework source code.

    Thanks.
  29. Replies
    2
    Views
    245

    VS 2019 How to trace implicit method calls

    I would like to better understand the event sequences behind the BindingSource buttons (Add New, Cancel, etc.).

    For example, when I click the "Add New" button, I would like to see the method calls...
  30. Re: Converting application from MS Access to SQLite database

    zvoni -

    Sorry for the confusion. What I meant is that the seed value is reset after compacting an Access database. :)

    Thanks again for all your help!
  31. Re: Converting application from MS Access to SQLite database

    zvoni -

    You wrote:



    Does this mean that there is not an equivalent SQLite function as the MS Access "Compact Database" function (which will reset the AUTONUMBER values)?
  32. Re: Converting application from MS Access to SQLite database

    zvoni -

    You mentioned:



    The following link discusses this point.

    https://www.sqlitetutorial.net/sqlite-autoincrement/
  33. Re: Converting application from MS Access to SQLite database

    Another nice feature of MS Access is its ability to create an Entity Relationship Diagram (ERD) and to also document the database. These can be created/saved as .PDF files for inclusion in a user...
  34. Re: Converting application from MS Access to SQLite database

    One thing nice about MS Access is its designer (IDE) interface that can be used to create a table, query, etc.

    I found the SQLite Administrator can do something similar.
    ...
  35. Re: Converting application from MS Access to SQLite database

    zvoni -

    Thank you for your tips! I am on the leading-edge of transitioning from MS Access to SQLite and your information is much appreciated.

    You wrote...



    I read the following link...
  36. [RESOLVED] Converting application from MS Access to SQLite database

    I am working on converting one of my applications that uses an MS Access back-end database to an SQLite database.

    I have installed the “System.Data.SQLite” NuGet package and have successfully...
  37. VS 2019 Re: DataGridView Autocomplete TextBox

    jmc -

    It looks like calling the Select method is usually faster than iterating the rows of the BindingSource. Here's some of the results (the first number after "search: " is the ElapsedTicks of...
  38. VS 2019 Re: DataGridView Autocomplete TextBox

    jmc -



    Roger that.

    Thanks for the demo code. I agree, your approach is much cleaner. My initial effort was a trial-and-error approach to just get something working. I'll rework it to make...
  39. VS 2019 Re: DataGridView Autocomplete TextBox

    This application is a password manager. It has a TableLayoutPanel with a DataGridView on the left-hand side of the panel (dgvAccounts). The grid is a listing of all accounts. The user (me) clicks...
  40. VS 2019 [RESOLVED] DataGridView Autocomplete TextBox

    I have a DataGridView that is ReadOnly. I would like to implement "type ahead" functionality for a column (DataGridViewTextBoxColumn) of the grid.

    I have seen examples for how this is done. For...
Results 1 to 40 of 399
Page 1 of 10 1 2 3 4



Click Here to Expand Forum to Full Width