• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1743
  • Last Modified:

Bind a TextBox to a SQL DataSource

How do I bind a textBox to a SQL Datasource?  
0
intchauspe
Asked:
intchauspe
  • 4
  • 3
1 Solution
 
kraffayCommented:
Make sure you have AutoGenerateColumnNames off and add a TemplateField:

<asp:GridView ....

<asp:TemplateField HeaderText="EventID">
                                <ItemTemplate>
                                    <asp:TextBox ID="txtBox" runat="server" Text='<%# Bind("YourDataField") %>'></asp:TextBox>
                                </ItemTemplate>
</asp:TemplateField>

</gridView>
0
 
intchauspeAuthor Commented:
actually what I want to do is return a value to a textbox.  I don't have a gridview on the page.   I just have a SQL data source and I want to display the result of the sql query in the textbox?  Can I do that or do I have to have a Gridview ?
0
 
kraffayCommented:
You could use a repeater with just a text box, that is the control with the least markup needed.  But a textbox by itself cannot bind to SQL DataSource.
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
intchauspeAuthor Commented:
well that seems to be good solution.  I only have one problem.  I have an emailing function that reads the value of the fields.  Previously I had used it with labels and text boxes like so....

 
        strText = Replace(strText, "REPLACE_uid", lblUserName.Text)
        strText = Replace(strText, "REPLACE_startdate", Date.Now)
        strText = Replace(strText, "REPLACE_title", txtTitle.Text)
        strText = Replace(strText, "REPLACE_username", lblUserName.Text)

I want to use the same email function but I can't figure out how to access the values that are in the repeaters.  

When I made the item templates I gave them the same names they had as before - ie: txtTitle.text but I guess since it is inside the repeater control it can't access it because when I use the code above it will tell me that txtTitle.text is not defined.

Any idea how to fix that ?
0
 
kraffayCommented:
With this example, I get a one-row, one-field recordset and bind it to a repeater.  Than I get a handle to the textbox in the repeater by referencing the control collection of the repeater and casting a control to a Textbox.  From there I can get the Text property:

<%@ Page Language="VB" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server" >

    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs)

        Dim txtCategory As TextBox = Me.Repeater1.Controls(0).Controls(1)
        Response.Write(txtCategory.Text)
       
    End Sub
</script>

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:Repeater ID="Repeater1" runat="server" DataSourceID="SqlDataSource1">
        <ItemTemplate>
            <asp:TextBox ID="txtCategory" runat="server" Text='<%# Bind("CategoryName")%>' ></asp:TextBox>
            </ItemTemplate>
        </asp:Repeater>
   
    </div>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:aspnet_starterKits_TimeTracker %>"
            SelectCommand="SELECT CategoryName FROM Category WHERE (CategoryID = 1)"></asp:SqlDataSource>
           
        <asp:Button ID="Button1" runat="server" Text="Get Value" OnClick="Button1_Click" />
           
    </form>
</body>
</html>
0
 
intchauspeAuthor Commented:
I haven't had a chance to try this yet but it seems like it should work... I'm going to work on it on Monday.  I'll let you know
0
 
intchauspeAuthor Commented:
Awesome.. that works.  THANK YOU !
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now