Is such a GridView possible to populate

check this

http://www.aspsnippets.com/Articles/Add-record-to-Database-using-ASP.Net-GridView-EmptyDataTemplate-and-FooterTemplate.aspx

Sir,

I am binding the gridview to DataTable object.

Let me explain.

I have a gridview which i populate using a datatable object. This datatable object is loaded from a sql table.

When i edit any of the columns or add a new record i do not want to reflext the changes to the database immediately.. Instead it should only show in the gridview..

You can refer the same article. Only thing you will need to add rows to datatable.

I'll give you one more article that will help yu how to add records to datatable

http://www.aspsnippets.com/Articles/Adding-Dynamic-Rows-in-ASP.NET-GridView-Control-with-TextBoxes-and-with-Delete-functionality.aspx

Sir,

That is a very nice article by you. Actually what i want to do is:

I am populating a DATATABLE OBJECT with data from sql table and then binding it to gridview like this:

gv.DataSource=DT;

gv.DataBind();

In this gridview when i update any data it should not affect the actual sql table but only the DATATABLE OBJECT which i again want to bind it to griview.

My problem here is if i have say some 2 or more rows. And i update 1 row how to reflect it in DATATABLE OBJECT if i am using gridview updating event?

You will have to find the row on datatable and then update it

http://msdn.microsoft.com/en-us/library/y06xa2h1(v=vs.80).aspx