Visual Basic

26-Oct-09 2:02

Hello,

Can someone tell me how i can tell my exe to look into sub folders if the dll being referenced isn't in the folder the exe is. I found the server config code but it doesn't work in the exe config.

Thank you.
Nathan

'Never argue with an idiot; they'll drag you down to their level and beat you with experience.' ~ anonymous

'Life's real failure is when you do not realize how close you were to success when you gave up.' ~ anonymous

sri_009926-Oct-09 2:48

sri_0099

26-Oct-09 2:48

Nathan,

Use System.AppDomain.CurrentDomain.BaseDirectory to get root directory where EXE is. from rootdirectory you can fetch directories inside root directory.

Regards,
Sr

nlarson1126-Oct-09 4:05

26-Oct-09 4:05

Thanks Sr...that doesn't work with references

I have several apps that reference dlls that have controls in them. Typically those same dlls would be in the same folder as the exe. Because of "cluttering up" the main folder i wanted to move the dlls and their supporting files into a sub folder. I want the exe to look local and then go through sub folder(s) to look there as well before it comes back and tells me "file not found". There is a config setting that you can give to make it do that on the server. I just need to know what is the config setting to do that for the exe.

Thank you...

DaveAuld26-Oct-09 5:29

DaveAuld

26-Oct-09 5:29

I amnot familiar with this type of operations but looking at the MSDN documentation;

AppDomainSetup class contains a method PrivateBinPath which states;
Gets or sets the list of directories under the application base directory that are probed for private assemblies.

Don't know if that will help or not!

Dave
Who am I?:
Web|Facebook|Twitter|LinkedIn|Bebo

nlarson1126-Oct-09 7:40

26-Oct-09 7:40

Thank you Dave...your privatepath gave me the right thing to lookup.

If you add this to your exe config, it will look in sub folders as well as the base directory for files that you are referencing.

In the example below, I want the exe to also prob sub folder controls.

<configuration>
   <runtime>
      <asemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
         <probing privatePath="controls"/>
      </assemblyBinding>
   </runtime>
.
.
.
</configuration>

exception

santhosh-padamatinti26-Oct-09 1:23

santhosh-padamatinti

26-Oct-09 1:23

hi
I established a data base connection, where I used a query

sql_querry="SELECT name FROM sample_table"

is displaying all values perfectly, now I want to use where condition

sql_querry="SELECT name FROM sample_table WHERE"+"(Designation=SE)"<br />

But it is throwing an exception.

I think this one I am getting because I am not giving query perfectly.

Please tell me how to write this query.

Thanx in advance...........

sampath-padamatinti

nlarson1126-Oct-09 2:00

26-Oct-09 2:00

sql_querry="SELECT name FROM sample_table WHERE Designation='SE'"

Henry Minute26-Oct-09 4:35

Henry Minute

26-Oct-09 4:35

You should not use inline queries, they are dangerous and can lead to SQL Injection attacks.

Before you get a bad habit ingrained into your coding style learn how to use parameterised queries (or parameterized queries, spelling differs). There is a reasonable tutorial here[^] in PDF format, although it deals with Access it covers how to convert an inline query into a parameterised one, and the principles are the same. If you don't like that one then there are plenty more examples, just google for the phrase. Smile | :)

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

Dave Kreskowiak26-Oct-09 10:07

Dave Kreskowiak

26-Oct-09 10:07

sampath-padamatinti wrote:
sql_querry="SELECT name FROM sample_table WHERE"+"(Designation=SE)"

On tpo of what everyone else said, if you look at the string you built closely, you'll see there is no space between "WHERE" and "(Designation=SE)". The resulting SQL looks like this (which is not a valid statement!):

SELECT name FROM sample_table WHERE(Designation=SE)

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Shameel27-Oct-09 0:48

Shameel

27-Oct-09 0:48

Dave, SQL Server parses and executes this statement. But if there was no '(' after the where clause, things would be different Smile | :)