getting info from mysql database in asp.net

Question

i am using these using statements-

  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;

and this is me attempting to get the term info into a dropdownlist

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

The info is not going into the drop down list. i have all of the drivers installed too.

Any particular reason you're not using the MySQL Connector for .Net? — womp
– womp, Commented Jul 14, 2011 at 19:31
Your catch block is empty. Did you check if it threw any exception? — ghimireniraj
– ghimireniraj, Commented Jul 14, 2011 at 19:33

Grant Winney · Accepted Answer · 2011-07-14 19:34:59Z

2

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

answered Jul 14, 2011 at 19:34

Grant Winney

66.6k13 gold badges120 silver badges167 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tim Over a year ago

+1 for complete example and doing something in the catch block

Xiphos · Accepted Answer · 2011-07-14 19:35:15Z

0

Try using the SqlConnection items if your data is in an SQL server.

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

answered Jul 14, 2011 at 19:35

Xiphos

3381 silver badge9 bronze badges

1 Comment

Tim Over a year ago

OP's question title and tags say MySQL.

Tim · Accepted Answer · 2011-07-14 19:36:18Z

0

If you're trying to add items that aren't in the list, you need to adjust the code in your foreach loop:

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

answered Jul 14, 2011 at 19:36

Tim

28.6k8 gold badges65 silver badges80 bronze badges

Collectives™ on Stack Overflow

getting info from mysql database in asp.net

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related