The parameters don't get substitued and then sent to SQL Server. Your statement gets sent and the parameters supplied seperately, SQL server then does the 'substitution'. It allows it to work more efficiently that way.
SQL Profiler is an application contanined in SQL Server 2005 client tools.
You will probably find it installed on your database server, you can also install it on your development machine. With it you can trace queries made on your database.
I keep getting error ID 1314 "An unhanded security exception has occurred" in the event log. However this only happens on the staging servers. If i run it on my local machine it works fine.
What I'm trying to do is run a file uploader (flex) this then calls the handlers (C#.Net 2.0) in the pres layer. This should then call the app layer and do the basic file IO (create a folder and stick the uploaded file into this folder). However when I try to execute this code on any of the staging servers I get error 1314. I've googled loads and looked on here. The one topic I found on here said that I should change the group policy and set it to be able to run as part of the operating system. Did this but the problem is still there.
Some more info, I'm using windows impersonation on all of my IO methods. The account that is being impersonated is in the administrators group (for now). Also this type of IO (create folder and stick something in it) is being done in other parts of the website and is working fine??
The error that the flex returns is as follows: "[IOErrorEvent type="ioError" bubbles=false cancelable=false eventPhase=2 text="Error #2038"]" and "[HTTPStatusEvent type="httpStatus" bubbles=false cancelable=false eventPhase=2 status=500]".
In the event log:
Event Type: Information
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1314
Event code: 4010
Event message: An unhandled security exception has occurred.
Event time: 18/06/2009 09:27:26
Event time (UTC): 18/06/2009 08:27:26
Event ID: 4de8de366e684eec959db42fb5231dae
Event sequence: 20
Event occurrence: 2
Event detail code: 0
You could look it up in the row of the data grid, or in the row of the data source.
Driven to the arms of OSX by Vista.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
In the event that fires when selecting a cell (cant remember the name), which should have parameter such as e.RowIndex and e.ColumnIndex, assuming your DataGridView is named myDGV:
myDGV.Rows[e.RowIndex].Cells[e.ColumnIndex].value.toString() -> this get the value of the selected cell.
myDGV.Rows[e.RowIndex].Cells["MyColumnName"].value = "MyStringValue" -> this sets a value for the specified cell.
I am trying to call a C++ function into C# using PInvoke. The C++ function accepts a filename as a parameter and then writes to that file.
However, the hitch is when a simple filename is passed from C#, at the C++ end it is implicitly appended with Escape characters which is why it cannot find the file.
For Eg: If I pass a file as "ABC.txt" which lies in my bin\debug folder of the C# application, at the C++ end it becomes bin\\debug\\abc.txt which is wht it cannot write to the file.
Did anyone encounter a similar problem and has resolved it?
Kinldy help me out here.
Any help is appreciated.
Are you sure that's not just the debugger representing the string as a C# string?
Have you viewed the string using the text visualiser instead to be absolutely sure it is really containing the double slashes? (Hover over the string variable, you'll get a little arrow in the tooltip which will offer you some visualisers, choose the Text Visualiser)
May be I was not very precise. In C#, I have to use '\' as an escape character. Hence If I pass a filename as "D:\\ABC.txt", the function in C++ does not take the path as is, it implcitly appends two more '\'s as escape characters (one for each '\' in the filename) and hence cannot
find the file.
I have a simple question.
With an interface I can force the classes that implements it, to implement methods and properties defined in the interface. But am I able to force the classes to inherit som other class, with an interface?
Last Visit: 31-Dec-99 18:00 Last Update: 20-Jun-21 20:46