oledbcommand syntax (Please help!)

ckjaime · 04-18-2007, 07:56 AM

I am trying to teach myself visual basic and am writing a prorgram that connects to an access database and reads in a table. The command that I am using to select the table is listed below.

MyCommand = New OleDbCommand("Select * from Table1", MyConnection)

My questions is whether or not I can use a variable as the table name instead of 'Table1'. I want the table which is read in to change depending on the value of a variable. Thanks in advance.

shuuhen · 04-18-2007, 01:34 PM

Well, the way things work in C# (similar to VB.NET, but it was introduced for .NET) is you can concatenate strings by using the '+' operator (no quotes). I'm not sure if it works the same in VB.NET (I assume that's the version of VB you're using), but you can try it out (I don't do VB, since I know C# and prefer C over that when possible).

So you can call your method, then concatenate the strings where the method arguement belongs.

Similar to how you do things:

CommandVar = New ObjectInitMethod("Common text " + variable, OtherArguement);

**Deckard** · 04-19-2007, 08:59 PM

VB uses & to concatenate, but shuuhen is right -- you can. You'd probably want something similar to:

Code:

Table = "Table1"
MyCommand = New OleDbCommand("Select * from " & Table, MyConnection)

ckjaime · 04-22-2007, 08:49 PM

Thanks for the help! Both of these options worked. I ended up going with

Code:

MyCommand = New OleDbCommand("Select * from " + Table, MyConnection)

04-18-2007, 07:56 AM	#1 (permalink)
ckjaime Registered User Join Date: Apr 2007 Posts: 2 OS: winxp	oledbcommand syntax (Please help!) I am trying to teach myself visual basic and am writing a prorgram that connects to an access database and reads in a table. The command that I am using to select the table is listed below. MyCommand = New OleDbCommand("Select * from Table1", MyConnection) My questions is whether or not I can use a variable as the table name instead of 'Table1'. I want the table which is read in to change depending on the value of a variable. Thanks in advance. Last edited by ckjaime; 04-18-2007 at 08:00 AM.

04-18-2007, 01:34 PM	#2 (permalink)
shuuhen Manager Join Date: Sep 2004 Location: Colorado Posts: 988 OS: Mac OS 9.1, Mac OS X 10.5.8, WinXP Pro, FreeBSD 6.0, Gentoo Linux My System	Re: oledbcommand syntax (Please help!) Well, the way things work in C# (similar to VB.NET, but it was introduced for .NET) is you can concatenate strings by using the '+' operator (no quotes). I'm not sure if it works the same in VB.NET (I assume that's the version of VB you're using), but you can try it out (I don't do VB, since I know C# and prefer C over that when possible). So you can call your method, then concatenate the strings where the method arguement belongs. Similar to how you do things: CommandVar = New ObjectInitMethod("Common text " + variable, OtherArguement); __________________ Has it been a few days since I replied to your thread? Don't panic! I'm a busy college student and may forget a post if I'm extra busy (or it might just take me a while to be able to do a decent reply). If you still need help and are awaiting my reply after a few days, PM me about it. When posting what errors you get, please give the full message. It makes helping you much easier.

04-19-2007, 08:59 PM	#3 (permalink)
Deckard Mentor, Analyst - Security Team Join Date: May 2006 Location: Oregon Posts: 2,503 OS: MacOS X, Debian, OpenBSD, Windows	Re: oledbcommand syntax (Please help!) VB uses & to concatenate, but shuuhen is right -- you can. You'd probably want something similar to: Code: Table = "Table1" MyCommand = New OleDbCommand("Select * from " & Table, MyConnection) __________________ The chance to begin again in a golden land of opportunity and adventure. Need HijackThis help? Please read MicroBell's Five Step Process before posting. Please donate and help keep this site free to all. UNITE/ASAP: Proud member since 2006

04-22-2007, 08:49 PM	#4 (permalink)
ckjaime Registered User Join Date: Apr 2007 Posts: 2 OS: winxp	Re: oledbcommand syntax (Please help!) Thanks for the help! Both of these options worked. I ended up going with Code: MyCommand = New OleDbCommand("Select * from " + Table, MyConnection)