c# - 无法绑定多部分标识符“Utility._userid”

Question

尝试在我的 C# WinForms 应用程序（使用 SQL 的数据库）中创建删除语句时出现此错误：

无法绑定多部分标识符“Utility._userid”。

这是我的代码：

foreach (DataRow dr in dtbl.Rows)
{
    if (dr[1].ToString() == this.user_TXT.Text.ToString() && dr[2].ToString() == this.pass_TXT.Text.ToString())
    {
        Utility._userid = Int16.Parse(dr[0].ToString());//**this is where im getting the error**
        SqlCommand cmd1 = new SqlCommand("Select Remainder from OrderHeader where UserID=Utility._userid ",sqlcon);
        int oi = Convert.ToInt16(cmd1.ExecuteScalar());
        if (oi != 0)
        {
            MessageBox.Show("User cannot be deleted! Existant orders.");
        }
        else
        {
            SqlCommand cmd = new SqlCommand("Delete * from Users where Username=this.user_TXT", sqlcon);
            cmd.ExecuteNonQuery();
            cmd.Dispose();
            MessageBox.Show("User has been deleted");
        }
    }
    else continue;
}
if (a == 0)
    MessageBox.Show("Wrong username or password!");
sqlcon.Close();

标签： c#sql