10 2020 档案

SQL语句修改not in 变为not exists
摘要：select t1.id from table1 t1 where tbl1.id not in (select t2.id from table2 t2); t1有9万条数据，t2有3万条数据 使用not exists 代替 not in select t1.id from table1 t1 w 阅读全文
posted @ 2020-10-27 08:55 它的眼角开过光 阅读(646) 评论(0) 推荐(0)
VB.net中获取键盘Enter键方法
摘要：1 .net 2 private void txtIDFromPrint_KeyPress(object sender, KeyPressEventArgs e) 3 { 4 if (e.KeyChar == '\r') 5 { 6 txtIDToPrint.Focus(); 7 } 8 } 9 V 阅读全文
posted @ 2020-10-24 15:59 它的眼角开过光 阅读(733) 评论(0) 推荐(0)
VB字符串分割为数组，并获取下标值
摘要：Dim A() As StringPrivate Sub Command1_Click()A() = Split(Text1.Text, "-", -1, vbTextCompare)'以“-”将字符串分割后存到一个以下标为0开始的数组里Dim i As IntegerFor i = 0 To UB 阅读全文
posted @ 2020-10-23 13:53 它的眼角开过光 阅读(885) 评论(0) 推荐(0)
VB字符串分割为数组并遍历下标值
摘要：Dim A() As StringPrivate Sub Command1_Click()A() = Split(Text1.Text, "-", -1, vbTextCompare)'以“-”将字符串分割后存到一个以下标为0开始的数组里Dim i As IntegerFor i = 0 To UB 阅读全文
posted @ 2020-10-23 13:51 它的眼角开过光 阅读(331) 评论(0) 推荐(0)
VB去除字符串中的字符.
摘要：Replace(txtCustomerPartNoSMT.text, ".", "") 阅读全文
posted @ 2020-10-21 09:21 它的眼角开过光 阅读(659) 评论(0) 推荐(0)
VB中case用法
摘要：'' Select Case .Process'' Case "AOI"'' varData(0, 1, 0) = IIf(.GdNg = "Y", "Pass", "NG")'' varData(0, 0, 1) = .WrkStation'' Case "ICTATE"'' varData(1, 阅读全文
posted @ 2020-10-21 09:10 它的眼角开过光 阅读(1504) 评论(0) 推荐(0)