C# Simple Statistics

[karenRoss]

I have an employee directory, but I want to see how many unique last name were typed in the search and how many times each last name was typed in?

I'm just not sure which direction I should take to go about this data collection

any thoughts?

[nateraaaa]

I have an employee directory, but I want to see how many unique last name were typed in the search and how many times each last name was typed in?

I'm just not sure which direction I should take to go about this data collection

any thoughts?

You will need to save the last name searched for in a database table. Then you can run queries on this data to determine how many names have been searched for and also how many names are unique.

You could also just get the names that have been searched for (using a database query) then (in the code behind) find the unique names by adding these names (names returned by your query) to an arraylist then looping through the arraylist to find the unique names.

I have some sample code for finding unique items in an arraylist if you need it. Just let me know.

Nathan

[karenRoss]

You will need to save the last name searched for in a database table. Then you can run queries on this data to determine how many names have been searched for and also how many names are unique.

You could also just get the names that have been searched for (using a database query) then (in the code behind) find the unique names by adding these names (names returned by your query) to an arraylist then looping through the arraylist to find the unique names.

I have some sample code for finding unique items in an arraylist if you need it. Just let me know.

Nathan

Of course I'll take that sample code. I just figured I'd throw in a feature to see who is searched for the most on the directory. just for fun today.

[nateraaaa]

Of course I'll take that sample code. I just figured I'd throw in a feature to see who is searched for the most on the directory. just for fun today.

I found this code while searching for a to remove duplicates.

http://authors.aspalliance.com/olson/methods/RemoveDups.aspx

Hope this helps.

Nathan

[karenRoss]

The only problem I'm having now is getting my data sql adapter into an array

[nateraaaa]

The only problem I'm having now is getting my data sql adapter into an array

Use your dataadapter to fill a dataset then use a for loop to assign each element in the array

ArrayList array = new ArrayList();
for(int i = 0; i < dataset.Tables[0].Rows.Count; i++)
{
if (!array.Contains(dataset.Tables[0].Rows[i]["LastName"].ToString().Trim()))
{
array.Add(dataset.Tables[0].Rows[i]["LastName"].ToString().Trim()));
}

}

this should work.

Nathan

[karenRoss]

great! just as i was getting into this someone came in and dropped a project on my desk :(

i better get to it.