向数据库中添加数据,如何得到自动编号呀???
向数据库中添加数据,如何得到自动编号呀???
OleDbCommand1.CommandText = "insert into TXT" & "(ItemNo,BNo,SNo,GNo,No4,No5,MyDate) values('" + qs + "','" + BNo + "','" + SNo + "','" + GNo + "','" + No4 + "','" + No5 + "','" + rq + "')"
OleDbCommand1.ExecuteNonQuery()
OleDbConnection1.Close()