Afternoon Forum,

This is a basic question on how to get a value (passed from another page) into a SQL Statement (SelectCommand).

int itemID, typeID;

void Page_Load() {

typeID = Int32.Parse(Request["type"].ToString());

      itemID = Int32.Parse(Request["item"].ToString());

} 

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="AccessDataSource1" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" GridLines="None" ShowHeader="False">

            <Columns>

                <asp:BoundField DataField="Description" HeaderText="Description" SortExpression="Description" />

            </Columns>

</asp:GridView>

<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/Database.mdb"

            SelectCommand="SELECT [Description] FROM [Parts] WHERE ([ItemList] = HERE)">

</asp:AccessDataSource>

Thanks in advance,
Harold Clements