C# Discussion Boards - CodeProject

Simon P Stevens25-Sep-08 0:32

Simon P Stevens

25-Sep-08 0:32

I don't use asp, so I could be wrong. But in html, & signs must be escaped.

You need to create a function to process the company name that you read from the database and replace any illegal html characters like < or > or & with the correct escape string.

(I noticed in my last post the escape string was escaped Smile | :)

the string you need is "&" without the quotes.)

(There is probably already a function to do this. You might be better asking this question in the asp.net forum)

Simon

Harvey Saayman25-Sep-08 0:36

Harvey Saayman

25-Sep-08 0:36

ASP.Net questions belong in the ASP.Net forum!

Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
you.suck = (you.Passion != Programming & you.Occupation == jobTitles.Programmer)
1000100 1101111 1100101 1110011 100000 1110100 1101000 1101001 1110011 100000 1101101 1100101 1100001 1101110 100000 1101001 1101101 100000 1100001 100000 1100111 1100101 1100101 1101011 111111

Guffa25-Sep-08 4:39

Guffa

25-Sep-08 4:39

You have to url-encode the string that you put in an url:

<a href="newdetails1.aspx?pid=<%#Server.UrlEncode(Eval("companyname"))%>">

Despite everything, the person most likely to be fooling you next is yourself.

Re: Winform app not closing

Prasanna Kumar Pete25-Sep-08 18:08

Prasanna Kumar Pete

25-Sep-08 18:08

Use HttpUtility.URLEncode()

This will solve your problem. Smile | :)

Thanks & Regards

Pete
SIEMENS Information Systems Ltd

Winform app not closing

Chazzysb25-Sep-08 0:21

Chazzysb

25-Sep-08 0:21

Hi,

.net 2 vs2005

I have a winform app with a close button. The code behind the close is this.Close(); this.Dispose();

The problem is that after deploying my app, in the task manager I can still see my exe under processes after pressing the close button. Do I need to shut down differently?

Thanks,
Chas

Simon P Stevens25-Sep-08 0:29

Simon P Stevens

25-Sep-08 0:29

You don't need to call this.dispose on the apps main form. If you started it up correctly (by using Application.Run(new Form1());) then the calling code will do the dispose for you. Do this first, and check that it's not causing your problem.

Apps remaining running is usually because you haven't stopped a background thread somewhere. Are you using any background workers, or threads, or anything like that? Check they are all stopped and disposed of before the form is closed.

Simon

Re: Winform app not closing

Mbah Dhaim25-Sep-08 1:09

Mbah Dhaim

25-Sep-08 1:09

try to use

Application.Exit();

hope it helps

dhaim
programming is a hobby that make some money as side effect Smile | :)

How can i Run my application form the WIndows service?

Sifar - 025-Sep-08 0:12

Sifar - 0

25-Sep-08 0:12

Hi all,

this msg is regarding my previous post.
(how to hide OS and run only SINGLE application)

i ve created a WIndows Service and it starts automatically with computer.
But how can I run my application from that Service.

My Windows service resides in the same project.

So where i m stuck is : How can i Run my application form the WIndows service?
I wrote OnStart event of Windows Service and wrote System.Diagnostics.Process in it,
but it did not work?

ANy solution.....

Regards,
SIFAR.

Re: How can i Run my application form the WIndows service?

Venkat Eswaran25-Sep-08 4:22

Venkat Eswaran

25-Sep-08 4:22

Are you sure OnStart event fired sucessfully in your windows service..

Venky

Re: How can i Run my application form the WIndows service?

Mark Salsbery25-Sep-08 7:33

Mark Salsbery

25-Sep-08 7:33

How do you know it didn't work?

Mark

Mark Salsbery
Microsoft MVP - Visual C++
Java | [Coffee]

Setting property Enable32BitAppOnWin64 for IIS 7 in C#

Mushtaque Nizamani24-Sep-08 23:48

Mushtaque Nizamani

24-Sep-08 23:48

ServerManager mgr = new ServerManager();
mgr.ApplicationPools["test"].Enable32BitAppOnWin64 = true;
mgr.CommitChanges();

Above code should set property Enable32BitAppOnWin64 to true for application pool having name test, but it doesn't do that, can anyone please tell what am I doing wrong.

Please note that ServerManager class is present in Microsoft.Web.Administration namespace.

Thanks,
Mushq

Re: Setting property Enable32BitAppOnWin64 for IIS 7 in C#

Pete O'Hanlon25-Sep-08 0:44

25-Sep-08 0:44

Do you get any exceptions? I use the following code and it works fine for me (cutdown a bit):

using (ServerManager mgr = new ServerManager())
{
  ApplicationPool appPool = mgr.ApplicationPools[appPoolName];
  if (appPool == null)
    throw new ApplicationException(string.Format("The pool {0} does not exist", appPoolName));
  appPool.Enable32BitAppOnWin64 = true;
  mgr.CommitChanges();
}

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

Re: Setting property Enable32BitAppOnWin64 for IIS 7 in C#

Mushtaque Nizamani25-Sep-08 17:32

Mushtaque Nizamani

25-Sep-08 17:32

Hi Pete,
Thanks for the response and sorry for the late reply.

Pete O'Hanlon wrote:
Do you get any exceptions?

No, I don't get any exception.

I have observed when i try to set property through code it shows me that the property has been successfully changed to true even next time I try to get that property programmatically it shows me that property is true, but when I open that in IIS it shows me that property to be false.

Please check the screen shot for that.
http://img87.imageshack.us/my.php?image=iiswin32bitcheckmf6.jpg[^]

Kind Regards,
Mushq

Re: Setting property Enable32BitAppOnWin64 for IIS 7 in C#

Mushtaque Nizamani8-Oct-08 19:23

Mushtaque Nizamani

8-Oct-08 19:23

Hi Pete O'Hanlon,
I was checking that property incorrectly, you are right that your mentioned code is working fine.
Thanks a lot.

Kind Regards,
Mushq

IDbParameter return value string only gives first character

jVersteegen24-Sep-08 23:35

Re: IDbParameter return value string only gives first character

24-Sep-08 23:35

hello
I am trying to get the return parameter from database stored procedure (very simple basic test):

create procedure TQMSpGetConcattenatedString @string1 varchar(50),@string2 varchar(50),@string3 varchar(50) output
as
set nocount on
select @string3 = @string1 + @string2

works fine when execute in query analyser. Then try to execute from C# code as follows:

private static string test2()
{
IDbCommand cmd = Program.db.GetCommand ();
cmd.Connection = Program.db.Connection;
cmd.CommandText = "TQMSpGetConcattenatedString";
cmd.CommandType = CommandType.StoredProcedure ;

IDataParameter p1 = Program.db.getDataParameter ();
p1.ParameterName = "@string1";
p1.Direction = ParameterDirection.Input ;
p1.DbType = DbType.String ;
p1.Value = "Monkey";
cmd.Parameters.Add (p1);

IDataParameter p2 = Program.db.getDataParameter ();
p2.ParameterName = "@string2";
p2.Direction = ParameterDirection.Input ;
p2.DbType = DbType.String ;
p2.Value = "Tail";
cmd.Parameters.Add (p2);

IDataParameter p3 = Program.db.getDataParameter ();
p3.ParameterName = "@string3";
p3.Direction = ParameterDirection.Output;
p3.DbType = DbType.String ;
p3.Value = "-";
cmd.Parameters.Add (p3);

cmd.ExecuteNonQuery ();
return p3.Value.ToString();
}

the return string only has 1 character in it. When i use SqlParameter it works good.
Does anybody have a suggestion for me?

Pete O'Hanlon25-Sep-08 0:09

25-Sep-08 0:09

jVersteegen wrote:
cmd.ExecuteNonQuery ();

Don't use this. You're executing a query, so use something like ExecuteDataReader() instead. Also, you need to close your connection and command. I suggest that you wrap them up in using blocks.

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

Re: IDbParameter return value string only gives first character

jVersteegen25-Sep-08 0:16

Re: IDbParameter return value string only gives first character

25-Sep-08 0:16

Thanks for the suggestion!
I'm not executing a query but a stored procedure.
your suggestion does not change the result.
by the way: what 's the advantage of a using block?

Ashfield25-Sep-08 0:24

Ashfield

25-Sep-08 0:24

ExecuteNonQuery is used for update/insert type queries (or stored procs) which do not return data.

The advantage of a using block is that it automatically closes/disposes for you.

you do not get the value of the output parameters until your connection is closed. A starnge thing, but there you are, thats how it works.

Bob
Ashfield Consultants Ltd

Re: IDbParameter return value string only gives first character

jVersteegen25-Sep-08 0:37

Re: IDbParameter return value string only gives first character

25-Sep-08 0:37

Like i say before: when i use SqlDataParameter and not IDataParameter it works fine.
But i want to be able to connect to SqlServer OR Oracle database, so i try IDataParameter.
So it has to with the parameter, not the connection. When i do not set the size for a SqlParameter, the result is also the first character only. However i cannot set the size for IDataParameter.

Pete O'Hanlon25-Sep-08 1:08

25-Sep-08 1:08

You don't need to assign a value to your output parameter. I suspect that it may be setting the size of the parameter because you only assign a single character to the input here.

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

Re: IDbParameter return value string only gives first character

jVersteegen25-Sep-08 1:31

Re: IDbParameter return value string only gives first character

25-Sep-08 1:31

tried that: an null value resluts in an error (invalid size property),
a very long string or empty string or gives the same result (only one char).

Pete O'Hanlon25-Sep-08 1:59

25-Sep-08 1:59

What character do you get back? Is it the one you'd expect?

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

Re: IDbParameter return value string only gives first character

jVersteegen25-Sep-08 2:29

Re: IDbParameter return value string only gives first character

25-Sep-08 2:29

It is the "M" from "Monkey", but i want "MonketTail".

jVersteegen25-Sep-08 2:39