C#

RameshwerE wrote:

your idea is good

RameshwerE wrote:

my forms backcolot is changing dynamically

//Constructor code
this.BackColorChanged += new System.EventHandler(this.yourForm_BackColorChanged);

private void yourForm_BackColorChanged(object sender, System.EventArgs e)
{
	this.TransparencyKey = this.BackColor;
}

SqlDataReader dr = myCommand.ExecuteReader();

while (dr.Read()) // reads as long as there are values 
{
  DataRow row = myTable.NewRow();
  row[0] = dr.GetString(0); // to get the Name column
  row[1] = ...... // if you have other columns
  myTable.Rows.Add(row);
}
dr.Close();

ArrayList myList = new ArrayList();
SqlDataReader dr = myCommand.ExecuteReader();
while (dr.Read()) // reads as long as there are values 
    myList.Add(dr.GetString(0)); // to get the Name column  
dr.Close();

Array myArray = myList.ToArray();

ddlFoo.DataSource = myTable;
ddlFoo.DataTextField = "ColumnNameForText";
ddlFoo.DataValueField = "ColumnNameForValue";
ddlFoo.DataBind();

ddlFoo.DataSource = myList;
ddlFoo.DataTextField = "Text";
ddlFoo.DataValueField = "Value";
ddlFoo.DataBind();