Click here to Skip to main content
11,430,109 members (73,348 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C#2.0
Table is having simple 1 to 1 relation like
MAPID | STUDENT | ADVISOR | ADVISORLEVLE | CREATEDDATE
And another log table as
LOGID | STUDENT | aDVISOR | ADVISORLEVEL | cTREATEDDATE | HISTORYDATE 

I have transposed the table data as I want disply it in grid as :


s
tudent Adviser1 Adv2   Adv3    Adv4    Adv 5
 
1	ASD	 SSD	BBC	COD	ADG
2	QQQ	 SFD	VBC	CGD	DFG
3	WWW	 SHD	BBC	CKD	AFG
4	SSS	 NSD	BFC	RCD	ADS
5	XXX	 YSD	LBC	UID	AHG


I have done transpose of data at database level and binding the datatable in transposed format to the gridview

I want to insert the records for history in the logtable and update the main mapping table


Can anyone help me out

I am stuck with this



Thanx a ton in advance ......

[edit]SHOUTING removed - OriginalGriff[/edit]
Posted 27-Dec-12 2:02am
Edited 27-Dec-12 2:21am
(no name)1.3M
v2
Comments
OriginalGriff at 27-Dec-12 7:21am
   
DON'T SHOUT. Using all capitals is considered shouting on the internet, and rude (using all lower case is considered childish). Use proper capitalisation if you want to be taken seriously.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



Advertise | Privacy | Mobile
Web04 | 2.8.150428.2 | Last Updated 27 Dec 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100