using System;
using System.Data;
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;

public partial class gridview : System.Web.UI.Page
{

    SqlConnection conn = new SqlConnection("server=70.86.107.2;database=AZ;uid=aztecexim;pwd=Az*nEw9");
    DataSet ds;
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlDataAdapter da = new SqlDataAdapter("Select top 20 * from [ac-subaccounts] where compid=3", conn);
        da.Fill(ds, "[ac-subaccounts]");


        if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item)
        {
            DropDownList list = (DropDownList)e.Item.FindControl("DropDownList1");
            list.DataSource = ds;
            list.DataBind();
        }
       


    }
}