Noob question: Displaying a List in a ListView - C# Discussion Boards

Display Datetime As per GMT

1-May-09 23:32

Well, I don't know. When I did this, none of the pages I targeted used javascripts for server interaction so it was easy to simulate clicking with HttpWebRequest/Response classes. In your case, I guess you'll have to emulate the javascript flow, as browsers do, to get the idea what the actual request should be. Unless someone else has something to say.
H.

Sun Rays1-May-09 19:35

Sun Rays

1-May-09 19:35

Hello All,
I am running on .Net Framework 2.0.
creating WEB Application.

I have a different users from different country. And I have property LOCATION for a User as well.
Now if UserA logged in and it's from UK country then all time should be display as per UK time. So i want to globalize the application. How can I do this ?

Kindly help into this.

Thanks.

Thanks,
Sun Rays

To get something you must have to try once.

My Articles

How to connect excel database

kaushik_dass1-May-09 19:34

kaushik_dass

1-May-09 19:34

I am working on server 2003.i am trying to connect excel database but it shows error could not find installable ISAM.
Please Help me.

here is my code
string strcnn=@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +strpath + ";Extended Properties=Excel 8.0;HDR=Yes";
oledbcon=new oledbcon(strcnn);
oledbcmd=new oledbcmd("select * from[QE150409$]",oledbcon);
oledbda=new oledbda(oledbcmd);
ds=new dataset();
oledbda.fill(ds,"e1");
DataGridView.Datasource=ds.Tables[0].DefaultView;

Re: How to connect excel database

Sun Rays1-May-09 19:38

Sun Rays

1-May-09 19:38

Hey,
check this.

http://www.google.co.in/search?q=could+not+find+installable+ISAM&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a[^]

Thanks,
Sun Rays

To get something you must have to try once.

My Articles

Noob question: Displaying a List in a ListView

Quake2Player1-May-09 19:00

Quake2Player

1-May-09 19:00

Hi,
I want to know if this is the way to work with ListViews:

I noticed that ListViews contain strings only.. so.. if I have a List of persons List<Person>, and each Person has properties Id, Name, Age, and much more.

I want to display only name and age (there are two columns in the ListView: Name, Age),

My question:
I'd like to work with the Person (object Person!) selected.. I'm currently doing it this way:

Adding the items to the list:

foreach (Person person in personList)
{
                ListViewItem lvi = new ListViewItem();
                lvi.SubItems.Add(person.Name);
                lvi.SubItems.Add(person.Age.ToString());
                lvi.SubItems.Add(person.Id.ToString()); 

                listView1.Items.Add(lvi);
}

And the subitem Id is not listed because of "lack of column", i mean: There are two columns.. so Id is not displayed because it would need 3 columns..

Then, that way i can use the Id of the person and refer to the object..

Is this the way one would do that ? I suppose not because it doesnt look very nice..
In fact if i would add later a new column i would have to change things

Help please!

Member 10339071-May-09 22:34

1-May-09 22:34

You've got it almost right. The property used for storing info about items is called Tag. For other purposes (when addressing items in the ListView if you don't know the index) you might like Name.
Also - the leftmost column is somewhat main and contains SubItems that specify text displayed in other comlums. Therefore set the Text and Tag property of the leftmost column and populate its subitems (the way you do) to specify the text of other coumns.
The code:

foreach (Person person in personList)
{
  ListViewItem lvi = new ListViewItem(person.Name); // sets the text of the main (leftmost) column
  lvi.Tag = person.Id; // no need for conversion, .Tag is of type object
  lvi.SubItems.Add(person.Age.ToString());
  listView1.Items.Add(lvi);
}

Hope it helps, H.

DaveyM691-May-09 23:24

DaveyM69

1-May-09 23:24

The previous answer was good!

If you're going to need this functionality alot then it can be useful to create a ToListViewItem method in the Person class.

Also, if a reference to the person object itself would be useful (sometimes it can be easier to deal with the object rather than one of its properties to save multiple lookups etc) then you can put that into the Tag instead - just cast the Tag back to Person when you need it.

public ListViewItem ToListViewItem()
{
    ListViewItem result = new ListViewItem(Name); // using name here saves you creating the item for the first column!
    result.Tag = this;
    result.SubItems.Add(Age.ToString());
    return result;
}

Add like this:

foreach (Person person in personList)
{
    listView1.Items.Add(person.ToListViewItem());
}

To get the object:

Person selectedPerson = (Person)listView.Items[itemIndex].Tag;
// ID is available in selectedPerson.ID

Nothing wrong with the previous answer, just throwing a couple more ideas out there Big Grin | :-D

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)

Quake2Player2-May-09 8:41

Quake2Player

2-May-09 8:41

The two ways totally helped me understanding how to work with ListView, thank you guys!!

Though I have a doubt about the two replies,
you both told me to put person.Name in the first column.. but, if I need to put a checkbox column?

And Dave, respect to your answer,
I really find it a good idea, in fact i'm going to do it that way, but..
I've been told not to produce cycles between packages, and I have the ClassLibrary package which contains the Persons, etc, etc. and the WindowsFormsApp which would have the ListView and etc. Is it ok to return a ListView from the ClassLibrary?

Thanks again Smile | :)

DaveyM693-May-09 0:28

DaveyM69

3-May-09 0:28

If you want name in a different column then add it as a sub item.

Your other point is a good question. It depends on just how fussy you want/need to be.

Quake2Player wrote:
Is it ok to return a ListView

Making the Person class reliant on a list view would be a bad idea:

// DO NOT do this!
public void AddToListView(ListView listView)
{
    ListViewItem listViewItem = new ListViewItem(Name);
    // ...
    listView.Items.Add(listViewItem);
}

but in my opinion, returning a ListViewItem from the class is OK as it doesn't rely on any existing object instance to be able to perform the method. I would draw the line at a ListViewItem (or a List<ListViewItem> or ListViewItem[] for a collection), returning an entire ListView would be taking it too far.

Not everyone would agree that returning a ListViewItem is OK - if this is for work/college, ask your boss/tutor for their opinion. The way you were doing it is good, but the reusability of having a method like that in the class (especially if it's going to be used a lot) can be advantageous.

Another minor thing that's often worth doing (along the same lines) is to override the ToString method e.g.

public override string ToString()
{
    return string.Format("Name: {0}, Age: {1}", Name, Age);
}

This is a very standard thing to do and not that disimilar to what I suggested.

DateTime problem

soulidentities1-May-09 17:26

soulidentities

1-May-09 17:26

Hi ppl
In my sql server 2005 database I have a column named "VistDate" in a table. Data type is DateTime and formate is short Date. when I try to get a date from that column and take it in a textbox it appears, if the date is 10/10/2009, it works fine. But if the date is
like 6/7/2009, it splits. Reason is I want to get indivisual formate: like

VisitorDate = row["VistDate"].ToString();
txtVisDay.Text = VisitorDate.ToString().Substring(0, 2);
txtVisMon.Text = VisitorDate.ToString().Substring(3, 2);
txtVisYr.Text = VisitorDate.ToString().Substring(6, 4);

Result:
6/
7/
09...
result is spliting.
But if the date is 10/10/2009 then it appears perfect.
Ques is converting 6/7/2009 to 06/07/2009?

whats the solution
Thanks in advance

Garth J Lancaster1-May-09 18:29

1-May-09 18:29

for that sort of thing you would really have to tokenise it - based on the '/'

The Substring will work fine if each data part always has exactly the same amount of characters, eg dates/months < 10 are padded with a leading '0'

When I read dates from Oracle (so Im not sure about Sql Server), I explicitly tell Oracle in the sql select statement to return the date in a particular format, which includes padding etc

oh, please dont use 'text speak' like 'ppl', 'Ques', and try to make more of an effort with spelling

'g'

J4amieC1-May-09 22:56

J4amieC

1-May-09 22:56

This is entirely the wrong answer, the DateTime object obtained using row["VisitDate"] has methods for obtaining the Day, Month and Year of that instance.

Your database should not be responsible for formatting anything, least of all Dates.

Garth J Lancaster1-May-09 23:58

1-May-09 23:58

shows you how much I know about Sql server then - I didnt know it returned a DateTime object, which yes, should have methods for obtaining parts of the date.

J4amieC wrote:
Your database should not be responsible for formatting anything, least of all Dates.

So doing a sql query in Oracle and outputting a date column using to_char(column, 'output format') is wrong ? ok .. whatever

'g'

J4amieC1-May-09 22:59

J4amieC

1-May-09 22:59

If its stored in Sql Server as datetime or smalldatetime datatype, then the result of the datareader call will be a .NET DateTime instance.

DateTime visitDate = (DateTime)row["VisitDate"];

now that instance has properties representing the Day, Month and Year (as an integer, so remember to .ToString() it when putting it in a textbox.

txtVisDay.Text = visitDate.Day.ToString();

I'll leave the other 2 to your imagination Wink | ;)

soulidentities2-May-09 14:59

soulidentities

2-May-09 14:59

Many Many thanks J4amieC.
Solved. Just a lil edit.

DateTime visitDate = (DateTime)row["VistDate"];
txtVisDay.Text = visitDate.ToString("dd");
txtVisMon.Text = visitDate.ToString("MM");
txtVisYr.Text = visitDate.ToString("yyyy");

Thanks a gain

connect four

Marwa Shams1-May-09 17:25

Marwa Shams

1-May-09 17:25

i want to implement connect four game
one player with computer
-->how can i make play computer?
-->how can i check if the layer or computer won?

Garth J Lancaster1-May-09 18:36

1-May-09 18:36

this doesnt go into great details about what you need, but its a start :-

http://www.codeproject.com/KB/mobile/Connect4.aspx Connect4 using MIN-MAX algorithm[^]

(and its only one way of doing it)

'g'

Member 10339071-May-09 22:36

1-May-09 22:36

Garth J Lancaster wrote:
and its only one way of doing it)

I strongly doubt that.

Garth J Lancaster1-May-09 23:54

1-May-09 23:54

I dont get you - I did not say 'it was the only way' (which would definately make me wrong)

for solving 'simple' issues, there's usually

a) brute force
b) anything smarter than brute force, a class of algorithms - in this case AI MinMax

are you implying that it cant be solved in some brute force manner ?

Member 10339072-May-09 0:30

2-May-09 0:30

My bad, I misunderstood you. I thought you actually said that minimax was the only way of dealing with connect-four, which obviously isn't.
That being said - what exactly do you mean by brute force? How more brute can it get than minimax? Smile | :)