.NET (Core and Framework)

13-Feb-06 5:05

Hi to all. I have a problem with my thesis. I'm realizing an application with VS .Net 2003 for PDA in C#.
I have a catalog stored into the PDA and I want to navigate into it.
I've builded a database which consists of 4 important tables: three categories tables (First, Second and Third) and the "Products" table.
I use a ListView object to navigate inside the categories. The code is this (I bolded the important part):

using System;

using System.Drawing;

using System.Collections;

using System.ComponentModel;

using System.Windows.Forms;

using System.Data.SqlServerCe;

using System.Data.SqlClient;

using System.Data;

using System.Reflection;

using System.IO;

namespace SmartDeviceApplication3

{

///

/// Form per sfogliare il catalogo - Form to navigate inside the catalog

///

public class FormSfogliaCatalogo : System.Windows.Forms.Form

{

private System.Windows.Forms.Panel panel1;

private System.Windows.Forms.Label label8;

private System.Windows.Forms.Label label7;

private System.Windows.Forms.Label label6;

private System.Windows.Forms.Label label5;

private System.Windows.Forms.PictureBox pictureBox3;

private System.Windows.Forms.PictureBox pictureBox2;

private System.Windows.Forms.PictureBox pictureBox1;

private System.Windows.Forms.PictureBox pictureBox4;

private System.Windows.Forms.MainMenu mainMenu1;

private System.Windows.Forms.ListView listViewCatalogo;

public FormSfogliaCatalogo()

{

//

// Required for Windows Form Designer support

//

InitializeComponent();

listViewCatalogo.Activation = ItemActivation.OneClick;

listViewCatalogo.View = System.Windows.Forms.View.SmallIcon;

//Declare the connection variable

SqlCeConnection sqlConn1 = new SqlCeConnection();

try

{

// Open a connection to the database

sqlConn1.ConnectionString = "Data Source =\\My Documents\\db.sdf";

sqlConn1.Open();

SqlCeCommand searchCommand = new SqlCeCommand();

searchCommand.Connection = sqlConn1;

searchCommand.CommandText = "SELECT * FROM TIPOLOGIA_PRIMARIA"; // it means select * from first category

// Execute and return the rows in the data reader object

SqlCeDataReader dR;

dR = searchCommand.ExecuteReader(CommandBehavior.CloseConnection);

int nFields = dR.FieldCount;

// Setup the columns in the listview using the fields in the table

listViewCatalogo.Clear();

listViewCatalogo.Columns.Add("Categoria", -1, HorizontalAlignment.Left);

// Fill the rows in the listview using the data in the rows

int nRow = 0;

while (dR.Read())

{

// Create an array of subitems for quick insertion

// The subitems will be all fields in the row except for

// the first field

String [] subitems = new String[nFields];

subitems[0] = dR[3].ToString();

// Insert a new item into the listview, and add the subitems at

// the same time. The item will be the first field in the row

ListViewItem item = new ListViewItem(subitems);

listViewCatalogo.Items.Add(item);

ImageList imageListSmall = new ImageList();

imageListSmall.ImageSize = new Size(30,30);

imageListSmall.Images.Add(LoadImage("Dir.bmp"));

listViewCatalogo.SmallImageList = imageListSmall;

listViewCatalogo.Items[nRow].ImageIndex = 0;

++nRow;

}

dR.Close();

}

catch (Exception ex)

{

// If an error occured alert the user

MessageBox.Show("Error: " + ex.Message);

}

finally

{

// Close the connection if necessary

if (sqlConn1.State == System.Data.ConnectionState.Open)

sqlConn1.Close();

}

//

// TODO: Add any constructor code after InitializeComponent call

//

}

///

/// Clean up any resources being used.

///

protected override void Dispose( bool disposing )

{

base.Dispose( disposing );

}

#region Windows Form Designer generated code

///

/// Required method for Designer support - do not modify

/// the contents of this method with the code editor.

///

private void InitializeComponent()

{

System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(FormSfogliaCatalogo));

this.listViewCatalogo = new System.Windows.Forms.ListView();

this.panel1 = new System.Windows.Forms.Panel();

this.label8 = new System.Windows.Forms.Label();

this.label7 = new System.Windows.Forms.Label();

this.label6 = new System.Windows.Forms.Label();

this.label5 = new System.Windows.Forms.Label();

this.pictureBox3 = new System.Windows.Forms.PictureBox();

this.pictureBox2 = new System.Windows.Forms.PictureBox();

this.pictureBox1 = new System.Windows.Forms.PictureBox();

this.pictureBox4 = new System.Windows.Forms.PictureBox();

this.mainMenu1 = new System.Windows.Forms.MainMenu();

//

// listViewCatalogo

//

this.listViewCatalogo.HeaderStyle = System.Windows.Forms.ColumnHeaderStyle.None;

this.listViewCatalogo.Location = new System.Drawing.Point(0, 56);

this.listViewCatalogo.Size = new System.Drawing.Size(256, 216);

this.listViewCatalogo.SelectedIndexChanged += new EventHandler(this.listViewCatalogo_SelectedIndexChanged);

this.Controls.Add(listViewCatalogo);

//

// panel1

//

this.panel1.BackColor = System.Drawing.Color.Gainsboro;

this.panel1.Controls.Add(this.label8);

this.panel1.Controls.Add(this.label7);

this.panel1.Controls.Add(this.label6);

this.panel1.Controls.Add(this.label5);

this.panel1.Controls.Add(this.pictureBox3);

this.panel1.Controls.Add(this.pictureBox2);

this.panel1.Controls.Add(this.pictureBox1);

this.panel1.Controls.Add(this.pictureBox4);

this.panel1.Size = new System.Drawing.Size(256, 56);

//

// label8

//

this.label8.Font = new System.Drawing.Font("Microsoft Sans Serif", 7.25F, System.Drawing.FontStyle.Regular);

this.label8.ForeColor = System.Drawing.Color.Blue;

this.label8.Location = new System.Drawing.Point(136, 32);

this.label8.Text = "Offerte e promozioni";

//

// label7

//

this.label7.Font = new System.Drawing.Font("Microsoft Sans Serif", 7.25F, System.Drawing.FontStyle.Regular);

this.label7.ForeColor = System.Drawing.Color.Blue;

this.label7.Location = new System.Drawing.Point(32, 32);

this.label7.Size = new System.Drawing.Size(80, 20);

this.label7.Text = "Cerca prodotto";

//

// label6

//

this.label6.Font = new System.Drawing.Font("Microsoft Sans Serif", 7.25F, System.Drawing.FontStyle.Regular);

this.label6.ForeColor = System.Drawing.Color.Blue;

this.label6.Location = new System.Drawing.Point(136, 8);

this.label6.Text = "Sfoglia catalogo";

//

// label5

//

this.label5.Font = new System.Drawing.Font("Microsoft Sans Serif", 7.25F, System.Drawing.FontStyle.Regular);

this.label5.ForeColor = System.Drawing.Color.Blue;

this.label5.Location = new System.Drawing.Point(32, 8);

this.label5.Size = new System.Drawing.Size(80, 20);

this.label5.Text = "Aggiornamento";

//

// pictureBox3

//

this.pictureBox3.Image = ((System.Drawing.Image)(resources.GetObject("pictureBox3.Image")));

this.pictureBox3.Location = new System.Drawing.Point(112, 8);

this.pictureBox3.Size = new System.Drawing.Size(20, 20);

this.pictureBox3.SizeMode = System.Windows.Forms.PictureBoxSizeMode.CenterImage;

//

// pictureBox2

//

this.pictureBox2.Image = ((System.Drawing.Image)(resources.GetObject("pictureBox2.Image")));

this.pictureBox2.Location = new System.Drawing.Point(8, 32);

this.pictureBox2.Size = new System.Drawing.Size(20, 20);

this.pictureBox2.SizeMode = System.Windows.Forms.PictureBoxSizeMode.CenterImage;

//

// pictureBox1

//

this.pictureBox1.Image = ((System.Drawing.Image)(resources.GetObject("pictureBox1.Image")));

this.pictureBox1.Location = new System.Drawing.Point(8, 8);

this.pictureBox1.Size = new System.Drawing.Size(20, 20);

this.pictureBox1.SizeMode = System.Windows.Forms.PictureBoxSizeMode.CenterImage;

//

// pictureBox4

//

this.pictureBox4.Image = ((System.Drawing.Image)(resources.GetObject("pictureBox4.Image")));

this.pictureBox4.Location = new System.Drawing.Point(112, 32);

this.pictureBox4.Size = new System.Drawing.Size(20, 20);

this.pictureBox4.SizeMode = System.Windows.Forms.PictureBoxSizeMode.CenterImage;

//

// FormSfogliaCatalogo

//

this.ClientSize = new System.Drawing.Size(258, 270);

this.Controls.Add(this.panel1);

this.Controls.Add(this.listViewCatalogo);

this.Menu = this.mainMenu1;

this.Text = "Catalogo";

}

#endregion

public void listViewCatalogo_SelectedIndexChanged(object sender, System.EventArgs e)

{

int sum = listViewCatalogo.SelectedIndices.Count;

int i;

i = listViewCatalogo.SelectedIndices[0];

if(listViewCatalogo.Items[i].Selected == true)

{

//to test the program

FormProdotto frm = new FormProdotto(i);

frm.Show();

return;

}

}

...

}

}

There are some problems:

1. If I deploy, I have no errors, but in executing phase I have error because the initialization of the listViewCatalogo.SelectedIndexChanged event is not correct, because it needs the items of the listview which are created dynamically (inside the "while dR.Read" clause);

2. If I put the eventhandler inside the "while clause", I have the problem that, for each row the listview creates dynamically, there is a call to my event (so I have X calls while I should have just one call, corresponding to the single item clicking).

I don't know where to initializes my event. Does anyone have a suggest?

Thank you.

Greetings from Italy

Nino

PS: Sorry for my bad English....

HumanOsc13-Feb-06 5:49

HumanOsc

13-Feb-06 5:49

1.) You can use the SelectedIndex Property to check if an item is selected...

<br />
if(listView.SelectedIndex == -1)<br />
  return;<br />

2.) It's recommend to disabling the updateing mechanism when you are adding items...

<br />
// disable updating mechanism<br />
listView.BeginUpdate();<br />
<br />
while(...)<br />
{<br />
// adding items here<br />
}<br />
<br />
// enable updating mechanism<br />
listView.EndUpdate();<br />
<br />

By the way you should named you variables more significant...
Wink | ;)

ninodago14-Feb-06 1:00

14-Feb-06 1:00

HumanOsc wrote:
1.) You can use the SelectedIndex Property to check if an item is selected...

if(listView.SelectedIndex == -1)
return;

I don't have the definition SelectedIndex inside ListView. ('System.Windows.Forms.ListView' does not contain a definition for 'SelectedIndex')... I use VS .Net 2003 with CF 1.0.
I used this code, but I'm not sure if it has the same effect...
if (listViewCatalogo.SelectedIndices[0] == -1)
return;

Another question. In which point of the program should I use this code? Inside the definition of listViewCatalogo_SelectedIndexChanged event?

When I deploy I have the same errors. If I declare the control inside or outside the while clause I have this message: Error: index (I mean, the variable passed to the last testing form(FormProdotto).

Guffa13-Feb-06 6:03

Guffa

13-Feb-06 6:03

Show only the relevand code, and use the pre tag to make it readable.

---
b { font-weight: normal; }

ninodago13-Feb-06 22:55

13-Feb-06 22:55

sorry, it was my first message and it was very important for me, I'll remember for the next time!
thank you

HumanOsc14-Feb-06 1:27

HumanOsc

14-Feb-06 1:27

Ok, sorry it was my fault... Sometimes i mix two different classes...

I mean the SelectedItems Property...

<br />
if(listView.SelectedItems.Count == 0)<br />
  return;<br />

You should check the collection if it's contains items, before you get anyone...

Well, in your app in the SelectedIndex_Changed handler...

<br />
// get sure that one item is selected<br />
if(listViewCatalogo.SelectedItems.Count == 0)<br />
  return;<br />
<br />
i = listViewCatalogo.SelectedIndices[0];<br />
<br />

-- modified at 7:28 Tuesday 14th February, 2006

ninodago14-Feb-06 6:02

reading third party Snap-in information in MMC programatically

14-Feb-06 6:02

Thanks a lot, I made the changes and now the running is quite good!

Bye
Nino

Look Torino 2006 - - - - - FORZA ITALIA!!!

krompo13-Feb-06 4:36

krompo

13-Feb-06 4:36

hi everyone,

I would need to get access to third party snapins in MMC so I can read information from these MMC snapins and store this information somewhere else into a text file. I don't need to modify this information, I only need to retrieve it, so I don't need to work with MMC manually in GUI form but can create reports in text file form from these MMC snapins. Do you have any idea if there is a way how to get this information from 3rd party snapins programatically (if possible in a consistent way) ?

thanks & regards,

krompo

Socket Exception Delay??

ckaneAV10-Feb-06 9:04

ckaneAV

10-Feb-06 9:04

i am trying to build a "missed message" queue on a C# TCP server. many
of the devices connecting are mobile and may drop out in bad signal
areas. i want to store any messages missed for when they reconnect.

so far....it takes activity on the client end to initialize the close.
isnt there a check when the server sends a socket.send to a client that
has lost connection? it takes a few minutes for the exception to get
hit, and i am losing vital time.

is there a way for as soon as the the server attempts Socket.Send it
can tell if the device on the other end still has an active connection?

even Socket.Poll() has quite a delay.

i have been testing with desktops. I connect two workstations to the
server and when i chat back and forth, i unplug one from the network.
it takes at least two minutes for the server to recognize that one
client is disconnected while the still-connected client is sending
messages. it seems they are just going nowhere.

activex .ocx with c# and visual studio .net

kopi_b10-Feb-06 3:14

kopi_b

10-Feb-06 3:14

please,

how can i make an activex control (i need an ocx file! and not a dll) with visual studio .net and c#?

thanks! kopi_b

Re: activex .ocx with c# and visual studio .net

Dave Kreskowiak10-Feb-06 5:56

Dave Kreskowiak

10-Feb-06 5:56

Don't corss post in multiple forums. It's considered rude...

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

.Net Framework Security

Indu Mahadevan9-Feb-06 19:03

Indu Mahadevan

9-Feb-06 19:03

In a vb. Net application I have to set user Level Code ACcess Permission. a Program Manager user can select a user and select applications he has permission to access.
So that when next time that user loggs in he won't be able to access those applications which he has no permission. I am not able to find a way to set Userwise FileIoPermissions . Pls Help me . Confused | :confused:

Indu

Framework version issue

Lisana9-Feb-06 11:01

Lisana

9-Feb-06 11:01

I have an app created by VS2003. The launch conditions of .net framework's supportedRuntime is V1.1.4322. It can be installed in those machine had this version. I have another machine that only have the newest version framework V2.0. When I installed it, it asks me to install the .net framework V1.1.4322. I think that should not happen when the computer has the newest version .net framework in it. But my app can't be installed. Is there anybody know how to solve this issue?

THANKS!!

Lisa

Dave Kreskowiak10-Feb-06 6:06

Dave Kreskowiak

10-Feb-06 6:06

You might want to test your application under the 2.0 Framework before you worry about its installation. Breaking Changes in .NET Framework 2.0[^].

You'll just have to change the installer for the app. You could get away with removing the .NET Framework dependancy or possibly just changing the version of the dependancy to 2.0.(something I can't remember offhand).

The code itself will launch (by default) under the latest runtime if the specified runtime is not available. That doesn't mean that it'll work 100% the same as it did under 1.1.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Lisana10-Feb-06 6:16

Lisana

10-Feb-06 6:16

I have changed the version of the dependancy to 2.0.50727, and it works fine under the 2.0 framework. But when I test in another workstation only have .net framework 1.1. The installation request it to install the .Net Framework 2.0, but my application should run under .net framework 1.1 without any problem.

How can I work around this? When the workstation has .Net framework version 1.1 and up, it doesn't need to install any more .net framework.

THanks, Dave!

Lisa

-- modified at 12:17 Friday 10th February, 2006

Dave Kreskowiak10-Feb-06 9:19

Dave Kreskowiak

10-Feb-06 9:19

Whoops! My bad! It's a Dependancy, so without that version, the app won't install. You can put the version number back to the original value, then set the AllowLaterVersions property of the .NET Framework dependency to True. By doing this, you're specifying that your app needs at least version 1.1 of the Framework installed. Newer versions are acceptable for installation.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome