bool match = false;
public void delmethod()
{
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
SqlCommand command = connection.CreateCommand();
command.CommandText = "SELECT * FROM YOURTABLE";
SqlDataReader dataread = command.ExecuteReader();
while (dataread.Read() && located != true)
{
if (textBox1.Text == dataread["PRECISEPASSWORD"].ToString())
{
match = true;
}
else
{
match = false;
}
}
}
private void button1_Click(object sender, EventArgs e)
{
delmethod();
if (match == true)
{
SqlConnection connection = new SqlConnection(ConnectionString.Conn);
connection.Open();
SqlCommand asd = connection.CreateCommand();
asd.CommandText = "DELETE FROM YOUTRABLE WHERE Username ='" + YOURUSERNAME + "'";
asd.ExecuteNonQuery();
connection.Close();
}
This should help with what you need. Any other questions don't hesitate to ask.