dcsimg

Search:

Type: Posts; User: ssalomon

Page 1 of 3 1 2 3

Search: Search took 0.26 seconds.

  1. query backup database and insert missing record

    hi

    I am try to loop thru each record in databasebackup and check if I have same record in database
    any help how I can do this how can I use While dr2.Read inside While dr.Read

    thanks
    ssalomon
  2. Re: Query Date from MDB using DateTimePicker how to format

    Thanks si_the_geek
  3. Query Date from MDB using DateTimePicker how to format

    Hi

    I have problem format date from DateTimePicker

    if I use "WHERE date = #2/19/2020#", Con" the it work well but not when I use DateTimePicker
    I just can not format DateTimePicker
  4. Re: File explorer Context Menu folder path with spaces

    Thanks Paul
  5. [RESOLVED] File explorer Context Menu folder path with spaces

    I am try to make file explorer Context Menu how can I get path from folder I select with spaces

    this is how I get the folder path I select if it is spaces in the name it split up...
  6. Re: reorder in Mysql or before I add it to Datagridview

    Thanks again si_the_geek

    "Exit For" solved the problem

    Regards
    ssalomon
  7. Re: reorder in Mysql or before I add it to Datagridview

    Hi


    I am almost fins with this using datagridview but sometime it don't count it right and mark two line with same order number

    in the loop next to select is JM0001 but it go to JM0004 and add...
  8. Re: reorder in Mysql or before I add it to Datagridview

    Thanks

    the problem is the ID can be random number when I connect record with t1.Tp_Ttl_ID and the name can be different

    the only thing what is right is the Name1 start with SI and Name2 will...
  9. [RESOLVED] reorder in Mysql or before I add it to Datagridview

    Hi

    how can I reorder this record in Mysql or before I add it to Datagridview
    it can have 3 record or 10 and different name I just need to loop thru the records and add number to Order

    I know...
  10. Re: Could not find specified column in results

    Thanks si_the_geek
  11. Could not find specified column in results

    Hi

    I try to insert the code but I get error so I upload it as png image

    how can I get ID3 to reader("ID3").ToString I get this error

    System.IndexOutOfRangeException: 'Could not find...
  12. Replies
    2
    Views
    1,077

    Re: Searching Combobox item by valuemember

    Thanks jmcilhinney
  13. Replies
    2
    Views
    1,077

    Searching Combobox item by valuemember

    Hi


    is it poseble to Search Combobox item by valuemember in TextChanged


    Sample Combobox I use with multi-columns
    ...
  14. Replies
    5
    Views
    636

    Re: Mysql into OutlookGrid Query

    Thanks si_the_geek
  15. Replies
    5
    Views
    636

    Re: Mysql into OutlookGrid Query

    Can not insert this Query as text in the forum I get error

    161157
  16. Replies
    5
    Views
    636

    Re: Mysql into OutlookGrid Query

    I get error in this forum if I try to Replay :)


    if I have 1 record in mainrecord and 3 record in Subrecord I get list like this in OutlookGrid

    What I get
    Mainrecord 1
    ---Subrecord 1...
  17. Replies
    5
    Views
    636

    Mysql into OutlookGrid Query

    Hi

    Hi

    I have two table Mainecord and Subrecord
    1. Mainecord only have one record
    2. Subrecord can have More than one record

    How can I Query Mysql into OutlookGrid need...
  18. Replies
    5
    Views
    684

    Re: Mysql Query get name twise

    Thanks jmcilhinney
  19. Replies
    5
    Views
    684

    Mysql Query get name twise

    Hi
    someone who can help me with this Query

    I need to get List from this Table but the problem is how can I get fiber name from Fiber twise in the list from this ID C_Fiber_INN_ID and...
  20. Replies
    2
    Views
    353

    Re: Mysql date 0000-00-00

    Thanks

    I change 0000-00-00 to 00:00:00




    If Not reader.IsDBNull(reader.GetOrdinal("date")) Then

    If reader.GetDateTime("date") = "00:00:00" Then
  21. Replies
    2
    Views
    353

    Mysql date 0000-00-00

    Hi


    I am tray to find out if Mysql date is 0000-00-00 but with no luck




    If Not reader.IsDBNull(reader.GetOrdinal("Date")) Then
  22. Replies
    1
    Views
    713

    Mysql AutoComplete Combobox

    Hi

    I am try to use Mysql AutoComplete Combobox
    if I add this code to TextChanged then I need to Wait for some time

    How can I use AutoComplete Combobox without Delay
    the database have 117739...
  23. Replies
    4
    Views
    1,071

    Re: Mysql to Treeview

    Thanks jmcilhinney
  24. Replies
    4
    Views
    1,071

    Re: Mysql to Treeview

    Thanks jmcilhinney this work well


    when I connect Parent(Town) to Child(contact) Each Parent(Town) can have many Child(contact)
    same with Child(contact) it can have many Parent(Town)

    it it...
  25. Replies
    4
    Views
    1,071

    [RESOLVED] Mysql to Treeview

    I need to have Treeview Regions/Town/contact any advice how it is best to do this

    anyone who can help me to get list to treeview like this
    Regions
    --Town
    --contact
    I have Table one...
  26. Replies
    8
    Views
    723

    Re: Xml move nodes up and down

    Thanks patel45 then I need to check this better

    this is another sample it works well
    MoveElementup is sample from this Url




    Dim elems = From el In xe...<Nodes>.<TreeNodeData>...
  27. Replies
    8
    Views
    723

    Re: Xml move nodes up and down

    This is treeview sample in VB.NET Download
  28. Replies
    8
    Views
    723

    Re: Xml move nodes up and down

    This is the code
    when I have only 2 nodes Category 1 and Category 2 then I can only move nodes down but if I have more Category then it work fine but not with the last Category can not move it up
    ...
  29. Replies
    8
    Views
    723

    Xml move nodes up and down

    Hi

    I am tray to move nodes up and down
    I can move nodes down but I have problem move nodes up
  30. Replies
    18
    Views
    3,076

    Re: vb.net read xml to listview and textbox

    Thanks dbasnett
  31. Replies
    18
    Views
    3,076

    Re: vb.net read xml to listview and textbox

    Thanks will check this out

    I was thinning about Category in the tree how I can add new Category to the tree




    <TreeNodeData>
    <Text>Category 1</Text>
    ...
  32. Replies
    18
    Views
    3,076

    Re: vb.net read xml to listview and textbox

    Hi

    I am finish to find out how I can add new but not how to add new Category




    Dim foo As XElement = DirectCast(Form1.Mytreev.SelectedNode.Tag, XElement)

    ...
  33. Replies
    18
    Views
    3,076

    Re: vb.net read xml to listview and textbox

    Thanks dbasnett

    Can I Go a little further and ask about add new and delete from the tree
  34. Replies
    18
    Views
    3,076

    Re: vb.net read xml to listview and textbox

    Thanks


    Too easy Just did not see the solution
  35. Replies
    18
    Views
    3,076

    Re: vb.net read xml to listview and textbox

    Hi


    tell me when I change the XML file in Notepad and try to reload the XML file I don't get the changes need to close and open the form again

    how can I reload the XML file
  36. Replies
    1
    Views
    396

    Re: Listview Sum to 12 then change ForeColor

    Thing I am finish to fix this


    but 12 is not always 12 how can I loop through list first count 12 change the line to Blue/brown then I keep counting
    next 8 change the line to Blue/brown and then...
  37. Replies
    1
    Views
    396

    Listview Sum to 12 then change ForeColor

    Hi
    Can someone help me with this


    I can Sum Listview and change ForeColor to Blue but I need to change "Address 6"
    1. Blue if sum is 12
    2. Brown sum is 14 but 12 is in this line

    ID, ...
  38. Replies
    3
    Views
    1,611

    Re: VB.NET count ArrayList SUM

    Change to Double and can count

    Thanks
  39. Replies
    3
    Views
    1,611

    VB.NET count ArrayList SUM

    Hi

    Anyone who can help me with this , Thanks

    I have list of words I Loop through and need to check if I have the words in arraylist and get total


    so I get
    Test_1 Fiber 3 500
    Test_2...
  40. Replies
    18
    Views
    3,076

    Re: vb.net read xml to listview and textbox

    Thanks dbasnett for your help ! and 4x2y your your help
Results 1 to 40 of 110
Page 1 of 3 1 2 3



Featured


Click Here to Expand Forum to Full Width