Search:
Type: Posts; User: dr223
Search:
Search took 0.03 seconds.
-
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...
-
Thank you again - Inferrd
Do you have any unzip code (Vb.Net) from a different library or advise me accordingly...
Many thanks
-
-
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...
-
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...
-
Yes - when I use a password it doesn't work and receive an error message,
Stored, but compressed! = uncompressed
-
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...
-
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...
-
Received error message;
Stored, but compressed ! = Uncompressed
When I introduced the Try Catch..
Hope this helps
-
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...
-
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()
-
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...
-
Sorry - My mistake - I have done it as noted in #3
Any idea why it is not unzipping the file
-
'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...
-
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...
-
-
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; ...
-
That's my reference table
132751
-
I have .NET Framework 4.0 ..
LINQ references am not sure - how can I do that ?
-
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",...
-
Hi,
I have the following SelectedIndexchanged code;
Private Sub TxtPracStatus_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles...
-
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 ...
-
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...
-
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...
-
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...
-
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
-
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
-
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...
-
Hi,
I have 2 tables TableA and TableB
TableA
MedicalCodeID EmisCode ReadCode
1 EMISATT NULL
2 NULL PCSDT
-
Pls help me to solve this dilemma . Thanks
-
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 ...
-
-
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...
-
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,...
-
Hi,
I have the following Code in my Form;
For 3 checkboxes - Yes, No and Don't Know
Dim Q3Selected As Integer = Nothing
-
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...
-
Hi,
I have a combo Box (cmbMQYr), in the Property section - Items (Collection) I have;
-- Please Select --
1950
1960
1970
1980
-
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 ...
-
-
If it is checked it can be 2 also if its NO checkbox checked rather than 1
|
Click Here to Expand Forum to Full Width
|