Foxtable(狐表)用户栏目专家坐堂 → [求助]


  共有2561人关注过本帖树形打印复制链接

主题:[求助]

帅哥哟,离线,有人找我吗?
lsy
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:版主 帖子:5246 积分:33163 威望:0 精华:8 注册:2013/1/17 21:28:00
  发帖心情 Post By:2014/4/28 16:16:00 [显示全部帖子]

Dim dst1 As Table = Tables("窗口1_table1")
If dst1.count >0 Then
    If MsgBox("确认删除选中信息?",65,"提示") = 1 Then
        Dim dr As Row = dst1.Current '获得选定行
        Dim str As String = dr("登陆账号")
        Dim cmd As New SQLCommand
        cmd.C
        '删除记录
        cmd.CommandText = "DELETE FROM [login] WHERE 登陆账号 = '" & str & "'"
        cmd.ExecuteNonQuery()
        cmd.CommandText = "Select * FROM [login] WHERE 登陆账号 <> '" & str & "'"
        dst1.DataSource  = cmd.ExecuteReader()
        For i As Integer=1 To dst1.count
            Dim dr1 As Row = dst1.Rows(i-1)
            dr1("登陆账号") = "" & i
        Next
        dst1.AutoSizeCols()
    End If
End If

 回到顶部