Re: Add data to an ArrayList - C# Discussion Boards

17-Dec-05 6:08

Hi, i try to add data from an Access-database to an ArrayList, so far so good, but something goes wrong, can someone help me...??

public List<cd> cdListe = new List<cd>();

public FyldListe()

{

string dbForbindelse = "provider=Microsoft.Jet.OLEDB.4.0; " + "data
source = C:\\databasenavn.mdb";

string HentAlleData = "SELECT nr, art, model, årgang, navn FROM
oversigt";

OleDbDataAdapter DataAdapter = new OleDbDataAdapter(HentAlleData,
dbForbindelse);

DataSet Datasæt = new DataSet();

DataAdapter.Fill(Datasæt, "oversigt");

DataTable dataTable = Datasæt.Tables[0];

foreach (DataRow dataRow in dataTable.Rows)

{

cdListe.Add(new Kamp(dataRow["nr"], dataRow["art"],
dataRow["model"], dataRow["årgang"]));

}

If i, instead of the last line, write:

listBox1.Items.Add(dataRow["nr"], dataRow["art"], dataRow["model"],
dataRow["årgang"]);

..everything add fine to the listBox.

But the other dosen't work, it say's, that it could not convert from
object to string, and .ToString doesn't help...

what do i do wrong...??

I use visual basic express 2005

(hope u can read my english)

Helge

Robert Rohde17-Dec-05 6:55

17-Dec-05 6:55

I would think it is the Kamp constructor.
I assume the constructor looks something like that:

public Kamp(string nr, string art, srting model, string argang){
//...
}

This means that if you call this constructor you need to pass 4 string parameters, but dataRow["xxx"] returns only an object.
If my constructor assumption is correct you'll need something like that:

cdListe.Add(new Kamp(Convert.ToString(dataRow["nr"]), 
                     Convert.ToString(dataRow["art"]), 
                     Convert.ToString(dataRow["model"]), 
                     Convert.ToString(dataRow["årgang"])));

Duif wrote:
I use visual basic express 2005

No you are obviously using Visual C# Express...

Duif17-Dec-05 7:03

17-Dec-05 7:03

Hi Robert, thank you for the fast reply...,

i will try it immediately...

And of course you are rigth, i use visual studio C# express...

Helge

Duif17-Dec-05 7:59

17-Dec-05 7:59

Hi Robert, it worked...., i'm happy... Smile | :)

Thank you..., have a nice week-end...

Helge

Duif17-Dec-05 9:36

17-Dec-05 9:36

Hi again Robert, can you also tell me, how i get the data from the ArrayList added to a DataGridView....???

I thought, that i could do it in the DataGridView properties, datasource...

Helge

Robert Rohde17-Dec-05 21:06

17-Dec-05 21:06

Depends a little bit on how you bound your data but here are two alternatives:

//1. Access values by row and column number and cast
string nr = (string)_entriesGridView[2, 3].Value;

//2. access via the DataSource property
//get the arraylist
ArrayList list = (ArrayList)_entriesGridView.DataSource;
//get entry
Kamp kamp = (Kamp)list[2];
//and value
string nr = Kamp.Nr;

ListView question

QzRz17-Dec-05 5:33

17-Dec-05 5:33

Hi
I have created a ListView, with View put to Details.
Added a few items, and gave them some subItems.
Then I changed the background colour on all the
items and subItems.

Then when I click on one item it the background on the
first subitem gets gray, and the other subitems get
a white background.

Is it possible to make all the subitems the same colour,
when the item is selected?

Thanks
QzRz

Re: ListView question

cmaissan17-Dec-05 8:43

cmaissan

17-Dec-05 8:43

In the properties for the ListView control you will see a property named "FullRowSelect". Set this property to true.

-Chris

Re: ListView question

QzRz17-Dec-05 9:22

Print the contents of an entire form

17-Dec-05 9:22

It works now Smile | :)

Thanks!

rikkemus17-Dec-05 5:12

rikkemus

17-Dec-05 5:12

Is it possible to print your entire form, with pictureboxes etc.

I know you can use ControlPaint.Button etc to print my controls, but what if i had an entire form(not mainmenu and the things above) i wished to output to my printer?

Re: Print the contents of an entire form

Robert Rohde17-Dec-05 5:50

Re: Print the contents of an entire form

17-Dec-05 5:50

Have you tried searching for print form[^]?

rikkemus17-Dec-05 9:20

rikkemus

17-Dec-05 9:20

Yes but those examples doesnt really do what i want, it has shortcomings when it comes to pictureboxes etc.

In old vb6.0 you could print an entire form, with PrintForm. MSDN makes an example where they Screenshot the memory for the drawed form(since printform isnt in .net), but if some part of the form is outside the screen, it cant dump that.

To me it sound logically, that you should be able to extract the drawed form somehow, even though it isnt on screen. Perhaps build a shadow of it in memory? and then memcpy that to the printerdocument.

Re: Print the contents of an entire form

Robert Rohde17-Dec-05 21:13

17-Dec-05 21:13

You could probably have a look at the WM_PRINT and WM_PRINTCLIENT apis. If I remember correctly they nearly did the same thing as WM_PAINT did with the difference not having an invalid area (i.e. outside of the screen).

C# question...

QzRz17-Dec-05 2:58

17-Dec-05 2:58

Hi
I have created a new Project in VS2003, and added a WindowsForm.
I want the to forms to "communicate". When i call from one to another
I usually create:
public static string/bool/int/etc.
But i want it to do it to:
public static void.

I have done it like this,
public static void Hello()
{
HelloWorld();
}
Where the HelloWorld get data from "private void HelloWorld()"
But that does not work it gives me the error:
'SkoleTing.MainForm.XmlData' denotes a 'field' where a 'class' was expected

I have no clue what I can use instead of the "static", because it is obvious
that I cannot use "static" in this case?

Can anyone help me how to do this?

Thanks
QzRz

Re: C# question...

Michael P Butler17-Dec-05 3:49

Michael P Butler

17-Dec-05 3:49

Is this what you are looking for?[^]

Michael

CP Blog [^] Development Blog [^]

Re: C# question...

QzRz17-Dec-05 3:59