Dim sql As String
sql = "select * from Teacher"
'è¿å¥æé®é¢ï¼è¯å®æ¯ä¿®æ¹ç¬¬ä¸è¡æ°æ®ï¼åºè¯¥æ¯
sql = "select * from Teacher Order BY id Desc"
Set rs = exesql(sql)
âå¨è¿éå¿
须添å ä¸é¢çè¯å¥ï¼
rs.AddNew 'æ°å¢æ°æ®
rs.Fields("管çåå§å") = Trim(Text1.Text)
rs.Fields("å·¥å·") = Trim(Text2.Text)
rs.Fields("管çåå¯ç ") = Trim(Text19.Text)
rs.Fields("æ§å«") = Trim(Text3.Text)
rs.Fields("èç³»æ¹å¼") = Trim(Text4.Text)
rs.Fields("家åºä½å") = Trim(Text5.Text)
rs.Update
rs.Close
å¦å¤ï¼æ认为以ä¸è¯å¥æ²¡æä»»ä½æä¹ï¼ä¸å¦å é¤ï¼
rs.Fields("管çåå§å") = ""
rs.Fields("å·¥å·") = ""
rs.Fields("管çåå¯ç ") = ""
rs.Fields("æ§å«") = ""
rs.Fields("èç³»æ¹å¼") = ""
rs.Fields("家åºä½å") = ""
温馨提示:答案为网友推荐,仅供参考