Copying a set of rows from clipboard in Excel sheet to Datagridview

[MathewJose]

Hi,

I have a DatagridView in windows form.It has got a column which has some names that are populated from master table in database.Now i need to copy a set of data against these names.

I tried to populate data to the first column from database and then tried to copy excel sheet data against each name but some exceptions are coming.It says "cannot programmaticaly add rows while using data bind".

This is the code that i used for copying excel to grid.Plz help.....

DataRow row = null;
Array colValues = null;
string excelRow = null;
DataTable excelTable = null;
IDataObject clipboardData = null;
excelTable = new DataTable("Exce l");

if (Clipboard.Cont ainsData(DataFo rmats.CommaSepa ratedValue))

{

clipboardData = Clipboard.GetDa taObject();

using (StreamReader reader = new StreamReader((S tream)(clipboar dData.GetData(D ataFormats.Comm aSeparatedValue ))))

{

while (reader.Peek() > 0)

{

excelRow = reader.ReadLine ();

colValues = excelRow.Split( ',');

if (! (excelTable.Col umns.Count > 0))

{

for (int i = 0; i <= colValues.GetUp perBound(0); i++)

{

excelTable.Colu mns.Add();

}

}

row = excelTable.NewR ow();

for (int i = 0; i <= colValues.GetUp perBound(0); i++)

{

row[i] = colValues.GetVa lue(i);

}

excelTable.Rows .Add(row);

}

}

}
uxGrid.DataSour ce = excelTable;