Member Avatar for kshahnazari

I am writing a simple data reader to fill a dropdownlist but i have an error that dont know what it means :

SqlConnection cmd = new SqlConnection(ConfigurationManager.ConnectionStrings["Mysqlcon"].ConnectionString);
        SqlCommand rmdd = new SqlCommand("Select Distinct Language from Ready Versions", cmd);
        cmd.Open();

        SqlDataReader mrreader = rmdd.ExecuteReader();

        if (mrreader.HasRows)
        {
            while (mrreader.Read())
            {
                DropDownList1.Items.Add(mrreader.ToString());
            }
        }
        mrreader.Dispose();
        cmd.Close();
        cmd.Dispose();

it gives this error in this line SqlDataReader mrreader = rmdd.ExecuteReader();

it says invalid object name Ready . Please someone help

  • 2 Contributors
  • 1 Reply
  • 80 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for pritaeas

If `Ready Versions` is your table name, then use the backticks. It does not allow a space like that.

Edited by pritaeas because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.