dcsimg

Search:

Type: Posts; User: dethredic

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Replies
    1
    Views
    517

    Re: large chunks of text in a rich text box

    anyone?
  2. Replies
    1
    Views
    517

    large chunks of text in a rich text box

    I have ~ 1 page how to that is currently in a text file which I want to add to a richtext box.

    I am just wondering if there is some way I can just copy/paste it so it keeps its formatting etc.
  3. Replies
    9
    Views
    806

    Re: Edit Database Entry

    My ninja edit was a little slow. Anyways I figured it out:


    ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
    ...
  4. Replies
    9
    Views
    806

    Re: Edit Database Entry

    Sorry, I should have given you my actual code, not just something similar.


    For i = 0 To (ListView1.CheckedItems.Count - 1)
    description =...
  5. Replies
    9
    Views
    806

    Re: Edit Database Entry

    Sorry, I am a little confused. I read the database like this:

    Using connection1 As New SqlConnection(Form1.ConnectionString)
    Using command1 As New SqlCommand("SELECT...
  6. Replies
    9
    Views
    806

    Re: Edit Database Entry

    Well I have something in my database like:


    JobNumber Hours Employee Exported
    1 3 Joe 0
    3 5 Bob 0


    I read that and and write it to a .csv...
  7. Replies
    0
    Views
    623

    [RESOLVED] Get ListView SubItem Values

    So I do something like this:


    ListView1.Columns.Add(" First Name", 150)
    ListView1.Columns.Add("Last Name", 150)
    ListView1.Columns.Add("Week Number", 50)
    ...
  8. Replies
    9
    Views
    806

    [RESOLVED] Edit Database Entry

    So when I export a database entry I want to change a value from either Null or 0 to 1. I have found tons of example on how to add entries, but I am not sure how to edit one.

    I currently I am...
  9. Replies
    2
    Views
    513

    Delete Table Rows From Database

    I have a table that has lots of entries. I want to delete all the entries.

    I tried this but it doesn't work.

    Using connection As New SqlConnection(Form1.ConnectionString)
    ...
  10. Re: Could not load file or assembly 'Microsoft.Office.Interop.Excel'

    Thanks, that seemed to work. My boss has the same Office products installed as me, so is there any other reason why it didn't work for him?
  11. Re: Could not load file or assembly 'Microsoft.Office.Interop.Excel'

    2008 express.
  12. Re: Could not load file or assembly 'Microsoft.Office.Interop.Excel'

    When I go projects-> add reference there is no "Microsoft Excel 11.0 Object Library" under the ".NET" tab.
  13. Re: Could not load file or assembly 'Microsoft.Office.Interop.Excel'

    I use the COM version cause thats what I read I needed and there is no .NET version.

    Not sure what you mean by installer or xcopy.
  14. Re: Could not load file or assembly 'Microsoft.Office.Interop.Excel'

    I don't know if it will be possible to install the PIA's on every computer running the app. I will need to include it with the app.


    If I look under my references, and choose properties for the...
  15. Re: Could not load file or assembly 'Microsoft.Office.Interop.Excel'

    There is no dll files there.
    edit: this is not a webserver, just a file server.
  16. Could not load file or assembly 'Microsoft.Office.Interop.Excel'

    I have a program that reads data from excel.

    I use:
    Imports Microsoft.Office.Interop
    as well as a Reference from the "COM" tab called "Microsoft Excel 11.0 Object Library"

    I built my program...
  17. Replies
    5
    Views
    596

    Encrypt a file then Read it

    So I have a connection string which is read from a basic text file. This string contains a password. Is there anyway to encrypt this text file so that anyone can't just open it up and read it. The...
  18. Replies
    17
    Views
    1,049

    Re: [RESOLVED] Excel won't quit

    I took it out and just use the value directly (without declaring it)

    ''''' Timesheet Table ''''''
    If nameexists = True Then

    Using connection...
  19. Replies
    17
    Views
    1,049

    Re: Excel won't quit

    Dim aWeekNumber As Int32 = WS.Range("I4").Value was the problem.

    Thanks so much.
  20. Replies
    17
    Views
    1,049

    Re: Excel won't quit

    Ok, I have done some rigorous testing and have some new info.

    If the database is empty then excel quits as expected.
    If the database is not empty then excel does not quit until the program exits....
  21. Re: Wait Until Form is Close Before Continuing

    sweet, thanks.
  22. [RESOLVED] Wait Until Form is Close Before Continuing

    So I have something like this:


    For Each Entry In CheckedListBox1.CheckedItems
    SheetName = Entry.ToString()
    Form2.Show()

    Next

    but I don't want to continue the loop until Form2...
  23. Replies
    17
    Views
    1,049

    Re: Excel won't quit

    Again this didn't work. I don't think it is a problem with how I am closing it (because it works other places), but something else must be the problem, or maybe the workbook itself because the close...
  24. Replies
    17
    Views
    1,049

    Re: Excel won't quit

    I did monitor the task manager. As soon as I hit my button an excel.exe appears. I then hit another button which opens up the same spread sheet and does similar stuff. Another excel.exe pops up, but...
  25. Replies
    17
    Views
    1,049

    Re: Excel won't quit

    any other ideas?
  26. Display Large Varying Table In a Windows Form

    I need to display 3 columns and a varying amount of rows (typically around 50) in a windows form, kinda like excel. What would be the best way of going about this? The data will likely be longer than...
  27. Replies
    17
    Views
    1,049

    Re: Excel won't quit

    That does not help either.

    I am starting to think I am closing it right, but there is something else that is causing it to stay open because it closes fine in another function.
  28. Replies
    17
    Views
    1,049

    Re: Excel won't quit

    If I add:

    WS.Close() above WB.Close() then I get a "MissingMemberException was unhanded"
  29. Replies
    17
    Views
    1,049

    Re: Excel won't quit

    Ok, I changed it to this:


    ' Close Excel
    WB.Close()
    Marshal.ReleaseComObject(WB)
    excelapp.Quit()
    'excelapp = Nothing
    ...
  30. Replies
    17
    Views
    1,049

    [RESOLVED] Excel won't quit

    So I have a little gui that will read a given spreadsheet and list all the "valid" sheets. This happens when a user presses a button.

    here is my code:


    Private Sub...
  31. VS 2008 Re: Get the Code that Makes the GUI

    Thanks guys, I just want to share the code with my friend, so I need to be able to copy it.
  32. VS 2008 [RESOLVED] Get the Code that Makes the GUI

    I just tried fooling around with a "windows forms" project, and I would like to see the code that creates the form. How would I go about looking at that?
    I can only edit the code that would occur...
  33. Replies
    12
    Views
    661

    Re: dealing with NullReferenceException

    Ok, it turns out the problem is merged cells. B4 was just a sneaky little bugger and was merged in a fashion which can only be described as "ninja like".

    I dunno if you guys know a work around for...
  34. Replies
    12
    Views
    661

    Re: dealing with NullReferenceException

    You code doesn't work, I get the same error.

    Also I don't think the range is off because the cell B4 is clearly there and says "Employee", and that is where the error occurs. If I comment out the...
  35. Replies
    17
    Views
    801

    Re: VB.net Code to coloured html?

    Maybe I should explain better. I pasted the code into word, then saved as a .htm file. This works fine, but it is super long and complex with tons of redundancy (to be expected from an auto generated...
  36. Replies
    12
    Views
    661

    Re: dealing with NullReferenceException

    @ techgnome the error comes on the if xxx cell = yyyy lines

    thanks to pradeep, megalith
  37. Replies
    17
    Views
    801

    Re: VB.net Code to coloured html?

    well that works great until I put it in <pre> tags. Ohh well.
  38. Replies
    12
    Views
    661

    dealing with NullReferenceException

    Basically I am checking several cells in different spreadsheets to see if they contain the correct value. On one sheet I get an error saying: "NullReferenceException was unhandled"

    I checked the...
  39. Replies
    17
    Views
    801

    Re: VB.net Code to coloured html?

    darn, thanks anyways.
  40. Re: Help with MS SQL Server Connection String

    great, thanks guys.
Results 1 to 40 of 58
Page 1 of 2 1 2



Featured


Click Here to Expand Forum to Full Width