C# Discussion Boards - CodeProject

haz1317-Jun-07 10:40

17-Jun-07 10:40

I am really stuck trying work out and understand how to achieve the following. I have a collection of objects and want to peform some data analysis on each of the fields in turn using a method.

The collection
List<CardData> CardDataCollection = new List<CardData>();

CardData class contains fields called Card1,Card2,Card3 etc

The code below has been simplified to show what I'm currently doing for one of the collection object fields (CardDataCollection[i].Card1).

public static void CalcData()
{

    int i;

    for (i = 0; i < CardDataCollection.Count; i++)
    {
        if (CardDataCollection[i].Card1 == 1)
        {
            //do data processing here
        }
    }
}

I need to perform the same exercise on each of the Card fields (for Card1 upto Card100) in the collection so I want to create a method that will allow me pass in some kind of reference to the collection object field (CardX).

Note: I need access using the [i] as the data processing requires me to use for example [i-5] (i.e can't use foreach loops)

I know what I want it do but just can quite get my head around how to do it. I'll try to explian below how I would change the code.

public static void CalcData(reference to relevant card number field eg Card50)
{

    int i;

    for (i = 0; i < CardDataCollection.Count; i++)
    {
        if (Card50[i] == 1) //I know this can't be done
        {
            //do data processing here
        }
    }
}

Please excuse any incorrect technical description as I'm only new to this C#. Thanks in advance for any help you can give me.

Haz

Re: Generic Collection &Method Problem

User 665817-Jun-07 10:51

User 6658

17-Jun-07 10:51

haz13 wrote:
I need to perform the same exercise on each of the Card fields (for Card1 upto Card100)

Why don't you use a card array of size 100?

regards

modified 12-Sep-18 21:01pm.

Re: Generic Collection &Method Problem

haz1317-Jun-07 11:48

haz13

17-Jun-07 11:48

Sorry Greeeg I don't understand how that would help what I'm doing (please explain more - maybe I haven't explined it very well)? Basically I need to itterate through all the collection object fields in turn. I have a method that does it for one of the fields, but instead of copying it 100 times and slightly changing the field refernces I was trying to create a method that was more generic (this is the bit I can't get my head around).

CardDataCollection[0].Card1
CardDataCollection[1].Card1
CardDataCollection[2].Card1
CardDataCollection[3].Card1
CardDataCollection[4].Card1
CardDataCollection[5].Card1
to end of collection

Then I need to do the same for the Card2 field
And so on for each of the remaining Card fields upto 100

CardDataCollection[0].Card100
CardDataCollection[1].Card100
CardDataCollection[2].Card100
CardDataCollection[3].Card100
CardDataCollection[4].Card100
CardDataCollection[5].Card100
to end of collection

Put another way I need one method to prevent me creating 100 very similar methods as described below.

public static void CalcDataCard1()
{

    int i;

    for (i = 0; i < CardDataCollection.Count; i++)
    {
        if (CardDataCollection[i].Card1 == 1)
        {
            //do data processing here
        }
    }
}

public static void CalcDataCard2()
{

    int i;

    for (i = 0; i < CardDataCollection.Count; i++)
    {
        if (CardDataCollection[i].Card2 == 1)
        {
            //do data processing here
        }
    }
}

public static void CalcDataCard3()
{

    int i;

    for (i = 0; i < CardDataCollection.Count; i++)
    {
        if (CardDataCollection[i].Card3 == 1)
        {
            //do data processing here
        }
    }
}

Thanks again for any help.

Haz

Re: Generic Collection &Method Problem

Christian Graus17-Jun-07 12:24

Christian Graus

17-Jun-07 12:24

haz13 wrote:
(for Card1 upto Card100)

As someone else said, instead of having 100 fields, have a collection which contains them ( and if they are named card1-card100, an array makes sense, you just put the number in the indexer ). Then you can iterate over them with foreach to do your test.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Export data to excel sheet

HexaDeveloper17-Jun-07 9:32

HexaDeveloper

17-Jun-07 9:32

hi all,

l made a class and i want to export its values stored in members data to an excel file
can any one give me a beginning
my class like

<br />
static class Export<br />
{<br />
private static ArrayList arrivalRate = new ArrayList();<br />
private static ArrayList customersNo = new ArrayList();<br />
}<br />

and i wanna to make member data is the header of the row and the values in the arraylist are in squence in the adjacent cells.

also i wanna to ask about automatic documentation, i used SandCastle but i cannot deal correctly with it, so can any one give me a program that only executable file i give it the file path only like what happened in javadoc.exe

thanx

Generator

Re: Export data to excel sheet

Jimmanuel18-Jun-07 3:48

Jimmanuel

18-Jun-07 3:48

Excel Automation : MSDN[^]

Javadoc for C#: XML Comments[^] or NDoc[^]

Re: Export data to excel sheet

HexaDeveloper21-Jun-07 2:17

HexaDeveloper

21-Jun-07 2:17

Hi,

thanx for ur help ur information make me make it successfully

thanx alot

Generator

Re: Export data to excel sheet

Jimmanuel21-Jun-07 2:23

Jimmanuel

21-Jun-07 2:23

glad to help Smile | :)

ComboBox change font on specific item..

akkram17-Jun-07 9:16

akkram

17-Jun-07 9:16

Hello. I have a combobox with a couple of items in it. Instead of having a label on the form that describes the content of the combobox id like to use the textproperty for this purpose. So far so fine. But now I want to change the textproperty of the combobox to italic but leave the rest of the items in the combobox as regular text. Anyone knows how I can do this.
As it is now when i change the combobox.Font.Italic prop all the items in the collection is set to italic.

//Thx

Re: ComboBox change font on specific item..

Dave Kreskowiak17-Jun-07 12:38

Dave Kreskowiak

17-Jun-07 12:38

It's all or nothing using the standard control.

If you wanted more control over the textbox and the list fonts, you'd have to create your own version that supports this, supplying the properties to be set for each side of the control and supplying all the rendering code to draw the textbox and the drop down list.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Connecting to FTP site

frqftgbdafr17-Jun-07 9:01

frqftgbdafr

17-Jun-07 9:01

I have a program that will connect to an FTP site with InternetConnect() if I use my Windows dialer.

If I try to connect to the FTP site using another dialer there is no connection to FTP site.

My Windows dialer has my user name and password for my ISP, but the other dialer does not, it just dials and connects.

I am confused, how can the other dialer connect without my ISP username and password? This is probably why I cannot connect to FTP site.

I can make a connection with the other dialer using HTTP settings and using a www.myspace.net address, but if I switch over to FTP settings and use ftp.myspace.net, no connection.

Please excuse me if I sound confused, I am, and I can't seem to get my brain wrapped around these concepts.

Thanks for any help.

The DateTime Value Type

Brendan Vogt17-Jun-07 8:24

Brendan Vogt

17-Jun-07 8:24

Hi,

Is it possible to assign a null to a DateTime value type? If not, what then?

Regards
ma se

Re: The DateTime Value Type

Guffa17-Jun-07 8:54

Guffa

17-Jun-07 8:54

ma se wrote:
Is it possible to assign a null to a DateTime value type?

No, it's not.

You can only assign null to a reference, and as DateTime is a value type, there is no reference.

ma se wrote:
If not, what then?

If you are using framework 2.x, you can use the nullable types:

DateTime? when;
if (something) {
   when = null;
} else {
   when = DateTime.UtcNow;
}
if (when.HasValue) {
   Console.WriteLine(when.Value.ToString("yyyy-MM-dd"));
} else {
   Console.WriteLine("No time specified.");
}

If you are using framework 1.x, you have to do something else to keep track of when there is a value or not, like using a bool variable along with the DateTime variable.

---
single minded; short sighted; long gone;

Re: The DateTime Value Type

Brendan Vogt17-Jun-07 9:03

Brendan Vogt

17-Jun-07 9:03

Thanks for the reply, but I struggle to see where you assigned it a nullable value?

Re: The DateTime Value Type

User 665817-Jun-07 9:11

User 6658

17-Jun-07 9:11

It's the question mark behind the type name.
See this for more information:

http://msdn2.microsoft.com/en-us/library/1t3y8s4s(VS.80).aspx

regards

modified 12-Sep-18 21:01pm.

Re: The DateTime Value Type

Luc Pattyn17-Jun-07 9:34

Luc Pattyn

17-Jun-07 9:34

You can solve this with a nullable type (since .NET 2.0)

or you might be able to set aside one value and let it represent the "has no value" situtation;
in case of DateTime it probably would be DateTime.MinValue

Smile | :)

Luc Pattyn

[My Articles] [Forum Guidelines]

Re: The DateTime Value Type

PIEBALDconsult17-Jun-07 14:45

PIEBALDconsult

17-Jun-07 14:45

Yeah, that's what I do.

Creating list of method execution time

AndrusM17-Jun-07 5:10

AndrusM

17-Jun-07 5:10

Winforms .net 2 application is running a bit slow.

How to find which methods take most of the time?

I'm using Visual C# 2005 Express Edition.
I havent found any way to create list of executed method calls ordered by execution time.

There a a lot of PostgreSQL database calls to show report.
I think some database calls take too lot time in summary.

Andrus

Re: Creating list of method execution time

Guffa17-Jun-07 7:05

Guffa

17-Jun-07 7:05

I would say that it's most likely that the performance problems are in the sql queries, at least without seeing any of the code.

The SqlConnection object can collect statistics about all queries made with it. Check if the connection object that you are using has something similar.

---
single minded; short sighted; long gone;

Re: Creating list of method execution time

AndrusM18-Jun-07 3:07

AndrusM

18-Jun-07 3:07

I checked NpgsqlConnection object documentation.
I does not contain any method for statistics collection.

Andrus

Re: Creating list of method execution time

User 665817-Jun-07 7:34

User 6658

17-Jun-07 7:34

I use this tool to find bottlenecks in my application, it's a really powerful profiler.

regards

modified 12-Sep-18 21:01pm.

How can I search for a record without using Primary key

Jon Stroh17-Jun-07 4:39

Jon Stroh

17-Jun-07 4:39

I would like to know how to search for a certain record by a value in a non keyed column, then being able to update that record to the values in another table. Here is what I have used in the past to locate a record by a primary key, is there a way to do the same with out a keyed column as a search value.Do I need to set the primary key temporarily to the new column I need to search?

DataSet1.HorseJoinTableDataTable dth = new DataSet1.HorseJoinTableDataTable();

DataSet1TableAdapters.HorseJoinTableTableAdapter tah = new FBWinMobileSync.DataSet1TableAdapters.HorseJoinTableTableAdapter();

dataSet1.EnforceConstraints = false;

tah.FillByMod(dth);

fB7MobileDBDataSet.EnforceConstraints = false;

foreach (DataSet1.HorseJoinTableRow dr in dth.Rows)

try

{ How can I accomplish this below on a non keyed column search

FB7MobileDBDataSet.HorseRow newMobileHorse = this.fB7MobileDBDataSet.Horse.FindByCODEHorseName(dr.CODE, dr.HORSENAME);

newMobileHorse.CODE = dr.CODE;

newMobileHorse.Stable = dr.STABLE;

newMobileHorse.HorseName = dr.HORSENAME;

newMobileHorse.Active = dr.ACTIVE;

newMobileHorse.AngleLF = dr.ANGLELF;

newMobileHorse.AngleLH = dr.ANGLELH;

newMobileHorse.AngleRF = dr.ANGLERF;

newMobileHorse.AngleRH = dr.ANGLERH;

dataSet1.EnforceConstraints = false;

//if(dr.DUEDATE.ToString().Trim()=="")

if (dr.IsNull("DUEDATE"))

dr.DUEDATE = DateTime.Today;

newMobileHorse.DueDate = dr.DUEDATE;

if (dr.IsNull("LASTCOST"))

dr.LASTCOST = "0";

double D = Convert.ToDouble(dr.LASTCOST);

newMobileHorse.LastCost = D; //Convert.ToDouble(dr.LASTCOST);

newMobileHorse.Totals = 3;

//Equals no change to record

if (dr.IsNull("LASTDATE"))

dr.LASTDATE = DateTime.Today;

newMobileHorse.LastDate = dr.LASTDATE;

newMobileHorse.LengthLF = dr.LENGTHLF;

newMobileHorse.LengthLH = dr.LENGTHLH;

newMobileHorse.LengthRF = dr.LENGTHRF;

newMobileHorse.LengthRH = dr.LENGTHRH;

newMobileHorse.MainWork = dr.MAINWORK;

newMobileHorse.NickName = dr.NICKNAME;

newMobileHorse.SizeLF = dr.SIZELF;

newMobileHorse.SizeLH = dr.SIZELH;

newMobileHorse.SizeRF = dr.SIZERF;

newMobileHorse.SizeRH = dr.SIZERH;

newMobileHorse.Weeks = Convert.ToInt16(dr.WEEKS);

newMobileHorse.Delete = dr.DELETE;

newMobileHorse.LengthList = dr.LENGTHLIST;

newMobileHorse.NeedsNewFr = dr.NEEDS_NEW_FR;

newMobileHorse.NeedsNewHd = dr.NEEDS_NEW_HD;

newMobileHorse.StartAngleLF = dr.START_ANGLE_LF;

newMobileHorse.StartAngleLH = dr.START_ANGLE_LH;

newMobileHorse.StartAngleRF = dr.START_ANGLE_RF;

newMobileHorse.StartAngleRH = dr.START_ANGLE_RH;

newMobileHorse.StartLengthLF = dr.START_LENGHT_LF;

newMobileHorse.StartLengthLH = dr.START_LENGTH_LH;

newMobileHorse.StartLengthRF = dr.START_LENGHT_RF;

newMobileHorse.StartLengthRH = dr.START_LENGTH_RH;

newMobileHorse.Front = dr.FRONT;

newMobileHorse.Hind = dr.HIND;

--------------------------------------------------------------------------------
Jon Stroh

Thanks Jon Stroh

Re: How can I search for a record without using Primary key

WillemM17-Jun-07 8:15

WillemM

17-Jun-07 8:15

DataSet ds = new DataSet();
DataTable table = new DataTable();

ds.Tables.Add(table);

DataRow rows[] = table.Find("MyField = 'Hello World');

That should do the trick.

WM.

What about weapons of mass-construction?
"What? Its an Apple MacBook Pro. They are sexy!" - Paul Watson
My blog

Re: How can I search for a record without using Primary key

Jon Stroh18-Jun-07 2:35

Jon Stroh

18-Jun-07 2:35

Thank You very much, I sure wish I could learn how to search vs2005's help file. Even after you gave me this code I can't find any help on .Find for tables. Thanks for your reply though with out it I would be dead in the water Smile | :)

Jon Stroh

Custom User Control and Repeater

Expert Coming17-Jun-07 4:34

Expert Coming

17-Jun-07 4:34

I am using a Repeater to make a menu off a SiteMap. I also made a custom user control that is a cool looking button. The button's events work fine and the properties work fine as long as I am not in a repeater control. If I use the repeater control I get a NullReferenceException because as far as I can see all my properties are null on postback.

How can I get all my properties to save?

The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo

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