12 2012 档案

After delete Trigger throw error：The row value(s) updated or deleted either do not make the row unique or they alter multiple rows (2 rows).
摘要：在after delete触发器中执行update语句，更新另外一个表单数据ALTER TRIGGER [dbo].[UpdateBookOfStudentFlag]on [dbo].[tblBookInvoiceDetail] AFTER DELETEAS BEGIN update BookOfStudent set flag_orderUsed=0 where BookOfStudent.id = 52812--(select Book_ofStudent_Id from deleted)END表错，提示受影响的行数多于1The row value(s) updated or dele.. 阅读全文
posted @ 2012-12-21 11:20 zyip 阅读(775) 评论(0) 推荐(0) 编辑
write mobile to ad
摘要：public static string path = "LDAP://192.168.8.1"; public static string admin = "administrator"; public static string pwd = ""; public static DirectoryEntry createDirectoryEntry(string admin, string pwd) { DirectoryEntry ldapConnection = new DirectoryEntry(... 阅读全文
posted @ 2012-12-21 09:48 zyip 阅读(206) 评论(0) 推荐(0) 编辑
限定textbox的输入长度，中文两字节英文一字节
摘要：textbox.maxlength可以限定输入内容的长度，但是如果想更精细地实现限定ansi字符串的长度该如何实现呢？ansi编码下，中文占2字节，英文1字节,textbox.maxlength无法限定混有中英文的ansi字符串。考虑一般情况下限定输入长度的方法：1.maxlength2.在KeyPress事件中处理3.在TextChanged中处理Dim oldTxt = "" Private Sub txtSingleTxt_TextChanged(sender As System.Object, e As System.EventArgs) Handles txtSi 阅读全文
posted @ 2012-12-13 12:53 zyip 阅读(341) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示