<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Data" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Atlas Test Page</title>
<script language="C#" runat="server">
private void btnGo_Click(Object sender, System.EventArgs e) {
sqlConnection.SelectCommand = "SELECT * FROM [dbo].[Customers] WHERE [CompanyName] LIKE '%" + this.txtSearch.Text + "%'";
grid.DataSource = sqlConnection;
grid.DataBind();
}
</script>
<atlas:ScriptManager runat="server" ID="ScriptManager" EnablePartialRendering="true" />
</head><body>
<form id="form1" runat="server">
<div>
<asp:TextBox runat="server" ID="txtSearch" />
<asp:LinkButton runat="server" ID="btnGo" OnClick="btnGo_Click">Submit</asp:LinkButton>
<atlas:UpdatePanel ID="myPanel" runat="server">
<ContentTemplate>
<asp:GridView runat="server" ID="grid"> </asp:GridView>
</ContentTemplate>
<Triggers>
<atlas:ControlEventTrigger ControlID="btnGo" EventName="Click" />
</Triggers>
</atlas:UpdatePanel>
<asp:SqlDataSource
ConnectionString="data source=PENTIUM4;uid=test;pwd=test;initial catalog=Northwind"
ID="sqlConnection"
runat="server" ProviderName="System.Data.SqlClient">
</asp:SqlDataSource>
</div>
</form></body></html>