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 Sub
radListView1.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 works
foreach
(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 work
DataTable 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;
#endregion
public
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;
}