I'm having trouble with something that should be simple...

I have a textbox that contains a value from a database table -categoryname. I want to use that value to search the table when the page loads and return the associated categoryId value to a hidden textbox on the same page.

I know its easy, just can't seem to get the code just right

As always, I appreciate your help....

hi there..
do you have already some code??

HTH

Gonzalo

That was fast - I actually just got it to work and was coming back to pull my question - Here is what I did so others can benefit. Thanks anyway for your quick response
<asp:SqlDataSource
          id="SqlDataSource1"
          runat="server"
          DataSourceMode="DataReader"
          ConnectionString="<%$ ConnectionStrings:OrderConnectionString %>"
          SelectCommand="SELECT [CategoryId] FROM [Categories] WHERE ([CategoryName] = @CategoryName)">
         <SelectParameters>
             <asp:ControlParameter ControlID="category" Name="CateogoryName" PropertyName="Text" Type="String" />
         </SelectParameters>
      </asp:SqlDataSource>

      <asp:TextBox
          id="CateoryIdTextBox"
          runat="server"
          DataTextField="CateogoryId"
          DataSourceID="SqlDataSource1">
      </asp:TextBox>

I spoke too soon. Above code does not work with TextBox only with ListBox. I guess the DataReader is returning a list of values even though only one row in the table meets the criteria. Can you help me out with the code to display the selected row in a TextBox?

Thanks!

I only know how to do it in code... sorry... as far as I know you can't bound a text box to a datasource..

HTH

Gonzalo