inserting the data in to the existing table

See more:

C#

ASP.NET

SQL-Server

, +

hi all,

i had created a webpage in that i taken the gridview and in that i used the column names as

openingbalance,totalhrs,leavetaken,remaining

Among all these columns except openingbalance remaining all columns are present in another table i just wrote the query like this and filled the gridview.

select E.EmployeeID,0 as OpeningBalance,E.FullName,S.TotalHrs,S.LeaveTaken,S.LeaveTypeId,
	 S.Remaining from Employee E left outer join CurrentYearLeaveSummery S on E.EmployeeID = S.EmployeeID 
	 where s.LeaveTypeId=1

in that webpage i given textbox for all columns and i given editing options to them.
Now my problem is i want to insert or update data then the table with that columns get reflected but if i enter value for openingbalance where it gets entered becoz there is no column in that table.

how i need to take that column in same table to enter the data from frontend.
also tell me edit option code in frontend withrespect to row command.