Search:

Type: Posts; User: robertx

Page 1 of 13 1 2 3 4

Search: Search took 0.33 seconds.

  1. VS 2017 Send string directly to local unshared USB Zebra label printer

    A string can be sent to a local USB Zebra printer (without ethernet connectivity) that is shared using a UNC path \\HOSTNAME\SHARENAME. Is there a way of printing directly to the printer in an...
  2. Re: Pass a list of integers to stored procedure and perform insert on each

    Thanks this led me to this solution which was a bit clearer for my situation:

    https://www.admfactory.com/split-a-string-and-loop-in-sql-server/
  3. Re: Pass a list of integers to stored procedure and perform insert on each

    I believe string_split wasn’t introduced until SQL Server 2016 and I need to be able to support 2012 and 2014. Is there an alternative method that is supported by these versions?
  4. Re: Pass a list of integers to stored procedure and perform insert on each

    Is there a way of looping through a table-valued parameter and assigning each value to a variable so that it can be passed to an insert query?
  5. Re: Pass a list of integers to stored procedure and perform insert on each

    I know how to pass a list to a stored procedure. How can I iterate it and perform an insert query with each value?
  6. Re: Pass a list of integers to stored procedure and perform insert on each

    MSSQL Server
  7. Pass a list of integers to stored procedure and perform insert on each

    Is there a way to pass a list of integers to a stored procedure and perform an insert query on each? I have tried running a SELECT query to return the integer list within the stored procedure but it...
  8. Replies
    1
    Views
    253

    VS 2017 .NET Framework Backward Compatibility

    I have an application that targets .NET Framework 4.5.2. Which versions of .NET Framework will be compatible? Is each subsequent version backward compatible?
  9. Replies
    18
    Views
    1,733

    VS 2017 Re: Programmatically set file association

    I revisited this topic - this time with some success as follows:

    First call the CreateFileAssociation method as per:
    ...
  10. Replies
    1
    Views
    432

    VS 2017 Application Freezing Randomly

    I have an application that is freezing periodically and randomly in the same process with one particular deployment. There is no exception thrown. The application simply freezes and becomes...
  11. VS 2017 Re: Show message box looping in BackgroundWorker_RunWorkerCompleted event procedure

    The form is a new instance displayed using ShowDialog. I figured out the problem. The background worker's RunWorkerAsync method was called in the form activate event procedure. I moved it the Shown...
  12. VS 2017 [RESOLVED] Show message box looping in BackgroundWorker_RunWorkerCompleted event procedure

    I have a message box that displays in a BackgroundWorker_RunWorkerCompleted event procedure called as follows:

    Private Sub myBackgroundWorker_RunWorkerCompleted(ByVal sender As Object, ByVal e As...
  13. Replies
    18
    Views
    1,733

    VS 2017 Re: Programmatically set file association

    I ran the test application and the test text file opened in Notepad. Not sure what the issue in on my machine.
  14. Replies
    18
    Views
    1,733

    VS 2017 Re: Programmatically set file association

    Did you get it to work? When I set Notepad as the default application for txt files then run the code (as administrator) using the parameters in my previous post, no exception is thrown but txt files...
  15. Replies
    18
    Views
    1,733

    VS 2017 Re: Programmatically set file association

    The CreateSubKey method creates a new subkey or opens an existing subkey.
  16. Replies
    18
    Views
    1,733

    VS 2017 Re: Programmatically set file association

    The procedure adds the leading dot if it is missing.
  17. Replies
    18
    Views
    1,733

    VS 2017 Re: Programmatically set file association

    So when trying to associate txt files with Notepad++, I passed as follows:

    extension = "txt"
    className = "txtfile"
    description = "Text File"
    exeProgram = "C:\Program...
  18. Replies
    18
    Views
    1,733

    VS 2017 Re: Programmatically set file association

    So when trying to associate txt files with Notepad++, I passed as follows:

    extension = "txt"
    className = "txtfile"
    description = "Text File"
    exeProgram = "C:\Program...
  19. Replies
    18
    Views
    1,733

    VS 2017 Re: Programmatically set file association

    In the case of the .NET code method, I ran the application as administrator. Should that be enough or does the manifest file need to be modified as well? From my experience, when registry...
  20. Replies
    18
    Views
    1,733

    VS 2017 Re: Programmatically set file association

    The solutions suggested in this thread were amongst those that I tried and couldn’t get to work.
  21. Replies
    18
    Views
    1,733

    VS 2017 Programmatically set file association

    How can file associations be set either with .NET code or via the command line / batch file? e.g. How can TXT files be programmatically associated so that they open by default in either Notepad,...
  22. Permissions required for executing stored procedures on SQL Server

    I have an application that uses an SQL Server database and stored procedures for data access. I generally assign db_owner permissions to the user. A DBA suggested that this might present a security...
  23. SQL Server - Implement TLS encryption of data in transit

    In order to implement TLS encryption of data in transit between an SQL Server database and a client workstation, is this achieved by:

    1) Installing an SSL/TLS certificate on the machine hosting...
  24. Migrate MSSQL Server 2017 database to 2012

    Can an MSSQL Server 2017 database be migrated onto an MSSQL Server 2012? I know that the 2017 database can't simply be instantiated on 2012 and there are articles describing doing this using...
  25. Replies
    4
    Views
    367

    VS 2017 Write to file using a service account

    Is it possible to write a file to a location using the permissions assigned to a service account rather than the current user account?
  26. VS 2017 Re: Cannot access network share via VB.NET application but can access via Explorer

    I found a registry fix for this issue:

    Click Start, type regedit in the Start programs and files box, and then press ENTER.

    Locate and then right-click the registry subkey...
  27. VS 2017 Cannot access network share via VB.NET application but can access via Explorer

    I am restoring a VB.NET application onto a new Windows 10 Home 64-bit machine. The application reads data from a file on a network share. It was working fine on the old machine. I can get to the...
  28. Replies
    6
    Views
    4,592

    VS 2017 Re: Could not load this custom viewer

    Running a Visual Studio 2017 Community Edition repair resolved this issue.
  29. VS 2017 Re: Save XML to file and assign to string using XMLWriter

    This worked well except that the encoding changed from UTF-8 to UTF-16 so I used this ExtendedStringWriter class to enable setting the encoding:


    Public NotInheritable Class ExtentedStringWriter...
  30. VS 2017 [RESOLVED] Save XML to file and assign to string using XMLWriter

    I am using an XMLWriter object to write XML to a file. I want to write to a file and also capture the XML and save the text to a database without having to reiterate and rebuild the XML. I don't want...
  31. Replies
    6
    Views
    4,592

    VS 2017 Re: Could not load this custom viewer

    I updated to the latest version without success. I'll try a repair.
  32. Replies
    6
    Views
    4,592

    VS 2017 Re: Could not load this custom viewer

    I have referenced a data table in my code. When I hover the cursor over the code and click on the magnifying glass, normally I can view the data table. At the point of clicking on the magnifying...
  33. Replies
    6
    Views
    4,592

    VS 2017 [RESOLVED] Could not load this custom viewer

    I am having trouble viewing data tables while debugging in Visual Studio 2017 Community Edition. When I attempt to view a data table, it throws the following exception:

    167011

    Is this a...
  34. VS 2013 Re: Check whether application is running for another user

    Whilst the sample application in this link is not coded in a thread-safe manner, it nevertheless demonstrates how to detect that the current Windows session has been locked.
  35. VS 2013 Re: Check whether application is running for another user

    There may be several machines accessing the one database but each machine will have its own set of hardware devices to connect to.



    I am trying to avoid this kind of inefficiency. I would...
  36. VS 2013 Re: Check whether application is running for another user

    Users will generally be standard users. I don't require information about any other particular user per se but rather whether the PC is running another instance of the application via another user's...
  37. VS 2013 [RESOLVED] Check whether application is running for another user

    I have an application that establishes connections to several hardware devices. Sometimes users will leave the application open and abandon the PC. Eventually the lockout screen appears and a new...
  38. Replies
    4
    Views
    532

    VS 2013 Restore executable file from database

    I have stored an executable file as a byte array in an SQL Server database. I can restore the file successfully but when I launch it, I am getting this "This app can't run on your PC" on Windows 10...
  39. Replies
    3
    Views
    510

    Re: Duplicate table column

    A new field can be added with a default value of 1 with:

    ALTER TABLE Table1 ADD NewField bigint NOT NULL DEFAULT(1)

    I am wondering whether it is possible to set the default value to that of...
  40. Replies
    3
    Views
    510

    Duplicate table column

    Is there an ALTER TABLE query that I can run to duplicate a bigint column in SQL Server with a different name but retaining the same values in each row?
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width