StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POcreating a dropdownlist in the header of the gridview while populating its column data from excel sheet
primarykey
Id
8214232
data
AcceptedAnswerId
0
AnswerCount
2
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-11-21T15:32:58.510
FavoriteCount
0
LastActivityDate
2011-11-21T19:58:54.873
LastEditDate
LastEditorUserId
0
OwnerUserId
1058053
ParentId
0
PostTypeId
1
Score
0
ViewCount
2579
LastEditorDisplayName
text
Body
I need to create a gridview which <ol> <li>fills its column with data from an excel sheet and</li> <li>for each column in the gridview ,the header should contain a drop down list with listitems like telephone,name,price which the user will select and set as the header for the particular column. </li> </ol> I imported data into gridview but i am not able to create a drop down list in the gridview. If i try to create a dropdownlist in the designer page,it is just creating the dropdownlist in the gridview header but not populating the data.So How can i create a dropdownlist in the header of the gridview while populating its column data from excel sheet. Please help. the code i used to populate data into gridview is <pre><code>Dim con As String = "" Select Case Extension Case ".xls" 'Excel 97-03 con=ConfigurationManager.ConnectionStrings("Excel03ConString").ConnectionString() Exit Select Case ".xlsx" 'Excel 07 con =ConfigurationManager.ConnectionStrings("Excel07ConString").ConnectionString() Exit Select End Select con = String.Format(con,Path) Dim connExcel As New OleDbConnection(con) Dim str As String = "SELECT * From [Sheets$]" Dim cmdExcel As New OleDbCommand(str, connExcel) Dim da As New OleDbDataAdapter(cmdExcel) Dim dset As New DataSet() da.Fill(dset, "Tabledata") Dim dtable As DataTable = ds.Tables(0) GridView1.DataSource = dset.Tables(0).DefaultView GridView1.DataBind() </code></pre> and the code to create drop down list is <pre><code><asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false"> <Columns> <asp:TemplateField> <HeaderTemplate> <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True"> <asp:ListItem Text="name " Value="Description of Goods" /> <asp:ListItem Text="telephone" Value="Count" /> <asp:ListItem Text="price" Value="Weight" /> <asp:ListItem Text="Value" Value="Value" /> </asp:DropDownList> </HeaderTemplate> </code></pre>
Tags
<.net><vb.net><gridview><drop-down-menu><datagridviewcolumn>
Title
creating a dropdownlist in the header of the gridview while populating its column data from excel sheet
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USs s
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.