Extracting data from two columns in a table in SQL server and displaying in two dropdownlists in ASP.NET respectively

See more:

ASP.NET

SQL

server

I have two dropdownlists in Asp.Net and a "Machines" table with two columns, "IPAddress" and "MachineName" in SQL Server. I am trying to extract data from both the columns in the table in SQL Server and put it in the dropdownlists. I was able to extract the "IPAddress" table only and put it in the first dropdownlist. I need to find out how to extract the data from the "MachineName" coluumn and put it in the second dropdownlist. Below I have the Page_Load with the codes for the first dropdownlist for reference.

What I have tried:

protected void Page_Load(object sender, EventArgs e)

{
    con.Open();
    string s = "Select distinct IPAddress from Machines order by IPAddress";
    SqlDataAdapter da = new SqlDataAdapter(s, con);
    DataSet ds = new DataSet();
    da.Fill(ds);
    DropDownList1.DataTextField = "IPAddress";
    DropDownList1.DataValueField = "IPAddress";
    DropDownList1.DataSource = ds;
    DropDownList1.DataBind();
    con.Close();
}