Search:
Type: Posts; User: YourSurrogateGod
Search:
Search took 0.03 seconds.
-
Nevermind, I goofed one of the loops.
-
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...
-
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?
-
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...
-
I close it later on in the code.
-
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...
-
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) " & _...
-
Thanks stanav, that did the trick.
-
I'll look into that as a possible solution.
-
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...
-
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...
-
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.
-
Yeh, that seems to work. I'd love to be able to read out only specific records/rows inside that 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...
-
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?
-
Did the convert.tobyte and it still crashes.
-
-
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...
-
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.
-
Is that supposed to be the portion of the code that needs to find the sum?
-
My code caught an error saying that there was no value given for one or more parameters... weird...
-
Well, it doesn't seem to be doing jack since I don't see the start menu popping up.
-
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...
-
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.)
-
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.
-
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...
-
The cases don't matter in VB and if VS was that picky, it would have corrected the cases for me automatically.
-
Imports System.windows.forms
Module Module1
Sub Main()
SendKeys.send(&H5B)
End Sub
End Module
Error:
-
-
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?
-
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...
-
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?
-
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...
-
Never mind, I figured it out.
-
if data.Tables("ResolutionTable").Rows(iter).Item(1).ToString.CompareTo("0") Or _
data.Tables("ResolutionTable").Rows(iter).item(1).ToString.CompareTo("") Or _...
-
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...
-
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?
-
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...
-
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?
|
Click Here to Expand Forum to Full Width
|