Append data to the exited data and display in gridview

znaneswar kodavanti

public static DataTable GetDataColumnExcel(string filename, string colomnname,string Table)
        {
            System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0; Data Source = " + filename + "; Extended Properties = \"Excel 8.0;HDR=Yes;IMEX=1\";");
            conn.Open();

            string strQuery = "SELECT [" + colomnname + "] FROM [" + Table + "]";


            System.Data.OleDb.OleDbDataAdapter adapter = new System.Data.OleDb.OleDbDataAdapter(strQuery, conn);
            System.Data.DataSet ds = new System.Data.DataSet();
            adapter.Fill(ds);
            return ds.Tables[0];
        }
dataGridView1.DataSource = dt1.DefaultView;

here the query gets the data from the excel sheet table. now i want to edit rows in particular column in that table and display to gridview. Please help me

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

znaneswar kodavanti14y ago
Thanks Dude Regards Znaneswar
0
Ehtesham14y ago
Just loop rows from datatable
foreach(DataRow dr in dt.Rows)
{
dr["qualification"]="pg";
}
dataGridView1.DataSource = dt;

Make sure before binding to datasource property of gridview your Datatable contains columnname "qualification"
0
znaneswar kodavanti14y ago
Tnx ehtesham ulla baig ur code is useful for me. But my task is i have to update the entire column by using column header. Suppose header is qualification i have to append all the rows under qualification column(suppose degree is there i had to add pg). your post also useful for me. Thanks Znaneswar.
0
Ehtesham14y ago
Use the below to get DataTable

//Get DataTable from grid
DataTable dt=(DataTable)dataGridView1.DataSource;
//Specify the row and column index which is needed to edit
dt.Rows[0][0]="value to display";
dataGridView1.DataSource=dt;

If you want to add new row use
DataRow dr= dt.NewRow();
dr[0]="value to display";
dt.Rows.add(dr);
dataGridView1.DataSource=dt;

Hope it helps
0