CharlieMay's Profile User Rating: *****

Reputation: 1533 Grandmaster
Group:
Expert w/DIC++
Active Posts:
4,913 (2.95 per day)
Joined:
25-September 09
Profile Views:
57,915
Last Active:
User is offline Today, 06:32 PM
Currently:
Offline

Previous Fields

Country:
US
OS Preference:
Windows
Favorite Browser:
FireFox
Favorite Processor:
Intel
Favorite Gaming Platform:
PC
Your Car:
Toyota
Dream Kudos:
25
Expert In:
VB.NET

Latest Visitors

Icon   CharlieMay has not set their status

Posts I've Made

  1. In Topic: How to get data or parse from XML file

    Posted 16 Apr 2014

    Have you though about taking this information and putting it into a database where you can then use your SQL skills to link and gather the information?

    Using your code and a datatable, I was able to quickly fill a datatable with

    TYPE   CoordX    CoordY
    VALLEY  C13       C5
    RIDGE   C5        C9
    

    etc...
    Just by changing the attributes I was looking for and adding a datarow.

    Just thinking that if you broke down each root (FACES, LINES, POINTS) into tables you would be able to get to the information in a more familiar format.

    Even pretty sure you could create a dataset and use the ReadXML method to put this information into a datatable

    ie,

    Dim DS as new Dataset
    ds.ReadXML("C:\YourFacesFile.xml")
    DataGridView1.DataSource = ds.Tables(0)
    


    Should populate a datagridview with a Table Layout of the information that the xml document contains.
  2. In Topic: How to get data or parse from XML file

    Posted 16 Apr 2014

    So you've learned that you can specify an attribute and get its value from your first example. So using that logic, what would you attempt in order to get the L1 path and type? Because once you get that, then from the path, you can get each value using the String.Split method with a comma delimiter so that you can then find the information you need from the two points that "path" gives you.

    What have you attempted to get this information?
  3. In Topic: How to get data or parse from XML file

    Posted 16 Apr 2014

    basically the same way you're concatenating them to that string with line breaks.

    Instead of txt being a string make it an integer

    Inside the for loop you can accumulate each value using += instead of the &= as you used with string concatenation while parsing the value to integer.

    assume the following data (ignoring the fact that this isn't actually xml and would still require your innertext values)
    "1"
    "2"
    "5"
    Dim total as integer
    For each i as xmlnode in mydata.nodes
      total+= integer.parse(i.Attributes("size").InnerXML)
    Next
    
    

    'Display Total which should show 8

    Edit: Fixed attribute as I had .InnerText instead of the Attributes value
  4. In Topic: Get a single cel value from excel into a textbox vb.net

    Posted 16 Apr 2014

    hmmm, I can't reproduce your problem.
    Even if I open excel first and then run that code, it still pulls in the values from excel.
    I even opened excel, ran the code, the textbox updates. Went back to the still opened excel spreadsheet, change the value and clicked save, went back to the still running application and clicked the button and the textboxes updated from the new saved version.

    If you had a crash early on during testing, then it may not have properly closed excel at some point. Go into your task manager and end task on all occurrences of excel.exe that appear, perhaps there is more than one. Also, I'm using Office 2007 and referencing Microsoft.Office.Interop.Excel Version 14.0.0.0

    Otherwise, explain the steps your are performing, maybe it will bring something to light.
  5. In Topic: Get a single cel value from excel into a textbox vb.net

    Posted 16 Apr 2014

    Kind of unclear on what you have going on. But I'll take a stab at it.

    The objects you are using can become a pain to dispose of using the methods you have. This in turn, leaves excel in an open state even though the window isn't appearing on your desktop. Then you have the problem of excel locking the workbook because your app didn't dispose of it properly.

    One method I've used in the past was to create the following sub:
        Private Sub releaseObject(ByVal obj As Object)
            Try
                System.Runtime.InteropServices.Marshal.FinalReleaseComObject(obj)
                obj = Nothing
            Catch ex As Exception
                obj = Nothing
            Finally
                GC.Collect()
            End Try
        End Sub
    


    Then after your APP.Quit line place the following
    ReleaseObject(APP)
    ReleaseObject(worksheet)
    ReleaseObject(workbook)
    


    But if this isn't your issue and your issue is that you are trying to use the worksheet from your application AND open the worksheet in Excel and manipulate it at the same time your app is using it, I don't think you're going to be allowed to do that. Just like if two people open the worksheet from a network share, one will be prompted to open in read-only mode.

    EDIT: Forgot to mention. In your future posts, please wrap your code segments in code blocks. This can be done by hilighting the code and clicking the code button on the toobar. You won't be able to edit your current post as you have not posted enough to get that feature but please try to do so in future posts.

My Information

Member Title:
This space intentionally left blank
Age:
46 years old
Birthday:
October 27, 1967
Gender:
Location:
Indiana
Years Programming:
25
Programming Languages:
VB, VB.NET, C#

Contact Information

E-mail:
Private
Website URL:
Website URL  http://

Comments

  • (3 Pages)
  • +
  • 1
  • 2
  • 3
  1. Photo

    orangebanana Icon

    03 Dec 2013 - 19:57
    thank you very much :)
  2. Photo

    vks.gautam1 Icon

    11 May 2013 - 06:53
    http://www.dreamincode.net/forums/topic/320780-what-is-basic-plan-you-make-before-starting-up-in-any-big-project/page__p__1849774__fromsearch__1&#entry1849774
  3. Photo

    CharlieMay Icon

    06 May 2013 - 14:10
    OK, up at the top of this page is the "About Me" tab where my signature is: in there is a link to a very helpful set of videos that should help you with what you want. Start at the beginning video and follow along.
  4. Photo

    pavanvadrevu Icon

    03 May 2013 - 08:53
    i want to learn complete vb.net from basics sir
  5. Photo

    nK0de Icon

    01 Feb 2013 - 10:18
    Hey Charlie! :) How's it going over there?
  6. Photo

    beginner_emman Icon

    30 Nov 2012 - 09:05
    i agree, you should teach a programming..thanks for your help..
  7. Photo

    CharlieMay Icon

    22 Oct 2012 - 18:30
    Wow! thanks everyone. I apparently need to check this area more often ;)
  8. Photo

    Wizmeister Icon

    18 Oct 2012 - 17:00
    You are awesome man. You should teach a class on programming.
  9. Photo

    wanabavbcoder Icon

    09 Oct 2012 - 15:38
    hi charlieMay, Thank you so much. It has really helped. I wish I had the knowledge you had.
  10. Photo

    wanabavbcoder Icon

    09 Oct 2012 - 00:48
    hi charlieMay, Ive posted a question that seems to have stumped google. Maybe you might be able to help
  11. Photo

    wanabavbcoder Icon

    08 Oct 2012 - 15:22
    Sorry to bug your'll again but another error appeared:
    An unhandled exception of type 'System.Reflection.AmbiguousMatchException' occurred in microsoft.visualbasic.dll
    Additional information: No accessible overloaded 'MessageBox.Show' is most specific for these arguments:
    Public Function Show ( ByVal text As String, ByVal caption As String ) As Sy...
  12. Photo

    wanabavbcoder Icon

    08 Oct 2012 - 13:36
    thank you so much for your prompt reply. will it be possible for you to email me? my email is yuvashsg@gmail.com
  13. Photo

    czarmaiyne Icon

    04 Oct 2012 - 09:47
    hey charlie, been reading some stuff at the lounge.. gaaawwd! this site is simply amazing. have to explore more!
    thank you for guiding! :]
  14. Photo

    czarmaiyne Icon

    04 Oct 2012 - 08:37
    thank you for your words charlie! :)
  15. Photo

    DimitriV Icon

    09 May 2012 - 03:57
    Ow! Charlie bit my finger!
  • (3 Pages)
  • +
  • 1
  • 2
  • 3