Re: SQL query from ASP page

frogive me, I used the wizard...

"Daniel Seipel" wrote:

> 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.
> >
> >
.

Loading