01 2013 档案

C#从datatable或dategridview导出到excel
摘要：1.datatableDataTable dtqzh= Service.getTableBySql("select * from table where"); if (dtqzh != null && dtqzh.Rows.Count > 0){ this.outLoadExcel(dtqzh); } private void outLoadExcel(DataTable dtqzh) { if (dtqzh.Rows.Count <= 0) { ... 阅读全文

posted @ 2013-01-31 14:49 MyBeN 阅读(3437) 评论(1) 推荐(1)

为checkedListBox赋值并 遍历checkedListBox中选中的值
摘要：//赋值CLBDJZLS.Items.Clear(); DataTable dtdjzl = Service.getTableBySql("SELECT * from talbe"); foreach (DataRow dr in dtdjzl.Rows) { CLBDJZLS.Items.Add(dr["登记种类"].ToString()); }//遍历for(int i=0;i<CLBDJZLS.Items.Count;i++){if (CLBDJZLS.GetItemChecked(i)){ string value=CLBDJZLS.Get 阅读全文

posted @ 2013-01-31 14:19 MyBeN 阅读(3470) 评论(0) 推荐(0)

导航