Function meeting_topics_binding()
ds = SQL.get_meeting_topics
Dim dt As New DataTable
dt.Columns.Add("item_no", GetType(System.String))
dt.Columns.Add("topic", GetType(System.String))
Dim drDSROW As DataRow
Dim drNewRow As DataRow
drNewRow = dt.NewRow
drNewRow("item_no") = 0
drNewRow("topic") = "เลือก"
dt.Rows.Add(drNewRow)
For Each drDSROW In ds.Tables("GetmeetingTopics").Rows()
drNewRow = dt.NewRow
drNewRow("item_no") = drDSROW("item_no") & "" & drDSROW("sub_item_no")
drNewRow("topic") = CStr("วาระที่ " & drDSROW("item_no") & "." & drDSROW("sub_item_no")).Replace(".0", "")
dt.Rows.Add(drNewRow)
Next
With cobTopics
.DataSource = dt
.DisplayMember = "topic"
.ValueMember = "item_no"
End With
End Function
C#
String sql = "select book_id,book_num +'-'+ book_name book_detail from book order by convert(int,book_id) desc";
DataTable dt1 = DB.GetDataSet(sql);
DataTable dt = new DataTable();
dt.Columns.Add("book_id", typeof(System.String));
dt.Columns.Add("book_detail", typeof(System.String));
DataRow drNewRow = default(DataRow);
drNewRow = dt.NewRow();
drNewRow["book_id"] = 0;
drNewRow["book_detail"] = "--เลือก--";
dt.Rows.Add(drNewRow);
foreach ( DataRow row in dt1.Rows) {
drNewRow = dt.NewRow();
drNewRow["book_id"] = row["book_id"];
drNewRow["book_detail"] = row["book_detail"];
dt.Rows.Add(drNewRow);
}
var _with1 = cbProject;
_with1.DataSource = dt;
_with1.DisplayMember = "book_detail";
_with1.ValueMember = "book_id";