<script language="C#" runat="server">
public DataSet ds;
...
void Page_Load(Object sender, EventArgs e) {
// ...set up a connection and command here...
if (!Page.IsPostBack) {
String query = "select * from Authors where FirstName like '%JUSTIN%'";
myCommand.Fill(ds, "Authors");
myDataGrid.DataBind();
}
}
void Button_Click(Object sender, EventArgs e) {
String query = "select * from Authors where FirstName like '%BRAD%'";
myCommand.Fill(ds, "Authors");
myDataGrid.DataBind();
}
</script>
<form runat="server">
<asp:datagrid datasource='<%# ds.DefaultView %>' runat="server"/><br>
<asp:button onclick="Button_Click" runat="server"/>
</form>
<script language="VB" runat="server">
Public ds As DataSet
...
Sub Page_Load(sender As Object, e As EventArgs)
' ...set up a connection and command here...
If Not (Page.IsPostBack)
Dim query As String = "select * from Authors where FirstName like '%JUSTIN%'"
myCommand.Fill(ds, "Authors")
myDataGrid.DataBind()
End If
End Sub
Sub Button_Click(sender As Object, e As EventArgs)
Dim query As String = "select * from Authors where FirstName like '%BRAD%'"
myCommand.Fill(ds, "Authors")
myDataGrid.DataBind()
End Sub
</script>
<form runat="server">
<asp:datagrid datasource='<%# ds.Tables["Authors"].DefaultView %>' runat="server"/><br>
<asp:button onclick="Button_Click" runat="server"/>
</form>
<script language="JScript" runat="server">
public var ds:DataSet;
...
function Page_Load(sender:Object, e:EventArgs) : void {
// ...set up a connection and command here...
if (!Page.IsPostBack) {
var query:String = "select * from Authors where FirstName like '%JUSTIN%'";
myCommand.Fill(ds, "Authors");
myDataGrid.DataBind();
}
}
function Button_Click(sender:Object, e:EventArgs) : void {
var query:String = "select * from Authors where FirstName like '%BRAD%'";
myCommand.Fill(ds, "Authors");
myDataGrid.DataBind();
}
</script>
<form runat="server">
<asp:datagrid datasource='<%# ds.DefaultView %>' runat="server"/><br>
<asp:button onclick="Button_Click" runat="server"/>
</form>
|