<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1250">
<META content="MSHTML 6.00.2900.3020" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=500235900-03012007><FONT face=Arial size=2>Hi all.
</FONT></SPAN></DIV>
<DIV><SPAN class=500235900-03012007><FONT face=Arial size=2>I have a couple of
days to look at some .net stuff.</FONT></SPAN></DIV>
<DIV><SPAN class=500235900-03012007><FONT face=Arial size=2>I am going to
convert a current ASP site (4 pages) to .Net.</FONT></SPAN></DIV>
<DIV><SPAN class=500235900-03012007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=500235900-03012007><FONT face=Arial size=2>I have a DBGrid I
want to populate froma stored procedure, and currently it works, BUT the fields
displayed on the screen are NOT the ones defined in the .aspx file,
</FONT></SPAN></DIV>
<DIV><SPAN class=500235900-03012007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=500235900-03012007><FONT face=Arial size=2><ASP:DataGrid
id="DataGrid1"
runat="server"><BR>
<Columns><BR>
<ASP:BoundColumn datafield="patient"
headertext="Patient"></ASP:BoundColumn><BR>
<ASP:BoundColumn datafield="APPLICATION_DATE"
headertext="Date"></ASP:BoundColumn><BR>
<ASP:BoundColumn datafield="Doctor"
headertext="Doctor"></ASP:BoundColumn><BR>
<ASP:BoundColumn datafield="SURGERY"
headertext="Surgery"></ASP:BoundColumn><BR>
<ASP:BoundColumn datafield="CANCER"
headertext="Cancer"></ASP:BoundColumn><BR>
</Columns></ASP:DataGrid></p></FONT></SPAN></DIV>
<DIV><SPAN class=500235900-03012007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=500235900-03012007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=500235900-03012007><FONT face=Arial size=2>what I get is ALL
the fields returned.</FONT></SPAN></DIV>
<DIV><SPAN class=500235900-03012007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=500235900-03012007><FONT face=Arial size=2>This is my code. can
anyoen see WHY I get the result I get ?</FONT></SPAN></DIV>
<DIV><SPAN class=500235900-03012007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=500235900-03012007><FONT face=Arial size=2> SqlConnection1
:= SQLConnection.create(sConstr);<BR> sqlDA :=
SQLDataAdapter.Create('EXEC PEP_SSB_Registration_Summary_lsp
1',SqlConnection1);<BR> ds :=
Dataset.create;</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN class=500235900-03012007><FONT face=Arial size=2>
sqlDA.Fill(ds);<BR>
DataGrid1.DataSource:=Ds;<BR>
DataGrid1.Columns.Clear;<BR>
DataGrid1.DataKeyField:='SSB_APPLICATION_ID';<BR>
DataBind;</FONT></SPAN></DIV>
<DIV><SPAN class=500235900-03012007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=500235900-03012007><FONT face=Arial size=2>Thanks,
Jeremy</FONT></SPAN></DIV></BODY></HTML>
<BR>
<P><FONT SIZE=2>--<BR>
No virus found in this outgoing message.<BR>
Checked by AVG Free Edition.<BR>
Version: 7.5.432 / Virus Database: 268.16.3/614 - Release Date: 02/01/2007 14:58<BR>
</FONT> </P>