<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" OnRowCancelingEdit="GridView1_RowcancelingEdit" OnRowUpdating="GridView1_RowUpdating" DataKeyNames="userid" OnRowEditing="GridView1_RowEditing" > <Columns> <asp:BoundField DataField="userid" HeaderText="userid" ReadOnly="true" /> <asp:TemplateField HeaderText="name"> <ItemTemplate> <%# Eval("name")%> </ItemTemplate> <EditItemTemplate> <asp:TextBox runat="server" ID="txtname" Text='<%# Bind("name")%>' /> </EditItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="age"> <ItemTemplate> <%# Eval("age")%> </ItemTemplate> <EditItemTemplate> <asp:TextBox runat="server" ID="txtage" Text='<%# Bind("age")%>' /> </EditItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="City" SortExpression="City"> <EditItemTemplate> <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource2" DataTextField="City" DataValueField="City" SelectedValue='<%# Bind("city") %>' > </asp:DropDownList> </EditItemTemplate> <ItemTemplate> <asp:Label ID="Label1" runat="server" Text='<%# Bind("city") %>'></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:CommandField ShowEditButton="True" ButtonType="Button" /> </Columns> </asp:GridView> <br /> </div> <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="Server=ALOK\SQLEXPRESS; Database=Employee; uid=sa; pwd=1234;" SelectCommand="SELECT DISTINCT [City] FROM [employ]"></asp:SqlDataSource> <br /> <br /> </form>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)