Dim getFieldNumbers As String = "SELECT fieldInfoID FROM fieldInformation FOR XML AUTO, XMLDATA"

Its a simple SELECT statement that formats the results in XML, I can't remember exactly what it is but I tested it on the database without the program - and it works just fine - when I get back to...

I am getting information from a database and reading it into an xml file - I've tested the SQL and it works just fine on the database I am using - but it won't return anything once I've got it and am...

I have no problem getting it there in the first place - my problem lies in the fact that I cannot get it to update - I have this code:


Private Sub reloadFieldNames(ByVal tableName)

...

I think I will create another data table in the database for the field information, thank you

I am using MS Visual Studio 2005 - btw

I've been looking for answers to this problem for awhile, and none of what I find seems to work. I have a program that creates a database, and a form based on that database, where the form fields...

Im not sure about this, but I think the "Runsheet Info" should be the table name that you are pulling from. According to your SQL the table is "Sheet1". Now, again I'm not sure about this, but it...

I am trying to insert tables into a database that I created at runtime, I am using MS SQL Server Express, and I have tested this query and it works, in the sense that a table is created. However the...

The Title says it all - I don't really need the exact code, but a point in the right direction would be appreciated.

using i, as you go through the loop you increment i, (0, 1, 2, 3, etc...) and that will increment the row that you are on. If you want a specific text then using the if statement you check to see...

You could iterate through the list box items in a for loop, keep a variable that changes by one each time (usually i) and use lst.Reorder.RemoveItem(i), replace i with whatever you use, and if you...

Goodness, This was a simple fix, something that occurs when I stare at code to long - I miss the obvious. I was only declaring the group box at the beginning and therefore using the same one every...

I am writing a program that will take input from the user in the form of a tree-view and create a form and a database based on the tree-view. I have everything working except the group-box control...

I have a program that creates a SQL statement based upon a treeview list that the user makes. The SQL statement looks like this:

CREATE TABLE Test ( Test ID PRIMARY KEY, Check1 CHAR(255), Check2...

I solved it myself, and since this happens to me often, I have stopped posting how I did it..

I am trying to add child nodes to a Treeview list, I have the parent node and this is the code I have to add the child node:


parentNode = New TreeNode()
parentNode.Text =...

I have tried that before but this is my problem with that:

http://www.daniweb.com/forums/thread99598.html

So I was looking to see if there was another way -- I have had this problem for a long...

I am writing a program in VB 2005 Express and I am using SQL to insert, delete, etc. I was curious if there was a SQL statement that would allow me to backup the database in Access - I have tried the...

Without knowing which error you are getting it is hard to tell what to say, something to check though would be to make sure that you have the same format of date in your database as you are passing...

This should help you out..

http://msdn2.microsoft.com/en-us/library/system.windows.forms.datagridview.columnheadersdefaultcellstyle.aspx

I believe you will want the code example second down (VB...

Instead of nesting the queries I pulled them apart and set the Select statement to a variable and then called my sql for the insert statement. If anyone has any better ideas just let me know I am...

First I will show you my sql, just in case it is some obvious syntax error on my part:


"INSERT INTO tblResults(status, enthusiasm, communication, knowledge, interaction,
...

oops - double post, sorry

I figured it out, apparently I have been looking at it for to long, SQL statements that you want to compare and are Integers do not have quotes around them. So i checked the type in an if statement...

i have this code to check and make sure that I wont be inserting duplicate records into my table. i take whatever is in the dr variable and if it is 0 then I go ahead, if not I don't do anything with...

Hi, I have two things that if I can do one I won't need to do the other, so whichever is easiest you guys answer me either way. What I am trying to do is get text from an email and download it into...

In order to interface with excel you have to make the reference to it, go to Project -> Add Reference -> under the COM tab select Microsoft Excel 11.0 Object Library (could be a different number...

I have looked quite a bit for this so if anyone could help that would be appreciated.

What I want to do is to access a Microsoft Outlook Web email account, I have the server name, port, there is...

hkdani - the only potential problem I can see with that is my database is in a different folder than what app.path return, the folders that each are in are in the same location, also I can't really...

The DB is installed to an alternate folder than the application directory for example:

Directory
Folder 1 = What app.path returns
Folder 2 = Where the database is at

All of the...

That works when I debug. However when I publish it and try to work on it as an application then i get an error message - it can't find the file. I looked and figured out it was in a different folder...

If(System.IO.File.Exists(path As String) = true){
MsgBox( message As String )
}else{
FileCopy(Source As String, Destination As String)
}

That worked well, thanks! I don't know why I didn't see that before. (I'm not being sarcastic if it sounds that way... seriously)

If someone could tell me if there is a function or method, or some way of finding the directory that the VB project loads to when it is installed on other computers that would be great. What I want...

This is what I did to backup my DB whenever I had to - problem is I'm not sure how to find the file to restore it.


Public Sub backupDB()

Dim backupName As String
Dim DBName...

Perhaps I didn't explain well enough. I need to know how to use relative paths that will work from within the program because apparently if I try to start from outside it cannot find the path (and...

I am currently using a database within my program and I have no problem backing it up or restoring it when i am simply debugging. However if it is published and downloaded it cannot find the path...

you will need a textbox, in your form, and set the OutlookMail.To = to the textbox name and put a .text after it.

OutlookMail.To = textboxname.text

The button changes an ugly peach color, which doesn't go well with a green theme, when they are clicked. I can't seem to find where to change this color. Any help is appreciated!