Re: SQL query from ASP page

I'm using ASP.net in Visual Web Developer 2005 express edition btea 2.

code:


<form id="form1" runat="server">
<div>
<asp:TextBox ID="TextBox1" runat="server"
TextMode="MultiLine"></asp:TextBox>
<asp:Button ID="Button1" runat="server" Text="Button" /><br />
<br />
<asp:GridView ID="GridView1" runat="server"
AutoGenerateColumns="False" DataKeyNames="CategoryID"
DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="CategoryID"
HeaderText="CategoryID" InsertVisible="False"
ReadOnly="True" SortExpression="CategoryID" />
<asp:BoundField DataField="CategoryName"
HeaderText="CategoryName" SortExpression="CategoryName" />
<asp:BoundField DataField="Description"
HeaderText="Description" SortExpression="Description" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
SelectCommand="SELECT [CategoryID], [CategoryName],
[Description] FROM [Categories] WHERE ([CategoryID] = @CategoryID)">
<SelectParameters>
<asp:ControlParameter ControlID="TextBox1" Name="CategoryID"
PropertyName="Text"
Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>

</div>
</form>

"alex_s" wrote:

> It is possible.
>
>
> Aare you using ASP or ASP.NET? In old ASP2.0 you will have to build you
> datagrid as HTML. ASP.NET will do this for you.
> Let me know what version of ASP are you using and I can help you with
> some samples.
>
>
.