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

本文关键字：数据库 获取 信息 mysql 中从 asp net | 更新日期: 2023-09-27 18:02:35

我正在使用这些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;

这是我试图将术语info放入下拉列表

   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();
        }
    }

信息没有进入下拉列表。我已经安装了所有的驱动程序

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

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();
    }
}

如果数据在SQL服务器中，请尝试使用SqlConnection项。

SqlConnection myConn = new SqlConnection();
SQLCommand myCommand = new SQLCommand("Select term from Terms", myConn);
SqlDataReader myDR = myCommand.ExecuteReader;

如果您试图添加列表中没有的项，则需要调整foreach循环中的代码:

foreach (ListItem item in ddlApplicationTerm.Items)
{
    if (!Status == item.Text)
    {
        ddlApplicationTerm.Items.Add(new ListItem(status));
    }
}
相关文章：