Re: Is there any way to hide teh blank rows in excel without using loop ? - C# Discussion Boards

Not Active30-Mar-10 4:23

30-Mar-10 4:23

You can add more than one validator, or use a custom validator, self validator

Introduction to Validation Application Block[^]

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

getting attributes of .mp3 and .wav

w_joerun@yahoo.com30-Mar-10 1:29

w_joerun@yahoo.com

30-Mar-10 1:29

How to get attributes of .mp3 and .wav in c# without using TagLib and Microsoft.Directx.AudioVideoPlayback?

Re: getting attributes of .mp3 and .wav

TheFoZ30-Mar-10 2:13

TheFoZ

30-Mar-10 2:13

try this article

Professional Tag Editor for MP3 (ID3) and WMA[^]

it does mp3 and WMA. Not sure for the WAV's tho.

The FoZ

Re: getting attributes of .mp3 and .wav

w_joerun@yahoo.com2-Apr-10 23:11

w_joerun@yahoo.com

2-Apr-10 23:11

Thank you....

Is there any way to hide teh blank rows in excel without using loop ?

abcurl30-Mar-10 1:21

abcurl

30-Mar-10 1:21

Is there any way to hide the blank rows in excel without using loop ?

Re: Is there any way to hide teh blank rows in excel without using loop ?

TheFoZ30-Mar-10 2:16

TheFoZ

30-Mar-10 2:16

If the blank rows are within the data, you can apply the auto filter within code to do this. It will leave you with the autofilter selectors on the sheet but it is the quickest method. Just record a macro of you doing the task and you will have the basis for the code.

The FoZ

Re: Is there any way to hide teh blank rows in excel without using loop ?

abcurl30-Mar-10 2:50

abcurl

30-Mar-10 2:50

i am exporting the data to excel and finally i get the blank row below the data. I want to hide those rows without iteration

Re: Is there any way to hide teh blank rows in excel without using loop ?

TheFoZ30-Mar-10 3:06

TheFoZ

30-Mar-10 3:06

If the rows are at the end, you can find the row of the last cell that contains any data. In VBA it looks like this

Dim lastCell As Range
Set lastCell = Range("A1").SpecialCells(xlCellTypeLastCell)

From that you can work your way up deleting the blank rows. It still uses iteration but there are fewer.

The FoZ

Re: Is there any way to hide teh blank rows in excel without using loop ?

abcurl30-Mar-10 3:15

abcurl

30-Mar-10 3:15

around 60,000 rows are blank, this means it will create performance issue

Re: Is there any way to hide teh blank rows in excel without using loop ?

TheFoZ30-Mar-10 3:23

TheFoZ

30-Mar-10 3:23

Are they just the normal blank rows you get in any Excel spreadsheet? Or do they actual contain something and is making your workbook file size huge?

The FoZ

Re: Is there any way to hide teh blank rows in excel without using loop ?

abcurl30-Mar-10 3:29

abcurl

30-Mar-10 3:29

normal.
Suppose i send 9 rows to excel through datatable class.
and the remaining 65000 are blank, i wanted to hide these blank rows

Re: Is there any way to hide teh blank rows in excel without using loop ?

TheFoZ30-Mar-10 3:36

TheFoZ

30-Mar-10 3:36

If you now where the data ends, you will be able to create a range object that starts from the last row and finishes at the end of the spreadsheet then set the hidden property to true. Something like rangeToHide.EntireRow.Hidden = true;

The FoZ

Re: Is there any way to hide teh blank rows in excel without using loop ?

abcurl30-Mar-10 3:47

abcurl

30-Mar-10 3:47

Thanks it worked

face and finger print recognition program

Enobong Adahada30-Mar-10 1:19

Enobong Adahada

30-Mar-10 1:19

Hi,
I am working on Human Resources software and i want to include face and finger print recognition in it,
i have no idea how to go about it in c#.
pls I need help on what to do.
Thanks.

Re: face and finger print recognition program

OriginalGriff30-Mar-10 2:20

OriginalGriff

30-Mar-10 2:20

Unfortunately, .NET is unlikely to include Face Recognition until at least V17.4, when the tecnology is mature. For the moment, that means you must join the growing band of highly-skilled teams working on getting it working reliably in the first place. Start here[^], but be aware that a lot of this technology is still under development, so what you find will not be the latest cutting edge developments. (Companies seem to have an aversion to publishing promising development until they can get the patents in place, for some reason)

You should never use standby on an elephant. It always crashes when you lift the ears. - Mark Wallace

C/C++ (I dont see a huge difference between them, and the 'benefits' of C++ are questionable, who needs inheritance when you have copy and paste) - fat_boy

Re: face and finger print recognition program

Enobong Adahada30-Mar-10 22:03

Enobong Adahada

30-Mar-10 22:03

this link is not connecting to the server.

how to trap masktextbox control if empty or not filled by user

crisjala30-Mar-10 0:44

crisjala

30-Mar-10 0:44

here's my code but its not functioning plz help how to fix this....
i set my masktextbox to filled up telephone number only

<br />
<br />
private void button1save_Click(object sender, EventArgs e)<br />
{<br />
     if (maskedTextBox2tel.text == string.Empty)<br />
     {<br />
               MessageBox.Show("Plz fill up tel No");<br />
                maskedTextBox2tel.Focus();<br />
            <br />
      }<br />
}<br />
<br />
<br />

Re: how to trap masktextbox control if empty or not filled by user

Richard MacCutchan30-Mar-10 3:43

Richard MacCutchan

30-Mar-10 3:43

crisjala wrote:
here's my code but its not functioning

What is happening, do you see the message box? What are the contents of your variables, have you traced it through with the debugger?

txtspeak is the realm of 9 year old children, not developers. Christian Graus

Re: how to trap masktextbox control if empty or not filled by user

Migounette30-Mar-10 7:02

Migounette

30-Mar-10 7:02

Change it to the static method:

String.IsNullOrEmpty(maskedTextBox2tel.text) == true

Zoom to previous and next extent

manushi8830-Mar-10 0:04

manushi88

30-Mar-10 0:04

how to do Zoom to previous and next extent on map control using C#?

Re: Zoom to previous and next extent

Keith Barrow30-Mar-10 0:45

Keith Barrow

30-Mar-10 0:45

We don't know what framework you are using, you haven't supplied any code. Please supply your code. If you are using an external API (Such as Virtual Earth) you will be much better off contacting a forum dedicated to that API.

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.

Message Removed

30-Mar-10 0:03

manushi88

30-Mar-10 0:03

Message Removed

Re: How to import an image object on map control?

Keith Barrow30-Mar-10 0:46

Keith Barrow

30-Mar-10 0:46

where to find Prefix C# (abbreviation of controls‎)

jojoba201129-Mar-10 23:18

jojoba2011

29-Mar-10 23:18

where can i find standard naming Conrols in C#.
I mean Prefix/like Hungarian notation.

for example:

Control Type               Prefix           Example
<code> Button               btn         btnName
 GroupBox             gb          gbName</code>

Re: where to find Prefix C#

Mirko198029-Mar-10 23:25

Mirko1980

29-Mar-10 23:25

You can find Microsoft standard naming guidelines here.
According to these guidelines, Hungarian Notation must not be used.

Still, nothing is said about private fields, so it's up to you to define your coding standards.

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