Form Table Data

[EDN Admin]

Hi,
I am writing a program that will take data from asp form and with the click of a button it will display information from an sql database and display it into a datagrid. Here is the code.
ASP


<asp:UpdatePanel runat="server" ID="updatepage
<ContentTemplate>
<br />

<div id="mvSearchHeader
<h5 id="headerText" style="display:inline; Search</h5>

<aspanel runat="server" id="mvSearch
<table runat="server" id="tbmvSearch
<tr class="hidden
<td>Site</td>
<td>
<aspropDownList runat="server" ID="ddlSites" />
</td>
</tr>
<tr>
<td>Arival Date</td>
<td>
<asp:TextBox ID="txtArrivalDate" runat="server </asp:TextBox>
<asp:CalendarExtender ID="txtArrivalDate_CalendarExtender" runat="server"
Enabled="True" TargetControlID="txtArrivalDate
</asp:CalendarExtender>
</td>
</tr>
<tr>
<td>Departure Date</td>
<td>
<asp:TextBox ID="txtDepartureDate" runat="server </asp:TextBox>
<asp:CalendarExtender ID="txtDepartureDate_CalendarExtender" runat="server"
Enabled="True" TargetControlID="txtDepartureDate
</asp:CalendarExtender>
</td>
</tr>
<tr>
<td>Reservation Number</td>
<td>
<asp:TextBox ID="resNumber" runat="server </asp:TextBox>
</td>
</tr>
<tr>
<td>Name</td>
<td>
<asp:TextBox ID="name" runat="server </asp:TextBox>
</td>
</tr>
<tr>
<td>Room Number</td>
<td>
<asp:TextBox ID="roomNum" runat="server </asp:TextBox>
</td>
</tr>
</table>

<asp:Button ID="btnSearch" runat="server" Text="Search"
onclick="btnSearch_Click" />

</aspanel>
<asp:CollapsiblePanelExtender runat="server" id="collapseSearchPanel" TargetControlID="mvSearch" CollapseControlID="mvSearchHeader" ExpandControlID="mvSearchHeader" Collapsed="true
</asp:CollapsiblePanelExtender>

<br />


<aspataGrid runat="server" ID="dgMonthlyView
<Columns>
<asp:BoundColumn HeaderText="Arrival Date" DataField="ArrivalDate" />
<asp:BoundColumn HeaderText="Departure Date" DataField="DepartureDate" />
<asp:BoundColumn HeaderText="Reservation Number" DataField="ID" />
<asp:TemplateColumn HeaderText="Name
<ItemTemplate>
<asp:Label runat="server" ID="lblName" Text=<%# ((HostelDataTypes.Guest)(Eval("Guest"))).Name %> />
</ItemTemplate>
</asp:TemplateColumn>
<asp:BoundColumn HeaderText="Room Number" DataField="Room" />
</Columns>
</aspataGrid>
</ContentTemplate>
</asp:UpdatePanel>
</asp:Content>


Code Within


namespace RANDOM
{
public partial class MonthlyView : System.Web.UI.Page
{
private List<HostelDataTypes.Reservation> reservations;
private List<HostelDataTypes.Site> sites;

private void BindSites()
{
DataLink dataLink = new DataLink();
sites = dataLink.lookUpSite();
if (sites != null)
{
if (sites.Count > 0)
{
ddlSites.DataSource = sites;
ddlSites.DataBind();
}
}
}

private void BindReservations()
{
DataLink dataLink = new DataLink();
reservations = dataLink.lookUpReservation();
if (reservations != null)
{
if (reservations.Count > 0)
{
dgMonthlyView.DataSource = reservations;
dgMonthlyView.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindReservations();
}
}

protected void btnSearch_Click(object sender, EventArgs e)
{

if()
{
dgMonthlyView.DataSource = reservations;
dgMonthlyView.DataBind();
}
}
}
}


I am unsure what to write inside of the click event, can someone help?

View the full article