请解决以下问题 [英] please solve the following problem

问题描述

我有一个带有4列的GridView。

Id Vendor_Name Asset_Type按钮

1 Tech_M鼠标按钮1



2 Religare键盘按钮1

3三星手机Button1

我的问题是当我点击第1行的按钮1时，相应的Vendor_Name Tech_M将显示在另一个Ratecard.Aspx页面中。类似地，当我点击第2行的第1按钮时，我想在Ratecard.aspx页面的标签中获得Religare。我该怎么做请帮忙。

I have a GridView with 4columns.
Id Vendor_Name Asset_Type Button
1 Tech_M Mouse Button1

2 Religare Keyboard Button1
3 Samsung Mobiles Button1
My problem is how when i will click button 1 of row 1 the corresponding Vendor_Name Tech_M will display in the other Ratecard.Aspx page. Similarly when i Click button 1 of row 2 the i want to get Religare in the Label of my Ratecard.aspx page. How will i do this. kindly help.

推荐答案

这完全取决于你的数据库设计。

你需要有这样的表格，

项目

+ ItemID | int | PK

+ ItemName | varchar



供应商

+ VendorId | int | PK

+ VendorName | varchar

+ ItemId | int | FK



现在查询，

SELECT * FROM Item i，Vendor v WHERE i.VendorId = v。 VendorId和i.ItemId = @itemId

这里 @itemId 从你的传递gridview。



代码，

This simply depends on your database design.
You need to have table like this,
Item
+ ItemID | int | PK
+ ItemName | varchar

Vendor
+ VendorId | int | PK
+ VendorName | varchar
+ ItemId | int | FK

Now the query,
SELECT * FROM Item i, Vendor v WHERE i.VendorId = v.VendorId AND i.ItemId = @itemId
here @itemId is passed from your gridview.

And the code,

SqlCommand cmd = new SqlCommand(SELECT * FROM Item i, Vendor v WHERE i.VendorId = v.VendorId AND i.ItemId = @itemId, conObject);
cmd.Paramaters.AddWithValue("@itemId", itemId);  // your item id i.e Samsung = 1, Nokia = 2 etc.
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);

foreach(DataRow dr in dt.Rows)
{
    YourLabel.Text = dr["YourColumn"].ToString();
}

希望你有这个想法.. :)



-KR

Hope you got the idea.. :)

-KR

这篇关于请解决以下问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！