更新时间:2023-10-07 10:00:16
如果您使用的是SqlDataSource和更新,然后通过它的数据的所有您需要做的是设置2路为DropDownList的GenderList结合。
您可以通过设计器中设置这样或直接在源还
<&EditItemTemplate的GT;
< ASP:DropDownList的ID =GenderList=服务器
的SelectedValue ='<%#绑定(性别)%GT;'>
< ASP:ListItem的> M< / ASP:ListItem的>
< ASP:ListItem的> F< / ASP:ListItem的>
< / ASP:DropDownList的>
< / EditItemTemplate中>
通知该绑定正在使用此2路。
I am using VS2005 C#.
Currently I have a GridView, and I have changed one of my GridView control to my column name Gender
, from the default TextBox
to a DropDownList
, which I gave the ID
of the control to GenderList
, and it contains 2 values, M and F.
I have a default update statement which is able to update the GridView after edit
, which is the following:
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString=
"<%$ ConnectionStrings:SODConnectionString %>" UpdateCommand="UPDATE
[UserMasterData] SET [Name] = @Name, [Age] = @Age, [ContactNo]=@ContactNo,
[Address]=@Address, [Gender]=@Gender"/>
The above UPDATE query works perfectly, and now I have changed my Gender
textbox to a dropdownlist, the UPDATE
query gave me an error which says:
Must declare the scalar variable "@Gender".
I assume the UPDATE query couldn't find the value from my Gender
column.
I tried to modify the UPDATE query to @GenderList
, but it did not work as well.
Anyone knows what I should do do the UPDATE query so that my UPDATE query can find the value from my GenderList
dropdownlist in my Gender
column?
Thank you.
Below is my previous Gender
column with a textbox control:
<asp:BoundField HeaderText="Gender"
DataField="Gender"
SortExpression="Gender"></asp:BoundField>
Below is my Gender
with the dropdownlist control:
<asp:TemplateField HeaderText="Gender" SortExpression="Gender" >
<EditItemTemplate>
<asp:DropDownList ID="GenderList" runat="server" Width="50px" >
<asp:ListItem>M</asp:ListItem>
<asp:ListItem>F</asp:ListItem>
</asp:DropDownList>
</EditItemTemplate>
<ItemTemplate>
EDIT:
Tried implementing RowDatBound
and onRowUpdating
:
RowDatBound
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
DataRowView dRowView = (DataRowView)e.Row.DataItem;
if (e.Row.RowType == DataControlRowType.DataRow)
{
if ((e.Row.RowState & DataControlRowState.Edit) > 0)
{
DropDownList genderList= (DropDownList)e.Row.FindControl("GenderList");
genderList.SelectedValue = dRowView[2].ToString();
}
}
}
RowUpdating
.aspx.cs
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
DropDownList genderSelect =(DropDownList)GridView1.Rows[e.RowIndex].FindControl("GenderList");
SqlDataSource1.UpdateParameters["Gender"].DefaultValue =
genderSelect.SelectedValue; --> error says not set to an instance of an object
}
If you are using SqlDataSource and updating data via it then all you have to do is to set 2 way binding for the dropdownlist GenderList.
You can set this via the designer or directly in source also
<EditItemTemplate>
<asp:DropDownList ID="GenderList" runat="server"
SelectedValue='<%# Bind("Gender") %>'>
<asp:ListItem>M</asp:ListItem>
<asp:ListItem>F</asp:ListItem>
</asp:DropDownList>
</EditItemTemplate>
notice that here 2 way binding is being used.