Non-invocable member 'DetailsForm.cmd' cannot be used like a method

Question

I`m trying to make command work but it doesnt work help please. this error appears at cmd("delete

i have sqlcommand cmd;

private void DeleteRecordBtn_Click(object sender, EventArgs e)
    {
        cmd("delete blacklist1 where idnumber=@Idnumber", con);
        con.Open();
        cmd.Parameters.AddWithValue("@idnumber", UID.Text);
        cmd.ExecuteNonQuery();
        con.Close();

    }

Non-invocable member 'DetailsForm.cmd' cannot be used like a method red line under cmd("delete blacklist1 where idnumber=@Idnumber", con); — Luka, Dec 18 '17 at 13:54
And for the next error you will get, add a `FROM` clause to your command. — oerkelens, Dec 18 '17 at 14:02

score 2 · Accepted Answer · answered Dec 18 '17 at 13:55

2

This line:

cmd("delete blacklist1 where idnumber=@Idnumber", con);

Should be:

cmd = new SqlCommand("delete blacklist1 where idnumber=@Idnumber", con);

However, you should put this inside a using block in order to release cmd resources once it finish. See: SqlCommand with using statement

answered Dec 18 '17 at 13:55

Oscar

13,594
8
47
75

using (cmd = new SqlCommand("delete blacklist1 where idnumber=@Idnumber", con)) worked thank you – Luka Dec 18 '17 at 14:01
@Luka I would declare cmd variable local to the using block instead of making it a class member. – Oscar Dec 18 '17 at 14:07
I failed to do that – Luka Dec 18 '17 at 14:13

Non-invocable member 'DetailsForm.cmd' cannot be used like a method

1 Answers1