Hi,
I think I've found a workaround.
I have used the method AutoGenerateColumns of Datagridview set to false;
In this way,
the datagridview does not create the columns alone, but we must be we to decide
what columns to show and what no..
Adding some
invisible columns is also possible, it is enough that they are not placed to
the first places of the datagridview.
I enclose
example.
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.Sql;
using System.Data.SqlClient;
namespace WindowsApplication2
{
public class Form2 : Form
{
private System.Windows.Forms.DataGridView dataGridView1;
private System.Windows.Forms.DataGridViewTextBoxColumn Column1;
private System.Windows.Forms.DataGridViewTextBoxColumn Column2;
private System.Windows.Forms.DataGridViewTextBoxColumn Column3;
DataTable dt;
DataView dw;
public Form2()
{
dt = new DataTable("MyTable");
dw = new DataView(dt);
dt.Columns.Add("Column1");
dt.Columns.Add("Column2");
dt.Columns.Add("Column3");
InitializeComponent();
//
// Column1
//
this.Column1.DataPropertyName = "ProductId";
this.Column1.HeaderText = "Column1";
this.Column1.Name = "Column1";
this.Column1.Visible = false;
//
// Column2
//
this.Column2.DataPropertyName = "Column2";
this.Column2.HeaderText = "Column2";
this.Column2.Name = "Column2";
//
// Column3
//
this.Column3.DataPropertyName = "Column3";
this.Column3.HeaderText = "Column3";
this.Column3.Name = "Column3";
// Here I've error
this.dataGridView1.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
this.Column1,
this.Column2,
this.Column3});
// If I remove this.Column1
// I haven't error
//this.dataGridView1.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
//this.Column2,
//this.Column3});
// OR
// Invert Column1 with Column2 in this way
//this.dataGridView1.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
//this.Column2,
//this.Column1,
//this.Column3});
dataGridView1.AutoGenerateColumns = false;
dataGridView1.DataSource = dt;
this.Validate();
}
private void InitializeComponent()
{
this.dataGridView1 = new System.Windows.Forms.DataGridView();
this.Column1 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.Column2 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.Column3 = new System.Windows.Forms.DataGridViewTextBoxColumn();
((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit();
this.SuspendLayout();
//
// dataGridView1
//
this.dataGridView1.ColumnHeadersHeightSizeMode =
System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.dataGridView1.EditMode = System.Windows.Forms.DataGridViewEditMode.EditOnEnter;
this.dataGridView1.Location = new System.Drawing.Point(21, 12);
this.dataGridView1.Name = "dataGridView1";
this.dataGridView1.Size = new System.Drawing.Size(296, 150);
this.dataGridView1.TabIndex = 0;
//
// Column1
//
this.Column1.Name = "Column1";
//
// Column2
//
this.Column2.Name = "Column2";
//
// Column3
//
this.Column3.Name = "Column3";
//
// Form2
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(453, 289);
this.Controls.Add(this.dataGridView1);
this.Name = "Form2";
this.Text = "Form2";
((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).EndInit();
this.ResumeLayout(false);
}
private System.ComponentModel.IContainer components = null;
/// <summary>
/// Clean up any resources being used.
/// </summary>
/// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
protected override void Dispose(bool disposing)
{
if (disposing && (components != null))
{
components.Dispose();
}
base.Dispose(disposing);
}
}
}
index > Windows Forms Data Controls and Databinding > DataGridView + RowValidating = Index 4 does not have a value?
