ansaurus

Question

Get data from sql datasource into asp.net controls

Answer 1

+1 A:

The easiest way (that I would think to do this) is to write all the data access and form population in the code-behind. I am a little confused, however, that you tagged this as both C# and VB.net. I'll update this post shortly with some C# example code; in the meantime feel free to start comment-spamming with questions. :)

Matt Ball 2009-08-31 14:25:49

I can read and write in both languages. And a question gets much more attention when tagged with C#

Eric 2009-08-31 14:31:06

I know how to do all of this in code behind by manually connecting and using a data reader, but i would like to do this without that.

Eric 2009-08-31 14:31:43

Ah, ok! Then I won't bother with the sample code. In that case, Scott's answer is the way to go.

Matt Ball 2009-08-31 14:37:46

Ok. thanks anyways. +1

Eric 2009-08-31 14:50:16

Answer 2

+2 A:

You should consider using a FormView control to do this. Using the binding controls is much easier and cleaner than trying to cram all of your code into the code-behind of the page. I also feel that it makes the page much easier to maintain, since you don't have all of the C#/VB code to manage as well.

<asp:FormView runat="server" ID="MyFormView" DataSourceID="MySqlDataSource" DefaultMode="Edit">
    <EditItemTemplate>
        <table>
            <tr>
                <td align="right">Interchange ID:</td>
                <td align="left">
                    <asp:TextBox ID="txtIntID" runat="server" Text='<%# Bind("InterchangeID") %>' size="1" MaxLength = "2"></asp:TextBox>
                    <asp:RequiredFieldValidator ID="RequiredFieldValidator8" ValidationGroup = "rouse"  Display ="None" ControlToValidate = "txtIntID" runat="server" ErrorMessage="You Must Provide an Interchange ID."></asp:RequiredFieldValidator>
                    <ajaxToolkit:ValidatorCalloutExtender ID="ValidatorCalloutExtender11" TargetControlID="RequiredFieldValidator8" HighlightCssClass="validatorCalloutHighlight" runat="server">                                             </ajaxToolkit:ValidatorCalloutExtender>
                </td>
            </tr>

        <!-- rest of your table here -->
        </table>
    </EditItemTemplate>
</asp:FormView>
<asp:SqlDataSource runat="server" ID="MySqlDataSource" 
    SelectCommand="SELECT * FROM MyTable" ConnectionString="<%$ ConnectionStrings:MyConnectionString %>" >
</asp:SqlDataSource>

See these links for more information:

Scott Ivey 2009-08-31 14:35:24

i like where you are going with this but i no longer see my textbox. I edited my code...can you see what i'm doing wrong?

Eric 2009-08-31 14:54:18

Never mind scott. My issue was the default mode being set to 'Edit'. Any idea why that is my issue? Don't i want it to be the default?

Eric 2009-08-31 14:56:52

Sorry - i wasn't thinking there - you'd want to use the EditItemTemplate instead of ItemTemplate. I'll update my sample...

Scott Ivey 2009-08-31 15:10:41

Answer 3

+1 A:

I like using this in the code behind:

GridView1.DataSource = getQuery(ConnectionString, "select * from mytable");
GridView1.DataBind();

 private DataTable getQuery(string ConnStr, string query)
    {
        DataTable dt = new DataTable();

        try
        {
            using (SqlConnection conn = new SqlConnection(ConnStr))  
            using (SqlDataAdapter cmd = new SqlDataAdapter(query, conn))


                cmd.Fill(dt);
        }
        catch { }
        return dt;
    }

of course not all the details are here

Brad 2009-08-31 14:42:12

this i believe is what i was looking for. But i like Scott's idea. Nevertheless +1

Eric 2009-08-31 14:58:09

ansaurus

tags:

views:

answers:

Get data from sql datasource into asp.net controls

related questions