I am not able to rectify this following error : System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'OAT'

0
protected void btnDeleteVenue_Click(object sender, EventArgs e)
        {
            try
            {
                con.Open();
                string ddl = DropDownList1.SelectedItem.Value;
                string sq = "select venue_name from Venue";
                cmd = new SqlCommand(sq, con);
                SqlDataReader r = cmd.ExecuteReader();
                string dq = null;
                if (r.HasRows)
                {
                    while (r.Read())
                    {
                        if (ddl.Equals(r.GetValue(0).ToString()))
                        {
                           string dq = "DELETE from Venue WHERE venue_name=" + ddl;
                            //.Close();
                            cmd = new SqlCommand(dq, con);
                            cmd.ExecuteNonQuery();
                            Response.Write("<script> alert('Venue Deleted') </script>");
                            con.Close();
                        }
                    }
                }

            }
            catch(Exception ex)
            {
                Response.Write(ex);
            }
        }
c#
sql-server
visual-studio
asked on Stack Overflow Mar 5, 2020 by Sonu Hc • edited Mar 5, 2020 by Shadow

1 Answer

1

Change this line to. A string must be quoted.

string dq = "DELETE from Venue WHERE venue_name='" + ddl + "'";
answered on Stack Overflow Mar 5, 2020 by Bernd Buffen

User contributions licensed under CC BY-SA 3.0