bind sqldatasource result to textbox c#

c# asp.net data-binding sqldatasource
gdubs picture gdubs · Mar 9, 2011 · Viewed 13k times · Source

I have a SqlDataSource that returns 1 field (1 row) for an ID. I would like to get that result and display it in a TextBox. I would normally do it using a stored procedure (since the stored procedure is already created), but I was thinking SqlDataSource would be easier. Is there a way to bind that result onto my TextBox? 

<asp:SqlDataSource ID="ds1" runat="server"
    ConnectionString="<%$ ConnectionStrings:conn1%>"
    ProviderName="<%$ Connectionstrings:conn1.ProviderName %>"
    SelectCommand="sp_1"
    SelectCommandType="StoredProcedure">
    <SelectParameters>
        <asp:Parameter Name="accountID" Type="Int32" />
        <asp:Parameter Name="activitydate" Type="DateTime" Direction="Output" />
    </SelectParameters>
</asp:SqlDataSource>

Answer

obulet picture obulet · Mar 10, 2011

You cannot just bind textbox like that, there is no DataSourceID property on textbox. My suggestion, you may create a DataList using that DataSource and on ItemTemplate, you can do:

<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind ('activitydate') %>'></asp:TextBox>

Related questions

How to set SelectedValue of DropDownList in GridView EditTemplate

I am trying to do this as asked earlier. The only difference that I found is additional List item that was included in above code. I tried to use AppendDataBoundItems=true but it is still not working. I also want …

Read More
Change select command of sqldatasource at runtime

HTML <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="id" DataSourceID="SqlDataSource1"> <Columns> <asp:BoundField DataField="id" HeaderText="id" /> <asp:BoundField DataField="name" HeaderText="name" /> </Columns> </asp:GridView&…

Read More
'DropDownList1' has a SelectedValue which is invalid because it does not exist in the list of items. Parameter name: value

I'm using TemplateField in GridView to implement edit/delete from database. I'm Querying Data with the SqlDataSource Control. when I edit the Table from page I get following error: 'DropDownList1' has a SelectedValue which is invalid because it does …

Read More