public void DeleteMainDisplayMenu() { string query, MenuName, GroupNo; SqlCommand command; connection = new SqlConnection(connectionString); connection.Open(); query = "select Menu_Name from tblSelectMenu"; command = new SqlCommand(query, connection); SqlDataReader reader = command.ExecuteReader(); while (reader.HasRows) { MenuName = reader.GetName(0); GroupNo = reader.GetName(1); while (reader.Read()) { MenuName = reader.GetString(0); GroupNo = reader.GetString(1); MenuName = MenuName.Trim(); GroupNo = GroupNo.Trim(); if (MenuName != "") { query = "DELETE FROM tblDisplayMenu WHERE Menu_Name='" + MenuName + "'"; DeleteItemFromTable(query); } } reader.NextResult(); } reader.Close(); query = "DELETE tblSellectMenu"; DeleteItemFromTable(query); connection.Close(); }