Search:

Type: Posts; User: VB.NETGAL

Page 1 of 2 1 2

Search: Search took 0.04 seconds.

  1. Help/Advice for binding datatable with paging to page.

    Hi, looking for any help i can get... as I'm sure this type of thing will be easy to those who know how.

    I've come across a problem in my work where I have data in my datatable after it has been...
  2. Re: Retrieve string from between two strings loop

    I've written a



    Public function OptionSplit(OptionString$, optional ByVal StrBegin$ = "", Optional byval StrEnd$ ="") As List(Of String)

    If StrBegin.Length > 0 AndAlso...
  3. Re: Retrieve string from between two strings loop

    I am a software developer for a ticketing company. We host and own the websites. It's not a case of getting an API done. We have api's for pricing but different areas of our stadium have different...
  4. Re: Retrieve string from between two strings loop

    How very perceptive of you..but I actually work for a ticketing company and I'm doing load testing and need to get the option values to pass different values into my load test.
  5. [RESOLVED] Retrieve string from between two strings loop

    Hi all.. been looking online for a solution for this but with no luck. A few posts suggested regular expression but I couldn't work out how to implement it as my solution.

    I'm just looking for...
  6. [RESOLVED] Help Novice with date conversion in Javascript

    Hi all, I'm a complete novice with Javascript so wondering if anybody can assist me with an issue I'm having.

    On my webpage I have a minimum and maximum date set in hidden fields hdfMinDate and...
  7. VS 2015 Re: Help with LINQ or datatable sorting code

    Both Excellent answers and exactly what I needed.

    Many thanks for your help! Appreciated :)
  8. VS 2015 [RESOLVED] Help with LINQ or datatable sorting code

    Hi all,

    I haven't posted for a long time...but need to ask the experts as I believe what I'm trying to do should be really easy

    I have a viewmodel returned with a list called called...
  9. Replies
    1
    Views
    771

    Re: Strange problem sorting datatable data

    update... it seems to sort properly when DEPT15 is the first column in datatable.. I'd love to know why tho
  10. Replies
    1
    Views
    771

    Strange problem sorting datatable data

    Hi,

    I'm having a really bizarre problem sorting datatable data.


    I have a datatable dtpayment which has several columns and one of them is DEPT15 and has different department names in. there's...
  11. Connection timeout on first connect to localdb

    Hi,

    I have a problem which I'm not sure on how to resolve.

    I've made a small reporting application in WPF which works with a local SQL database stored in the same folder as the report tool.
    ...
  12. Re: Properly close all active connections to database DB2

    Thanks for your reply... I have refactored my code to your format as it certainly looks alot more logical. For some strange reason though I'm still getting the same error and the connection not...
  13. Re: Properly close all active connections to database DB2

    Yes... if I remove the using... then I'm guessing it just creates new objects each time?

    Without the using statement because I use the same function to pull data 3 times using different select...
  14. Re: Properly close all active connections to database DB2

    ;) I guess the error would help ha.

    When i first run the code it creates a "job" on the iseries database and it's this instance that makes me think its not being killed properly
    124779

    the...
  15. Properly close all active connections to database DB2

    Public Function IBMDatatable(SelectCommand$) As DataTable

    Dim dt As New DataTable

    Using cn As New iDB2Connection
    cn.ConnectionString = "Data Source=" & SYSTEMID &...
  16. VS 2013 Re: Loading WPF user control into another user control

    I'm using button click events like winforms app.

    Was hoping for a similar way to do it like the code above but then I don't know how to reference the different controls.

    I can load one control...
  17. VS 2013 [RESOLVED] Loading WPF user control into another user control

    Hi there,

    I'm creating WPF application and I am creating some different user controls which I am loading into my main form.

    So, I have my main form called MainWindow

    This form consists of 3...
  18. Replies
    1
    Views
    4,271

    Re: WPF Calendar Remove Blank space

    Hi... My mistake.

    I had some style in my global application settings to change the style of "button" to make it a minimal width and that property must be used on the calendar control itself.
    ...
  19. Replies
    1
    Views
    4,271

    [RESOLVED] WPF Calendar Remove Blank space

    <Calendar DisplayMode="Month" Name="DTRECFROM"></Calendar>


    Hope somebody can help..Hopefully an easy one.

    I have a WPF calendar inside a control and I've noticed there is a lot of blank...
  20. Re: [RESOLVED] Datatable expression with NULL value

    I just wanted NETTVALUE to be updated with PRENETTVALUE if PRENETTVALUE had a value.

    If PRENETTVALUE is DBNULL then update with SALESVALUE.

    I know that for my testing the first bit of code you...
  21. Re: Datatable expression with NULL value

    Hi, Yes that worked perfectly!

    I just couldn't work out the syntax as I thought it would need to be as an IIF statement.
  22. [RESOLVED] Datatable expression with NULL value

    Hi there,

    Hoping somebody can help.

    I have 3 columns in a datatable which has been created in memory.

    PRENETTVALUE, SALESVALUE, NETTVALUE

    NETTVALUE is my calculated column. I want to...
  23. VS 2010 Remove datatable columns if not equal to certain names

    Hi,

    I'm copying data from one table to another using the below

    Dim dt2 As DataTable = dt1.Select("STATUS = 'SALE'").CopyToDataTable

    My problem is that I want my new datatable to only have...
  24. Re: Comparing datatables and showing differences

    Thank you for all of your help. It has been extremely useful!!

    :thumb:
  25. Re: Comparing datatables and showing differences

    Hi there.. could you help me account for this situation.. where there may be a reference in dt1 but nothing to match it to in dt2

    With the below ref 1006 is in table 1 but not table 2.
    ...
  26. Re: Comparing datatables and showing differences

    No it's okay I understand.. I'm going too far ahead instead of breaking it down into manageable parts. I just don't have too much experience with Linq.

    I'm getting an error "Specified cast is not...
  27. [RESOLVED] Comparing datatables and showing differences

    Hi,
    Been trying to find out how to do this for a while.

    Let's say I have two data tables. dt1 and dt2

    They both have two columns: reference, amount

    Is there a way to go to each reference...
  28. Replies
    3
    Views
    616

    Re: Help with coding a loop

    Hi.. yea think I was having a mind block trying to make it harder than it needed to be.

    I can just call the same code inside an If statement for each checkbox :duck:
  29. Replies
    3
    Views
    616

    Help with coding a loop

    Hello,

    I don't have much experience with using a loop but hoping someone can help.

    I am using windows forms to run a report and download data from location1 into a datatable. I want to add...
  30. VS 2010 Re: Problem releasing Excel COM object

    I found this answer on another forum and worked perfectly.. no need to release any objects :D

    Sub Main()
    DoOfficeStuff()
    GC.Collect()
    GC.WaitForPendingFinalizers()
    '' Excel.exe...
  31. VS 2010 [RESOLVED] Problem releasing Excel COM object

    Hi.. hope somebody can advise on what I might be doing wrong.. I've had a look on some other forums to no avail.

    Basically, after I release my COM objects and close my excel application it's not...
  32. VS 2010 Re: Populate textbox from datatable based on search criteria

    I figured it out.. thanks for you help


    Dim BindingSource1 As New BindingSource


    BindingSource1.DataSource = dt

    With BindingSource1
    .Filter = "ID = 1"
  33. VS 2010 Re: Populate textbox from datatable based on search criteria

    Hi,

    Thanks for your input.. I have seen this example before online but I'm not sure it does exactly what I need.

    Basically I have more than 1 text box. txt0,txt1,txt2,txt3,txt4 and so on.
    ...
  34. VS 2010 [RESOLVED] Populate textbox from datatable based on search criteria

    Hi.. I'm hoping somebody can help with something I'm trying to achieve.

    To keep it simple.. lets say I have a datatable called dt

    dt has two columns, ID, Description

    in ID it has rows 0-9...
  35. Replies
    2
    Views
    2,022

    VS 2010 Datatable expression COUNTIF or equivalent

    Hi there..

    In Excel it's possible to do a COUNTIF function on a column... eg say I had a named range called REF filled with

    A
    A
    A
    A
    B
    A
  36. VS 2010 Re: Datatable joins or expression comparison

    102633

    Hi.. as an example in the attached image I have the two tables... which all the tables/columns are built visually in dataset designer, so not defined by my own code. I just want to be able...
  37. VS 2010 Re: Datatable joins or expression comparison

    Thanks for your help.. I have created the relation in my dataset between the two tables so I'll just have to read up some more on returning my results
  38. VS 2010 Re: Datatable joins or expression comparison

    I have downloaded data from a database into two data tables which I have called dtsales and dtpayments.

    Both of my initial SQL downloads are already quite labour intensive on the database so I'd...
  39. VS 2010 Datatable joins or expression comparison

    Hi..

    I have two datatables..one with purchases information, one with payment types.

    Each table has a payment reference in.

    I want to know how I can pull the payment type i.e COLUMN PYTP...
  40. VS 2010 [RESOLVED] Memory allocation and thread priority

    Hi there.. I was hoping a few things could be clarified for me...

    I have started building a simple reporting application which runs SQL, downloads the data into Excel, and then creates pivot...
Results 1 to 40 of 62
Page 1 of 2 1 2



Click Here to Expand Forum to Full Width