Search:

Type: Posts; User: squatman

Page 1 of 8 1 2 3 4

Search: Search took 0.05 seconds.

  1. VS 2019 Re: Downloading a file from Sharepoint - Completly Lost

    Hi there,

    Did you get anywhere with this?

    I had a console application working fine with just user credentials, but now the company has two factor authentication enabled it has stopped working....
  2. Replies
    4
    Views
    617

    VS 2022 Re: Do I need to use BindingSource

    dday9, thanks for the response.

    Expanding on my item no. 3. I would have a form with textboxes for example that the user would click a button to accept, this would (in this example) add a new...
  3. Replies
    2
    Views
    600

    VS 2022 DataGridView Memory Consumption

    Hi there,

    I've recently started trying looking into memory usage of my application and if I need to make some changes.

    To start with I've been looking at my DataGridView (these figures are from...
  4. Replies
    4
    Views
    617

    VS 2022 Do I need to use BindingSource

    Hi there,

    I've been programming in VB for a while now and I've always:


    Filled a DataTable using SqlDataAdapter
    Set DataGridView.DataSource = DataTable.DefaultView
    Added/Updated/Removed...
  5. VS 2022 Re: Passing mousescroll event to different control

    Thanks Shaggy
  6. VS 2022 [RESOLVED] Passing mousescroll event to different control

    Hi,

    I have various controls within a Panel running vertically (they're actually in a TableLayoutPanel, that is within a Panel). The Panel has AutoScroll enabled.

    When a user is scrolling down...
  7. Replies
    2
    Views
    684

    VS 2022 Re: Copied Solution Identifier

    jmc,

    Thank you very much, that did the trick. Legend.
  8. Replies
    2
    Views
    684

    VS 2022 [RESOLVED] Copied Solution Identifier

    Hi,

    I'm not sure if this will be the correct forum so apologies if not.

    I have a solution for one client that will be the basis as a solution for a new client, it will basically be the same...
  9. Replies
    6
    Views
    1,140

    VS 2022 Re: Moving from SQL Server to MySQL

    Thanks all for your replies.

    I've managed to create a Web Service in NodeJS with ExpressJS that accepts requests based on a URL. This returns data in the form of JSON. Which I assume means I have...
  10. Replies
    6
    Views
    1,140

    VS 2022 Re: Moving from SQL Server to MySQL

    techgnome thanks for the reply,

    I've been playing around in Azure for the first time today and set up a free trial SQL server which actually allowed me to connect exactly the same with my original...
  11. Replies
    6
    Views
    1,140

    VS 2022 Moving from SQL Server to MySQL

    Hi there,

    I've developed applications previously that would connect to a Microsoft SQL Server on the same network using the following code:


    Imports System.Data.SqlClient

    Public Class Form1...
  12. Re: Unable to connect to any of the specified MySQL hosts

    Aussie,

    I've come across this exact problem today after using SQL Server on our network, the MySQL code examples looked like once reference I could just replace things like SqlConnection,...
  13. Replies
    5
    Views
    1,220

    VS 2019 Windows service connect to SQL server error

    Hi there,

    I'm creating a windows service application in vb. When using WinForms I can connect to the SQL database no problem, but with the Windows Service I get the following error:



    I've...
  14. Replies
    10
    Views
    3,456

    VS 2017 Re: Execution Timeout Expired

    Goggy, I have remote users operating on poor connections which is what I think may be my issues. What was you going to suggest if the connection is the problem?

    Thank you
  15. VS 2019 Re: Disable Scroll on ComboBox MouseOver

    Thanks for the response .paul.

    I tried a couple of solutions that used the WM_MOUSEWHEEL aka &H020A, but I couldn't get them to work.

    Luckily your mention of this message allowed me to find a...
  16. VS 2019 [RESOLVED] Disable Scroll on ComboBox MouseOver

    Hi there,

    I have a ComboBox inside a TableLayoutPanel, inside another TableLayoutPanel, inside a Panel. The Panel has scrolling enabled when the Form windows is resized smaller than the content.
    ...
  17. Replies
    24
    Views
    20,508

    Re: how to change color of label when mouse hover?

    Niya, thanks for the response.

    Unfortunately neither worked, and now I get this all too familiar screen when I've been using custom controls :-(

    183624

    I'm using Visual Studio Community 2019...
  18. Replies
    24
    Views
    20,508

    Re: how to change color of label when mouse hover?

    Hi there, I stumbled across this post whilst working on a CustomLabel, that enables part of the Label to be bold. I'd now like the bold section to change colour on MouseEnter.

    I'm somewhat new to...
  19. Re: Server based listener to send file to web client

    szlamany, thanks for the response that's good to hear!

    This is all new to me, but I'd assumed the SO code would sit on the my Windows server which has direct access to the files, but rather than...
  20. Server based listener to send file to web client

    Hi,

    We have a windows server in our office that stores our files.

    We have a web hosting with GoDaddy.

    I want to create a secure web page on the web hosting, this page will display a list of...
  21. Replies
    1
    Views
    639

    VS 2019 Rotated Text Quality

    Hi there,

    I've rotated the Text within a Button using the Paint Event.

    And I've been messing around with the Graphics quality, and I just can't seem to get it to look the same as the non...
  22. VS 2019 Re: LINQ - DataTable Group By and Cell values to dynamic Column Headers

    Using a post from NetMage on StackOverFlow I've managed to sort this, though unfortunately I don't fully understand the LINQ section.
    ...
  23. VS 2019 Re: Filter DT & Show/Hide Columns or Query Database each time..?

    I decided to figure out how to achieve the PIVOT within VB, so that I can retrieve all data values initially and each time a user filters, it will filter the data and re-apply the PIVOT.

    This...
  24. VS 2019 LINQ - DataTable Group By and Cell values to dynamic Column Headers

    Hi there,

    I have a DataTable that looks like this:



    Employee | Cert | Expiry Date
    Joe | H&S | 2022-02-12
    Joe | Induction | 2023-07-20
    Bob | H&S ...
  25. VS 2019 Filter DT & Show/Hide Columns or Query Database each time..?

    Hi there,

    I'm developing a form that uses a DataTable/DataGridView to show the expiry dates of various training certificates for each employee.

    Each certificate has a "valid from date", "expiry...
  26. VS 2019 Re: Database Rows to Columns in Result

    Done. Thank you. Sorry.



    SELECT @test1 = STUFF((SELECT DISTINCT ',' + 'MAX(' + QUOTENAME(ct.[name] + ' (Valid)') + ') AS ''' + ct.[name] + ' (Valid)'''
    FROM...
  27. VS 2019 Re: Database Rows to Columns in Result

    Actually not quite, now my columns don't have a name!! aahhh!!
  28. VS 2019 Re: Database Rows to Columns in Result

    Apologies again, I need to learn a lot more SQL.

    A bit of Googling and creating some more variables with MAX( ) around the columns names I've managed to get it as I want it.

    Final query below,...
  29. VS 2019 Re: Database Rows to Columns in Result

    Ok I've managed to get the query to execute and now I understand what you was referring to with the ALIAS, with you saying in the SET I was looking in the wrong place.

    Thank you techgnome.

    I've...
  30. VS 2019 Re: Database Rows to Columns in Result

    Apologies for all the replies, I've been writing the SQL out manually rather then with variables to see exactly what's going on.

    The problem with the "name" is in the PIVOT:



    PIVOT ...
  31. VS 2019 Re: Database Rows to Columns in Result

    Ok I've been playing around and saw the my SELECT @cols where returning the column names with squad brackets around them e.g. [Cert 1 ' (Valid)' AS 'V'] which I thought this may have been causing the...
  32. VS 2019 Re: Database Rows to Columns in Result

    Thanks for the response tg, appreciate it.

    Not sure if I've got the wrong end of the stick, but I updated the SELECTs to the following to include the aliases:



    SELECT @cols = STUFF((SELECT...
  33. VS 2019 Re: Database Rows to Columns in Result

    techgnome,

    Thanks for your response, I'm just picking this up again now; I managed to get it working as a stored procedure so thank you. During development for filtering purposes I've realised I...
  34. VS 2019 Re: Database Rows to Columns in Result

    The SQL ran fine in SQL Management Studio so I didn't think there was anything wrong with the query, I wanted to make sure it wasn't a result of me doing something wrong with the Parameters.

    I've...
  35. VS 2019 Re: Database Rows to Columns in Result

    I've just got a bit further setting my parameters direction to Output:


    cmd.Parameters.Add(New SqlParameter("@cols", SqlDbType.NVarChar, 255) With {.Direction =...
  36. VS 2019 Re: Database Rows to Columns in Result

    jmc, thanks for the response.

    I've used Parameters before e.g. cmd.Parameters.Add("@cols", SqlDbType.NVarChar).Value = "value"

    But what would values would I fill them with in this instance, as...
  37. VS 2019 [RESOLVED] Database Rows to Columns in Result

    Hi there,

    I have the following tables:

    User


    id | full_name

    1 | Bill Gates
  38. VS 2019 Re: Original DataTable columns after LINQ query

    Thank you both for your responses.

    Paul, I'm still tot est but that looks like a really neat way to get the information back into a DataTable so thank you.

    Chris, it doesn't look like this...
  39. VS 2019 Re: Original DataTable columns after LINQ query

    Jmc,

    Thank you for your response.

    I've updated my code as follows, though do I really need to enter and select every column?

    I've opted for your first solution, as every other column is...
  40. VS 2019 [RESOLVED] Original DataTable columns after LINQ query

    Hi there,

    My original issue was wanting to concatenate values in a DataColumn across DataRows.

    I have the following data:



    id | col1 | col2 | Category...
Results 1 to 40 of 304
Page 1 of 8 1 2 3 4



Click Here to Expand Forum to Full Width