게시판 - 1 개 / 게시물 - 7 개 1 / 1 페이지 열람 중
{"Table":[{"link_product_list":"\/category\/\ub514\ud4e8\uc800\/115\/","name":"\ub514\ud4e8\uc800","param":"?cate_no=115","cate_no":115,"parent_cate_no":1,"design_page_url":"product\/list.html…
가끔 DataTable에서 중복되지 않는 값을 추출해야 할 때가 있습니다.DataTable에서 중복되지 않는 유일한 값 추출 및 ComboBox에 아이템 추가하는 예제 소스입니다. Dim ctg() As String = D.AsEnumerable().Select( Function(DR) Return DR.Field(Of String)("카테고리") End Function).Distinct().ToArray ComboBo…
Example1:)Write:dt1.TableName="MyDataTable"dt1.WriteXmlSchema(Application.StartupPath+"\test_sh.xml",True)dt1.WriteXml(Application.StartupPath+"\test_dt.xml",True)Read:dt2=NewDataTabledt2.ReadXmlSchema(Application.StartupPath+"\test_sh.xml")dt2.ReadXml(Applica…
지식인 답변내용입니다.PublicClassForm1PrivateSubForm1_Load(senderAsObject,eAsEventArgs)HandlesMyBase.LoadDimDAsNewDataTable,RAsDataRowD.Columns.Add("금액",GetType(Integer))D.Columns.Add("날짜",GetType(Date))D.Columns.Add("종류",GetType(String))D.Columns.Add("품명",GetType(Strin…
DimdtAsNewDataTable()dt.Columns.AddRange(NewDataColumn(3){NewDataColumn("Id"),NewDataColumn("Name"),NewDataColumn("Sid",GetType(Integer)),NewDataColumn("Age",GetType(Integer))})dt.Rows.Add("1","xxx",19,20)dt.Rows.Add("2","yyy…
PublicSubColumnRemoval(DAsDataTable,ByValColumnAsDataColumn)DimColumnsAsDataColumnCollection=D.ColumnsIfColumns.Contains(Column.ColumnName)ThenColumns.Remove(Column)EndSub
DimDTAsDataTable=DataGridView1.DataSourceDimDTRAsDataRow=DT.Rows(3)DimiAsInteger=DT.Rows.IndexOf(DTR)