Hello Friends,
I have Two tables Product,Category Table.I apply Join On both and show in grid view.
SELECT Products.ProductSNo, Products.ProductName, Products.ProductDescription, Products.ProductPrice,Products.ProductQuantity, Products.ProductImage, Category.CategoryName
FROM [Products] INNER JOIN
[Category]
ON Products .CategorySNO = Category.CategorySNo
I take a drop down for CategoreyName at the time of Editing in grid vIew.
Now my Question Is How to Update CategorySNo in Products Table.
Or how to fetch CategorySNo value From Drop Down.