如何更新表值在gridView中的两个表上应用连接后 [英] How to update a table value After applying join on two Tables in gridView

问题描述

Hello Friends，

我有两个表Product，Category Table.I apply Join On both并在网格视图中显示。

SELECT Products.ProductSNo，Products.ProductName ，Products.ProductDescription，Products.ProductPrice，Products.ProductQuantity，Products.ProductImage，Category.CategoryName

FROM [Products] INNER JOIN

[种类]

ON产品.CategorySNO = Category.CategorySNo





我在网格vIew中编辑时为了CategoreyName下拉。

现在我的问题是如何在产品表中更新CategorySNo。

或者如何从Drop Down获取CategorySNo值。

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.

推荐答案

Samira是正确的。绑定Dropown时，应该将文本字段绑定为DataTextField，将id字段绑定为DataValueField。



因此，当您更新网格时，循环遍历行，你可以找到下拉的SelectedValue并做你想做的任何事情。

Samira is correct. When you bind the dropsown, you should bind the text field as DataTextField and id field as DataValueField.

So, when you update the grid, while looping through the rows, you can find the drop down SelectedValue and do whatever you want to do with that.

这篇关于如何更新表值在gridView中的两个表上应用连接后的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！