C#

int count = dt.Columns.Count;
string[] tempRowIn = finalLine.Split(',');
if (IgnoreExtraLines && tempRowIn.Length > count) {
   string[] tempRowOut = new string[count];
   Array.Copy(tempRowIn, tempRowOut, count);
   tempRowIn = tempRowOut;
}
row.ItemArray = tempRowIn;

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