C# Discussion Boards - CodeProject

Paul Brower6-Nov-09 2:27

6-Nov-09 2:27

I have the following lines of code (2.0 framework) that worked in Win XP, but doesn't work with Windows 7:

if (!Directory.Exists(@"c:\Program Files\Newsham\PigtrakDesktop\RAPI"))
{
Directory.CreateDirectory(@"c:\Program Files\Newsham\PigtrakDesktop\RAPI");
}

Here's the weird part: If I try to navigate to c:\Program Files\Newsham\PigtrakDesktop using the Windows 7 explorer, the RAPI directory is NOT there.

However, in my code, if tell it to list the files in the same directory, there ARE FILES THERE!

This is really killing me. Any thoughts?

Re: Windows 7 and Directory.Exists ???

Paul Brower6-Nov-09 3:18

Paul Brower

6-Nov-09 3:18

I can't explain WHY the **** this is like this, but I found my files. They are located at:

C:\Users\pbrower\AppData\Local\VirtualStore\Program Files\Newsham\PigtrakDesktop

What the hell?

Re: Windows 7 and Directory.Exists ???

Calla6-Nov-09 3:27

Calla

6-Nov-09 3:27

Maybe something to do with MS not being so keen on us writing (and adding directories) to the Program Files folder in Vista and Windows 7? Just a thought (on friday afternoon)... Smile | :)

Re: Windows 7 and Directory.Exists ???

Daniel Grunwald6-Nov-09 3:29

Daniel Grunwald

6-Nov-09 3:29

"C:\Program Files" is not writable for standard users (just as it was since Win2000 and earlier).
Starting with Vista, the default user account is a standard user; getting admin rights only when you explicitly run an app with them (UAC).

To allow old programs to continue to run, Windows will redirect writes to the "VirtualStore". This is done only with programs that are not marked as "UAC-compatible".

So you have to do two things:
1) to avoid confusion due to file system virtualization; mark your program as UAC-compatible by embedding an UAC manifest. VS2008 should do this automatically (see "Application Manifest" in the project options); for VS2005 it's a little bit more complicated: http://blogs.msdn.com/shawnfa/archive/2006/04/06/568563.aspx[^]

2) Don't write to Program Files.

Re: Windows 7 and Directory.Exists ???

#realJSOP8-Nov-09 2:01

#realJSOP

8-Nov-09 2:01

More specifically, don't write anywhere but the AppData folder.

.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001

C# "for example desktop icon"(object) drag and drop method

Renven6-Nov-09 1:38

Renven

6-Nov-09 1:38

Hi,

Lets supose i have C# application witch gets object position in desktop (for example "icon" or "shotcut") coordinates (x,y).
I need method whitch uses coordinates from application (x,y, and x_put, y_put) take object from one position and DRAG and DROP that objet to other position. Also it would be great if that methot can WORK FAST.

I appretiate your help,

Re: C# "for example desktop icon"(object) drag and drop method

Richard MacCutchan6-Nov-09 2:34

Richard MacCutchan

6-Nov-09 2:34

Lots of information here[^].

Telnet/pop3..........??

Hum Dum6-Nov-09 1:33

Hum Dum

6-Nov-09 1:33

I created an small pop3 application(with help of articles present here) to retrieve emails, its working for small emails. But when it comes to large emails say 5 MB+ it stuck.

Can't able to retrieve whole data from pop3 server.

I tried check thru telnet also, but it also got stuck in infinite loop, and continue to remian same.

Can any one plz help me, how to retrieve whole message from pop3 ?

So that i can strip whole message.

regards

SQL querying problem

Emmet_Brown6-Nov-09 0:52

Emmet_Brown

6-Nov-09 0:52

Hi!

I'm trying to check my database if an entry on a field is already exists in the DB.

My Sql command is this:

string Sqlcommand = "SELECT Name FROM Students WHERE Id LIKE '" + TextBox1 + "'";

and I'm executing this as follows

SqlCeCommand com = new SqlCeCommand(Sqlcommand, conn);
SqlCeDataAdapter da = new SqlCeDataAdapter(com);

after these, just to be sure, I want to check if the query returned some rows or not
what should I do?

note: I've tried these ->

DataSet s = new DataSet();
da.Fill(s);
if( s == null)
if( s.Tables.Count == 0)
if( da == null)

can anybody help? :/

Message Closed

6-Nov-09 1:09

stancrm

6-Nov-09 1:09

Message Closed

modified 23-Nov-14 7:19am.

Re: SQL querying problem

Emmet_Brown6-Nov-09 1:22

Emmet_Brown

6-Nov-09 1:22

Oh THANK YOU!

but now it started to give an error
da.Fill(s) says
SqlCeException was unhandled
There was an error parsing the query. [ Token line number = 1, Token line offset = 61, Token in error =)]

I don't know why, this line did not give an error just 5 minutes ago, I erased new codes and still it gives an error

what should I do? :/

Message Closed

6-Nov-09 1:33

stancrm

6-Nov-09 1:33

Message Closed

modified 23-Nov-14 7:19am.

Re: SQL querying problem

Emmet_Brown6-Nov-09 1:42

Emmet_Brown

6-Nov-09 1:42

well it seems like a bug, but this is a very simple action to encounter a bug, maybe I should ask in a seperate topic

thank you for your answers Big Grin | :-D

Re: SQL querying problem

Emmet_Brown6-Nov-09 1:52

Emmet_Brown

6-Nov-09 1:52

I found that I just made a stupid syntax error in my SQL command Big Grin | :-D

thank you, my problem is solved Big Grin | :-D

oh the code project, you're a saint

Re: SQL querying problem

sravsk15-Dec-09 21:12

sravsk

15-Dec-09 21:12

Hi
{
using (SqlCeConnection ceConn = new SqlCeConnection("Data Source=" + (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase)) + "\\Northwind.sdf; Persist Security Info=False"))
{

ceConn.Open();

SqlCeException was unhandled
There was an error parsing the query. [ Token line number = 1, Token line offset = 61, Token in error =)]

I don't know why, this line did not give an error just 5 minutes ago, I erased new codes and still it gives an error

what should I do?

sravanthi veerisetti

Re: SQL querying problem

Nicholas Butler6-Nov-09 2:00

Nicholas Butler

6-Nov-09 2:00

You should probably also read this:

SQL Injection Attacks and Some Tips on How to Prevent Them[^]

Nick

----------------------------------
Be excellent to each other Smile | :)

Re: SQL querying problem

Calla6-Nov-09 2:36

Calla

6-Nov-09 2:36

Maybe you're screwing up the SQL if you add '" + TextBox1 + "' instead of '" + TextBox1.Text + "'

Re: SQL querying problem

Emmet_Brown6-Nov-09 3:15

Emmet_Brown

6-Nov-09 3:15

Thank y'all Big Grin | :-D

Re: SQL querying problem

Md. Marufuzzaman6-Nov-09 7:09

Md. Marufuzzaman

6-Nov-09 7:09

Try the following......

Function:

<PRE>
string strSqlQuery= "SELECT Name FROM Students WHERE Id LIKE '" + TextBox1 + "%'";

object retValue;
            try
            {
                  ObjSqlCommand = new SqlCommand(strSqlQuery, ObjSqlConnection);
                  ObjSqlConnection.Open();
                  retValue = ObjSqlCommand.ExecuteScalar();

            }
            catch (Exception ex)
            {
                  return (object)ex.Message.ToString();
            }
            finally
            {
                  ObjSqlConnection.Close();
                  ObjSqlCommand = null;
                  ObjSqlConnection= null;
                  strSqlQuery = null;

            }
   return retValue;
</PRE>

Thanks
Md. Marufuzzaman

Don't forget to click [Vote] / [Good Answer] on the post(s) that helped you.

I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.

Transferring items from a listbox to a string variable [modified]

gamer11276-Nov-09 0:34

gamer1127

6-Nov-09 0:34

Hello. I'm having a little problem transferring all the items in the listbox to a string variable. All the items in the listbox are also string type so i don't have any problems about data types. I tried to use array of string type variable but when i transfer them using a for..loop statement it gets a run-time error that the index was out of bounds. How will I resolve that? How can i store all the items into a variable without selecting them? I used the listbox as a control for outputs.

this is the code:

for (int a = 0; a < lstBoxRequests.Items.Count; a++)
                {
                    string[] passedRequests = new string[a];

                    passedRequests[a] = Convert.ToString(lstBoxRequests.Items[a]);

                    MessageBox.Show(passedRequests[a]);
                }

modified on Friday, November 6, 2009 6:41 AM

Re: Transferring items from a listbox to a string variable

Covean6-Nov-09 1:03

Covean

6-Nov-09 1:03

Try this:

string[] passedRequests = new string[lstBoxRequests.Items.Count];
for (int a = 0; a < lstBoxRequests.Items.Count; a++)
                {
                    

                    passedRequests[a] = Convert.ToString(lstBoxRequests.Items[a]);

                    MessageBox.Show(passedRequests[a]);
                }

Greetings
Covean

Re: Transferring items from a listbox to a string variable

Eddy Vluggen6-Nov-09 1:14

Eddy Vluggen

6-Nov-09 1:14

How manu elements are there in your array? And how many elements would the loop go through?

If your array holds 10 items, then a for-next loop will go from either 1 to 10 or from 0 to 9. Your loop goes 11 times, starting at passedRequest[0] and moving on to passedRequst[10], generating an "index out of bounds". That means that the number between the [] is smaller or larger then the number of items in the array Smile | :)

for (int a = 0; a < lstBoxRequests.Items.Count -1; a++)

Next item is that you're reinitializing the array on each loop. That means that the entire Array is created anew, with a new maximum-upperbound of "a". You'd prolly want a maximum number in the array that corresponds to the number of items in the combobox. That would come to something like this;

int itemCount = lstBoxRequests.Items.Count -1;
string[] passedRequests = new string[itemCount];
for (int a = 0; a < itemCount; a++)
{
    passedRequests[a] = Convert.ToString(lstBoxRequests.Items[a]);

There are easier ways to enumerate through the items, but I'll leave that to the next poster Smile | :)

I are Troll Suspicious | :suss:

Re: Transferring items from a listbox to a string variable

V.6-Nov-09 1:27

6-Nov-09 1:27

I think you'll miss one item with this code.

Eddy Vluggen wrote:
for (int a = 0; a < lstBoxRequests.Items.Count -1; a++)

or do this:

for (int a = 0; a <= lstBoxRequests.Items.Count -1; a++)

or this:

for (int a = 0; a < lstBoxRequests.Items.Count; a++)

V.

Stop smoking so you can: Enjoy longer the money you save.
Moviereview Archive

Re: Transferring items from a listbox to a string variable

Covean6-Nov-09 1:29

Covean

6-Nov-09 1:29

for (int a = 0; a < lstBoxRequests.Items.Count; a++)

Is right, your loop:

for (int a = 0; a < lstBoxRequests.Items.Count - 1; a++)

is wrong it leaves one item alone!

General:

for(int loop=0; loop < count; loop++) or for(int loop=0; loop <= count -1; loop++)!

His problem was the following:

for (int a = 0; a < lstBoxRequests.Items.Count; a++)
                {
                    string[] passedRequests = new string[a];

                    passedRequests[a] = Convert.ToString(lstBoxRequests.Items[a]);   <---- this causes the out of array, because passedRequests.length = a but passedRequests[a] is wrong !!!

                    MessageBox.Show(passedRequests[a]);
                }

Edit: Second problem was the creation of the string array in the loop.

Greetings
Covean

Re: Transferring items from a listbox to a string variable

Eddy Vluggen6-Nov-09 2:12

Eddy Vluggen

6-Nov-09 2:12

Covean wrote:
or (int a = 0; a < lstBoxRequests.Items.Count - 1; a++)
is wrong it leaves one item alone!

You're right, I was wrong. I've been looking at these too much;

for(int x = 0; x <= bla.Count - 1; x++)

Notice that the check has an equals-sign. The current project that I'm working has both styles mixed throughout the code. In VB6 Smile | :)

I are Troll Suspicious | :suss:

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.