Edit a DataGridView ComboBox Item.

Question

I need an editable combo (DropDownCombo style) appears on a DataGridView current cell. 
I tryed setting the column type as 'DataGridViewComboBoxColumn'. It works fine but I can't 
edit ComboBoxItems.   
How can I edit and insert new items direcly from combo ? Is it possible ?
There is any workaround to do ?
Thanks.
Brainjar.

Answer 1

Hi Anoop,

 

Please try this SQL and let me know if it works for you

 

declare @storeid bigint
set @storeid=19
select  I.NameOfStores, I.ReferenceNo, SUM(Inwards.InwardQty) InwardQty,  SUM(ISNULL(Issued.IssuedQty,0)) IssuedQty, SUM((ISNULL(Inwards.InwardQty,0)-ISNULL(Issued.IssuedQty,0)))as Balance
from InventoryInwards as I
LEFT JOIN
        (select ReferenceNo,  nameofStores, ISNULL(Sum(ISNULL(Qty,0)),0) as InwardQty
        from InventoryInwards where StoreID=@storeid
        group By NameOfStores, ReferenceNo, Unit) as Inwards ON I.NameOfStores = Inwards.NameOfStores
        and i.ReferenceNo=Inwards.ReferenceNo

left JOIN
        (select   nameofStores, ISNULL(Sum(ISNULL(Qty,0)),0) as IssuedQty
        from InventoryIssued where StoreID=@storeid
        group By NameOfStores, ReferenceNo, unit) as Issued on I.NameOfStores= Issued.NameOfStores



where i.StoreID = @storeid
group by I.NameOfStores, I.ReferenceNo, I.Unit

Answer 2

Thanks Ankit... that was I missing out.