Re: debug sql with parameters - C# Discussion Boards

Re: 3DES Encryption ?

stancrm18-Jun-09 0:42

stancrm

18-Jun-09 0:42

http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/b9239824-e8a1-4955-9193-d9f6993703f3[^]

Re: 3DES Encryption ?

Mohammad Dayyan18-Jun-09 5:28

Mohammad Dayyan

18-Jun-09 5:28

Great, Thank you

Re: 3DES Encryption ?

Colin Angus Mackay18-Jun-09 0:43

Colin Angus Mackay

18-Jun-09 0:43

Mohammad Dayyan wrote:
Do we have 3DES Encryption in .Net Framework ?

According to the documentation, yes: System.Security.Cryptography.TripleDES[^]

debug sql with parameters

jogisarge18-Jun-09 0:06

jogisarge

18-Jun-09 0:06

Hi,

i use VS2008 and SQLServer 2005.

How can i debug a sql-statement, that includes parameters like this ?

string sqlstatement = "INSERT INTO artikel (nr,text1,text2)" +
                                                      "VALUES" +
                                                      "( @parm1, " +
                                                      "  @parm2, " +
                                                      "  @parm3 " +
                                                      "  " +
                                                      "  )";
SqlCommand sqlins = new SqlCommand(sqlstatement, con);
sqlins.Parameters.Add("@parm1", SqlDbType.NVarChar).Value = var1;
sqlins.Parameters.Add("@parm2", SqlDbType.Int).Value = var2;
sqlins.Parameters.Add("@parm3", SqlDbType.Int).Value = var3;
sqlins.ExecuteNonQuery();

so, how can i see the statement, that will be sent to the sql-server ?

bye jogi

Re: debug sql with parameters

Rob Philpott18-Jun-09 0:20

Rob Philpott

18-Jun-09 0:20

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.

Re: debug sql with parameters

DoctorMick18-Jun-09 0:23

DoctorMick

18-Jun-09 0:23

Run a trace in SQL Profiler

Re: debug sql with parameters

jogisarge18-Jun-09 1:25

jogisarge

18-Jun-09 1:25

sorry, i never did hat.
can you give a example ?

Re: debug sql with parameters

Mirko198018-Jun-09 3:47

Mirko1980

18-Jun-09 3:47

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.

how to Upgrade visual studio 2005 windows application project to 2008?

amit_8317-Jun-09 23:59

amit_83

17-Jun-09 23:59

hi,
how to Upgrade visual studio 2005 windows application project to
visual studio 2008?

Re: how to Upgrade visual studio 2005 windows application project to 2008?

^crayzeecoder18-Jun-09 0:08

^crayzeecoder

18-Jun-09 0:08

Open the Visual Studio 2005 solution(.sln) file in Visual Studio 2008 and it will ask you do you want to convert it. Smile | :)

Keep getting error 1314 after calling generic handler?

Phillip Donegan17-Jun-09 22:53

Phillip Donegan

17-Jun-09 22:53

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

Create Control on RunTime

Socheat.Net17-Jun-09 22:52

Socheat.Net

17-Jun-09 22:52

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

Re: Create Control on RunTime

OriginalGriff17-Jun-09 23:14

OriginalGriff

17-Jun-09 23:14

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

Re: Create Control on RunTime

Michael Bookatz17-Jun-09 23:37

Michael Bookatz

17-Jun-09 23:37

You left of the sarcasm smiley!

Re: Create Control on RunTime

OriginalGriff17-Jun-09 23:53

OriginalGriff

17-Jun-09 23:53

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

Regarding DataGridView

Muammar©17-Jun-09 21:34

Muammar©

17-Jun-09 21:34

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)
(><)

Re: Regarding DataGridView

Christian Graus17-Jun-09 21:51

Christian Graus

17-Jun-09 21:51

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

Re: Regarding DataGridView

I Believe In GOD17-Jun-09 21:55

I Believe In GOD

17-Jun-09 21:55

DataView dataview = new DataView(datatable);
dataview.RowFilter = "Code = '1' AND Name = 'A'";
GridView.DataSource = dataview;

I know nothing , I know nothing ...

Re: Regarding DataGridView

himanshu256117-Jun-09 21:58

himanshu2561

17-Jun-09 21:58

Hi From where you want to choose the code column value??Is it dropdown or something else

himanshu

Re: Regarding DataGridView

Muammar©

17-Jun-09 22:36

Yes, both columns are drop down and have the full values listed.

All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)

Re: Regarding DataGridView

MatthysDT17-Jun-09 22:00

MatthysDT

17-Jun-09 22:00

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.

Doggy treat[^]

Trying to call a c++ function in C# code using PInvoke

siddy1717-Jun-09 21:16

siddy17

17-Jun-09 21:16

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

Re: Trying to call a c++ function in C# code using PInvoke

Colin Angus Mackay17-Jun-09 21:39

Colin Angus Mackay

17-Jun-09 21:39

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)

Re: Trying to call a c++ function in C# code using PInvoke

siddy1717-Jun-09 23:00

siddy17

17-Jun-09 23:00

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

Re: Trying to call a c++ function in C# code using PInvoke

dan!sh 17-Jun-09 23:19

dan!sh

17-Jun-09 23:19

What if you send the path as @"d:\abc.txt"?

जय हिंद

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