Gridview template field

See more:

C#

Friends,


I am using gridview with the template fields.If we put list box in the edititem template then if we put sqldatasource then the error is coming "Login failed for sql server".Below is the code.Plz help me.

<asp:TemplateField HeaderText="ImpactedEntity">
   <ItemTemplate>
   <%#Eval("ImpactedEntity")%>
   </ItemTemplate>
   <EditItemTemplate>
       <asp:ListBox ID="ListBox3" runat="server" AutoPostBack="True"
           DataSourceID="SqlDataSource1" DataTextField="ImpactedEntity"
           DataValueField="ImpactedEntity"></asp:ListBox>
       <asp:SqlDataSource ID="SqlDataSource1" runat="server"
           ConnectionString="<%$ ConnectionStrings:DashboardConnectionString %>"
           SelectCommand="SELECT [ImpactedEntity] FROM [Bug]"></asp:SqlDataSource>
   </EditItemTemplate>
    <FooterTemplate>
   <asp:TextBox ID="txtImpactedEntity" runat="server">
                   </asp:TextBox>
   </FooterTemplate>
   </asp:TemplateField>

Thanks in Advance