Comments by Member 12741312 (Top 5 by date)

i have added it through dgv's edit column property ......

I think ,this is same of that I posted above . I want both will run but first duplicate check and then select query.

@Suvendu , thanks , but I know how to display all the data in the datagridview using SELECT statement .So question is how can I fill the row in the datagridview keeping the value of first cell freeze and fill remaining cells with data returned from query.
i am using simple fill method to do it , but it is not working.

dear @Mike , thanks for your reply but it returns open_stock same for all items ... any rectification ???