»Dotnet Ads
»Message Boards
Message Boards
Dotnet Books
»Member Details
Register
Login
LogOut
Submit Code
Submit Jobs
Submit Projects
»Competition
Community
Winners
Prizes
Write For Us
Members
»Other Resources
Links
Dotnet Resources
|
Converting Selected columns from a DataGrid to a DataTable
int colindex, rowindex;
if (this.dataGridView1.SelectedRows.Count > 0)
{
DataTable dt = new DataTable("Table1");
int columns = dataGridView1.ColumnCount;
int i = 0;
for (i = 0; i < columns; i++)
{
dt.Columns.Add(dataGridView1.Columns[i].Name.ToString());
}
DataRow dr = null;
foreach (DataGridViewCell cell in dataGridView1.SelectedCells)
{
colindex = cell.ColumnIndex;
rowindex = cell.RowIndex;
textBox1.Text = this.dataGridView1.Rows[rowindex].Cells[colindex].Value.ToString();
if (colindex == 0)
{
dr = dt.NewRow();
}
dr[colindex] = textBox1.Text;
if (colindex == (columns-1))
{
dt.Rows.Add(dr);
dt.AcceptChanges();
}
}
DataSet ds = new DataSet("table");
ds.Tables.Add(dt);
sendParameters(dt, 1);
|
|