Search:

Type: Posts; User: dr223

Page 1 of 13 1 2 3 4

Search: Search took 0.03 seconds.

  1. Thread: VisionID

    by dr223
    Replies
    1
    Views
    1,240

    VisionID

    Hi,

    I have the following code on the DS;



    SELECT '-- Please Select --' AS GoldPatID, 0 AS OrderCol1, 0 AS OrderCol2
    UNION ALL
    SELECT GOLDPatID, PracNo, GOLDPatID AS Expr1...
  2. Replies
    25
    Views
    2,937

    Re: De-crypt and Unzip the folder

    Thank you again - Inferrd

    Do you have any unzip code (Vb.Net) from a different library or advise me accordingly...

    Many thanks
  3. Replies
    25
    Views
    2,937

    Re: De-crypt and Unzip the folder

    Any help please
  4. Replies
    25
    Views
    2,937

    Re: De-crypt and Unzip the folder

    One step nearly there--- Inferrd

    Tried the code above as;


    Private Sub unzip1(ByVal filename As String, ByVal targetdir As String, ByVal overwrite As Boolean, Optional ByVal password As...
  5. Replies
    25
    Views
    2,937

    Re: De-crypt and Unzip the folder

    Thanks -

    1) the password was OK
    2) WinZip opens fine manually, with password above problem.
    Any chance I can update ZipLib to allow the decrypt to happen??

    Please anyone can update the...
  6. Replies
    25
    Views
    2,937

    Re: SharpZipLib - Error Message

    Yes - when I use a password it doesn't work and receive an error message,

    Stored, but compressed! = uncompressed
  7. Replies
    25
    Views
    2,937

    SharpZipLib - Error Message

    Hi,

    I have unzip function as shown below;


    Private Sub unzip(ByVal filename As String, ByVal targetdir As String, ByVal overwrite As Boolean, Optional ByVal password As String = "Here's a...
  8. Replies
    25
    Views
    2,937

    Re: De-crypt and Unzip the folder

    Thanks for all input Inferrd

    I am not doing the zipped files - I receive them from external clients and I have to automate the process to unzip the file as it arrives daily.

    If I unzip the...
  9. Replies
    25
    Views
    2,937

    Re: De-crypt and Unzip the folder

    Received error message;

    Stored, but compressed ! = Uncompressed

    When I introduced the Try Catch..

    Hope this helps
  10. Replies
    25
    Views
    2,937

    Re: De-crypt and Unzip the folder

    Used break-point and it stops here;


    Dim inputStrm As New ZipInputStream(File.OpenRead(filename))
    inputStrm.Password = password
    Dim nextEntry As ZipEntry = inputStrm.GetNextEntry()

    any...
  11. Replies
    25
    Views
    2,937

    Re: De-crypt and Unzip the folder

    Ok -

    I set it as a sub and called the sub as follows;

    No errors at all - the file doesn't get unzipped, that's all




    Private Sub FolderUnzip()
  12. Replies
    25
    Views
    2,937

    Re: De-crypt and Unzip the folder

    Inferrd - Correct it does work, but not fully for me.

    Let me explain - if I have zipped file not PASSWORD PROTECTED then it works perfect.

    Now, the zipped files are password protected and...
  13. Replies
    25
    Views
    2,937

    Re: De-crypt and Unzip the folder

    Sorry - My mistake - I have done it as noted in #3

    Any idea why it is not unzipping the file
  14. Replies
    25
    Views
    2,937

    Re: De-crypt and Unzip the folder

    'source of the zipped files
    Label1.Text = "F:\Transformation Project\CPRDApps\NEW INPS Data Transfer\INPS Test\"

    'destination of the unzipped files
    Label2.Text = "F:\Transformation...
  15. Replies
    25
    Views
    2,937

    De-crypt and Unzip the folder

    Hi,

    I have a file when you use the WinZip to open it prompts for a password which is = Password123
    Entering the password open the zip file, which has a number of files.

    Now, I want to...
  16. Replies
    7
    Views
    997

    Re: Selected Index Issue

    Thank you - Sorted
  17. Replies
    7
    Views
    997

    Selected Index Issue

    Hi,

    I am working with .NET framework 4. When I open the solution and run the code below the form opens with NO ERRORS. However, when I open the executable in the Bin I receive the error message; ...
  18. Thread: Combo Boxes

    by dr223
    Replies
    7
    Views
    818

    Re: Combo Boxes

    That's my reference table

    132751
  19. Thread: Combo Boxes

    by dr223
    Replies
    7
    Views
    818

    Re: Combo Boxes

    I have .NET Framework 4.0 ..

    LINQ references am not sure - how can I do that ?
  20. Thread: Combo Boxes

    by dr223
    Replies
    7
    Views
    818

    Re: Combo Boxes

    I added the code below on my form;


    Public Class ComboBoxEx
    Inherits ComboBox

    Private allItems() As String = {"Collections Ongoing", "Collections Hold", "No Longer IPS", "Withdrawn",...
  21. Thread: Combo Boxes

    by dr223
    Replies
    7
    Views
    818

    Combo Boxes

    Hi,

    I have the following SelectedIndexchanged code;



    Private Sub TxtPracStatus_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles...
  22. Thread: Select Statement

    by dr223
    Replies
    3
    Views
    600

    Re: Select Statement

    Did you mean this below....


    SELECT '-- Please Select --' AS pick_code, 0 AS OrderCol1, 0 AS OrderCol2
    UNION ALL
    SELECT pick_code, pick_desc, pick_code AS Expr1
    FROM ...
  23. Thread: Select Statement

    by dr223
    Replies
    3
    Views
    600

    Select Statement

    Hi,

    I have the following code as a data table adapter for the combo box (cmbCollStatus);



    SELECT '-- Please Select --' AS pick_code, 0 AS OrderCol1, 0 AS OrderCol2
    UNION ALL
    SELECT...
  24. Thread: Combo Boxes

    by dr223
    Replies
    6
    Views
    768

    Re: Combo Boxes

    Ok - Tried to set up the dictionary;


    'Create the Dictionary
    Private statuses As Dictionary(Of String, List(Of String)) = New Dictionary(Of String, List(Of String)) From {"Active", New...
  25. Thread: Combo Boxes

    by dr223
    Replies
    6
    Views
    768

    Re: Combo Boxes

    The issue with the above - its Ok for 4 values but I have quite a long pick list.

    Please is there an easier way.

    I was thinking maybe to change the select statement - and introduce a case...
  26. Thread: Combo Boxes

    by dr223
    Replies
    6
    Views
    768

    Combo Boxes

    Hi,

    I have a combo box called cmbPracStatus - it has the following values

    Active
    Old

    I have another combo box called CmbCollStatus - it has the following values

    Coll Ongoing
  27. Combo Box affects another combo box drop down

    Hi,

    I have a combo box called cmbPracStatus which has the following items;

    Active
    Old

    Then I have another combo box called cmbColStatus which has the following items;

    Act1
  28. Search GridView Disappears on Navigate Button Click

    Hi,

    On my Form I have 2 gridviews namely; gvCRSearch (that displays search results) and gvCRView (that displays all the change requests raised)..
    Now, when the records are more than 10 in...
  29. Thread: Join Statement

    by dr223
    Replies
    3
    Views
    896

    Join Statement

    Hi,

    I have 2 tables TableA and TableB

    TableA


    MedicalCodeID EmisCode ReadCode
    1 EMISATT NULL
    2 NULL PCSDT
  30. Thread: Select Statement

    by dr223
    Replies
    5
    Views
    1,134

    Re: Select Statement

    Pls help me to solve this dilemma . Thanks
  31. Thread: Select Statement

    by dr223
    Replies
    5
    Views
    1,134

    Re: Select Statement

    Thank you so much for responding.. Let me explain

    I have a table called CPRDLkupMedical, with a sample of the data as shown below;


    MedicalCodeID Snomed SnomedDescription Emiscode ...
  32. Thread: Select Statement

    by dr223
    Replies
    5
    Views
    1,134

    Re: Select Statement

    pls help
  33. Thread: Select Statement

    by dr223
    Replies
    5
    Views
    1,134

    Select Statement

    Hi,

    I have created the following table using the insert statement below;
    In this insert statement, for emiscode and readcode, am trying to create one medicalcodeid for all emiscode with PCSDT...
  34. Replies
    5
    Views
    1,099

    Conversion Failed

    Hi,

    I have the foolowing select statement in my query;


    SELECT '-- Please Select --' AS PhysicianID, 0 AS OrderCol1, 0 AS OrderCol2
    UNION ALL
    SELECT PhysicianID, PracNo,...
  35. Thread: Enter NULL Value

    by dr223
    Replies
    5
    Views
    860

    Enter NULL Value

    Hi,

    I have the following Code in my Form;

    For 3 checkboxes - Yes, No and Don't Know




    Dim Q3Selected As Integer = Nothing
  36. Thread: Insert statement

    by dr223
    Replies
    5
    Views
    747

    Insert statement

    Hi,

    I have an insert statement which works OK - Only when a combobox value is not selected (Yr not inserted) I receive an error


    Conversion failed when converting the nvarchar value...
  37. Thread: Combo Box

    by dr223
    Replies
    1
    Views
    487

    Combo Box

    Hi,

    I have a combo Box (cmbMQYr), in the Property section - Items (Collection) I have;


    -- Please Select --
    1950
    1960
    1970
    1980
  38. Replies
    2
    Views
    671

    Reset a combo box

    Hi,

    I have a data bounded combo box (cmbQ7) and this is populated by a tableadapter


    SELECT 0 AS RateScaleID, '-- Please Select --' AS RateScaleDesc
    UNION ALL
    SELECT ...
  39. Thread: Select Statement

    by dr223
    Replies
    7
    Views
    741

    Re: Select Statement

    Thank you so much
  40. Thread: Select Statement

    by dr223
    Replies
    7
    Views
    741

    Re: Select Statement

    If it is checked it can be 2 also if its NO checkbox checked rather than 1
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width