问题描述

table模板里放个chart控件，然后放在repeater控件里，请问如何绑定chart?

protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
System.Web.UI.DataVisualization.Charting.Chart ct = (System.Web.UI.DataVisualization.Charting.Chart)e.Item.FindControl("Chart2");

        string connStr = "server=localhost;database=T_DB;uid=sa;pwd=123";
        SqlConnection myConn = new SqlConnection(connStr);
        string selStr = "select * from T_Motor1";
        SqlCommand myCmd = myConn.CreateCommand();
        myCmd.CommandText = selStr;
        myConn.Open();
        SqlDataReader sdr = myCmd.ExecuteReader(CommandBehavior.CloseConnection);
        ct.Series[0].Points.DataBindXY(sdr, "time", sdr, "speed");

        sdr.Close();
        myConn.Close();

    }

            <asp:Repeater ID="Repeater1" runat="server" OnItemDataBound="Repeater1_ItemDataBound">
   <ItemTemplate>   <table border="3" class="auto-style1">
        <tr>
            <td class="auto-style2">NO.<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
            </td>
            <td class="auto-style2">
                <asp:Chart ID="Chart2" runat="server">
                    <Series>
                        <asp:Series Name="Series1">
                        </asp:Series>
                    </Series>
                    <ChartAreas>
                        <asp:ChartArea Name="ChartArea1">
                        </asp:ChartArea>
                    </ChartAreas>
                </asp:Chart>
            </td>
        </tr>
    </table></ItemTemplate>
    </asp:Repeater>

解决方案

可以用databinder

解决方案二：

Repeater控件的模板