Fixed header in a gridview (both horizontally and vertically)

Question

Hi,
How to get a fixed header both horizontally and vertically in a gridview?
 
I have my gridview located in a scrollable (auto) panel control and want to have the header row fixed. I want it always visible and when I scroll horizontally I want that the header row should follow so that I can see headers for columns all the time.
 
I have just found solutions for making the header row fixed vertically but I need it to be fixed both vertically and horizontally. Any ideas/solutions is highly appreciated. 

Answer 1

Hi check the link

http://www.aspsnippets.com/Articles/Create-and-Drop-SQL-Server-Table-programmatically-using-ADONet-C-and-VBNet.aspx

For insert record in table

http://www.aspsnippets.com/Articles/Using-SqlBulkCopy-to-import-Excel-SpreadSheet-data-into-SQL-Server-in-ASPNet-using-C-and-VBNet.aspx

Answer 2

Hi,

Its just the idea, try to use the import functionality of SQL server.

Hope it helps.

Thanks.