将下拉列表中的数据绑定到gridview coloumn中 [英] Bind data in Dropdown list into gridview coloumn

问题描述

我在gridview coloum中有一个下拉列表。

我想在数据库的dropdownlist中添加值.. !!

我该怎么办？plzz告诉我..

网格代码如下？

< asp：GridView ID =   GridView2 runat =   server AutoGenerateColumns =   False 
 DataSourceID =   SqlDataSource1 >  
 
 
< Columns> 
< asp：TemplateField HeaderText =   Product_ID >  
< ItemTemplate> 
< asp：标签ID =   idlbl runat =   server Text = ' <％＃DataBinder.Eval（Container.DataItem，id）％>' >  
 < /   asp：标签 >  
 < /   ItemTemplate  >  
 < /   asp：TemplateField  >  
 
< asp：TemplateField HeaderText =   Product_Name >  
< ItemTemplate> 
< asp：标签ID =   idlbl runat =   server Text = ' <％＃DataBinder.Eval（Container.DataItem，id）％>' >  
 < /   asp：标签 >  
 < /   ItemTemplate  >  
 < /   asp：TemplateField  >  
 
< asp：TemplateField HeaderText =   Product_Image >  
< ItemTemplate> 
< asp：标签ID =   idlbl runat =   server Text = ' <％＃DataBinder.Eval（Container.DataItem，id）％>' >  
 < /   asp：标签 >  
 < /   ItemTemplate  >  
 < /   asp：TemplateField  >  
 
 
< asp：TemplateField HeaderText =   Product_Qty >  
< ItemTemplate> 
< asp：DropDownList ID =   ddl runat =   server DataTextField =   Product_Qty DataValueField =   id DataSourceID =   SqlDataSource1 >  
 < /   asp：DropDownList  >  
 < /   ItemTemplate  >  
 < /   asp：TemplateField  >  
 
< asp：TemplateField HeaderText =   Product_Rates >  
< ItemTemplate> 
< asp：标签ID =   idlbl runat =   server Text = ' <％＃DataBinder.Eval（Container.DataItem，id）％>' >  
 < /   asp：标签 >  
 < /   ItemTemplate  >  
 < /   asp：TemplateField  >  
 
 < /  列 >  
 
 < /   asp：GridView  >  

数据库表是......下面我想将Product_Size值添加到下拉列表中。



CREATE TABLE [dbo]。[Productmaster]（

[product_Id] [int] IDENTITY（1,1）NOT NULL，

[product_Name] [nvarchar]（max）NOT NULL，

[product_Image] [nvarchar]（max）NOT NULL，

[product_Size] [int] NOT NULL，

[product_Rate] [int] NOT NULL，

CONSTRAINT [PK_Productmaster] PRIMARY KEY CLUSTERED

（

[product_Id] ASC

）

解决方案

像这样

检查以下链接： -

http://usingaspdotnet.blogspot.in/2011/03/dropdownlist-inside-gridview-in-aspnet.html [< a href =http://usingaspdotnet.blogspot.in/2011/03/dropdownlist-inside-gridview-in-aspnet.htmltarget =_ blanktitle =New Window> ^ ]

http：// www.aspsnippets.com/Articles/How-to-bind-data-to-DropDownList-in-GridView-in-ASPNet.aspx [ ^ ]

< a href =http://www.dotnetfox.com/articles/how-to-use-dropdownlist-control-to-gridview-in-Asp-Net-using-C-Sharp-1020.aspx> http：/ /www.dotnetfox.com/articles/how-to-use-dropdownlist-control-to-gridview-in-Asp-Net-using-C-Sharp-1020.aspx [ ^ ]

Hii i have a dropdownlist in gridview coloum.
I wants to add values in dropdownlist from database..!!
how can i do it?plzz tell me..
Gridview code is below??

<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" 
                    DataSourceID="SqlDataSource1">
                    

<Columns> 
<asp:TemplateField HeaderText="Product_ID"> 
<ItemTemplate> 
<asp:Label id="idlbl" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"id")%>' > 
</asp:Label> 
</ItemTemplate> 
</asp:TemplateField> 

<asp:TemplateField HeaderText="Product_Name"> 
<ItemTemplate> 
<asp:Label id="idlbl" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"id")%>' > 
</asp:Label> 
</ItemTemplate> 
</asp:TemplateField> 

<asp:TemplateField HeaderText="Product_Image"> 
<ItemTemplate> 
<asp:Label id="idlbl" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"id")%>' > 
</asp:Label> 
</ItemTemplate> 
</asp:TemplateField> 


<asp:TemplateField HeaderText="Product_Qty"> 
<ItemTemplate> 
<asp:DropDownList ID="ddl" runat ="server" DataTextField ="Product_Qty" DataValueField ="id" DataSourceID ="SqlDataSource1" > 
</asp:DropDownList> 
</ItemTemplate> 
</asp:TemplateField>

<asp:TemplateField HeaderText="Product_Rates"> 
<ItemTemplate> 
<asp:Label id="idlbl" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"id")%>' > 
</asp:Label> 
</ItemTemplate> 
</asp:TemplateField> 

</Columns>

</asp:GridView>

Database table is...below and i wants to add Product_Size Values into Dropdownlist.

CREATE TABLE [dbo].[Productmaster](
[product_Id] [int] IDENTITY(1,1) NOT NULL,
[product_Name] [nvarchar](max) NOT NULL,
[product_Image] [nvarchar](max) NOT NULL,
[product_Size] [int] NOT NULL,
[product_Rate] [int] NOT NULL,
CONSTRAINT [PK_Productmaster] PRIMARY KEY CLUSTERED
(
[product_Id] ASC
)

解决方案

like this

check below links:-
http://usingaspdotnet.blogspot.in/2011/03/dropdownlist-inside-gridview-in-aspnet.html[^]
http://www.aspsnippets.com/Articles/How-to-bind-data-to-DropDownList-in-GridView-in-ASPNet.aspx[^]
http://www.dotnetfox.com/articles/how-to-use-dropdownlist-control-to-gridview-in-Asp-Net-using-C-Sharp-1020.aspx[^]

这篇关于将下拉列表中的数据绑定到gridview coloumn中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！