Code for Repeater Controll in ASP.NET

I am populating some data in a table with 6 columns using a repeater control in ASP.NET (VB) using the enclosed code. I want a piece of code to achieve the following functionality by attaching an if/elseif/else condition to the repeater controll: 1. For the record with<%#Eval("SOLID")%> = "40103" then the data to be displayed in one cell, merging all 6 columns in to one (ideally using colspan = 6). 2. For the record having <%#Eval("SOLID")%> = "40105" then the data to be displayed in two cell, merging the second and third column. 3. For all the other records the data to be displayed in the actual format. Following files are attached: [login to view URL] - Code written to populate repeater control. [login to view URL] - Design of existing and proposed new output.