Search:

Type: Posts; User: kpmc

Page 1 of 13 1 2 3 4

Search: Search took 0.32 seconds.

  1. Re: Vb net matching datagrdviews values another datagrigview

    Based on your description and code/procedure provided, I recommend that you use PhotoShop to accomplish your goal.
  2. Replies
    6
    Views
    774

    Re: Calling a Function from a Dictionary

    You will probably have to loop through the dictionary collection using a keyvalue pair and compare your string to the key. Also, maybe you should be using a task? Not sure...

    Dim Dict As...
  3. Replies
    9
    Views
    3,821

    Re: Sql `float` type = vb.net `double` with scale

    I was thinking that too, I am unsure when decimal became part of SQL, but we've been kicking this erp around for quite some time now.
  4. Replies
    9
    Views
    3,821

    Re: Sql `float` type = vb.net `double` with scale

    Hey tg. The erp/mrp giant in their infinite wisdom decided to use float in their order table. I assume so it could be used in several different applications, ie some end users may sell things by the...
  5. Replies
    9
    Views
    3,821

    Re: Sql `float` type = vb.net `double` with scale

    Good advice, Sir Geek. All the scales I have seen were .999~ so I just plopped ceiling. You're spot on though.
  6. Replies
    9
    Views
    3,821

    Re: Sql `float` type = vb.net `double` with scale

    Thanks Si, I want whole numbers in this case. I figure if I cast through sql command it should get me there. I am about to find out

    Changed my Sql Command to:

    Dim ProductionOrdersSelCols As...
  7. Replies
    9
    Views
    3,821

    Sql `float` type = vb.net `double` with scale

    So I have a sql table i am loading into dataset with SqlDataReader. The sql column type is float, the value is 225. In the datatable the type is double, and the value is 224.99999999999997
    How can...
  8. Replies
    2
    Views
    837

    Re: DateTime Compare Nullable

    The data comes from a cloud based HR service that offers no validity, or restraint. You can literally type the word hippo into a date field. You're right, it is terrible. I have a few other words I...
  9. Replies
    2
    Views
    837

    DateTime Compare Nullable

    Hello folks, It's been a while, hope your all doing well.

    I've been crawling around the rabbit hole of nullable types and am wondering if anyone can simplify this procedure. The incoming date from...
  10. Thread: Close Please

    by kpmc
    Replies
    17
    Views
    2,082

    Re: Setting Control Tag from Background Worker

    As is, you would go with Option A for simplicity?
  11. Thread: Close Please

    by kpmc
    Replies
    17
    Views
    2,082

    Re: Setting Control Tag from Background Worker

    Here is one for yas,

    Mission is to fill a datatable available from Class scope, which of the below options most closely matches how you would do it, and do you recon there is anything "unsafe"...
  12. Thread: Close Please

    by kpmc
    Replies
    17
    Views
    2,082

    Re: Setting Control Tag from Background Worker

    This one is all you, JMC
  13. Thread: Close Please

    by kpmc
    Replies
    17
    Views
    2,082

    Re: Setting Control Tag from Background Worker

    Show your complete code.
  14. Replies
    7
    Views
    911

    VS 2017 Re: Binding a textbox to a code built datagrid

    Though your description contradicts your code, or in the least, makes very little sense, the problem is youre not binding to a table, youre binding to a dataset.

    txtcust.DataBindings.Add("Test",...
  15. Thread: Close Please

    by kpmc
    Replies
    17
    Views
    2,082

    Re: Setting Control Tag from Background Worker

    No, you cant, You can however pass the Tag value into the DoWork event
  16. Replies
    10
    Views
    1,276

    Re: Add a row to DatagridView

    I was just doing some tests on dgv and found its the new row messing with it and was about to tell you to calculate for it.
  17. Replies
    10
    Views
    1,276

    Re: Add a row to DatagridView

    What if you hired a DataTable?


    Option Strict On
    Public Class Form1

    Dim DtTable As New DataTable

    Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
  18. Replies
    10
    Views
    1,276

    Re: Add a row to DatagridView

    Dim Position As Integer = 20
    Dim RowCount As Integer = DataGridView1.Rows.Count - 1

    If Position > RowCount Then
    DataGridView1.Rows.Add(Position - RowCount)
    ...
  19. Re: Problem with radiobuttons when looping through controls on a Windows form

    You are better off describing what you want without the code.
  20. Re: Replace characters in textfile without opening it

    No, it is not possible to open and write string to txt without opening it.
  21. Replies
    30
    Views
    5,566

    Re: Insert records into two related tables

    I dont know about that tablemanager/updateall business, but it is likely there is no command builder, insert or update commands, I dont see any fk update/delete/cascade rules. It seems like you are...
  22. Replies
    30
    Views
    5,566

    Re: Insert records into two related tables

    Do you have a particular reason that you are using a TableAdapter rather than a DataAdapter?
  23. VS 2017 Re: Working with CheckedListox and database

    Why is that? A Union would form 1 table with their items from useritems table and from all items in itemtable minus their items. then just databind to that table with 1 clb.
  24. VS 2019 Re: How To Make RichTextBox So That The User Can Not Type Text Into It?

    You could

    Private Sub RichTextBox1_KeyDown(sender As Object, e As KeyEventArgs) Handles RichTextBox1.KeyDown
    e.SuppressKeyPress = True
    End Sub
  25. VS 2017 Re: Working with CheckedListox and database

    If both lists come from SQL type database you could select all user items and union all items where not in user items.
  26. Replies
    1
    Views
    472

    Re: Commit issues with CurrentCellDirty event

    If you call on `NotifyCurrentCellDirty` after the WriteXml then the cell will act normally, but then for some reason `Dgv.IsCurrentCellDirty` no longer returns True... Scratching my head on this one....
  27. Replies
    1
    Views
    472

    Commit issues with CurrentCellDirty event

    I would like to understand what is happening with a DataGridViewCell and why keypresses are replacing instead of appending. For some reason it is difficult for me to explain, so I have prepared a...
  28. Replies
    3
    Views
    622

    Re: List Issue

    Try like this

    Public Class check
    Public payee As String
    Public amount As Single
    End Class

    Module Module1

    Sub Main()
  29. Re: Can not see value entered into text box when code running.

    this forum is for visual basic.net not vb6
  30. Replies
    1
    Views
    343

    Re: Help !! Binding Excel with Visual Basic

    Try Application.StartupPath
  31. VS 2015 Re: Problem: Serial port stops when I hold mouse on Tab Control

    Fair point JMC, and I did know that, it is the reason you need a method invoke from within that event to access controls; though I reckon that the data is not taking the same journey when using...
  32. VS 2015 Re: Problem: Serial port stops when I hold mouse on Tab Control

    I have been tinkering with ThreadPooling lately. See if this solution will help. More info for ThreadPool


    Private Sub FormThreading_Load(sender As Object, e As EventArgs) Handles MyBase.Load...
  33. Replies
    30
    Views
    5,566

    Re: Insert records into two related tables

    I cant speak much on tableadapter, but using DataAdapter a typical setup may look like this (give or take)


    Dim DtSet As New DataSet
    Dim ParentBS, ChildBS As New BindingSource

    Using SqlConn...
  34. VS 2017 Re: [RESOLVED] Update TableAdapter without losing focus in DGV selected row

    I am glad it worked out for you.
  35. VS 2017 Re: Update TableAdapter without losing focus in DGV selected row

    I cant think of a reason to refill the table at all unless you need data that another user entered. The database table gets the row from the row entered into the DataTable, its redundant to pull all...
  36. VS 2017 Re: Update TableAdapter without losing focus in DGV selected row

    Yes. When you say they are related I am going to assume that they are related in a dataset. I also assume you related them through the table wizard dealyo... If that is the case then goto that wizard...
  37. VS 2010 Re: How to export to excel the autoincremented row value of datagridview using VB.NET

    Remove the AI from the datagridview and add it to the datatable prior to filling it
  38. Replies
    9
    Views
    775

    VS 2017 Re: Write DataGridView Headers to excel

    You can use the OledbConnection to write changes back to the excel file. The only thing you cant do is delete.
  39. Replies
    9
    Views
    775

    VS 2017 Re: Write DataGridView Headers to excel

    I am pretty confused by what your problem is. I am going to use the keyword "unbound" and ignore the rest of what you said.
    Here is a working sample how to add data from an XLSX to a datagridview...
  40. Replies
    9
    Views
    775

    VS 2017 Re: Write DataGridView Headers to excel

    Nono, not ADODB... ADO.Net

    it looks more like this

    Dim XLSFile As String = "C:\DATA\xlfile.xlsx"
    Dim connstring As String = "Provider=Microsoft.ACE.OLEDB.12.0;" &
    "Data...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width