我的两个具有父子关系的下拉列表在我的gridview中的EditItemTemplate中出现问题 [英] I have a problem with my two Dropdownlists with parent-child relation in EditItemTemplate in my gridview
问题描述
I have a page with gridview in it.my gridview shows the products Information and Admin can Edit gridviews columns.two of my columns show the brand name and category name for each product;I use lables in ItemTemplate tag in my grid view to show these two columns value and I use two dropdownlists(branddrop,categorydrop) in my EditItemTemplate tag for editing these two columns value,when admin select an item in branddrop the categorydrop should show categories name which are related to selected brand name in branddrop. brands name in my brand table in database are:Samsung
Nokia,Sony Ericsson,Apple,LG,HTC....
and my categories name in category table are :
Galaxy Nexus,Galaxy Tab 2 7. 0,Galaxy S3,Asha,Lumia,iPhone,iPad,Xperia Arc,Xperia Neo,Xperia X8,Cookie 3g,Cookie lite,Km555e,Optimus l9,Optimus elite,Optimus g,wt18i,w8,500,n8...
when I click the Edit button,first item in the branddrop is Equal to brandlable.Text in ItemTemplate and it works fine my problem is the first item in category drop is not Equal to categorylable.text in ItemTemplate and the category drop does not show the related categories name to brandname.for every product it shows iphone and ipad so I have to select another items in branddrop and then select again the related brandname which is related to that product then the categorydrop can show the list of related categories name.I tried to use brandDrop_SelectedIndexChanged and GridView1_RowEditing but it is not work. I dont know how to solve it.I'll become so thankfull if anybody help me
this is my first code:
<asp:TemplateField HeaderText="brand name">
<ItemTemplate>
<asp:Label ID="brandname" runat="server" Text='<%#Eval("brand_name") %>'></asp:Label>
<asp:Label ID="idfrombrand" runat="server" Text='<%#Eval("idfrombrands") %>' Visible="false"></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:Label ID="br" runat="server" Text='<%# Eval("idfrombrands") %>' Visible="false"></asp:Label><%--OnSelectedIndexChanged="brandDrop_SelectedIndexChanged" --%>
<asp:DropDownList ID="brandDrop" runat="server" DataTextField="brand_name" DataValueField="id" DataSourceID="SqlDataSource4" AutoPostBack="true" OnSelectedIndexChanged="brandDrop_SelectedIndexChanged" >
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:mobile_storeConnectionString2 %>" SelectCommand="select [id],[brand_name] from [brands]" ></asp:SqlDataSource>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="category name">
<ItemTemplate>
<asp:Label ID="catname" runat="server" Text='<%# Eval("category_name") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:Label ID="OldCatName" runat="server" Text='<%# Eval("idfromCategories") %>' Visible="false"></asp:Label>
<asp:DropDownList ID="categoryDrop" runat="server" AutoPostBack="true" DataTextField="category_name" DataValueField="id" DataSourceID="SqlDataSource3"> <%-- --%>
</asp:DropDownList>
<asp:Label ID="cat" runat="server" Text='<%# Eval("idfromCategories") %>' Visible="false" ></asp:Label>
<asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:mobile_storeConnectionString2 %>" SelectCommand="select [category_name],[id],[idfrombrands] from [categories] where idfrombrands=@idfrombrands " >
<SelectParameters>
<asp:ControlParameter ControlID="brandDrop"
Name="idfrombrands" PropertyName="SelectedValue" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
</EditItemTemplate>
</asp:TemplateField>
这是我的代码背后
GridView1_RowDataBound和GridView1_RowUpdating：
protected void GridView1_RowUpdating（object sender，GridViewUpdateEventArgs e）
{
int brand = 0;
int category = 0;
// Drop Brand ----- ---------------------------------
DropDownList list1 =（DropDownList）GridView1.Rows [e.RowIndex] .FindControl（brandDrop）;
Label lbl =（Label）GridView1.Rows [e.RowIndex] .FindControl（br） ;
if（list1.SelectedItem.Value！= null）
{
brand = Convert.ToInt32 （list1.SelectedItem.Value）; // NewIdFromBrand
}
else
{
brand = Convert.ToInt32（lbl.Text）;
}
//掉落类别------ --- -------------------------------
DropDownList list2 = （DropDownList）GridView1.Rows [e.RowIndex] .FindControl（categoryDrop）;
Label lbl2 =（Label）GridView1.Rows [e.RowIndex] .FindControl（OldCatName）;
// int NewIdFromBrand2 = -1;
if（list2.SelectedItem.Value！= null）
{
category = Convert.ToInt32（list2.SelectedItem.Value）; // NewIdFromBrand2
}
否则
{
category = Convert.ToInt32（lbl2.Text）;
}
//照片-------------------------------------------
string photoname = System.Guid.NewGuid（）。ToString（）;
GridViewRow row = GridView1.Rows [e.RowIndex];
FileUpload fileUpload = row.FindControl（FileUploadimg）as FileUpload;
Label lbl3 =（Label）GridView1.Rows [e .RowIndex] .FindControl（ oldImage）;
if（fileUpload！= null&& fileUpload.HasFile）
{
fileUpload.SaveAs（Server.MapPath（〜/ P_Image）+ photoname + fileUpload.FileName）;
SqlDataSource1.UpdateParameters [path]。DefaultValue =〜/ P_Image+ photoname + fileUpload.FileName;
}
else
{
SqlDataSource1.UpdateParameters [path]。DefaultValue = l bl3.Text ; // oldImage.Text;
}
int prid = Convert.ToInt32（GridView1.DataKeys [e.RowIndex] .Value）;
SqlConnection cn = new SqlConnection（）;
cn.ConnectionString =server = .; database = mobile_store; Trusted_Connection = true;
DataTable tb = new DataTable（） ;
SqlCommand cmd = new SqlCommand（）;
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText =UpdateProduct;
cmd .Parameters.AddWithValue（@ brandid，品牌）;
cmd.Parameters.AddWithValue（@ catid，类别）;
cmd.Parameters.AddWithValue（ @pid，prid）;
试试
{
cn.Open（）;
cmd.ExecuteNonQuery （）;
SqlDataSource1.DataBind（）;
}
catch（exception ex2）
{
}
finally {cn.Close（）; }
//GridView1.EditIndex = -1;
//GridView1.DataBind（）;
}
protected void GridView1_RowDataBound（object sender，GridViewRowEventArgs e）
{
if（e.Row。 RowType == DataControlRowType.DataRow）
{
//检查是否处于编辑模式
if（（e.Row.RowState& DataControlRowState.Edit）> 0）
{
DataRowView dRowView1 =（DataRowView）e.Row.DataItem;
if（e.Row .RowType == DataControlRowType.DataRow）
{
if（（e.Row.RowState& DataControlRowState.Edit）> 0）
{
DropDownList ddlStatus =（DropDownList）e.Row.FindControl（brandDrop）;
ddlStatus.SelectedValue = dRowView1 [brandId]。ToString（）;
DropDownList ddlStatus2 =（博士opDownList）e.Row.FindControl（categoryDrop）;
ddlStatus2.SelectedValue = dRowView1 [categoryID]。ToString（）;
//Label1.Text = ddlStatus.SelectedValue;
}
}
}
}
}
this is my code behind for
GridView1_RowDataBound and GridView1_RowUpdating:
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int brand=0;
int category=0;
//Drop Brand--------------------------------------
DropDownList list1 = (DropDownList)GridView1.Rows[e.RowIndex].FindControl("brandDrop");
Label lbl = (Label)GridView1.Rows[e.RowIndex].FindControl("br");
if (list1.SelectedItem.Value != null)
{
brand = Convert.ToInt32(list1.SelectedItem.Value);//NewIdFromBrand
}
else
{
brand = Convert.ToInt32(lbl.Text);
}
//Drop Category----------------------------------------
DropDownList list2 = (DropDownList)GridView1.Rows[e.RowIndex].FindControl("categoryDrop");
Label lbl2 = (Label)GridView1.Rows[e.RowIndex].FindControl("OldCatName");
//int NewIdFromBrand2 = -1;
if (list2.SelectedItem.Value != null)
{
category = Convert.ToInt32(list2.SelectedItem.Value);//NewIdFromBrand2
}
else
{
category = Convert.ToInt32(lbl2.Text);
}
//Photo-------------------------------------------
string photoname = System.Guid.NewGuid().ToString();
GridViewRow row = GridView1.Rows[e.RowIndex];
FileUpload fileUpload = row.FindControl("FileUploadimg") as FileUpload;
Label lbl3 = (Label)GridView1.Rows[e.RowIndex].FindControl("oldImage");
if (fileUpload != null && fileUpload.HasFile)
{
fileUpload.SaveAs(Server.MapPath("~/P_Image") + photoname + fileUpload.FileName);
SqlDataSource1.UpdateParameters["path"].DefaultValue = "~/P_Image" + photoname + fileUpload.FileName;
}
else
{
SqlDataSource1.UpdateParameters["path"].DefaultValue = l bl3.Text;//oldImage.Text;
}
int prid = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value);
SqlConnection cn = new SqlConnection();
cn.ConnectionString = "server = . ; database = mobile_store ; Trusted_Connection=true";
DataTable tb = new DataTable();
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "UpdateProduct";
cmd.Parameters.AddWithValue("@brandid", brand );
cmd.Parameters.AddWithValue("@catid", category );
cmd.Parameters.AddWithValue("@pid", prid);
try
{
cn.Open();
cmd.ExecuteNonQuery();
SqlDataSource1.DataBind();
}
catch (Exception ex2)
{
}
finally { cn.Close(); }
//GridView1.EditIndex = -1;
//GridView1.DataBind();
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
//check if is in edit mode
if ((e.Row.RowState & DataControlRowState.Edit) > 0)
{
DataRowView dRowView1 = (DataRowView)e.Row.DataItem;
if (e.Row.RowType == DataControlRowType.DataRow)
{
if ((e.Row.RowState & DataControlRowState.Edit) > 0)
{
DropDownList ddlStatus = (DropDownList)e.Row.FindControl("brandDrop");
ddlStatus.SelectedValue = dRowView1["brandId"].ToString();
DropDownList ddlStatus2 = (DropDownList)e.Row.FindControl("categoryDrop");
ddlStatus2.SelectedValue = dRowView1["categoryID"].ToString();
//Label1.Text = ddlStatus.SelectedValue;
}
}
}
}
}
推荐答案
ConnectionStrings：mobile_storeConnectionString2％>SelectCommand =从[品牌]>< / asp：SqlDataSource>中选择[id]，[brand_name]
< / EditItemTemplate>
< / asp：TemplateField>
< asp：TemplateField HeaderText =category name>
< ItemTemplate>
< asp：Label ID =catnamerunat =serverText ='<％＃Eval（ category_name）％> ' >< / asp：Label> ;
< / ItemTemplate>
< EditItemTemplate>
< asp：Label ID =OldCatNamerunat =serverText ='<％＃Eval（ idfromCategories）％> ' Visible =false>< ; / ASP：标签>
< asp：DropDownList ID =categoryDroprunat =serverAutoPostBack =trueDataTextField =category_nameDataValueField =idDataSourceID =SqlDataSource3> <％ - - ％>
< / asp：DropDownList>
< asp：Label ID =catrunat =serverText ='<％＃Eval（ idfromCategories）％> ' Visible =false>< ; / ASP：标签>
< asp：SqlDataSource ID =SqlDataSource3runat =serverConnectionString =<％
ConnectionStrings:mobile_storeConnectionString2 %>" SelectCommand="select [id],[brand_name] from [brands]" ></asp:SqlDataSource> </EditItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="category name"> <ItemTemplate> <asp:Label ID="catname" runat="server" Text='<%# Eval("category_name") %>'></asp:Label> </ItemTemplate> <EditItemTemplate> <asp:Label ID="OldCatName" runat="server" Text='<%# Eval("idfromCategories") %>' Visible="false"></asp:Label> <asp:DropDownList ID="categoryDrop" runat="server" AutoPostBack="true" DataTextField="category_name" DataValueField="id" DataSourceID="SqlDataSource3"> <%-- --%> </asp:DropDownList> <asp:Label ID="cat" runat="server" Text='<%# Eval("idfromCategories") %>' Visible="false" ></asp:Label> <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%
ConnectionStrings：mobile_storeConnectionString2％> SelectCommand =select [category_name]，[id]，[idfrombrands] from [categories]其中idfrombrands = @ idfrombrands>
< SelectParameters>
< asp：ControlParameter ControlID =brandDrop
Name =idfrombrandsPropertyName =SelectedValueType =Int32/>
< / SelectParameters>
< / asp：SqlDataSource>
< / EditItemTemplate>
< / asp：TemplateField>
ConnectionStrings:mobile_storeConnectionString2 %>" SelectCommand="select [category_name],[id],[idfrombrands] from [categories] where idfrombrands=@idfrombrands " > <SelectParameters> <asp:ControlParameter ControlID="brandDrop" Name="idfrombrands" PropertyName="SelectedValue" Type="Int32" /> </SelectParameters> </asp:SqlDataSource> </EditItemTemplate> </asp:TemplateField>
这是我的代码背后
GridView1_RowDataBound和GridView1_RowUpdating：
protected void GridView1_RowUpdating（object sender，GridViewUpdateEventArgs e）
{
int brand = 0;
int category = 0;
// Drop Brand ----- ---------------------------------
DropDownList list1 =（DropDownList）GridView1.Rows [e.RowIndex] .FindControl（brandDrop）;
Label lbl =（Label）GridView1.Rows [e.RowIndex] .FindControl（br） ;
if（list1.SelectedItem.Value！= null）
{
brand = Convert.ToInt32 （list1.SelectedItem.Value）; // NewIdFromBrand
}
else
{
brand = Convert.ToInt32（lbl.Text）;
}
//掉落类别------ --- -------------------------------
DropDownList list2 = （DropDownList）GridView1.Rows [e.RowIndex] .FindControl（categoryDrop）;
Label lbl2 =（Label）GridView1.Rows [e.RowIndex] .FindControl（OldCatName）;
// int NewIdFromBrand2 = -1;
if（list2.SelectedItem.Value！= null）
{
category = Convert.ToInt32（list2.SelectedItem.Value）; // NewIdFromBrand2
}
否则
{
category = Convert.ToInt32（lbl2.Text）;
}
//照片-------------------------------------------
string photoname = System.Guid.NewGuid（）。ToString（）;
GridViewRow row = GridView1.Rows [e.RowIndex];
FileUpload fileUpload = row.FindControl（FileUploadimg）as FileUpload;
Label lbl3 =（Label）GridView1.Rows [e .RowIndex] .FindControl（ oldImage）;
if（fileUpload！= null&& fileUpload.HasFile）
{
fileUpload.SaveAs（Server.MapPath（〜/ P_Image）+ photoname + fileUpload.FileName）;
SqlDataSource1.UpdateParameters [path]。DefaultValue =〜/ P_Image+ photoname + fileUpload.FileName;
}
else
{
SqlDataSource1.UpdateParameters [path]。DefaultValue = l bl3.Text ; // oldImage.Text;
}
int prid = Convert.ToInt32（GridView1.DataKeys [e.RowIndex] .Value）;
SqlConnection cn = new SqlConnection（）;
cn.ConnectionString =server = .; database = mobile_store; Trusted_Connection = true;
DataTable tb = new DataTable（） ;
SqlCommand cmd = new SqlCommand（）;
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText =UpdateProduct;
cmd .Parameters.AddWithValue（@ brandid，品牌）;
cmd.Parameters.AddWithValue（@ catid，类别）;
cmd.Parameters.AddWithValue（ @pid，prid）;
试试
{
cn.Open（）;
cmd.ExecuteNonQuery （）;
SqlDataSource1.DataBind（）;
}
catch（exception ex2）
{
}
finally {cn.Close（）; }
//GridView1.EditIndex = -1;
//GridView1.DataBind（）;
}
protected void GridView1_RowDataBound（object sender，GridViewRowEventArgs e）
{
if（e.Row。 RowType == DataControlRowType.DataRow）
{
//检查是否处于编辑模式
if（（e.Row.RowState& DataControlRowState.Edit）> 0）
{
DataRowView dRowView1 =（DataRowView）e.Row.DataItem;
if（e.Row .RowType == DataControlRowType.DataRow）
{
if（（e.Row.RowState& DataControlRowState.Edit）> 0）
{
DropDownList ddlStatus =（DropDownList）e.Row.FindControl（brandDrop）;
ddlStatus.SelectedValue = dRowView1 [brandId]。ToString（）;
DropDownList ddlStatus2 =（博士opDownList）e.Row.FindControl（categoryDrop）;
ddlStatus2.SelectedValue = dRowView1 [categoryID]。ToString（）;
//Label1.Text = ddlStatus.SelectedValue;
}
}
}
}
}
this is my code behind for
GridView1_RowDataBound and GridView1_RowUpdating:
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int brand=0;
int category=0;
//Drop Brand--------------------------------------
DropDownList list1 = (DropDownList)GridView1.Rows[e.RowIndex].FindControl("brandDrop");
Label lbl = (Label)GridView1.Rows[e.RowIndex].FindControl("br");
if (list1.SelectedItem.Value != null)
{
brand = Convert.ToInt32(list1.SelectedItem.Value);//NewIdFromBrand
}
else
{
brand = Convert.ToInt32(lbl.Text);
}
//Drop Category----------------------------------------
DropDownList list2 = (DropDownList)GridView1.Rows[e.RowIndex].FindControl("categoryDrop");
Label lbl2 = (Label)GridView1.Rows[e.RowIndex].FindControl("OldCatName");
//int NewIdFromBrand2 = -1;
if (list2.SelectedItem.Value != null)
{
category = Convert.ToInt32(list2.SelectedItem.Value);//NewIdFromBrand2
}
else
{
category = Convert.ToInt32(lbl2.Text);
}
//Photo-------------------------------------------
string photoname = System.Guid.NewGuid().ToString();
GridViewRow row = GridView1.Rows[e.RowIndex];
FileUpload fileUpload = row.FindControl("FileUploadimg") as FileUpload;
Label lbl3 = (Label)GridView1.Rows[e.RowIndex].FindControl("oldImage");
if (fileUpload != null && fileUpload.HasFile)
{
fileUpload.SaveAs(Server.MapPath("~/P_Image") + photoname + fileUpload.FileName);
SqlDataSource1.UpdateParameters["path"].DefaultValue = "~/P_Image" + photoname + fileUpload.FileName;
}
else
{
SqlDataSource1.UpdateParameters["path"].DefaultValue = l bl3.Text;//oldImage.Text;
}
int prid = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value);
SqlConnection cn = new SqlConnection();
cn.ConnectionString = "server = . ; database = mobile_store ; Trusted_Connection=true";
DataTable tb = new DataTable();
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "UpdateProduct";
cmd.Parameters.AddWithValue("@brandid", brand );
cmd.Parameters.AddWithValue("@catid", category );
cmd.Parameters.AddWithValue("@pid", prid);
try
{
cn.Open();
cmd.ExecuteNonQuery();
SqlDataSource1.DataBind();
}
catch (Exception ex2)
{
}
finally { cn.Close(); }
//GridView1.EditIndex = -1;
//GridView1.DataBind();
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
//check if is in edit mode
if ((e.Row.RowState & DataControlRowState.Edit) > 0)
{
DataRowView dRowView1 = (DataRowView)e.Row.DataItem;
if (e.Row.RowType == DataControlRowType.DataRow)
{
if ((e.Row.RowState & DataControlRowState.Edit) > 0)
{
DropDownList ddlStatus = (DropDownList)e.Row.FindControl("brandDrop");
ddlStatus.SelectedValue = dRowView1["brandId"].ToString();
DropDownList ddlStatus2 = (DropDownList)e.Row.FindControl("categoryDrop");
ddlStatus2.SelectedValue = dRowView1["categoryID"].ToString();
//Label1.Text = ddlStatus.SelectedValue;
}
}
}
}
}
我改变了我的活动，现在工作正常：
protected void GridView1_RowDataBound（object sender，GridViewRowEventArgs e）
{
if（e .Row.RowType == DataControlRowType.DataRow）
{
//检查是否处于编辑模式
if（（e.Row。 RowState&DataControlRowState.Edit）> 0）
{
DataRowView dRowView1 =（DataRowView）e.Row.DataItem;
if（e.Row.RowType == DataControlRowType。 DataRow）
{
if（（e.Row.RowState&DataControlRowState.Edit）> 0）
{
DropDownList ddlStatus =（DropDownList）e.Row.FindControl（brandDrop）;
ddlStatus.SelectedValue = dRowView1 [brandId]。ToString（）;
DropDownList ddlStatus2 =（DropDownList）e.Row.FindControl（categoryDrop）;
ddlStatus2.SelectedValue = dRowView1 [categoryID]。ToString（）;
SqlDataSource sq =（SqlDataSource）e.Row.FindControl（SqlDataSource3）;
sq.SelectParameters [idfrombrands]。DefaultValue = dRowView1 [brandId]。 ToString（）;
}
}
}
}
}
I changed my event like this and it works fine now:
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
//check if is in edit mode
if ((e.Row.RowState & DataControlRowState.Edit) > 0)
{
DataRowView dRowView1 = (DataRowView)e.Row.DataItem;
if (e.Row.RowType == DataControlRowType.DataRow)
{
if ((e.Row.RowState & DataControlRowState.Edit) > 0)
{
DropDownList ddlStatus = (DropDownList)e.Row.FindControl("brandDrop");
ddlStatus.SelectedValue = dRowView1["brandId"].ToString();
DropDownList ddlStatus2 = (DropDownList)e.Row.FindControl("categoryDrop");
ddlStatus2.SelectedValue = dRowView1["categoryID"].ToString();
SqlDataSource sq = (SqlDataSource)e.Row.FindControl("SqlDataSource3");
sq.SelectParameters["idfrombrands"].DefaultValue = dRowView1["brandId"].ToString();
}
}
}
}
}
这篇关于我的两个具有父子关系的下拉列表在我的gridview中的EditItemTemplate中出现问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
