Author: VxChemical | Posted on: 3/23/2010 9:16:05 AM | Views : 216

out of this code, do i see what table that it selects from my database?


</asp:GridView> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:VisitorAccessConnectionString %>" SelectCommand="SELECT Id, LastName, FirstName, Company, Escort, DateofAccessFromD, DateOfAccessFromM, DateOfAccessFromY, DateOfAccessToM, DateOfAccessToD, DateOfAccessToY, Location_Id, RequestingOffice_Id, TimeOfAccessFrom, TimeOfAccessTo, RequestDate, ApprovedBy, VisitingSection, LastName + ', ' + FirstName AS FullName, ISNULL(IsApproved, 0) AS ApproveStatus FROM dbo.Visitors WHERE (DateOfAccessFrom <= @DateOfAccessFrom) AND (DateOfAccessTo > @DateOfAccessTo) ORDER BY LastName"> <SelectParameters> <asp:ControlParameter Co ...

Go to the complete details ...