Search:

Type: Posts; User: wild_bill

Page 1 of 13 1 2 3 4

Search: Search took 0.16 seconds; generated 43 minute(s) ago.

  1. Replies
    9
    Views
    1,593

    Re: OLEDB Excel Export

    Try disposing the InsertCMD object after executing the non-query.
  2. VS 2017 Re: Match string and cut then move to the top of document

    A couple things I notice from your original regex expression, it's missing the ! and proper casing. So Try


    Dim regex = New Regex("^<!ENTITY.*$")
  3. VS 2017 Re: Match string and cut then move to the top of document

    Is this valid XML you're dealing with? Perhaps an example or two of your input would help us determine the best solution.
  4. Replies
    24
    Views
    50,753

    Re: Input Wanted: 3rd Party Products

    Compression - https://icsharpcode.github.io/SharpZipLib/
    Batch Applications - https://www.nuget.org/packages/CommandLineParser/
    Code Metrics - https://stylecop.codeplex.com/
    Database Deployment -...
  5. Replies
    21
    Views
    4,463

    Re: split city state zip

    Dim rx As New Regex("^([A-Za-z\s]+),? ([A-Za-z]{2}) ([\d\-]+)$", RegexOptions.Compiled)
  6. Replies
    9
    Views
    1,498

    Re: Super beginner in SQL :(

    After you change the table schema in SSMS you would have to refresh the data table in your project to get the changes.
  7. VS 2013 Re: Remove blank entries from the end of an Array

    I think this is a more succinct method for you


    Private Sub WriteDocumentToFile(filePath As String)
    ' create buffer to store data
    Dim buffer As New...
  8. Replies
    4
    Views
    1,718

    Re: Need some help about programming logic

    I do understand, perfectly! You need a datagrid control and you need to implement its paging functionality. I've posted a link above.
  9. Replies
    4
    Views
    1,718

    Re: Need some help about programming logic

    This should help get you started
    https://support.microsoft.com/en-us/kb/305271
  10. Replies
    5
    Views
    2,122

    Re: SQL Database Table Query

    I would probably tackle it a little differently. This assumes OwnerName uniquely defines a customer, which it may not. This is why you should follow normal database modeling practices.


    ...
  11. Replies
    2
    Views
    2,205

    Re: Adding sum in subquery...

    I'm not sure what database you're using, but in sql server it would look like this


    SELECT N, CAR, SUM(EURO)
    FROM PRE
    GROUP BY N, CAR
    HAVING SUM(EURO) >= 1500
  12. Replies
    6
    Views
    3,313

    Re: Insert Blob into .SQL Insert Statement

    I don't think you need to convert anything. If you've got a byte array you should be able to do something like this


    Private Sub SaveBytes(ByVal myItem As Byte())
    Using cmd As New...
  13. Replies
    3
    Views
    5,394

    Re: Loading a Csv

    Since you don't have to use comma delimited files, don't. Use a grid for the user interface then use a data table to read/write xml.


    Private Sub Form1_Load(sender As Object, e As EventArgs)...
  14. Replies
    2
    Views
    1,818

    Re: Account Recovery

    Thanks, I'm back!
  15. Replies
    3
    Views
    751

    Re: How can I do so that each .has a space

    I would use regex. This finds common punctuation followed by zero or more spaces and replaces that with the matched punctuation and a single space. I also added a TrimEnd.


    Dim...
  16. Replies
    3
    Views
    1,800

    VS 2010 Re: index of in lists

    Dim list = New Dictionary(Of String, Integer)
    Dim index = -1

    list.Add("John", 3)
    list.Add("Peter", 5)
    list.Add("David", 7)

    For Each key In list.Keys
    ...
  17. Re: Runtime error :Null reference exception was unhandled

    Nice find tg.
    Check out the TableMappings property of the data adapter. You can use it to change the default table names to names of your choosing.
  18. Re: Runtime error :Null reference exception was unhandled

    I think you're missing the spare parts table. Add this before the line throwing the error.


    If Not antallaktikaDataSet.Tables.Contains("Spare_Parts") Then
    Throw New...
  19. Replies
    5
    Views
    2,299

    Re: convert this to vb code please

    This should get you started


    Sub Main()

    For Each drive As System.IO.DriveInfo In System.IO.DriveInfo.GetDrives
    DirSearch(drive.ToString)
    Next
    End Sub
  20. Replies
    5
    Views
    2,299

    Re: convert this to vb code please

    This should help get you started


    Sub Main()
    Dim doubleQuote = Convert.ToChar(34)

    For Each a As String In System.IO.Directory.GetFiles(My.Application.Info.DirectoryPath,...
  21. VS 2005 Re: System,Runtime.InterloopServices.COMException when writing to excel

    Did you look at DBasnett's link and try the solution?
  22. Re: add data programmatically to sql table vs 2015

    http://www.vbforums.com/showthread.php?469872-Retrieving-and-Saving-Data-in-Databases
  23. VS 2013 Re: Error when trying to reopen excel file after closing

    You quit the excel application in Button3_Click (shame on your naming!). Then you attempt to reuse it in Button2_Click. I think if you initialize the object everytime, it may solve your problem.
    ...
  24. Replies
    4
    Views
    1,106

    VS 2015 Re: Slot Machine Problem

    Let's refactor your code a little bit. First thing add your images from your C drive to your project's resources:
    138695

    Now you should be able to use the following code:


    Private...
  25. Re: My code only produces a two-digit number, not a single-digit number, kinda annoye

    Here's an example if you're still having problems.


    Sub Main()
    Console.WriteLine(RollupNumber(123))
    Console.WriteLine(RollupNumber(129))
    End Sub

    Private Function...
  26. Re: My code only produces a two-digit number, not a single-digit number, kinda annoye

    You would need to implement a recursive function. For example,
    123 = 1+2+3 = 6 (no problem)
    129 = 1 + 2 + 9 = 12 (You would need to send 12 back into the function to get 3 as a result)
  27. VS 2015 Re: Getting a list of FileInfo with Linq parameters

    Dim files As System.IO.FileInfo() = (From file In New IO.DirectoryInfo(appFolder).GetFiles Where Not file.Extension = ".exe" Select file).ToArray
  28. Replies
    15
    Views
    2,566

    Re: Ideas for games

    The games I built back in the day were keno and pong.
  29. VS 2013 Re: WinForm Not Responding message while background thread is running

    Thanks Tn, you were correct, I was making this a whole lot more complicated. Building the node structure was very fast, so adding the parent to the tree view once at the end of the process as...
  30. VS 2013 [RESOLVED] WinForm Not Responding message while background thread is running

    I've got a custom tree view control. It take several seconds for all the nodes to be populated. I decided to kick this functionality off in its own thread to prevent UI locking. The UI is...
  31. Replies
    9
    Views
    2,746

    VS 2013 Re: How to protect my shared data?

    Do you mind giving us some more detail as to what your application does? It will help us help you.
  32. Replies
    9
    Views
    2,746

    VS 2013 Re: How to protect my shared data?

    https://msdn.microsoft.com/en-us/library/bb386386.aspx
  33. Replies
    9
    Views
    2,746

    VS 2013 Re: How to protect my shared data?

    Create a WCF service that runs using a service account. The service account would need access to your file system, but the individual user would not. Your application would then have to be built to...
  34. Re: Checking for existence of PrimaryKey?

    Try a search in your project for "dtComments =". Maybe your table is getting reinitialized else where.
  35. Re: Checking for existence of PrimaryKey?

    If table.PrimaryKey Is Nothing Then
    Trace.TraceInformation("No key found.")
    Else
    Trace.TraceInformation("Key found.")
    End If
  36. Re: RegEx to limit number not digits

    Here's an idea


    ' 1 digit or 1 digit with a decimal
    Dim one = "\d|\d\.\d"
    ' 2 digits or 2 digits with a decimal
    Dim two = "\d{2}|\d{2}\.\d"
    ...
  37. Replies
    10
    Views
    4,262

    Re: JS Evaluator?

    Don't use the normal command prompt, use the visual studio command prompt.
  38. Replies
    10
    Views
    4,262

    Re: JS Evaluator?

    Do not open the javascript file in the IDE. Open the visual studio command prompt and navigate to the folder containing you file. Then type in the command listed in step 2.
  39. Re: Copying "Excel like data" (cells) from clipboard to array and merging columns

    In that case I would use a data table, and the program would start looking like this


    Sub Main()

    Try
    If...
  40. Re: Copying "Excel like data" (cells) from clipboard to array and merging columns

    I would create a dictionary or data table to store the information. Can you be more specific what you plan to do with the data?
Results 1 to 40 of 499
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width