Search:

Type: Posts; User: YourSurrogateGod

Page 1 of 2 1 2

Search: Search took 0.03 seconds.

  1. Re: [02/03] Program hangs for some unexplained reason.

    Nevermind, I goofed one of the loops.
  2. [RESOLVED] [02/03] Program hangs for some unexplained reason.

    This usually happens when I try to connect to a MySQL database, the title bar has the string (Not Responding) displayed in the task manager when I open it and the the text in the StatusBar doesn't...
  3. Replies
    5
    Views
    1,033

    The 'resolve' feature.

    I really like it. Just curious, where did you guys get it? I've heard that the latest version of vBulletin doesn't have it. Did you guys use a plugin of some sort?
  4. [02/03] Unable to read dates from MySQL.

    I get this error whenever I try to read dates from a MySQL database.

    Here is my code.
    Dim myCommand As New MySqlCommand
    Dim myAdapter As New MySqlDataAdapter
    Dim myData As New DataTable
    Dim...
  5. Re: [02/03] Can't put together two strings, runtime error.

    I close it later on in the code.
  6. Re: [02/03] Can't put together two strings, runtime error.

    There is such table (I'm looking at the Access DB right now) and the dataset does have values in it (I checked beforehand by taking the length of it, which was greater than 0.)

    The weird thing is...
  7. [RESOLVED] [02/03] Can't put together two strings, runtime error.

    This is the offending piece of code, the boldened part is where the error occurs.
    Dim sqlQuery As String = "INSERT INTO longdescs (bug_id, " & _
    "bug_when, " & _
    "thetext, " & _
    "who) " & _...
  8. Re: [02/03] Runtime error, object reference not set to an instance of an object.

    Thanks stanav, that did the trick.
  9. Re: [02/03] Runtime error, object reference not set to an instance of an object.

    I'll look into that as a possible solution.
  10. Re: [02/03] Runtime error, object reference not set to an instance of an object.

    Option Strict On
    Option Explicit On

    Imports MySql.Data.MySqlClient
    Imports System.Data

    Public Class Form1
    Inherits System.Windows.Forms.Form

    Private Sub retrieve_Click(ByVal sender...
  11. [RESOLVED] [02/03] Runtime error, object reference not set to an instance of an object.

    I get that error when I ran the below and caught an error.
    Dim value As String
    value &= myData.DataSet.Tables("table1").Rows(0).Item(0).ToString()
    myData is a DataTable object. Anyone know why...
  12. Re: [02/03] Reading from an Excel file.

    I did manage to work around. I took all of the data out of the Excel file and stored it in a datagrid object in memory and then simply accessed that. It works, but it's an ugly solution.
  13. Re: [02/03] Reading from an Excel file.

    Yeh, that seems to work. I'd love to be able to read out only specific records/rows inside that excel file.
  14. Re: [02/03] Reading from an Excel file.

    I just did, no go.
  15. Re: [02/03] Reading from an Excel file.

    Here's the entire method that is responsible for working with the Excel file.
    Private Sub productComponentAssignedTo(ByRef sqlQuery As String, ByVal internalSequenceNumber As String)
    Dim excelConn...
  16. Replies
    12
    Views
    1,122

    Re: [2005]

    Do it the exact same way that you did the first query, another connection object and the like.

    Well that just sucks. Did you use a debugger in order to locate the problem?
  17. Re: Call winxp start button menu from vb.net

    Did the convert.tobyte and it still crashes.
  18. Re: Call winxp start button menu from vb.net

    2003
    .............
  19. Replies
    12
    Views
    1,122

    Re: [2005]

    Well, it's kind of unclear if you ask me. I'd recommend scrapping it and simply executing a completely different query (and for each time that you need to find a sum, execute a different query), it...
  20. Re: Call winxp start button menu from vb.net

    Didn't work. First it gave me an error saying that you can't convert from a key object to a byte because option strict was on. When I turned that off and re-ran the program, it crashed.
  21. Replies
    12
    Views
    1,122

    Re: [2005]

    Is that supposed to be the portion of the code that needs to find the sum?
  22. Re: [02/03] Reading from an Excel file.

    My code caught an error saying that there was no value given for one or more parameters... weird...
  23. Re: Call winxp start button menu from vb.net

    Well, it doesn't seem to be doing jack since I don't see the start menu popping up.
  24. Replies
    12
    Views
    1,122

    Re: [2005]

    What do you mean? You query the DB once in order to get the results and print them out in the DataGrid (or whatever.) Then you query the DB again in order to get the sum (repeat this step depending...
  25. Re: Call winxp start button menu from vb.net

    Would it matter if I'm running Win 2000? It doesn't seem to be working, I click the button and nothing happens (I created a windows forms app.)
  26. Replies
    12
    Views
    1,122

    Re: [2005]

    Access has a sum function. Use that in a query and get your result that way, it's much more efficient than having to go through the queried results via a for-loop and add all of that stuff up.
  27. Replies
    12
    Views
    1,122

    Re: [2005]

    Why not just have a separate call that executes a query and have the DB do the summation for you?

    MySQL has a feature like that... but then, since you haven't given the name of the DB that you're...
  28. Re: Call winxp start button menu from vb.net

    The cases don't matter in VB and if VS was that picky, it would have corrected the cases for me automatically.
  29. Re: Call winxp start button menu from vb.net

    Imports System.windows.forms

    Module Module1
    Sub Main()
    SendKeys.send(&H5B)
    End Sub
    End Module
    Error:
  30. Re: Call winxp start button menu from vb.net

    I did that, no go.
  31. Re: Call winxp start button menu from vb.net

    Weird, when I tried to insert "Imports System.Windows.Forms" into the top of my source code, that line was underlined, meaning that that was a syntax error. Why is that?
  32. Re: [02/03] Reading from an Excel file.

    Thanks for the code penny. I managed to find this after posting my last post in this thread (which seems to be fine.) Now I have another problem. I'd like be able to do a select where I can easily...
  33. Re: [02/03] Reading from an Excel file.

    I'm at work right now and can't check my e-mail. Would it be possible for you to post only the parts that are relevant to opening, reading/manipulating and closing the excel file?
  34. [RESOLVED] [02/03] Reading from an Excel file.

    Anyone know of a way to do this? I've looked online but couldn't find a good example, I'm not even sure as to where to start off.

    Any good tutorials or code samples in order to get me going would...
  35. Re: [02/03] Can't use 'Or' in an if statement.

    Never mind, I figured it out.
  36. [RESOLVED] [02/03] Can't use 'Or' in an if statement.

    if data.Tables("ResolutionTable").Rows(iter).Item(1).ToString.CompareTo("0") Or _
    data.Tables("ResolutionTable").Rows(iter).item(1).ToString.CompareTo("") Or _...
  37. Replies
    1
    Views
    656

    Making a graph...

    Ok, one of my projects involves me making a graph in order to display temperature from a sensor over a period of time. Personally, I don't even know where to begin. At the moment I'm concerned about...
  38. Replies
    1
    Views
    500

    Get all of the colors...

    I would like to populate a drop-down list with all of the Public Properties of the Color class (the colors themselves that is.) I was wondering how to do that. Does anyone know?
  39. Can't change the panel's color [solved]...

    What I'm trying to do is create a program that will be able to change the color of Panel1 with the slider bars. But when I tried the below, the color of the panel did not change and I don't...
  40. Re: Threads, using , program cras

    So I take it that in a VB .NET specific forum, for a site dedicated exclusively to Visual Basic, no one knows why the heck when I call a setter method, the program crashes?
Results 1 to 40 of 64
Page 1 of 2 1 2



Click Here to Expand Forum to Full Width