datagrid datatable problem.

[clyyy2002]

At added two column and more column hereafter,I immediately click del
button,the program is no problem.

but if i first click the DataGrid columnHeader and then click the del
button, i find when column is

finally ,a error is happen

underside is my program.



using System;

using System.Drawing;

using System.Collections;

using System.ComponentModel;

using System.Windows.Forms;

using System.Data;

namespace deldatagridcolumn

{
public class Form1 : System.Windows.Forms.Form

{

private System.Windows.Forms.Button button1;

private System.Windows.Forms.Button button2;

private System.ComponentModel.Container components = null;

private System.Windows.Forms.DataGrid grid;

DataTable dt = new DataTable("T");

public Form1()

{
InitializeComponent();
}

protected override void Dispose( bool disposing )

{

if( disposing )

{

if (components != null)

{

components.Dispose();

}

}

base.Dispose( disposing );

}

#region Windows ´°ÌåÉè¼ÆÆ÷Éú³ÉµÄ´úÂë
private void InitializeComponent()

{

this.grid = new System.Windows.Forms.DataGrid();

this.button1 = new System.Windows.Forms.Button();

this.button2 = new System.Windows.Forms.Button();
((System.ComponentModel.ISupportInitialize)(this.g rid)).BeginInit();

this.SuspendLayout();

//

// grid

//

this.grid.DataMember = "";

this.grid.HeaderForeColor =
System.Drawing.SystemColors.ControlText;

this.grid.Location = new System.Drawing.Point(24, 16);

this.grid.Name = "grid";

this.grid.Size = new System.Drawing.Size(448, 288);

this.grid.TabIndex = 0;

//

// button1

//

this.button1.Location = new System.Drawing.Point(304, 312);

this.button1.Name = "button1";

this.button1.TabIndex = 1;

this.button1.Text = "Add";

this.button1.Click += new
System.EventHandler(this.button1_Click);

//

// button2

//

this.button2.Location = new System.Drawing.Point(400, 312);

this.button2.Name = "button2";

this.button2.TabIndex = 2;

this.button2.Text = "Del";

this.button2.Click += new
System.EventHandler(this.button2_Click);

//

// Form1

//

this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);

this.ClientSize = new System.Drawing.Size(504, 341);

this.Controls.Add(this.button2);

this.Controls.Add(this.button1);

this.Controls.Add(this.grid);

this.Name = "Form1";

this.Text = "Form1";

this.Load += new System.EventHandler(this.Form1_Load);
((System.ComponentModel.ISupportInitialize)(this.g rid)).EndInit();

this.ResumeLayout(false);

}

#endregion


[STAThread]

static void Main()

{

Application.Run(new Form1());

}

private void Form1_Load(object sender, System.EventArgs e)

{

DataColumn dc = new DataColumn("dcode",typeof(string));

dt.Columns.Add(dc);

DataRow dr = dt.NewRow();

dr[0] = "aa";

dt.Rows.Add(dr);

grid.DataSource = dt;

DataGridTableStyle myGridStyle = new DataGridTableStyle();

myGridStyle.MappingName = "T";

DataGridTextBoxColumn style = new DataGridTextBoxColumn();

style.MappingName = "dcode";

style.HeaderText = "DCODE";

style.Width = 100;

myGridStyle.GridColumnStyles.Add(style);

grid.TableStyles.Add(myGridStyle);

}

private void button1_Click(object sender, System.EventArgs e)

{
string FieldEn = "";

int i=0;

int j=0;

string caption = "";

while(FieldEn.Length==0)

{


for(j=0;j<dt.Columns.Count;j++)

{

if(("F" + i.ToString()) == dt.Columns[j].ColumnName)

{

break;

}

}


if(j==dt.Columns.Count)

{

FieldEn = "F" + i.ToString();

caption = "f" + i.ToString();

break;

}

i++;

}

DataColumn column = new DataColumn(FieldEn,typeof(string));

column.Caption = caption;

dt.Columns.Add(column);

DataGridTextBoxColumn myGridStyle = new
DataGridTextBoxColumn();

myGridStyle.MappingName = column.ColumnName;

myGridStyle.HeaderText = column.Caption;

myGridStyle.Width = 100;

grid.TableStyles[0].GridColumnStyles.Add(myGridStyle);

}

private void button2_Click(object sender, System.EventArgs e)

{

if(dt.Columns.Count > 1)

{

dt.Columns.RemoveAt(1);

grid.TableStyles[0].GridColumnStyles.RemoveAt(1);

}

}

}

}

[William Ryan eMVP]

can you tell me a little more about the problem.

Basicaly, you created a datatable and added some datacolumns. If you fill
the datatable, bind it to the grid and try to delete a row, everything is
fine. However if you sort the grid first and then delete a column - you get
an exception? If this is correct, can you tell me what exception you are
getting? does teh exception occur when you hit the delete button or does it
happen when you try to update the db (ie call .Update method of the
dataadapter?). Could you post teh code you are using for the delete?

--
W.G. Ryan MVP Windows - Embedded

Have an opinion on the effectiveness of Microsoft Embedded newsgroups?
Let Microsoft know!
https://www.windowsembeddedeval.com/...ity/newsgroups
"clyyy2002" <cl*******@yahoo.com.cn> wrote in message
news:uj*************@TK2MSFTNGP11.phx.gbl...

At added two column and more column hereafter,I immediately click del
button,the program is no problem.

but if i first click the DataGrid columnHeader and then click the del
button, i find when column is

finally ,a error is happen

underside is my program.



using System;

using System.Drawing;

using System.Collections;

using System.ComponentModel;

using System.Windows.Forms;

using System.Data;

namespace deldatagridcolumn

{
public class Form1 : System.Windows.Forms.Form

{

private System.Windows.Forms.Button button1;

private System.Windows.Forms.Button button2;

private System.ComponentModel.Container components = null;

private System.Windows.Forms.DataGrid grid;

DataTable dt = new DataTable("T");

public Form1()

{
InitializeComponent();
}

protected override void Dispose( bool disposing )

{

if( disposing )

{

if (components != null)

{

components.Dispose();

}

}

base.Dispose( disposing );

}

#region Windows ´°ÌåÉè¼ÆÆ÷Éú³ÉµÄ´úÂë
private void InitializeComponent()

{

this.grid = new System.Windows.Forms.DataGrid();

this.button1 = new System.Windows.Forms.Button();

this.button2 = new System.Windows.Forms.Button();
((System.ComponentModel.ISupportInitialize)(this.g rid)).BeginInit();

this.SuspendLayout();

//

// grid

//

this.grid.DataMember = "";

this.grid.HeaderForeColor =
System.Drawing.SystemColors.ControlText;

this.grid.Location = new System.Drawing.Point(24, 16);

this.grid.Name = "grid";

this.grid.Size = new System.Drawing.Size(448, 288);

this.grid.TabIndex = 0;

//

// button1

//

this.button1.Location = new System.Drawing.Point(304, 312);

this.button1.Name = "button1";

this.button1.TabIndex = 1;

this.button1.Text = "Add";

this.button1.Click += new
System.EventHandler(this.button1_Click);

//

// button2

//

this.button2.Location = new System.Drawing.Point(400, 312);

this.button2.Name = "button2";

this.button2.TabIndex = 2;

this.button2.Text = "Del";

this.button2.Click += new
System.EventHandler(this.button2_Click);

//

// Form1

//

this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);

this.ClientSize = new System.Drawing.Size(504, 341);

this.Controls.Add(this.button2);

this.Controls.Add(this.button1);

this.Controls.Add(this.grid);

this.Name = "Form1";

this.Text = "Form1";

this.Load += new System.EventHandler(this.Form1_Load);
((System.ComponentModel.ISupportInitialize)(this.g rid)).EndInit();

this.ResumeLayout(false);

}

#endregion


[STAThread]

static void Main()

{

Application.Run(new Form1());

}

private void Form1_Load(object sender, System.EventArgs e)

{

DataColumn dc = new DataColumn("dcode",typeof(string));

dt.Columns.Add(dc);

DataRow dr = dt.NewRow();

dr[0] = "aa";

dt.Rows.Add(dr);

grid.DataSource = dt;

DataGridTableStyle myGridStyle = new DataGridTableStyle();

myGridStyle.MappingName = "T";

DataGridTextBoxColumn style = new DataGridTextBoxColumn();

style.MappingName = "dcode";

style.HeaderText = "DCODE";

style.Width = 100;

myGridStyle.GridColumnStyles.Add(style);

grid.TableStyles.Add(myGridStyle);

}

private void button1_Click(object sender, System.EventArgs e)

{
string FieldEn = "";

int i=0;

int j=0;

string caption = "";

while(FieldEn.Length==0)

{


for(j=0;j<dt.Columns.Count;j++)

{

if(("F" + i.ToString()) == dt.Columns[j].ColumnName)
{

break;

}

}


if(j==dt.Columns.Count)

{

FieldEn = "F" + i.ToString();

caption = "f" + i.ToString();

break;

}

i++;

}

DataColumn column = new DataColumn(FieldEn,typeof(string));

column.Caption = caption;

dt.Columns.Add(column);

DataGridTextBoxColumn myGridStyle = new
DataGridTextBoxColumn();

myGridStyle.MappingName = column.ColumnName;

myGridStyle.HeaderText = column.Caption;

myGridStyle.Width = 100;

grid.TableStyles[0].GridColumnStyles.Add(myGridStyle);

}

private void button2_Click(object sender, System.EventArgs e)

{

if(dt.Columns.Count > 1)

{

dt.Columns.RemoveAt(1);

grid.TableStyles[0].GridColumnStyles.RemoveAt(1);

}

}

}

}

[clyyy2002]

underside is my new program.

you sort the grid (column caption is "DNAME" ) first and then click "del"
button, a exception occur(System.IndexOutOfRangeException) .


using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;

namespace deldatagridcolumn
{
public class Form1 : System.Windows.Forms.Form
{
private System.Windows.Forms.Button button2;
private System.ComponentModel.Container components = null;
private System.Windows.Forms.DataGrid grid;

DataTable dt = new DataTable("T");
public Form1()
{
InitializeComponent();
}

protected override void Dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}

private void InitializeComponent()
{
this.grid = new System.Windows.Forms.DataGrid();
this.button2 = new System.Windows.Forms.Button();
((System.ComponentModel.ISupportInitialize)(this.g rid)).BeginInit();
this.SuspendLayout();
//
// grid
//
this.grid.DataMember = "";
this.grid.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.grid.Location = new System.Drawing.Point(24, 16);
this.grid.Name = "grid";
this.grid.Size = new System.Drawing.Size(448, 288);
this.grid.TabIndex = 0;
//
// button2
//
this.button2.Location = new System.Drawing.Point(400, 312);
this.button2.Name = "button2";
this.button2.TabIndex = 2;
this.button2.Text = "Del";
this.button2.Click += new System.EventHandler(this.button2_Click);
//
// Form1
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(504, 341);
this.Controls.Add(this.button2);
this.Controls.Add(this.grid);
this.Name = "Form1";
this.Text = "Form1";
this.Load += new System.EventHandler(this.Form1_Load);
((System.ComponentModel.ISupportInitialize)(this.g rid)).EndInit();
this.ResumeLayout(false);

}

[STAThread]
static void Main()
{
Application.Run(new Form1());
}

private void Form1_Load(object sender, System.EventArgs e)
{

DataColumn dc = new DataColumn("dcode",typeof(string));
DataColumn dc1 = new DataColumn("dname",typeof(string));
dt.Columns.Add(dc);
dt.Columns.Add(dc1);
DataRow dr = dt.NewRow();
dr[0] = "aa";
dr[1] = "aa";
dt.Rows.Add(dr);

grid.DataSource = dt;

DataGridTableStyle myGridStyle = new DataGridTableStyle();
myGridStyle.MappingName = "T";
DataGridTextBoxColumn style = new DataGridTextBoxColumn();
style.MappingName = "dcode";
style.HeaderText = "DCODE";
style.Width = 100;
myGridStyle.GridColumnStyles.Add(style);

DataGridTextBoxColumn style1 = new DataGridTextBoxColumn();
style1.MappingName = "dname";
style1.HeaderText = "DName";
style1.Width = 100;

myGridStyle.GridColumnStyles.Add(style1);
grid.TableStyles.Add(myGridStyle);

}
private void button2_Click(object sender, System.EventArgs e)
{
if(dt.Columns.Count > 1)
{
dt.Columns.RemoveAt(1);
grid.TableStyles[0].GridColumnStyles.RemoveAt(1);
}
button2.Enabled = false;
}
}
}

[clyyy2002]

the reason is sort.

dt.DefaultView.Sort = "";
dt.Columns.RemoveAt(1);

"clyyy2002" <cl*******@yahoo.com.cn> дÈëÏûÏ¢
news:uj*************@TK2MSFTNGP11.phx.gbl...

At added two column and more column hereafter,I immediately click del
button,the program is no problem.

but if i first click the DataGrid columnHeader and then click the del
button, i find when column is

finally ,a error is happen

underside is my program.



using System;

using System.Drawing;

using System.Collections;

using System.ComponentModel;

using System.Windows.Forms;

using System.Data;

namespace deldatagridcolumn

{
public class Form1 : System.Windows.Forms.Form

{

private System.Windows.Forms.Button button1;

private System.Windows.Forms.Button button2;

private System.ComponentModel.Container components = null;

private System.Windows.Forms.DataGrid grid;

DataTable dt = new DataTable("T");

public Form1()

{
InitializeComponent();
}

protected override void Dispose( bool disposing )

{

if( disposing )

{

if (components != null)

{

components.Dispose();

}

}

base.Dispose( disposing );

}

#region Windows ´°ÌåÉè¼ÆÆ÷Éú³ÉµÄ´úÂë
private void InitializeComponent()

{

this.grid = new System.Windows.Forms.DataGrid();

this.button1 = new System.Windows.Forms.Button();

this.button2 = new System.Windows.Forms.Button();
((System.ComponentModel.ISupportInitialize)(this.g rid)).BeginInit();

this.SuspendLayout();

//

// grid

//

this.grid.DataMember = "";

this.grid.HeaderForeColor =
System.Drawing.SystemColors.ControlText;

this.grid.Location = new System.Drawing.Point(24, 16);

this.grid.Name = "grid";

this.grid.Size = new System.Drawing.Size(448, 288);

this.grid.TabIndex = 0;

//

// button1

//

this.button1.Location = new System.Drawing.Point(304, 312);

this.button1.Name = "button1";

this.button1.TabIndex = 1;

this.button1.Text = "Add";

this.button1.Click += new
System.EventHandler(this.button1_Click);

//

// button2

//

this.button2.Location = new System.Drawing.Point(400, 312);

this.button2.Name = "button2";

this.button2.TabIndex = 2;

this.button2.Text = "Del";

this.button2.Click += new
System.EventHandler(this.button2_Click);

//

// Form1

//

this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);

this.ClientSize = new System.Drawing.Size(504, 341);

this.Controls.Add(this.button2);

this.Controls.Add(this.button1);

this.Controls.Add(this.grid);

this.Name = "Form1";

this.Text = "Form1";

this.Load += new System.EventHandler(this.Form1_Load);
((System.ComponentModel.ISupportInitialize)(this.g rid)).EndInit();

this.ResumeLayout(false);

}

#endregion


[STAThread]

static void Main()

{

Application.Run(new Form1());

}

private void Form1_Load(object sender, System.EventArgs e)

{

DataColumn dc = new DataColumn("dcode",typeof(string));

dt.Columns.Add(dc);

DataRow dr = dt.NewRow();

dr[0] = "aa";

dt.Rows.Add(dr);

grid.DataSource = dt;

DataGridTableStyle myGridStyle = new DataGridTableStyle();

myGridStyle.MappingName = "T";

DataGridTextBoxColumn style = new DataGridTextBoxColumn();

style.MappingName = "dcode";

style.HeaderText = "DCODE";

style.Width = 100;

myGridStyle.GridColumnStyles.Add(style);

grid.TableStyles.Add(myGridStyle);

}

private void button1_Click(object sender, System.EventArgs e)

{
string FieldEn = "";

int i=0;

int j=0;

string caption = "";

while(FieldEn.Length==0)

{


for(j=0;j<dt.Columns.Count;j++)

{

if(("F" + i.ToString()) == dt.Columns[j].ColumnName)
{

break;

}

}


if(j==dt.Columns.Count)

{

FieldEn = "F" + i.ToString();

caption = "f" + i.ToString();

break;

}

i++;

}

DataColumn column = new DataColumn(FieldEn,typeof(string));

column.Caption = caption;

dt.Columns.Add(column);

DataGridTextBoxColumn myGridStyle = new
DataGridTextBoxColumn();

myGridStyle.MappingName = column.ColumnName;

myGridStyle.HeaderText = column.Caption;

myGridStyle.Width = 100;

grid.TableStyles[0].GridColumnStyles.Add(myGridStyle);

}

private void button2_Click(object sender, System.EventArgs e)

{

if(dt.Columns.Count > 1)

{

dt.Columns.RemoveAt(1);

grid.TableStyles[0].GridColumnStyles.RemoveAt(1);

}

}

}

}