Simplistic Grid

Question

I've got a form on which I'd like to display a "Grid" ( hate to use the word), giving the user the option of amending the Working days per week for each of the 4 Yearly quarters (Q1,Q2,Q3 and Q4) and for each week within each quarter.
So I've got (in essence ) an Array[4,13] which I want to display and to allow the user to edit.
The data to be edited is picked up from a property from a Visio Shape.
Can anyone give me any adice simply on how to display an array, with predetermined values, and then address elements of the array to extract their values?
I've been messing around with DataView Controls, Arrays of Controls, invocation of Excel and I'm at a complete loss as to how I might achieve this simple task without opening a box that I know will cause even more problems.
So, to paraphrase, if you have a 10x10 array with known values, what is the best control to use to display this array, allow editing and have the edit results available for query?

Thanks, any advice will really help

Brent Wherry

d

Sam Hobbs · Answer

There are many ways to do it. The following shows one way. using System; using System.Windows.Forms; namespace _78802 { public partial class Form1 : Form { public Form1() { InitializeComponent(); dataGridView1.ColumnCount = 14; dataGridView1.Columns[0].Name = Q; dataGridView1.Columns[1].Name = W 1; dataGridView1.Columns[2].Name = W 2; dataGridView1.Columns[3].Name = W 3; dataGridView1.Columns[4].Name = W 4; dataGridView1.Columns[5].Name = W 5; dataGridView1.Columns[6].Name = W 6; dataGridView1.Columns[7].Name = W 7; dataGridView1.Columns[8].Name = W 8; dataGridView1.Columns[9].Name = W 9; dataGridView1.Columns[10].Name = W 10; dataGridView1.Columns[11].Name = W 11; dataGridView1.Columns[12].Name = W 12; dataGridView1.Columns[13].Name = W 13; } private void Form1_Load(object sender EventArgs e) { int x; for (int q = 0; q { x = dataGridView1.Rows.Add(); dataGridView1.Rows[x].Cells[0].Value = x.ToString(); for (int c = 1; c { dataGridView1.Rows[x].Cells[c].Value = c.ToString(); ; } } dataGridView1.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells); } private void Form1_FormClosing(object sender FormClosingEventArgs e) { string s; foreach (DataGridViewRow row in dataGridView1.Rows) { if (row.Index != dataGridView1.NewRowIndex) { s = ; for (int c = 0; c s += row.Cells[c].Value.ToString() + ' '; MessageBox.Show(s); } } } } }

Sam Hobbs · Answer

Something else that can be done is to bind a control such as DataGridView to a data source and the data source can be an  object . An object can be a class with members and you provide the logic to read the data into the object and write data from the object but .Net manages putting the data into and getting the data from the bound control. Note that controls such as the DataGridView have a collection (Rows or some other relevant name) that can be used like a one-dimensional array and DataGridView rows have a collection of cells which is effectively a two-dimensional array although it is not possible to access the data using two-dimensional syntax. If my reply aboved helped you then please check the  Do you like this Answer  checkbox. Note that there can be only one checkbox checked per thread.

rbwherry · Answer

That is very good. It's exactly what I've been struggling for . I was just about to convert the listBox to edit but your suggestion is so much better. Thankyou again. Brent p.s. Although I've shown a big gap in my C# skills I do have some pretty good experience in automating Visio and using the Extend simulation system and some iThink System Dynamics (see www.focused-on.com ) . If I can ever help you please feel welcome to ask.

rbwherry · Answer

Yep I mean't DataGridView not DataView. Is there a neat DataGid conrol that can be easily bound to an Array? Thanks Brent

kiran kumar · Answer

hello friendit is better to use datagrid