摘要:
一、DataGridView數(shù)據(jù)轉(zhuǎn)成DataTable 1.已綁定過數(shù)據(jù)源:DataTable dt = (dataGridView1.DataSource as DataTable) 2.未綁定過數(shù)據(jù)源:public DataTable GetDgvToTable(DataGridView dgv
閱讀全文
摘要:
1.創(chuàng)建自定義DataTable /// 創(chuàng)建自定義DataTable(一) 根據(jù)列名字符串?dāng)?shù)組, /// </summary> /// <param name="sList">列名字符串?dāng)?shù)組</param> /// <returns>DataTable</returns> public stati
閱讀全文
摘要:
20、SUM()和 列+ 統(tǒng)計結(jié)果時:如果列里有一行為null,SUM函數(shù)會忽略它;如果+,則結(jié)果集也為NULL了 19 SUBSTRING (expression,startIndex, endIndex) SELECT SUBSTRING ('Los Angeles',1, 3) 返回結(jié)果Los
閱讀全文