c# - 在asp.net中从mysql数据库获取信息

Question

我正在使用这些 using 语句-

  using System;
  using System.Data;
  using System.Data.Odbc;
  using System.Configuration;
  using System.Collections;
  using System.Web;
  using System.Web.Security;
  using System.Web.UI;
  using System.Web.UI.WebControls;
  using System.Web.UI.WebControls.WebParts;
  using System.Web.UI.HtmlControls;
  using System.Data.SqlClient;

这是我尝试将术语信息放入下拉列表

   protected void getAppTerm()
         {
            string status, y;
           y = "";
            string CommandText = "select term from Terms";
            OdbcConnection myConnection = dbconnect();
            OdbcCommand myCommand = new OdbcCommand(CommandText, myConnection);

        try
        {
            myConnection.Open();
            OdbcDataReader reader = myCommand.ExecuteReader();
            while (reader.Read())
            {
                status = reader.GetString(0);
                foreach (ListItem item in ddlApplicationTerm.Items)
                {
                    y = item.Text;
                }
                if (!(status == y))
                {
                    ddlApplicationTerm.Items.Add(status);
                }
            }

        }
        catch (OdbcException ex)
        {

        }
        finally
        {
            myConnection.Close();
        }
    }

该信息不会进入下拉列表。我也安装了所有驱动程序。

Answer 1

protected void getAppTerm()
{
    string CommandText = "select term from Terms";
    OdbcConnection myConnection = dbconnect();
    OdbcCommand myCommand = new OdbcCommand(CommandText, myConnection);

    try
    {
        myConnection.Open();
        OdbcDataReader reader = myCommand.ExecuteReader();
        while (reader.Read())
        {
            // Currently, you're overwriting the variable "y" on every iteration
            // and then just comparing the last item.text to status.

            var status = reader.GetString(0);
            if (!ddlApplicationTerm.Items.Contains(status)
                ddlApplicationTerm.Items.Add(status);
        }
    }
    catch (Exception e)
    {
        MessageBox.Show(e.ToString());
    }
    finally
    {
        myConnection.Close();
    }
}