C#

Re: inserting data SQLCommand C# - am I missing something?

20-Jun-08 5:11

You forgot to insert command.Transaction = transaction before executing the query.

modified 12-Sep-18 21:01pm.

leppie20-Jun-08 4:29

leppie

20-Jun-08 4:29

So do you get an error?

Are you attaching the correct database file when you look for the data?

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

Re: inserting data SQLCommand C# - am I missing something?

laziale20-Jun-08 4:31

laziale

20-Jun-08 4:31

I do not get any error, I am going through each line of the code, everything seems OK, the right DB is attached and at the end I do not get anything in the DB, is the ExecuteNonQuery method declared ok?

Re: inserting data SQLCommand C# - am I missing something?

User 665820-Jun-08 4:42

Re: inserting data SQLCommand C# - am I missing something?

20-Jun-08 4:42

By the way, your code is also vulnerable to SQL injections[^], you should fix that Smile | :)

regards

modified 12-Sep-18 21:01pm.

Pete O'Hanlon20-Jun-08 5:01

Pete O'Hanlon

20-Jun-08 5:01

You are facing a common problem here I suspect, where the database is being copied over with a default instance. Basically, what is happening is that you have a default version of the database which is being copied over every time you run the application.

Deja View - the feeling that you've seen this post before.

My blog | My articles

Re: inserting data SQLCommand C# - am I missing something?

laziale20-Jun-08 5:02

laziale

20-Jun-08 5:02

Any help with that, how I can solve?? Thx

Re: inserting data SQLCommand C# - am I missing something?

User 665820-Jun-08 5:12

Problem executing the Order of Forms..............pls help.

20-Jun-08 5:12

The article does describe how to solve it. Look in the section "Parameterised Queries" in the article

regards

modified 12-Sep-18 21:01pm.

Verghese20-Jun-08 4:11

Verghese

20-Jun-08 4:11

I have 2 windows forms, lets say Form1 and Form2........after designing I came to knowe that Form2 should execute before Form1...........how can I do that........

Re: Problem executing the Order of Forms..............pls help.

User 665820-Jun-08 4:16

Re: Problem executing the Order of Forms..............pls help.

20-Jun-08 4:16

Depends on how the first form is created and displayed. Usually, if you create a simple Windows Forms application, then in your source file Program.cs you will find something like this:

[STAThread]
static void Main()
{
   Application.EnableVisualStyles();
   Application.SetCompatibleTextRenderingDefault(false);
   Application.Run(new Form1());
}

There you can simply change new Form1() to new Form2() (or their correct form type name).

regards

modified 12-Sep-18 21:01pm.

Verghese20-Jun-08 4:35

Verghese

20-Jun-08 4:35

Thanks a lot.

Re: Problem executing the Order of Forms..............pls help.

Abhijit Jana20-Jun-08 4:17

20-Jun-08 4:17

Hey just change in Program.Cs

<br />
 [STAThread]<br />
        static void Main()<br />
        {<br />
            Application.EnableVisualStyles();<br />
            Application.SetCompatibleTextRenderingDefault(false);<br />
            Application.Run(new Form2());  // Now you have Form1 Change it to Form2 <br />
        }<br />

Best Regards
-----------------
Abhijit Jana
Check Out My Latest Article

Java.NET : Integration of Java and .NET[^]
"Success is Journey it's not a destination"

filesystemwatcher

arkiboys20-Jun-08 3:56

20-Jun-08 3:56

Hi,
I am using filesystemwatcher to mononitor a folder when changes occur to files in that folder.
I am happy with the changes it detects and it seems it is working correctly.

Question:
How is it possible to display the notifyfilter which gets detected i.e. size or filename, LastWrite, etc...
Thanks

Abhijit Jana20-Jun-08 4:08

20-Jun-08 4:08

Here is a complete tool in code project by me. Wink | ;)

Network Spy By :Abhijit[^]

Hope you will like it Smile | :)

Best Regards
-----------------
Abhijit Jana
Check Out My Latest Article

Java.NET : Integration of Java and .NET[^]
"Success is Journey it's not a destination"

arkiboys20-Jun-08 4:17

20-Jun-08 4:17

Hi,
Thanks for the link.
Un-fortunately I do not see anything relatinig to my issue.
I am basically tring to detect what has exactly changed.
For example, I detect e.ChangeType where e is FileSystemEventArgs

But do not detect whether it is a size or creationtime or lastaccess or what change it exactly is.
Thanks

Abhijit Jana20-Jun-08 4:20

20-Jun-08 4:20

i think if you check The tool and code throughly you will get your answer.

Best Regards
-----------------
Abhijit Jana
Check Out My Latest Article

Java.NET : Integration of Java and .NET[^]
"Success is Journey it's not a destination"

arkiboys20-Jun-08 4:26

20-Jun-08 4:26

Are you able to point me to it please?
Because I do not find that bit
Thanks

arkiboys20-Jun-08 4:30

20-Jun-08 4:30

Hi,
I have checked the code again.
There does not seem to be what i am after.
I basically would like to detect the kind of the ChangeType whether it is size change or anything else that has caused the notifyfilter.
Thanks

User 665820-Jun-08 4:09

C# Application Performance issue

20-Jun-08 4:09

Looking at the FileSystemEventArgs[^] members it doesn't seem like there's a way to find out this information.

regards

modified 12-Sep-18 21:01pm.

Rizawn20-Jun-08 3:43

Rizawn

20-Jun-08 3:43

Hi,

I developed a simple C# desktop application that uses the MS Access Data base, I created the deployment project and passed it to my client..The issue is that on the first run application get some time for loading...and after that it's working fine.. However on My side it is running smooth..

Well by chance my client had installed visual studio 2005.. When i compiled it on his machine.. the problem is resolved.. Any Idea whats the problem here?

Q@!$3r

leppie20-Jun-08 3:45

leppie

20-Jun-08 3:45

So how many times will the client need to start the application for the first time. My guess is once at most!

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

leppie20-Jun-08 4:30

leppie

20-Jun-08 4:30

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

Abhijit Jana20-Jun-08 3:46

20-Jun-08 3:46

Rizawn wrote:
first run application get some time for loading...

does your application doing some background job on that time ?

Best Regards
-----------------
Abhijit Jana
Check Out My Latest Article

Java.NET : Integration of Java and .NET[^]
"Success is Journey it's not a destination"

Rizawn20-Jun-08 4:02

Rizawn

20-Jun-08 4:02

well in MAIN FORM's load method i am showing a dialogue box which asks for user name and password if the user provides incorent login then some buttons on the main form are Disabled..

But thats not the issue.. as i mentioned when i recompiled it on client machine the issue was resolved..

yesterday i saw some utitlites on code project the compile the code on the fly... I was thinking if it's possible to make application recompile on the client machine by using some sort of single calle function..

Q@!$3r

Abhijit Jana20-Jun-08 4:09

20-Jun-08 4:09

Rizawn wrote:
compile the code on the fly

well, good idea.. could you kindly provide me the link for the same

Thanks in advance !!!!

Best Regards
-----------------
Abhijit Jana
Check Out My Latest Article

Java.NET : Integration of Java and .NET[^]
"Success is Journey it's not a destination"