Craig, Raterus,
I've tried what you have suggested, but I get the error 'denotes a
'property' where a 'method' was expected'. Here is my complete datagrid
:
<asp:datagrid id="dgShoppingCart" runat="server" CellPadding="3"
Font-Name="arial" Font-Size="8pt" ForeColor="Black"
HeaderStyle-ForeColor="#FFFFFF"
HeaderStyle-BackColor="#000000" HeaderStyle-Font-Bold="True"
GridLines=Horizontal
BorderColor="DarkBlue" BackColor="LightGoldenrodYellow"
AutoGenerateColumns="False" DataKeyField="Quantity">
<ItemStyle BackColor="White"></ItemStyle>
<SelectedItemStyle ForeColor="GhostWhite"
BackColor="DarkSlateBlue"></SelectedItemStyle>
<AlternatingItemStyle
BackColor="#eeeeee"></AlternatingItemStyle>
<HeaderStyle Font-Bold=True BackColor=#000000
ForeColor=#FFFFFF></HeaderStyle>
<Columns>
<asp:TemplateColumn HeaderText="Product*ID"
ItemStyle-Width="40px" HeaderStyle-HorizontalAlign=Center
ItemStyle-HorizontalAlign=Center>
<ItemTemplate>
<asp:Label id="lblProductID" runat="server" Text='<%#
DataBinder.Eval(Container.DataItem, "Product ID") %>' />
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Product Type"
ItemStyle-Width="140px" HeaderStyle-HorizontalAlign=Center
ItemStyle-HorizontalAlign=Center>
<ItemTemplate>
<asp:Label id="lblProductType" font-bold="True"
Font-Name="tahoma" ForeColor="Maroon" runat="server" Text='<%#
DataBinder.Eval(Container.DataItem, "Product Type") %>' />
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="SIP Account/s"
ItemStyle-Width="75px" HeaderStyle-HorizontalAlign=Center
ItemStyle-HorizontalAlign=Center>
<ItemTemplate>
<asp:DropDownList id="ddlSIPAccounts" runat="server"
DataValueField="SIP Account" Font-Name="arial" Font-Size="8pt"
DataTextField="SIP Account"
DataSource='<%# GetSIPAccounts(Container.DataItem("Product ID")) %>' />
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="SIP Domain"
ItemStyle-Width="75px" HeaderStyle-HorizontalAlign=Center
ItemStyle-HorizontalAlign=Center>
<ItemTemplate>
<asp:Label id="lblSIPDomain" runat="server" Text='<%#
DataBinder.Eval(Container.DataItem, "SIP Domain") %>' />
</ItemTemplate>
</asp:TemplateColumn>
<asp:BoundColumn DataField="Unit Price (GBP)"
HeaderText="Unit Price (GBP)" DataFormatString="{0:c}"
ItemStyle-Width="50px" HeaderStyle-HorizontalAlign=Center
ItemStyle-HorizontalAlign=Center />
<asp:TemplateColumn HeaderText="Quantity"
ItemStyle-Width="55px" HeaderStyle-HorizontalAlign=Center
ItemStyle-HorizontalAlign=Center>
<ItemTemplate>
<asp:Label id="lblQuantity" runat="server" Text='<%#
DataBinder.Eval(Container.DataItem, "Quantity") %>' />
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Sub Total (GBP)"
ItemStyle-Width="60px" HeaderStyle-HorizontalAlign=Center
ItemStyle-HorizontalAlign=Center>
<ItemTemplate>
<asp:Label id="lblSubTotal" runat="server"
ForeColor="Maroon" Text='<%# DataBinder.Eval(Container.DataItem, "Sub
Total", "{0:c}") %>' />
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Remove"
ItemStyle-Width="50px" HeaderStyle-HorizontalAlign=Center
ItemStyle-HorizontalAlign=Center>
<ItemTemplate>
<asp:CheckBox id="chkRemove" runat="server"
Checked=False EnableViewState=True />
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:datagrid>
I am populating the datagrid with a stored procedure, and I am trying to
add the additional column with this code :
public DataSet GetSIPAccounts(int intProductID)
{
shopping_cartDB scCart = new shopping_cartDB();
string strCartID = scCart.GetShoppingCartId();
SqlConnection objConnection = new
SqlConnection(ConfigurationSettings.AppSettings["strConnectTest"]);
string strSIPAccounts = "SELECT SIPACCOUNT AS 'SIP Account' FROM
SHOPPING_CART_SIP WHERE CARTID = '" + strCartID + "' AND PRODUCTID = " +
intProductID;
SqlDataAdapter objDataAdapter = new SqlDataAdapter(strSIPAccounts,
objConnection);
DataSet ddlDataSet = new DataSet();
objDataAdapter.Fill(ddlDataSet, "SIPAccounts");
return ddlDataSet;
}
Thanks,
Mike
*** Sent via Devdex
http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!