C# Discussion Boards - CodeProject

Steven Solberg5-Jul-10 20:24

5-Jul-10 20:24

Okay... I just did the biggest WTF?? in my life.

Check this out:
http://www.microsoft.com/express/support/support-faq.aspx[^]

Then search for the word 'commercial'. I wonder what the hell I have been wasting so much time on because THAT is definitely not what I read in the EULA of express.

Re: Use a database like a resource

Roger Wright6-Jul-10 3:04

Roger Wright

6-Jul-10 3:04

As far as I know there are no restrictions on products developed with the Express editions. But there are features missing that make it easier to deploy finished products, and probably other bits I haven't discovered. On the Visual Studio website there used to be a table that compares the features of all editions, including Express. If you can locate it, spend a little time looking it over and thinking about what you are likely to need over the next 3 years, then decide which one fits your requirements. If your plans for your career turn out well you probably will one day want to go whole hog and take the MSDN subscription route with the top of the line development tools. But there's little sense in spending all that money before you're even got your toes wet. Big Grin | :-D

"A Journey of a Thousand Rest Stops Begins with a Single Movement"

AxisItemLabelStyle

It_tech3-Jul-10 22:28

It_tech

3-Jul-10 22:28

Hi all ,

I am trying to lable my datapoints in Y axis to a currency.

This will format my Y axis to currency ---- Chart1.ChartAreas(0).AxisY.LabelStyle.Format="C"

How can i format my datapoints for Y Axis to have the same format as Currency?

I thought this will work but there is no property like 'ItemlableStyle' --- : Chart1.ChartAreas(0).AxisY.ItemlableStyle="C"?????

Can any one Suggeet any ideas?

Thanks

Re: AxisItemLabelStyle

kevinnicol5-Jul-10 7:32

kevinnicol

5-Jul-10 7:32

Is this a .NET Chart or some 3rd party, such as DeveloperExpress? I am looking through the default toolbox in .net and can't find any sort of chart like you are talking about.

conversion

Parthi278873-Jul-10 6:02

Parthi27887

3-Jul-10 6:02

Hi

I want to convert a unicode character(multi byte) into its hexadecimal value using C#.

Re: conversion

Keith Barrow3-Jul-10 6:13

Keith Barrow

3-Jul-10 6:13

Yeh me too.

Do you have a question?
[edit]

This looks like it might be useful

http://stackoverflow.com/questions/3170523/converting-unicode-character-to-a-single-hexadecimal-value-in-c[^]

Dalek Dave: There are many words that some find offensive, Homosexuality, Alcoholism, Religion, Visual Basic, Manchester United, Butter.
Pete o'Hanlon: If it wasn't insulting tools, I'd say you were dumber than a bag of spanners.

Re: conversion

Luc Pattyn3-Jul-10 6:49

Luc Pattyn

3-Jul-10 6:49

char unicodeChar = 'a';
int integerValueOfUnicodeChar = (int)unicodeChar;
string stringShowingUnicodeValueInHex = integerValueOfUnicodeChar.ToString("X");

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use < PRE > tags for code snippets, it preserves indentation, and improves readability.

Sqlparameter

humayunlalzad3-Jul-10 1:59

humayunlalzad

3-Jul-10 1:59

The following does not work

cmd = con.CreateCommand();
cmd.CommandText = @"select * from tblcustomer where @column = @value";
cmd.Parameters.Add("@column", SqlDbType.NVarChar , 50);
cmd.Parameters.Add("@value", SqlDbType.NVarChar , 100);
cmd.Parameters["@column"].Value = comboBox1.SelectedItem.ToString();
cmd.Parameters["@value"].Value = txtSearch.Text;

But this workds

cmd = con.CreateCommand();
            cmd.CommandText = @"select * from tblcustomer where " + comboBox1.SelectedItem.ToString() + " = @value";
            //cmd.Parameters.Add("@column", SqlDbType.NVarChar , 50);
            cmd.Parameters.Add("@value", SqlDbType.NVarChar , 100);
            //cmd.Parameters["@column"].Value = comboBox1.SelectedItem.ToString();
            cmd.Parameters["@value"].Value = txtSearch.Text;

Can someone tell me whats the problem with the first code snippet

Re: Sqlparameter

Estys3-Jul-10 2:06

Estys

3-Jul-10 2:06

Yep, it's as if you had written :

@"select * from tblcustomer where <big>'</big>" + comboBox1.SelectedItem.ToString() + "<big>'</big>= @value"

Note the single quotes. You can't insert a column name as a parameter.

Cheers

^I _don't like ^my _signature at ^all

Re: Sqlparameter

humayunlalzad3-Jul-10 2:18

humayunlalzad

3-Jul-10 2:18

Ok I get it now.

But is there any other way of doing it?

Re: Sqlparameter

Estys3-Jul-10 2:26

Estys

3-Jul-10 2:26

Maybe, haven't tested this :

Select blabla FROM YourTable WHERE
CASE
WHEN @a = 'YourColumn1' THEN YourColumn1
WHEN @a = 'YourColumn2' THEN YourColumn2
ELSE YourColumn1
END
= @value

If this works it has the drawback is that when columns are added or changed, you need to edit your query.

Cheers

[edit] forgot the END Sleepy | :zzz:

[/edit]

^I _don't like ^my _signature at ^all

modified on Saturday, July 3, 2010 8:51 AM

Re: Sqlparameter

Not Active4-Jul-10 3:01

Not Active

4-Jul-10 3:01

Very poor example that opens up sql injection attacks

I know the language. I've read a book. - _Madmatt

Re: Sqlparameter

Not Active3-Jul-10 2:38

Not Active

3-Jul-10 2:38

Column names are not simple strings, they are literals that represent values from the sys.columns table.

In oder to do this you need to construct the sql dynamically and I highly and strongly recommend you do it in a stored procedure

As an example:

declare @value nvarchar(255)
declare @column nvarchar(255)
 
set @value = 'Some value'
set @column = 'ColumnName'
 
declare @sql nvarchar(1024)
 
set @sql = 'select * from tblcustomer where ' + @column + ' = ''' + @value + ''''
exec(@sql)

Notice that @value needs to be in quotes since it is a string. Also, don't use * to return results. It is more efficient to return named columns and better documented.

I know the language. I've read a book. - _Madmatt

Incrementing the pointer returned by GCHandle.Alloc

Keith Vitali2-Jul-10 22:57

Keith Vitali

2-Jul-10 22:57

Hello,

I am using GCHandle to allow unmanaged code to access some managed data.

My code is as follows:

<br />
byte[] data = new byte[numBytes];<br />
GCHandle dataPtr = GCHandle.Alloc(data, GCHandleType.Pinned);<br />

Now what I would like to do is to be able to address with an offset into my dataPtr array. So, I need to get the address of an element (say element number 100) and pass that to my unmanaged C++ code. I see some method to convert it ToIntPtr(). However, does anyone know what might be the best way to address the offset?

Many thanks,

keith

Re: Incrementing the pointer returned by GCHandle.Alloc

DaveyM692-Jul-10 23:16

DaveyM69

2-Jul-10 23:16

You can use dataPtr.AddrOfPinnedObject() to get the IntPtr. You can convert an IntPtr from/to an int for any pointer arithmetic.

Dave

If this helped, please vote & accept answer!

Binging is like googling, it just feels dirtier.
Please take your VB.NET out of our nice case sensitive forum.(Pete O'Hanlon)

BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)

Re: Incrementing the pointer returned by GCHandle.Alloc

Keith Vitali3-Jul-10 12:16

Keith Vitali

3-Jul-10 12:16

Did not think this post would generate so many replies!

Many thanks everyone.

Cheers,
Keith

Re: Incrementing the pointer returned by GCHandle.Alloc

DaveyM693-Jul-10 10:34

DaveyM69

3-Jul-10 10:34

I've just had a thought about my previous response, for 64bit applications any pointer arithmetic will need to be done on a long rather than an int!

Dave

If this helped, please vote & accept answer!

Binging is like googling, it just feels dirtier.
Please take your VB.NET out of our nice case sensitive forum.(Pete O'Hanlon)

BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)

Re: Incrementing the pointer returned by GCHandle.Alloc

harold aptroot3-Jul-10 10:37

harold aptroot

3-Jul-10 10:37

I was going to reply that to your first post, but then I though "it has a native part, so it will probably be 32bit only anyway" and decided not to post.

Re: Incrementing the pointer returned by GCHandle.Alloc

Pete O'Hanlon3-Jul-10 11:26

Pete O'Hanlon

3-Jul-10 11:26

That's a dangerous assumption that's bitten us on the ass in the past, unless you like thunking the app down to 32 bit later on.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

Re: Incrementing the pointer returned by GCHandle.Alloc

harold aptroot3-Jul-10 11:33

harold aptroot

3-Jul-10 11:33

Just because that happened, doesn't mean it's likely
Besides, OP knows how many bits he's using

Re: Incrementing the pointer returned by GCHandle.Alloc

Pete O'Hanlon3-Jul-10 11:50

Pete O'Hanlon

3-Jul-10 11:50

harold aptroot wrote:
Just because that happened, doesn't mean it's likely

Funnily enough, those are almost exactly the words that the client architect used when he landed us with the POS that we ended up having to fix.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

Re: Incrementing the pointer returned by GCHandle.Alloc

harold aptroot3-Jul-10 11:56

harold aptroot

3-Jul-10 11:56

That's a nice coincidence, but it means nothing
Plus, OP knows how many bits he's using - if that was 64 and he uses int anyway it's entirely his own fault

Re: Incrementing the pointer returned by GCHandle.Alloc

Pete O'Hanlon4-Jul-10 1:18

Pete O'Hanlon

4-Jul-10 1:18

Sorry harold, but on this one I have to disagree.

harold aptroot wrote:
if that was 64 and he uses int anyway it's entirely his own fault

If he inherits other peoples code that does this, then it's not his fault.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

Re: Incrementing the pointer returned by GCHandle.Alloc

harold aptroot4-Jul-10 1:31

harold aptroot

4-Jul-10 1:31

He'd be asking a different kind of question if he were

Re: Incrementing the pointer returned by GCHandle.Alloc

DaveyM693-Jul-10 11:44

DaveyM69

3-Jul-10 11:44

I was sitting watching a film with the family and it suddenly popped into my head! It's better dealt with now rather than later when his pointers turn out to be invalid and he has no clue why.

I've just knocked up a utility struct wrapping IntPtr with arithmetic/conversion operators built in for future use prompted by this to solve this problem the next time I need it. Not sure whether to post as a Tip or just as an answer to the OP...

Dave

If this helped, please vote & accept answer!

Binging is like googling, it just feels dirtier.
Please take your VB.NET out of our nice case sensitive forum.(Pete O'Hanlon)

BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)

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