IDbParameter return value string only gives first character - C# Discussion Boards

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

DateTimePicker and BindingSource Problem

25-Sep-08 2:39

found it!
I incidently selected IDataParameter interface, which should have been IDbDataParameter.
IDbDataParameter parameters have a size property.
Thanks for the trouble taken to try to help!
bye.

Ahmad Safwat24-Sep-08 23:31

Ahmad Safwat

24-Sep-08 23:31

Hi all,
I have a problem with DateTimePicker and BindingSource.

The BindingSource DataSource is a DataTable of 3 Columns (ID, Name, and Date).

The "ID" Field is Primary key that of cource doesn't allow nulls.
Both "ID" and "Name" fields are bound to TextBoxes, and "Date" Field is bound to a DateTimePicker control.

Now when I'm trying to add a new record, I got an exception of:
"Column 'ID' does not allow nulls."
although it has a value.

when I don't bind "Date" field, problem doesn't occur

Can you help meeee?? Cry | :((

Re: DateTimePicker and BindingSource Problem

Acid_Inex25-Sep-10 18:25

Acid_Inex

25-Sep-10 18:25

Take a look http://www.devnewsgroups.net/group/microsoft.public.dotnet.framework.windowsforms/topic64486.aspx[^]

Re: DateTimePicker and BindingSource Problem

PeSVe24-Aug-12 3:59

PeSVe

24-Aug-12 3:59

Before actually adding a the new record, you should clear the datetimepicker's databinding, using the method datetimepicker1.DataBindings.Clear() in C#. After that binding the datetimepicker1 to the same data source it's bound before.

delegate

Mogaambo24-Sep-08 23:26

Mogaambo

24-Sep-08 23:26

Control.Invoke((MethodInvoker)delegate()
{

});

This is a syntax of a code which i have copied but i didn't understand use of "MethodInvoker" here.

can any body explain me.

“You will never be a leader unless you first learn to follow and be led.”
–Tiorio

"Coming together is a beginning, staying together is progress, and working together is success." Henry Ford

leppie24-Sep-08 23:28

leppie

24-Sep-08 23:28

You cant pass an anonymous delegate into a method expecting a Delegate type. You need to cast it to a compatible delegate type.

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)
((lambda (x) `((lambda (x) ,x) ',x)) '`((lambda (x) ,x) ',x))

Mogaambo25-Sep-08 0:08

Mogaambo

25-Sep-08 0:08

SO WHAT'S THE USE OF DELEGATE KEYWORD HERE

“You will never be a leader unless you first learn to follow and be led.”
–Tiorio

"Coming together is a beginning, staying together is progress, and working together is success." Henry Ford

leppie25-Sep-08 0:16

leppie

25-Sep-08 0:16

Mogaambo wrote:
SO WHAT'S THE USE OF DELEGATE KEYWORD HERE

TO CREATE AN ANONYMOUS DELEGATE! D'Oh! | :doh:

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)
((lambda (x) `((lambda (x) ,x) ',x)) '`((lambda (x) ,x) ',x))