datagrid prevent append new row

[ramyar]

Hi,

How do I prevent the datagrid from displaying the append row, the one with a "*".

"http://www.syncfusion.com/FAQ/WinForms/FAQ_c44c.asp#q653q" says how to do this but the sample code is in C# and I am not able to figure out a way to convert it to VB.NET.

The example given in syncfusion is------------

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;

-------------- code ends----------------------------------------


How do I convert

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

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

to vb.net

Thanks in advance.
Ramya

 

[dusans]

Dim Cm As System.Windows.Forms.CurrencyManager
Dim Dv As System.Data.DataView

Cm = CType(Me.BindingContext(DSet.Tables("TABLE NAME")), System.Windows.Forms.CurrencyManager)
Dv = CType(Cm.List, System.Data.DataView)
Dv.AllowNew = False

That's it!

 

[ramyar]

Thanks. It works.