up 例如,刚加载时,列表中高亮选择的是第一项,我想单击选中其它项(在LISTBOX中就可以),就总是不行。 是不是哪个属性设置错了? binding connection error field not updatable ,bound property name :boundtext,field name: firstname 应该怎么做呀?
奇怪,我试了下,没有你说的问题Option Explicit Public Rs As New ADODB.Recordset Public Conn As New ADODB.ConnectionPrivate Sub Form_Load() Dim strConn As String strConn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=pubs;Data Source=LocalHost" Conn.CursorLocation = adUseClient Conn.Open strConn If Rs.State = 1 Then Rs.Close Rs.Open "Select * from jobs", Conn, adOpenStatic, adLockOptimistic With DataList1 Set .RowSource = Rs .ListField = "Job_ID" .BoundColumn = "Job_ID" End With End Sub
例如,刚加载时,列表中高亮选择的是第一项,我想单击选中其它项(在LISTBOX中就可以),就总是不行。
是不是哪个属性设置错了?
binding connection error
field not updatable ,bound property name :boundtext,field name: firstname
应该怎么做呀?
Public Rs As New ADODB.Recordset
Public Conn As New ADODB.ConnectionPrivate Sub Form_Load()
Dim strConn As String
strConn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=pubs;Data Source=LocalHost"
Conn.CursorLocation = adUseClient
Conn.Open strConn If Rs.State = 1 Then Rs.Close
Rs.Open "Select * from jobs", Conn, adOpenStatic, adLockOptimistic
With DataList1
Set .RowSource = Rs
.ListField = "Job_ID"
.BoundColumn = "Job_ID" End With
End Sub
DataList1.Locked=false
怎么样在datalist中删除表中的一条记录?