|
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.
So, not sure you can.
Regards,
Rob Philpott.
|
|
|
|
|
Run a trace in SQL Profiler
|
|
|
|
|
sorry, i never did hat.
can you give a example ?
|
|
|
|
|
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.
For reference, look here.
|
|
|
|
|
hi,
how to Upgrade visual studio 2005 windows application project to
visual studio 2008?
|
|
|
|
|
Open the Visual Studio 2005 solution(.sln) file in Visual Studio 2008 and it will ask you do you want to convert it.
|
|
|
|
|
Hi all,
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
Date: 18/06/2009
Time: 09:27:26
User: N/A
Computer: OAXGS22
Description:
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
Application information:
Application domain: /LM/W3SVC/1214093380/Root-1-128897866071562500
Trust level: Full
Application Virtual Path: /
Application Path: D:\xgs_dev_published_web\Xerox_Apps\photo\presentation\
Machine name: OAXGS22
Process information:
Process ID: 5712
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Request information:
Request URL: http://pres.photo.xerox.xgsdev.com/handle/ImageUpload.ashx
Request path: /handle/ImageUpload.ashx
User host address: 13.215.60.31
User:
Is authenticated: False
Authentication Type:
Thread account name: NT AUTHORITY\NETWORK SERVICE
Custom event details:
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Any ideas?
Thanks
Phil
|
|
|
|
|
Dear All,
I have problem with create control on runtime
I create control Panel Or PictureBox, I want to send it to back or front but can not,
Please help me
Socheat
|
|
|
|
|
This is so difficult to do! It took me ages to work it out...Send to back of z-order[^]
No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.
This message is made of fully recyclable Zeros and Ones
|
|
|
|
|
You left of the sarcasm smiley!
|
|
|
|
|
I wanted him to click on it!
No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.
This message is made of fully recyclable Zeros and Ones
|
|
|
|
|
Hi everyone, I'd be grateful if you can help me on this:
Suppose I have this table:
Code Name
---- ----
1 A
2 B
3 C
When bound to a DataGridView , when choosing from the Code column a value of say "2" how would I populate the corresponding value from column Name that is "B" in this case??
Thanks a million guys!
All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)
|
|
|
|
|
You could look it up in the row of the data grid, or in the row of the data source.
Christian Graus
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
|
|
|
|
|
DataView dataview = new DataView(datatable);
dataview.RowFilter = "Code = '1' AND Name = 'A'";
GridView.DataSource = dataview;
I know nothing , I know nothing ...
|
|
|
|
|
Hi
From where you want to choose the code column value??Is it dropdown or something else
himanshu
|
|
|
|
|
Yes, both columns are drop down and have the full values listed.
All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)
|
|
|
|
|
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.
|
|
|
|
|
Hi All,
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.
Thanks in advance
Siddy
|
|
|
|
|
siddy17 wrote: at the C++ end it becomes bin\\debug\\abc.txt
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)
|
|
|
|
|
Hi I have used Text visualizer.
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.
The problem lies at at the C++ end.
Thanks,
Siddy
|
|
|
|
|
What if you send the path as @"d:\abc.txt" ?
जय हिंद
|
|
|
|
|
Hi!
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?
Thanks!
|
|
|
|
|
No.
What you could do is make the class "inherit" the interface and then you inherit the class. If it is an abstract class I would imagine (because I've not tried it) that you could delay the implementation of the interface until it got to the class that inherits the abstract class.
|
|
|
|
|
AFAIK no.
Why do you want to do a forced inheritance?
जय हिंद
|
|
|
|
|
I want my derived classes both to have the functionality from the System.Windows.Forms.UserControl and have to implement the methods and properties described in my IGroup interface.
|
|
|
|