Default3.aspx
<form id="form1" runat="server">
<div>
<asp:Label ID="Label1" runat="server" Text="Please Enter your name here :"></asp:Label>
<asp:TextBox ID="TextBox1" runat="server" Height="26px"
ontextchanged="TextBox1_TextChanged" style="margin-left: 13px" Width="161px"></asp:TextBox>
<asp:Button ID="Button1" runat="server" onclick="Button1_Click"
style="margin-left: 13px" Text="Click Me" Width="108px" />
</div>
<asp:FormView ID="FormView1" runat="server" DataKeyNames="ID"
DataSourceID="SqlDataSource1">
<EditItemTemplate>
ID:
<asp:Label ID="IDLabel1" runat="server" Text='<%# Eval("ID") %>' />
<br />
Name:
<asp:TextBox ID="NameTextBox" runat="server" Text='<%# Bind("Name") %>' />
<br />
<asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True"
CommandName="Update" Text="Update" />
<asp:LinkButton ID="UpdateCancelButton" runat="server"
CausesValidation="False" CommandName="Cancel" Text="Cancel" />
</EditItemTemplate>
<InsertItemTemplate>
ID:
<asp:TextBox ID="IDTextBox" runat="server" Text='<%# Bind("ID") %>' />
<br />
Name:
<asp:TextBox ID="NameTextBox" runat="server" Text='<%# Bind("Name") %>' />
<br />
<asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True"
CommandName="Insert" Text="Insert" />
<asp:LinkButton ID="InsertCancelButton" runat="server"
CausesValidation="False" CommandName="Cancel" Text="Cancel" />
</InsertItemTemplate>
<ItemTemplate>
ID:
<asp:Label ID="IDLabel" runat="server" Text='<%# Eval("ID") %>' />
<br />
Name:
<asp:Label ID="NameLabel" runat="server" Text='<%# Bind("Name") %>' />
<br />
</ItemTemplate>
</asp:FormView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:CPTempDBConnectionString %>"
SelectCommand="SELECT * FROM [Student] WHERE ([Name] = @Name)">
<SelectParameters>
<asp:ControlParameter ControlID="TextBox1" Name="Name" PropertyName="Text"
Type="String" />
</SelectParameters>
</asp:SqlDataSource>
<asp:Label ID="Label2" runat="server" Text="Record Not Found"></asp:Label>
</form>
Default3.aspx.cs
protected void Button1_Click(object sender, EventArgs e)
{
}
protected void TextBox1_TextChanged(object sender, EventArgs e)
{
if (TextBox1.Text != String.Empty)
{
FormView1.DataBind();
if (FormView1.DataItemCount > 0 ) Label2.Visible = false;
else Label2.Visible = true;
}
else
{
Label2.Visible = true;
}
}