<asp:GridView ID="GVProductOrder" runat="server" AutoGenerateColumns="false" GridLines="Vertical" Height="200" Width="1050"> <HeaderStyle CssClass="HeaderStyleGrid" /> <Columns> <asp:BoundField DataField="ItemCode" HeaderText="Item Code" /> <asp:BoundField DataField="ItemName" HeaderText="Item Name" /> <asp:BoundField DataField="Cost" HeaderText="Cost" /> <asp:BoundField DataField="MRP" HeaderText="MRP" /> <asp:BoundField DataField="SP" HeaderText="SP" /> <asp:BoundField DataField="MBQ" HeaderText="MBQ" /> <asp:BoundField DataField="Quantity" HeaderText="Quantity" /> <asp:BoundField DataField="FreeQty" HeaderText="Free Qty" /> <asp:BoundField DataField="FixedDisc" HeaderText="Fixed Disc" /> <asp:BoundField DataField="Tax" HeaderText="Tax" /> <asp:BoundField DataField="Value" HeaderText="Value" /> <asp:BoundField DataField="OnOrder" HeaderText="On Order" /> <asp:BoundField DataField="Remarks" HeaderText="Remarks" /> <asp:BoundField DataField="Type" HeaderText="Type" /> <asp:BoundField DataField="EanCode" HeaderText="Ean Code" /> </Columns> </asp:GridView>
<EmptyDataTemplate> No Data ! </EmptyDataTemplate>
SELECT ItemID,ItemName FROM TableName UNION ALL SELECT 0,'' FROM TableName HAVING COUNT(*)=0 ";
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)