need to delete dataset

[jrjan1]

I'm a vb newbie and I successfully added a dataset to my program, then I closed it down. Next day, I didn't realize I had to actually go in and start it, so when nothing was working, I entered a new connection. Then realized my error. Now I have 2 datasets in the program, both connections are pointing to the same thing. How can I get rid of one of them.

Also, while I have your attention. I added a column to the one dataset called fullName. I want to concatenate first name and last name together to fill this field. The book says go to the Expression property and add lastName+', '+firstName. That sounds easy enough, except the fields in this database seem to be Last Name and First Name. I've never worked with any database that allows spaces between words on a column. Is that allowed in VB? How can I fix that? I keep getting the error: Syntax error: Missing operand after 'name' operator.

Any help would be greatly appreciated.

[Killer42]

I'm a vb newbie and I successfully added a dataset to my program, then I closed it down. Next day, I didn't realize I had to actually go in and start it, so when nothing was working, I entered a new connection. Then realized my error. Now I have 2 datasets in the program, both connections are pointing to the same thing. How can I get rid of one of them.

Also, while I have your attention. I added a column to the one dataset called fullName. I want to concatenate first name and last name together to fill this field. The book says go to the Expression property and add lastName+', '+firstName. That sounds easy enough, except the fields in this database seem to be Last Name and First Name. I've never worked with any database that allows spaces between words on a column. Is that allowed in VB? How can I fix that? I keep getting the error: Syntax error: Missing operand after 'name' operator.

I can't help with the first problem, but the second one sounds as though (if it's an MS Access database) you probably need to put square brackets around the field names. For example...
[Last Name]+', '+[First Name]