开发者

how to delete a user in a mysql server based on search results?

how to delete a user in a mysql server based on search results?

I have a datagrid control with a list of names that it retrieves from a MySql database. I can search through them until i have one result. I want to be able to Display a groupbox control when the number of results is equal to 1. Also, in the groupbox i have a button that when clicked will delete this user from the server and their information from the mysql table called "employee". when the user is deleted i'll display a confirmation message in a messagebox, and reload the table with the updated list. so far the only two problems i have are showing the groupbox when the results are equal to 1 and deleting the user from the sql server based on the name of the search result. im using vb.net in visual basic 2010 express on windows 7 laptop. Thanks!

EDIT1:

Heres my code so far, please suggest how i can apply your answers to it. Thanks!

Private Sub TextBox1_KeyUp(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles TextBox1.KeyUp
    'Search Function.
    Dim sqlsearch1 As My开发者_高级运维SqlCommand = New MySqlCommand("SELECT * FROM employee where name LIKE '%?name%' GROUP BY name;", con)
    Dim sqlsearch2 As MySqlCommand = New MySqlCommand("SELECT * FROM employee where title LIKE '%?title%' GROUP BY title;", con)
    sqlsearch1.Parameters.AddWithValue("?name", TextBox1.Text)
    sqlsearch2.Parameters.AddWithValue("?title", TextBox1.Text)

    If RadioName.Checked = True Then
        con.Open()

        Dim table As DataTable
        For Each table In ds.Tables
        Next
        ' Clear all rows of each table.
        ds.Clear()

        ' display results in Datagrid1.
        DataAdapter1.SelectCommand = sqlsearch1
        DataAdapter1.Fill(ds, "stratos")
        DataGrid1.DataSource = ds
        DataGrid1.DataMember = "stratos"
        con.Close()
    Else
    End If

    If RadioTitle.Checked = True Then
        con.Open()

        Dim table As DataTable
        For Each table In ds.Tables
        Next
        ' Clear all rows of each table.
        ds.Clear()

        ' display results in Datagrid1.
        DataAdapter1.SelectCommand = sqlsearch2
        DataAdapter1.Fill(ds, "stratos")
        DataGrid1.DataSource = ds
        DataGrid1.DataMember = "stratos"
        con.Close()
    Else
    End If
End Sub


for deleting, you can simply issue a delete statement and pass it a parameter, namely name.

DELETE FROM MyTable WHERE MyName = @Name

Im not sure what you need the group box for.


If you are doing something like

 Set recBooks = con.Execute("SELECT * FROM Admin WHERE Name like 'hey' ;")

recbooks.count will return the number of records.

And for deleting, just run the query

  DELETE FROM Admin WHERE Name = {0}

when the button is clicked, and reload the datagrid using datagrid.refresh()

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜