Search results

  1. L

    Remote database access

    Connection I replaced the server 'Localhost' with the IP address of the computer that stores the database. How do you connect the database to the ftp? I simply have the database on the ftp site, why is this not enough? with replacing localhost with the IP address I currently get the error...
  2. L

    Remote database access

    Hi all, I have a mysql database stored in an FTP site. Currently I am able to connect to this database bacause it is on my pc and I have a connection string hardcoded in my code in vb.net, that looks like this: Dim DBname As New OdbcConnection("DRIVER={MySQL ODBC 3.51 Driver};" &...
  3. L

    moving parts of a treeview around

    I have a mysql table called term in which all the term names have been developed as treenodes on the interface. I now have a term2term table that tells the relationship between each of the nodes on the interface I just created. What I need to do, is a) to say if something in the treeview...
  4. L

    Hyperlink using vb.net

    weblink I changed, the child to childadapter. The code is compiling and the treenodes at the grandparent, parent and child level are opening fine. The only problem is that the weblinks are not opening. I think there is a problme at the highlighted line below. If I hardcode a weblink to open...
  5. L

    Hyperlink using vb.net

    I see! Ok, the primary key error has been fixed, but now I vannot compile the code because, I had declared child as a new datatable and also as a new odbcadapter and I need both. The table in my database is called child so I guess at least i am changing the primary key of the correct table...
  6. L

    Hyperlink using vb.net

    added primary key but still missing I did try this way, but I had the error (highlighted in bold in the code): An unhandled exception of type 'System.Data.MissingPrimaryKeyException' occurred in system.data.dll Additional information: Table doesn't have a primary key. I thought I made names...
  7. L

    Hyperlink using vb.net

    I think error is minor Thankyou for that, it was very helpful. I have tried to do as best what you said....I have my code below. I have within vb.net set the friendly names ("names") as a primarykey, although in my real mysql schema, the "id" is the primary key, if i type "describe table...
  8. L

    Hyperlink using vb.net

    code Thanks again, I understand the logic, but I am stuck with the code. Can I explain the mysql structure to you a bit more. My table that I use to display the "friendly" names is in column 2, after the primary id column. The hyperlink addresses are stored in column 3. The treeview...
  9. L

    Hyperlink using vb.net

    thankyou Thankyou, thats been a great help. I have got each node to go to the same weblink as follows: Private Sub TreeView1_AfterSelect(ByVal sender As System.Object, ByVal e As System.Windows.Forms.TreeViewEventArgs) Handles TreeView1.AfterSelect ' Determine by checking the Node property...
  10. L

    Hyperlink using vb.net

    I have data from a mysql database being displayed in a treeview structure using vb.net. The last childnode that is coded for needs to be a huperlink to the actual site that the hyperlink represents. Please please please does anyone know the code to do this, as I dont have a clue and have been...
  11. L

    split method

    example text file: abc def hij klm The following code puts the data into an arraylist called a and prints: hij klm I only want abc and hij to be in array a at position 0 and 1. I want def and klm to be in array to. Please someone tell me how to do this and how to...
  12. L

    split method

    i have: so the new is there Dim reader As New IO.StreamReader("C:\testing2.txt") Dim temparray() As Array Dim a As New ArrayList While reader.Peek > -1 temparray(0) = reader.ReadLine.Split(ChrW(9)) 'move data into an array a.Add(temparray(0))
  13. L

    split method

    the last problem was solved. The error now reading is : object reference not set to an instance of an object :-(
  14. L

    split method

    also i get the error at the line: temparray(0) = reader.ReadLine.Split(ChrW(9)) saying : Value of type '1-dimensional array of String' cannot be converted to 'String'. help!
  15. L

    split method

    can i ask what what is readre in the code please?
  16. L

    split method

    also, i have 4 columns of about 2000 rows in my text file that i need to split into separate arrays!
  17. L

    split method

    thats great, but can you give me the whole code as im totally new to VB.net :-(
  18. L

    split method

    does anyone know how to split a tabbed delimited text file and read each column into a different dynamic array? The first two columns consist of strings and the last two columns are doubles. :-)
  19. L

    maths function

    Does anyone know the code in vb.net for doing a simple division? I want to be able to divide all the contents (double numbers) of an array by the contents of another array and display them on the gui. Thanks!
  20. L

    arrays

    Can someone please tell me how to read in a file and save it to a dynamic array at the same time? I have the code to read a file and display it on screen, I just need the code to save the contents to an array at the same time. Its a one dimensional dynamic array. This is the code I have so far...
Top Bottom