or
Private Sub InsertNewContactDetails() Dim iSql As String = "Insert into CompanyDetails (EmailOffice,EmailAdmin,EmailOrders,EmailAccounts,EmailOther,ContactPersonOffice,ContactPersonAdmin,ContactPersonOrders,ContactPersonAccounts,ContactPersonOther,ContactNumber,ContactNumberExtension,ContactnumberFax,ContactNumberFaxExtension,ContactNumberMobile1,ContactNumberMobile2,ContactNumberDirectNumber,ContactNumberFaxToEmail) VALUES ( ' " + txtEmailOffice.Text + " ',' " + txtEmailAdmin.Text + " ' ,' " + txtEmailOrders.Text + " ' , ' " + txtEmailAccounts + " ' , ' " + txtEmailOther.Text + " ', ' " + txtContactPersonOffice.Text + " ', ' " + txtPostalAddress1.Text + " ',' " + txtPostalAddress2.Text + " ', ' " + cmbPostalAddress3.Text + "','" + cmbCategory.Text + "' ,'" + cmbClassification.Text + "')" Dim da As New OleDb.OleDbDataAdapter(iSql, MyConnection) Dim dt As New DataTable da.Fill(dt) da.Dispose() myDataSet() txtEmailOffice.Text = "" End SubradListView1.ItemValueChanged += (s, e) => { Edited.Add(new ListViewEditedItems() { Loan = e.ListViewElement.Columns[0].ToString(), Recovery = e.ListViewElement.Columns[1].ToString(), CurrInstNo = e.ListViewElement.Columns[2].ToString(), TotInstNo = e.ListViewElement.Columns[3].ToString(), AmtDrawn = e.ListViewElement.Columns[4].ToString(), AmtRecoverd = e.ListViewElement.Columns[5].ToString(), BalAmt = e.ListViewElement.Columns[6].ToString() }); };List<WorkItem> _workitems = new List<WorkItem>();List<GridViewDataColumn> _workitemColumns = new List<GridViewDataColumn>();_workitemColumns.Add(new GridViewTextBoxColumn() { DataField = "InstanceID", HeaderText = "Instance ID" });_workitemColumns.Add(new GridViewTextBoxColumn() { DataField = "StorageObjectID", HeaderText = "Object ID" });_workitemColumns.Add(new GridViewTextBoxColumn() { DataField = "Document.BatchID", HeaderText = "Batch ID" });_workitemColumns.Add(new GridViewTextBoxColumn() { DataField = "ReferenceTypeName", HeaderText = "Document Type" });_workitemColumns.Add(new GridViewDateTimeColumn() { DataField = "CreateDate", HeaderText = "Create Date", ExcelExportType = DisplayFormatType.Custom, ExcelExportFormatString = "MM/dd/yyyy hh:mm:ss" });_workitemColumns.Add(new GridViewTextBoxColumn() { DataField = "Title", HeaderText = "Title" });_workitemColumns.Add(new GridViewTextBoxColumn() { DataField = "OwningUser", HeaderText = "Assigned User" });_workitemColumns.Add(new GridViewTextBoxColumn() { DataField = "Status", HeaderText = "Status"});#region this worksforeach (GridViewDataColumn curCol in this._workitemColumns){ this.workItemsGridView1.Columns.Add(curCol);}BindingList<WorkItem> bindingWorkitems = new BindingList<WorkItem>(this._workitems);BindingSource dbBindSource = new BindingSource();dbBindSource.DataSource = bindingWorkitems;this.workItemsGridView1.DataSource = dbBindSource;#endregion#region does not workDataTable workitemsDT = this._workitems.ToDataTable();foreach (GridViewDataColumn curCol in this._workitemColumns){ this.workItemsGridView1.Columns.Add(curCol);}foreach(GridViewDataColumn curCol in this._layerColumns[this._selectedLayer]){ this.workItemsGridView1.Columns.Add(curCol);}this.workItemsGridView1.DataSource = workitemsDT;#endregionpublic static DataTable ToDataTable<T>(this List<T> items){ var tb = new DataTable(typeof(T).Name); PropertyInfo[] props = typeof(T).GetProperties(BindingFlags.Public | BindingFlags.Instance); foreach (var prop in props) { if (prop.PropertyType.IsGenericType && prop.PropertyType.GetGenericTypeDefinition() == typeof(Nullable<>)) { tb.Columns.Add(prop.Name, prop.PropertyType.GetGenericArguments()[0]); } else tb.Columns.Add(prop.Name, prop.PropertyType); } foreach (var item in items) { var values = new object[props.Length]; for (var i = 0; i < props.Length; i++) { values[i] = props[i].GetValue(item, null); } tb.Rows.Add(values); } return tb;}