两个列在datagrid输出如下图
name nc
a b
b c
c b
d t
e y
如果在datagrid控件nc列出现两个b那么程序给出提示信息“以经有两个B了”,如果出现两个c在给出提示信息“以经有2个c了”
谢谢各位兄弟!!这个问题我会令加分的!!
解决方案 »
- Form1.frm启动之后,里面的所有图片都不见了,包括按扭的图标等等。
- 急聘VB高手兼职
- 求教 如何判断磁盘上某个位子是否又个名为“a.xls”的文件
- winsock中State为6是什么意思?
- 想看美人请进入“http://www.kan120.com/?yongliux_y”
- 用VB.NET做的应用程序(.EXE)为什么不能在别的操作系统上运行?
- 字符串处理函数的应用问题!各位老大帮帮忙,急!
- 有用过speech开发过语音识别吗,怎样提高识别率。
- 如何在Datareport中增加一行合计栏?
- 关于MSFlexGrid控件合并单元格的问题
- 在VB6.0下怎样使用控件WindowsMediaPlayer?
- 检测文件是否被读取
select1="select nc from table_name group by nc having count(*)=2 "
if rs.state=1 then rs.close
rs.open select1,cn,1,3
if rs.eof or rs.bof then exit sub
do while not rs.eof
msgbox "有2个"+rs.fields("nc")
rs.movenext
loop
Set Rs = New ADODB.Recordset
Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;Data Source=" & App.Path & "\wlj.mdb;Persist Security Info=False"
Conn.Open
If Rs.State = 1 Then Rs.Close
Rs.Open "select xb from d1 group by xb having count(*)=2", Conn, 1, 3
If Rs.EOF Or Rs.BOF Then Exit Sub
Do While Not Rs.EOF
MsgBox "有2个" + Rs.Fields("nc")
Rs.MoveNext
Loop------------------
根本没有什么提示啊!!兄弟。。把那里换成要 找的东西(b) 啊。。
Set Conn = New ADODB.Connection
Set Rs = New ADODB.Recordset
Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;Data Source=" & App.Path & "\wlj.mdb;Persist Security Info=False"
Conn.Open
If Rs.State = 1 Then Rs.Close
Rs.Open "select xb from d1 where xb='b' group by xb having count(*)=2", Conn, 1, 3
If Rs.EOF Or Rs.BOF Then Exit Sub
Do While Not Rs.EOF
MsgBox "有2个" + Rs.Fields("nc")
Rs.MoveNext
Loop
Private Sub DataGrid1_RowColChange(LastRow As Variant, ByVal LastCol As Integer)
Dim i As Integer,str(100) as string,g as integer
For i = 0 To DataGrid1.VisibleRows
DataGrid1.Row = i
str(i)=dataGrid1.Columns(1).Text
for g=0 to i
If DataGrid1.Columns(1).Text = str(g) Then
MsgBox str(i) & " 以经存在", vbInformation + vbOKOnly, "数据重复"
End If
next g
Next i
end sub