fahad sheikhji

fahad sheikhji

  • NA
  • 53
  • 56.8k

hi how to Display Single Column records from sql table to girdview with 6 rows ?

Mar 6 2012 4:25 AM
in aspx page three dropdwons r there..when i slect from three drop downs and enter search that records only have to show in gridview.i mean only single column should show in 6 rows for example
1001 (I)1021 (IV)
1028 (I)1068 (IV)
1035 (I)1075 (IV)
1002 (I)1022 (IV)
1029 (I)1069 (IV)
1036 (I)1076 (IV)
1003 (I)1023 (IV)
1030 (I)1070 (IV)
1037 (I)1077 (IV)
1004 (I)1024 (IV)
1031 (I)1071 (IV)
1038 (I)1078 (IV)
1005 (I)1025 (IV)
1032 (I)1072 (IV)
1039 (I)1079 (IV)
1026 (I)1066 (IV)
1033 (I)1073 (IV)
1040 (I)1080 (IV)
1027 (I)1067 (IV)
1034 (I)1074 (IV)
1041 (I)1081 (IV)
1001 s register number and (I) semister number..here i want to show records while entering search button should display like this.
my sql table contains like this

aNo,RegNo,RoomNo,DeskNo,DeskSide,ExamDate,eSession,Semister,BranchName,SubjectCode
136106210221L2/23/2012 12:00:00 AMMIPhy CyclePhysics I
13710631031L2/23/2012 12:00:00 AMMIPhy CyclePhysics I
13810641032L2/23/2012 12:00:00 AMMIPhy CyclePhysics I
13910651033L2/23/2012 12:00:00 AMMIPhy CyclePhysics I
14010061011R2/23/2012 12:00:00 AMMVIIIElectronicsCS Circuits 222
14110071012R2/23/2012 12:00:00 AMMVIIIElectronicsCS Circuits 222
14210081013R2/23/2012 12:00:00 AMMVIIIElectronicsCS Circuits 222
14310091014R2/23/2012 12:00:00 AMMVIIIElectronicsCS Circuits 222
14410101015R2/23/2012 12:00:00 AMMVIIIElectronicsCS Circuits 222
14510111011L2/24/2012 12:00:00 AMMIChe CycleElectronics
14610121012L2/24/2012 12:00:00 AMMIChe CycleElectronics
14710131013L2/24/2012 12:00:00 AMMIChe CycleElectronics
14810141014L2/24/2012 12:00:00 AMMIChe CycleElectronics
14910151015L2/24/2012 12:00:00 AMMIChe CycleElectronics
15010211011R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
15110221012R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
15210231013R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
15310241014R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
15410251015R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
15510661016R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
15610671017R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
15710681018R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
15810691019R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
159107010110R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
160107110111R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
161107210112R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
162107310113R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
163107410114R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
164107510115R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
165107610116R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
166107710117R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
167107810118R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
168107910119R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
169108010120R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
170108110121R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
17110821021R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
17210831022R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
17310841023R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
17410851024R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
17510861025R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
17610871026R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
17710881027R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
17810891028R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
17910901029R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
180109110210R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
181109210211R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
182109310212R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
183109410213R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
184109510214R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
185109610215R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
186109710216R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
187109810217R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
188109910218R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
189110010219R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV
190110110220R2/24/2012 12:00:00 AMMIVElectronicsElectronics IV


Answers (1)