Hi
I have just added in a second textbox and tried, still only getting the first date, this is the code I think you mean. Thanks
<%@ Page Title="Home Page" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<asp:Content runat="server" ID="FeaturedContent" ContentPlaceHolderID="FeaturedContent">
<section class="featured">
<div class="content-wrapper">
<hgroup class="title">
<h1><%: Title %>.</h1>
<h2>Web Samples Table</h2>
</hgroup>
</div>
</section>
</asp:Content>
<asp:Content runat="server" ID="BodyContent" ContentPlaceHolderID="MainContent">
<h3>
Date1:
<asp:TextBox ID="TexDate" runat="server" Width="295px"></asp:TextBox>
Date2:<asp:TextBox ID="TexDate2" runat="server" Width="282px"></asp:TextBox>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataKeyNames="Column_0" DataSourceID="Websamples" AllowPaging="True"
Height="236px" Width="1288px" BackColor="White" BorderColor="#DEDFDE"
BorderStyle="None" BorderWidth="1px" CellPadding="4" ForeColor="Black"
GridLines="Vertical">
<AlternatingRowStyle BackColor="White" />
<Columns>
<asp:BoundField DataField="Column_0" HeaderText="Column_0" ReadOnly="True"
SortExpression="Column_0" />
<asp:BoundField DataField="Date_Submitted" HeaderText="Date_Submitted"
SortExpression="Date_Submitted" />
<asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
<asp:BoundField DataField="Email" HeaderText="Email" SortExpression="Email" />
<asp:BoundField DataField="Telephone" HeaderText="Telephone"
SortExpression="Telephone" />
</Columns>
<FooterStyle BackColor="#CCCC99" />
<HeaderStyle BackColor="#6B696B" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#F7F7DE" ForeColor="Black" HorizontalAlign="Right" />
<RowStyle BackColor="#F7F7DE" />
<SelectedRowStyle BackColor="#CE5D5A" Font-Bold="True" ForeColor="White" />
<SortedAscendingCellStyle BackColor="#FBFBF2" />
<SortedAscendingHeaderStyle BackColor="#848384" />
<SortedDescendingCellStyle BackColor="#EAEAD3" />
<SortedDescendingHeaderStyle BackColor="#575357" />
</asp:GridView>
<asp:Button ID="Button1" runat="server" Text="Find" />
<asp:SqlDataSource ID="Websamples" runat="server"
ConnectionString="<%$ ConnectionStrings:wensamplesConnectionString %>"
SelectCommand="SELECT Column_0, Date_Submitted, Name, Email, Telephone FROM WebSamples WHERE (Date_Submitted = @Date_Submitted) OR (Date_Submitted = @Date_Submitted2)"
ConflictDetection="CompareAllValues"
DeleteCommand="DELETE FROM [WebSamples] WHERE [Column_0] = @original_Column_0 AND (([Date_Submitted] = @original_Date_Submitted) OR ([Date_Submitted] IS NULL AND @original_Date_Submitted IS NULL)) AND (([Name] = @original_Name) OR ([Name] IS NULL AND @original_Name IS NULL)) AND ((
= @original_Email) OR ([Email] IS NULL AND @original_Email IS NULL)) AND (([Telephone] = @original_Telephone) OR ([Telephone] IS NULL AND @original_Telephone IS NULL))"
InsertCommand="INSERT INTO [WebSamples] ([Column_0], [Date_Submitted], [Name], [Email], [Telephone]) VALUES (@Column_0, @Date_Submitted, @Name, @Email, @Telephone)"
OldValuesParameterFormatString="original_{0}"
UpdateCommand="UPDATE [WebSamples] SET [Date_Submitted] = @Date_Submitted, [Name] = @Name, [Email] = @Email, [Telephone] = @Telephone WHERE [Column_0] = @original_Column_0 AND (([Date_Submitted] = @original_Date_Submitted) OR ([Date_Submitted] IS NULL AND @original_Date_Submitted IS NULL)) AND (([Name] = @original_Name) OR ([Name] IS NULL AND @original_Name IS NULL)) AND (([Email] = @original_Email) OR ([Email] IS NULL AND @original_Email IS NULL)) AND (([Telephone] = @original_Telephone) OR ([Telephone] IS NULL AND @original_Telephone IS NULL))">
<DeleteParameters>
<asp
arameter Name="original_Column_0" Type="String" />
<asp
arameter Name="original_Date_Submitted" Type="String" />
<asp
arameter Name="original_Name" Type="String" />
<asp
arameter Name="original_Email" Type="String" />
<asp
arameter Name="original_Telephone" Type="String" />
</DeleteParameters>
<InsertParameters>
<asp
arameter Name="Column_0" Type="String" />
<asp
arameter Name="Date_Submitted" Type="String" />
<asp
arameter Name="Name" Type="String" />
<asp
arameter Name="Email" Type="String" />
<asp
arameter Name="Telephone" Type="String" />
</InsertParameters>
<SelectParameters>
<asp:ControlParameter ControlID="TexDate" Name="Date_Submitted"
PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="TexDate2" Name="Date_Submitted2"
PropertyName="Text" />
</SelectParameters>
<UpdateParameters>
<asp
arameter Name="Date_Submitted" Type="String" />
<asp
arameter Name="Name" Type="String" />
<asp
arameter Name="Email" Type="String" />
<asp
arameter Name="Telephone" Type="String" />
<asp
arameter Name="original_Column_0" Type="String" />
<asp
arameter Name="original_Date_Submitted" Type="String" />
<asp
arameter Name="original_Name" Type="String" />
<asp
arameter Name="original_Email" Type="String" />
<asp
arameter Name="original_Telephone" Type="String" />
</UpdateParameters>
</asp:SqlDataSource>
</h3>
</asp:Content>