Category / Section
How to databind a WinForms SyntaxEditor (EditControl) to a datasource?
1 min read
Data binding
Please refer to the code sample given below which shows how an EditControl can be databound to a table in a DataSet.
C#
//create a new DataSet this.dataset = new DataSet("MyDataSet"); //create a new DataTable this.table = new DataTable("MyDataTable"); //create a new DataColumn and add it to the DataTable this.datacolumn = new DataColumn("Code",System.Type.GetType("System.String")); this.table.Columns.Add(this.datacolumn); //create a new DataRow, and assign it to the specific column //assign a string value ‘program’ to that DataRow-DataColumn field this.datarow = this.table.NewRow(); this.datarow[this.datacolumn] = program; // Add this DataRow to the DataTable this.table.Rows.Add(this.datarow); //Add this DataTable to the DataSet this.dataset.Tables.Add(this.table); // Databinding EditControl.Text to the DataColumn "Code" // where "Code" contains the program to be displayed in the EditControl this.editControl1.DataBindings.Add("Text", this.dataset.Tables[0], "Code");
VB
'create a new DataSet Me.dataset = New DataSet("MyDataSet") 'create a new DataTable Me.table = New DataTable("MyDataTable") 'create a new DataColumn and add it to the DataTable Me.datacolumn = New DataColumn("Code",System.Type.GetType("System.String")) Me.table.Columns.Add(Me.datacolumn) 'create a new DataRow, and assign it to the specific column 'assign a string value ‘program’ to that DataRow-DataColumn field Me.datarow = Me.table.NewRow() Me.datarow(Me.datacolumn) = program ' Add this DataRow to the DataTable Me.table.Rows.Add(Me.datarow) 'Add this DataTable to the DataSet Me.dataset.Tables.Add(Me.table) ' Databinding EditControl.Text to the DataColumn "Code" ' where "Code" contains the program to be displayed in the EditControl Me.editControl1.DataBindings.Add("Text", Me.dataset.Tables(0), "Code")