If there's no relation then you really have no choice but to manually update.

Have fun with that one. :-)

exactly, if we haven't another way.  I have to hard code to update database table. By the way, these 2 tables dont have relation.

Thanks Robert.

But how are these 2 tables joined together or are they not joined at all???  Do you have a PK on each table that is a 1-1 relation? 

Look into joining your tables through the use of PIVOT since your trying to do a cross tab type report.

You might not be able to use the SqlDataSource intrinsic update methods though. You will have to capture the update event and manually update the database.  Just handle the UpdateRow event:

    Protected Sub UltraWebGrid1_UpdateRow(ByVal sender As Object, ByVal e As Infragistics.WebUI.UltraWebGrid.RowEventArgs) Handles UltraWebGrid1.UpdateRow
       
    End Sub

we can write store procedure using CURSOR, add column one by one. column name is  2008-02-02,2008-02-03,... 

How are these 2 tables joined together?  AllI see is a date in the one?