Re: executable file - C# Discussion Boards

JoeManche9-Feb-12 4:15

9-Feb-12 4:15

I am doing some project which has interactions with an existing excel file. i have successfully connected with the excel file and i have already retrieved data from it to a DataGridview. But i am having one big problem. when the data from the excel sheet is displayed on the DataGridView, the format is changed and it is just a scrambled data.... i can only see the perfect tabular data if it is with out merged cells,charts or pictures.
can anyone help me how to import data from the excel sheet to the DataGridView with the same look as it is in the Excel sheet?.... Thank u in advance!

Re: Hi all

BobJanova9-Feb-12 5:06

BobJanova

9-Feb-12 5:06

The DataGridView doesn't support anything other than cellular data. So what you're asking is impossible.

If you want a fully functioning Excel, why not just embed Excel?

Re: Hi all

JoeManche9-Feb-12 18:48

JoeManche

9-Feb-12 18:48

Thanks for the quick reply BobJanova!
Ok, but besides importing charts or pictures, I just want to import cell formats of the excel sheet. as i said yesterday, most of the cells in the excel sheets are merged to make the data organized in some structure. so while i import it to the DataGridView with out any other pictures or charts, it does not have the same look as it is in the excel sheet. any suggestion please? and if datagridview doesn't allow the pictures thing what else shall i use other than the datagridview? Thank u again!

Re: Hi all

BillWoodruff9-Feb-12 20:24

BillWoodruff

9-Feb-12 20:24

JoeManche wrote:
what else shall i use other than the datagridview?

Bob Janova's answer nailed it for you; the only other alternative would be to pay big buck$ for a 3rd. party .NET control that can duplicate all of Excel's (innumerable ?) presentation options ... and good luck with that !

best, Bill

"The first principle is that you must not fool yourself, and you are the easiest person to fool." Richard Feynman

executable file

AndyInUK9-Feb-12 3:14

AndyInUK

9-Feb-12 3:14

Is there anyway to create a executable file that support mac ?

I know there are few third party softwares that can help running exe files on mac. But is there any direct way?

Thanks

Re: executable file

BobJanova9-Feb-12 3:53

BobJanova

9-Feb-12 3:53

Do you count Mono? That's the only way to get C#/.Net applications to run on Unix variants (which includes Mac OS).

Message Removed

9-Feb-12 5:29

N_tro_P

9-Feb-12 5:29

Message Removed

Re: executable file

raven198529-Feb-12 13:11

raven19852

9-Feb-12 13:11

mono though does not cover all the things that .net does. So bare in mind you might have to do some things on your own whereas at .net its already been done.

Δημιουργία websites, web εφαρμογών και εφαρμογών ηλεκτρονικού υπολογιστή. http://www.remiakstudio.gr

Re: executable file

BobJanova9-Feb-12 22:04

BobJanova

9-Feb-12 22:04

Mono covers pretty much anything you'd actually want to use. (See here[^].) The only major omissions are WPF and Entity Framework.

how to reverse string on column - datagridview

goldsoft9-Feb-12 2:22

goldsoft

9-Feb-12 2:22

hi
i have this code:

private void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
 {
  if (e.Value != null)
  {
   string l_value = e.Value.ToString();
   char[] l_array = l_value.ToCharArray();
   Array.Reverse(l_array);
   e.Value = new string(l_array);
  }
 }

it reverse all of the datagridview
i need only column 2 that be reverse

how to change this code ?
thanks in advance

Re: how to reverse string on column - datagridview

_AnsHUMAN_ 9-Feb-12 2:32

_AnsHUMAN_

9-Feb-12 2:32

This because you are doing it in a function that would be called for every cell and hence the reversal on all values for all columns

You talk about Being HUMAN. I have it in my name
AnsHUMAN

Displaying a 32bit bitmap with Alpha channel transparency

__John_9-Feb-12 2:14

__John_

9-Feb-12 2:14

Hi,

I want to display(on a Form) a 32bit bitmap with Alpha channel transparency, so thet the transparency is honoured.

I have tried a Picture control but it ignores the Alpha channel.

Any ideas?

Thanks - John

“If I had asked people what they wanted, they would have said faster horses.”
― Henry Ford

Re: Displaying a 32bit bitmap with Alpha channel transparency

Pete O'Hanlon9-Feb-12 2:59

Pete O'Hanlon

9-Feb-12 2:59

What format is the image? As far as I'm aware a bitmap doesn't support the alpha channel in Windows, but you would rather manage it using a chroma key (that's where you choose one colour as being transparent). If it is a bitmap, then you might want to try out the code sample here[^]

If you are using a PNG (for instance), then just set the appropriate PixelFormat, i.e. PixelFormat.Format32bppArgb;

*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington

"Mind bleach! Send me mind bleach!" - Nagy Vilmos

My blog | My articles | MoXAML PowerToys | Mole 2010 - debugging made easier - my favourite utility

Re: Displaying a 32bit bitmap with Alpha channel transparency

__John_9-Feb-12 4:07

__John_

9-Feb-12 4:07

Thanks Pete,

The image format is 32bit bmp. But I could easly change it to png using Gimp.
Where does PixelFormat come from?
I checked Image.PixelFormat on msdn...
http://msdn.microsoft.com/query/dev10.query?appId=Dev10IDEF1&l=EN-US&k=k(SYSTEM.DRAWING.IMAGE.PIXELFORMAT);k(TargetFrameworkMoniker-%22.NETFRAMEWORK%2cVERSION%3dV4.0%22);k(DevLang-CSHARP)&rd=true[^]

All it does is show how to call ToString() on it (why do they bother).

Thanks - John

“If I had asked people what they wanted, they would have said faster horses.”
― Henry Ford

Re: Displaying a 32bit bitmap with Alpha channel transparency

Pete O'Hanlon9-Feb-12 4:24

Pete O'Hanlon

9-Feb-12 4:24

PixelFormat is an enumeration[^].

*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington

"Mind bleach! Send me mind bleach!" - Nagy Vilmos

My blog | My articles | MoXAML PowerToys | Mole 2010 - debugging made easier - my favourite utility

Re: Displaying a 32bit bitmap with Alpha channel transparency

__John_9-Feb-12 4:46

__John_

9-Feb-12 4:46

Image.PixelFormat

Has no Set method it can only be read.

“If I had asked people what they wanted, they would have said faster horses.”
― Henry Ford

Re: Displaying a 32bit bitmap with Alpha channel transparency

harold aptroot9-Feb-12 4:26

harold aptroot

9-Feb-12 4:26

Just FYI, 32bit BMP is almost universally unsupported. Even by image manipulation programs.

Re: Displaying a 32bit bitmap with Alpha channel transparency

__John_9-Feb-12 4:53

__John_

9-Feb-12 4:53

Yeh, I see what you mean.
You would think by now that there would be a standard way of handling transparency, but ther isn't. its all over the place, Alpha channels, transparency masks of every posible value ever known, what a can of worms it is.

“If I had asked people what they wanted, they would have said faster horses.”
― Henry Ford

Re: Displaying a 32bit bitmap with Alpha channel transparency

harold aptroot9-Feb-12 5:08

harold aptroot

9-Feb-12 5:08

Transparency is a lot easier in WPF than in Windows Forms, would it be possible to convert the program to WPF?

Re: Displaying a 32bit bitmap with Alpha channel transparency

BillWoodruff9-Feb-12 20:28

BillWoodruff

9-Feb-12 20:28

__John_ wrote:
You would think by now that there would be a standard way of handling transparency

I'm glad to see there are optimists still afloat ! Smile | :)

imho, using PNG's with transparency has become a standard: they work in .NET, they work on the web.

best, Bill

"The first principle is that you must not fool yourself, and you are the easiest person to fool." Richard Feynman

Re: Displaying a 32bit bitmap with Alpha channel transparency

SledgeHammer019-Feb-12 5:13

SledgeHammer01

9-Feb-12 5:13

Pete O'Hanlon wrote:
As far as I'm aware a bitmap doesn't support the alpha channel in Windows

Since when? Bitmaps (BMP) have supported the alpha channel for probably close to a decade or more.

Re: Displaying a 32bit bitmap with Alpha channel transparency

Pete O'Hanlon9-Feb-12 5:22

Pete O'Hanlon

9-Feb-12 5:22

Note the careful use of Windows here - it's not the problem with Bitmaps, it's a problem with Windows.

*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington

"Mind bleach! Send me mind bleach!" - Nagy Vilmos

My blog | My articles | MoXAML PowerToys | Mole 2010 - debugging made easier - my favourite utility

How to get value from Reorder List Ajax control?

Manish_Kumar_Nayak9-Feb-12 2:10

Manish_Kumar_Nayak

9-Feb-12 2:10

How to get value from Reorder List Ajax control?
I am using link Button to Bind and display ID field and wants to get that ID when I m going to click on link Button.
It doesn't give any response by clicking on it.
please help me..... Frown | :(

How to get value from Reorder List Ajax control?

Manish_Kumar_Nayak9-Feb-12 18:40

Manish_Kumar_Nayak

9-Feb-12 18:40

pls some body help.......

Start any Application(Say Skype) on remote machine using c# language .

Ashish payghan8-Feb-12 22:34

Ashish payghan

8-Feb-12 22:34

Hi,
I want code in c# language that start application on remote machine.
Please suggest me for c# not vbScript.

Thanks
Ashish

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