<div>
That looks like a pivot/cross-tab, but you didn't indicate the database that you are using. &nbsp;That could either be the job for a query, or you could do it in code also.
</div>


That looks like a pivot/cross-tab, but you didn't indicate the database that you are using.  That could either be the job for a query, or you could do it in code also.

<div>
I am using SQL Server 2000. Would you please help me out. Thanks.
</div>


I am using SQL Server 2000. Would you please help me out. Thanks.

<div>
<div class="content wysiwyg-content">
I want to display the data in the following format in a gridview whenever a user is selected.<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Username1 &nbsp; &nbsp; Username2 &nbsp; &nbsp; Password<br />
IPAD &nbsp; &nbsp; &nbsp; &nbsp; XXXXX11 &nbsp; &nbsp; &nbsp; &nbsp;XXXXX21 &nbsp; &nbsp; &nbsp; &nbsp; XXXXXp1<br />
PC1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XXXXX12 &nbsp; &nbsp; &nbsp; &nbsp;XXXXX22 &nbsp; &nbsp; &nbsp; &nbsp; XXXXXp2<br />
PC2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XXXXX13 &nbsp; &nbsp; &nbsp; &nbsp;XXXXX23 &nbsp; &nbsp; &nbsp; &nbsp; XXXXXp3 &nbsp; &nbsp;<br />
PC3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XXXXX14 &nbsp; &nbsp; &nbsp; &nbsp;XXXXX24 &nbsp; &nbsp; &nbsp; &nbsp; XXXXXp4 &nbsp;<br />
<br />
I have two tables 1) tblMachines 2)tblPasswords<br />
1) tblMachine --&gt;<br />
&nbsp; &nbsp; &nbsp;MachineId,<br />
&nbsp; &nbsp; &nbsp;MachineName<br />
2) tblPasswords --&gt;<br />
&nbsp; &nbsp; &nbsp;PassId<br />
&nbsp; &nbsp; &nbsp;UserId<br />
&nbsp; &nbsp; &nbsp;MachineId<br />
&nbsp; &nbsp; &nbsp;Username1<br />
&nbsp; &nbsp; &nbsp;Username2<br />
&nbsp; &nbsp; &nbsp;Password<br />
<br />
Would someone help me. Thanks.
</div>
</div>


I want to display the data in the following format in a gridview whenever a user is selected.

              Username1     Username2     Password
IPAD         XXXXX11        XXXXX21         XXXXXp1
PC1          XXXXX12        XXXXX22         XXXXXp2
PC2          XXXXX13        XXXXX23         XXXXXp3    
PC3          XXXXX14        XXXXX24         XXXXXp4  

I have two tables 1) tblMachines 2)tblPasswords
1) tblMachine -->
     MachineId,
     MachineName
2) tblPasswords -->
     PassId
     UserId
     MachineId
     Username1
     Username2
     Password

Would someone help me. Thanks.

Gridview - Matrix format

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications