dcsimg

Search:

Type: Posts; User: Mark@SF

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    2
    Views
    210

    VS 2010 Re: Access sub-query in VB.Net?

    Thanks, jmc. You helped me find the problem.

    As I mentioned in my previous post:



    Your advice re: 3 arguments was the key. I was focusing on the query itself. The tblPrices DataTable was...
  2. Replies
    2
    Views
    210

    VS 2010 [RESOLVED] Access sub-query in VB.Net?

    I have the following query that works fine in MS Access:



    SELECT Q1.RecID AS AssetID, Q2.MaxDate, [Asset Prices].ClosePrice, [Asset Prices].AdjClose FROM (Assets AS Q1 INNER JOIN (SELECT...
  3. Re: Checkbox.Click to raise DataTable.ColumnChanged event?

    Problem found - problem solved! I had a misplaced End If that was preventing all the logic in my ColumnChanged event from executing. :cry: Along the way, I also learned a bit about the Binding...
  4. Re: Checkbox.Click to raise DataTable.ColumnChanged event?

    I need to study this a bit more. The ColumnChanged event is now firing. I swear that it wasn't so just a minute ago. I'll look at this again in the morning with a set of "fresh eyes".
  5. Re: Checkbox.Click to raise DataTable.ColumnChanged event?

    No change even with the following configuration.



    cbxActive.DataBindings.Add("Checked", bsMain, "AssetStatus").DataSourceUpdateMode = DataSourceUpdateMode.OnPropertyChanged


    The...
  6. Re: Checkbox.Click to raise DataTable.ColumnChanged event?

    Hi jmc -

    Thanks for the help with this issue.



    Wouldn't be the first time for me. :)

    The reason I use the Click event instead of the CheckedChanged event is because when I move the...
  7. [RESOLVED] Checkbox.Click to raise DataTable.ColumnChanged event?

    I have a checkbox on a form. The checkbox is bound to a Yes/No field in the MS Access dB. I've added a handler for the ColumnChanged event of the datatable. When I click the checkbox the...
  8. VS 2010 Re: OleDb.OleDbDataAdapter InsertCommand Parameter Default Value

    jmc -

    You asked to see my code.

    Here's the procedure that I use to initialize the daStockSplits DataAdapter.



    Sub InitializeStockSplitsDataAdapter()
  9. VS 2010 Re: OleDb.OleDbDataAdapter InsertCommand Parameter Default Value

    jmc -

    Appreciate your quick response. Always learn a lot from your feedback!

    I probably didn't use the correct wording in my original posting, but I am setting the InsertCommand parameters...
  10. VS 2010 OleDb.OleDbDataAdapter InsertCommand Parameter Default Value

    I have an OleDb.OleDbDataAdapter with an InsertCommand parameter as follows:



    insertData.Parameters.Add("@Notes", OleDb.OleDbType.LongVarWChar, 65536).SourceColumn = "Notes"


    The "Notes"...
  11. Replies
    11
    Views
    227

    VS 2010 Re: [RESOLVED] DataRowView DataType assignment

    Hi tg -

    I wanted to get back to you and the others who took time to discuss my question. You commented...



    The SelectCommand for the DataAdapter that I'm using includes a couple of fields...
  12. Replies
    11
    Views
    227

    VS 2010 Re: DataRowView DataType assignment

    OK, figured it out. If I explicitly create each Column before loading the data into the DataTable, then there is no data type issue with my DataGridView.


    ...
  13. Replies
    11
    Views
    227

    VS 2010 Re: DataRowView DataType assignment

    OK, figured it out. If I explicitly create each Column before loading the data into the DataTable, then there is no data type issue with my DataGridView.


    ...
  14. Replies
    11
    Views
    227

    VS 2010 Re: DataRowView DataType assignment

    Hi Shaggy Hiker -

    The field in the underlying table is a Double data type.

    I have a DataGridView that is bound to a DataTable, and the DataTable is loaded via a DataAdapter using data from a MS...
  15. Replies
    11
    Views
    227

    VS 2010 [RESOLVED] DataRowView DataType assignment

    How can I get an item in a DataRowView to have a DataType that is not Integer?

    In the code below, the rowPosition.Item("PositionShares") is an Integer, but the value I'm assigning to it is a...
  16. Replies
    5
    Views
    174

    VS 2010 Re: Need help with OleDbCommand Parameter

    tg -

    Thanks, you pointed me in the right direction for how to do this in a single line of code:



    cmd.Parameters.AddWithValue("@AddDate", Date.Today).SourceColumn = "AddDate"
  17. Replies
    5
    Views
    174

    VS 2010 Re: Need help with OleDbCommand Parameter

    tg -

    Thanks, you pointed me in the right direction for how to do this in a single line of code:



    cmd.Parameters.AddWithValue("@AddDate", Date.Today).SourceColumn = "AddDate"
  18. Replies
    5
    Views
    174

    VS 2010 Need help with OleDbCommand Parameter

    I am trying to add a Parameter having a data-type of date to an OleDbCommand object. I'm having trouble with the Parameter's "size" property (VS 2010 Intelligence insists on an integer value). ...
  19. Replies
    11
    Views
    363

    VS 2010 Re: Undefined function in query

    Ok, thanks. I've never worked with LINQ so I'll have to do some homework...
  20. Replies
    11
    Views
    363

    VS 2010 Re: Undefined function in query

    Right, I need the SQL to convert the GetAssetPrice() function into a decimal value: GetAssetPrice(20,#4/18/2019#,"ClosePrice") = 133.56

    And do this for each row of data that the SQL returns.
    ...
  21. Replies
    11
    Views
    363

    VS 2010 Re: Undefined function in query

    Hi .paul. -

    How would I pass the "Assets.RecID" field value to the GetAssetPrice function if I don't enclose the function in my SQL string?

    I think I'm just missing something really obvious...
  22. Replies
    11
    Views
    363

    VS 2010 Undefined function in query

    I've got a DataAdapter that I'm using to load a DataTable. I've configured the DataAdpater's SelectCommand as follows (note the "GetAssetPrice" function that is embedded in the SELECT statement)......
  23. Replies
    0
    Views
    123

    VS 2010 WebDriver and Process ID

    How can one get the PID for an instance of a WebDriver (MicrosoftWebDriver)? I’m interested in the driver’s PID, not the associated browser’s PID. The processes and PIDs can be seen in the Windows...
  24. Replies
    5
    Views
    304

    VS 2010 Re: Selenium and Edge

    Is it possible to start the Edge browser as a hidden window and once the login has completed, show the window?
  25. Replies
    5
    Views
    304

    VS 2010 Re: Selenium and Edge

    I've figured it out. The Selenium WebDriver that I was using was not the correct release for my Edge browser version.

    I had downloaded Release 17134 from the Microsoft Developer website...
  26. Replies
    5
    Views
    304

    VS 2010 Re: Selenium and Edge

    Hi passel -

    Yes, here's my Reference list:

    167477

    I've added the WebDriver and WebDriver.Support references.

    I also added the MicrosoftWebDriver.exe file to the project.
  27. Replies
    5
    Views
    304

    VS 2010 [RESOLVED] Selenium and Edge

    I'm trying to use Selenium to automate my login to the Morningstar website using the Microsoft Edge browser. This is my first time working with Selenium.

    I've added the following project...
  28. Replies
    9
    Views
    881

    VS 2010 Re: MessageBox layout

    JMC -

    Thanks for the follow-up. My bad re: the framework (I was working off-line on my iPad last night and relying on my memory instead of the actual VB Studio screen!). It is indeed the...
  29. Replies
    9
    Views
    881

    VS 2010 Re: MessageBox layout

    Looking through my project for some clues as to what might be happening. This project is a Windows Forms Application. It does not have any forms (including a startup form), it uses the Main...
  30. Replies
    9
    Views
    881

    VS 2010 Re: MessageBox layout

    Yes, it a Windows 10, version 1809 machine. Iíve done a lot of VB.Net work and this is the first time Iíve seen this.
  31. Replies
    9
    Views
    881

    VS 2010 Re: MessageBox layout

    Yes, it a Windows 10, version 1809 machine. I’ve done a lot of VB.Net work and this is the first time I’ve seen this.
  32. Replies
    9
    Views
    881

    VS 2010 [RESOLVED] MessageBox layout

    The layouts of the MessageBox dialogs in my application are not right. The text overlaps the icon. Here's an example:

    164963

    The code that creates this dialog is pretty simple:


    strMSG =...
  33. VS 2010 Re: Detecting changes when using the mouse to change focus

    This works for me...


    Private Sub TextBox_Leave(sender As Object, e As System.EventArgs) Handles txtCategory.Leave, txtCategoryNote.Leave

    '...when you change the focus by using the...
  34. VS 2010 Re: Detecting changes when using the mouse to change focus

    Hi Wes4dbt -

    Thanks for your quick reply.

    Yes, I meant the BindingNavigator :blush:.



    The Leave event is triggered when I click on the BindingNavigator's move arrows.
  35. VS 2010 Detecting changes when using the mouse to change focus

    I have a form with several controls and a BindingSource with its underlying data being a DataTable. The controls are bound to the BindingSource.

    Scenario #1:
    After changing the text in a TextBox...
  36. VS 2010 Re: ComboBox keyboard typeahead focus

    Thanks. Not planning to reinvent the wheel...:)
  37. VS 2010 Re: ComboBox keyboard typeahead focus

    Hi jmc -

    Thanks for your interest in my posting.

    Here is a screen shot of the situation that I was describing in my initial post:

    155113

    When the user clicks the ComboBox and then presses...
  38. VS 2010 [RESOLVED] ComboBox keyboard typeahead focus

    I have a ComboBox control that is populated with a list of records from a DataTable. When the user clicks on the ComboBox, the drop-down list shows these 200 records as a scrollable list.

    The...
  39. VS 2010 Re: [RESOLVED] Inserting records into database table from Excel worksheet

    I took a second look at the data adapter class on MSDN and noticed that it's Fill method has a AcceptChangesDuringFill property that is by default set to True. So I modified my code to set this...
  40. VS 2010 Re: [RESOLVED] Inserting records into database table from Excel worksheet

    Shaggy Hiker -

    The code that I benchmarked has the DoEvents statements, and they are in both techniques (single INSERT INTO code block and the pair of data adapters code blocks) so I would think...
Results 1 to 40 of 220
Page 1 of 6 1 2 3 4



Featured


Click Here to Expand Forum to Full Width