DataGrid new Row problem. (VB)

[alexk]

DataGrid new Row problem.

 

When a user tries to edit last row in DataGrid control, the new empty row appears. How can I avoid the appearance?

Please Help.

[bwgc]

(From "Windows Forms FAQs" above)

 

The DataGrid class does not have a property that controls whether a new row can be added. But the DataView class does have such a property (along with some others such as AllowEdit and AllowDelete). Here is code that will turn off the append row by getting at the dataview associated with the datagrid.

 

string connString = @"Provider=Microsoft.JET.OLEDB.4.0;data source=C:\northwind.mdb";

 

string sqlString = "SELECT * FROM customers";

 

 

 

// Connection object

 

OleDbConnection connection = new OleDbConnection(connString);

 

 

 

// Create data adapter object

 

OleDbDataAdapter dataAdapter = new OleDbDataAdapter(sqlString, connection);

 

 

 

// Create a dataset object and fill with data using data adapter's Fill method

 

DataSet dataSet = new DataSet();

 

dataAdapter.Fill(dataSet, "customers");

 

 

 

// Attach dataset's DefaultView to the datagrid control

 

dataGrid1.DataSource = dataSet.Tables["customers"];

 

 

 

//no adding of new rows thru dataview...

 

CurrencyManager cm = (CurrencyManager)this.BindingContext[dataGrid1.DataSource, dataGrid1.DataMember];

 

((DataView)cm.List).AllowNew = false;