|
I use it the informations what you provide me, and it gives me error after the ExecuteNonQuery line, here is how I tried to solve:
SqlTransaction transaction;
transaction = conn.BeginTransaction("BeginTransaction");
SqlCommand command = conn.CreateCommand();
try
{
command.CommandText = query;
command.ExecuteNonQuery();
transaction.Commit();
}
catch (Exception ex)
{
throw new Exception(ex.ToString(), ex);
}
finally
{
conn.Close();
}
This is the exception:
System.InvalidOperationException: ExecuteNonQuery requires the command to have a transaction when the connection assigned to the command is in a pending local transaction. The Transaction property of the command has not been initialized.
|
|
|
|
|
You forgot to insert command.Transaction = transaction before executing the query.
modified 12-Sep-18 21:01pm.
|
|
|
|
|
So do you get an error?
Are you attaching the correct database file when you look for the data?
|
|
|
|
|
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?
|
|
|
|
|
By the way, your code is also vulnerable to SQL injections[^], you should fix that 
regards
modified 12-Sep-18 21:01pm.
|
|
|
|
|
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.
|
|
|
|
|
Any help with that, how I can solve?? Thx
|
|
|
|
|
The article does describe how to solve it. Look in the section "Parameterised Queries" in the article
regards
modified 12-Sep-18 21:01pm.
|
|
|
|
|
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........
|
|
|
|
|
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.
|
|
|
|
|
|
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());
}<br />
|
|
|
|
|
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
|
|
|
|
|
|
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
|
|
|
|
|
i think if you check The tool and code throughly you will get your answer.
|
|
|
|
|
Are you able to point me to it please?
Because I do not find that bit
Thanks
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
So how many times will the client need to start the application for the first time. My guess is once at most!
|
|
|
|
|
|
Rizawn wrote: first run application get some time for loading...
does your application doing some background job on that time ?
|
|
|
|
|
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
|
|
|
|
|
Rizawn wrote: compile the code on the fly
well, good idea.. could you kindly provide me the link for the same
Thanks in advance !!!!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
