asp.net中DataList中的更新错误 [英] error in update in DataList in asp.net
本文介绍了asp.net中DataList中的更新错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
hi
我有一个datalist从Databse获取图片
当我点击编辑文本框并且复选框没有获得价值(txtAlt_Txt,chk_Active)
hi
I have a datalist get picture from Databse
when i click on "Edit" the textbox and checkbox not get value(txtAlt_Txt , chk_Active)
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<div align="center">
<div style="width: 600px; margin-removed 80px;">
<ul class="hoverbox">
<asp:DataList ID="DataList1"
RepeatColumns="4"
RepeatDirection="Horizontal"
DataKeyField="ID_Pic"
OnEditCommand="DataList1_OnEditCommand"
OnCancelCommand="DataList1_OnCancelCommand"
OnUpdateCommand="DataList1_OnUpdateCommand"
OnDeleteCommand="DataList1_OnDeleteCommand"
runat="server">
<ItemTemplate>
<asp:Label ID="lbl_ID_Pic" runat="server" Visible="False" Text='<%# Eval("ID_Pic") %>'></asp:Label>
<li>
<a href="#">
<img src='<%# Eval("PinNameMD5") %>' alt='<%# Eval("Alt_Txt") %>' />
<img src='<%# Eval("PinNameMD5") %>' alt='<%# Eval("Alt_Txt") %>' class="preview" />
</a>
</li>
<asp:LinkButton
ID="lnkEdit"
CommandName="Edit"
ValidationGroup="g"
Text="Edit"
runat="server" />
|
<asp:LinkButton
ID="lnkDelete"
CommandName="Delete"
Text="Delete"
ValidationGroup="g"
OnClientClick="return confirm('Are you sure?');"
runat="server" />
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox
ID="txtAlt_Txt"
Text='<%#Bind("Alt_Txt")%>'
ValidationGroup="g"
runat="server" />
<br />
<asp:CheckBox
ID="chk_Active"
Text="Active"
Checked='<%#Bind("Active")%>'
ValidationGroup="g"
runat="server" />
<br />
<asp:LinkButton
ID="lnkUpdate"
CommandName="Update"
ValidationGroup="g"
Text="Update"
runat="server" />
|
<asp:LinkButton
ID="lnkCancel"
CommandName="Cancel"
ValidationGroup="g"
Text="Cancel"
runat="server" />
</EditItemTemplate>
</asp:DataList>
</ul>
</div>
</div>
</ContentTemplate>
</asp:UpdatePanel>
private void Galleryset()
{
DataTable dt=new DataTable();
Dal.Fill_Dt("SELECT ID_Pic,'Wallpaper/thumb/'+ PinNameMD5 as 'PinNameMD5',Alt_Txt FROM Tbl_Glry", dt);
DataList1.DataSource = dt;
DataList1.DataBind();
}
protected void DataList1_OnEditCommand(object source, DataListCommandEventArgs e)
{
DataList1.EditItemIndex = e.Item.ItemIndex;
// DataList1.DataBind();
// Galleryset();
}
protected void DataList1_OnUpdateCommand(object source, DataListCommandEventArgs e)
{
Label lbl_ID_Pic = (Label)e.Item.FindControl("lbl_ID_Pic");
TextBox txtAltText = (TextBox)e.Item.FindControl("txtAlt_Txt");
CheckBox chk = (CheckBox)e.Item.FindControl("chk_Active");
Dal.Cmd_Qry("UPDATE Tbl_Glry SET Alt_Txt=N'" + txtAltText.Text + "',Active='" + chk.Checked + "' WHERE ID_Pic='"+lbl_ID_Pic.Text+"'");
Galleryset();
DataList1.EditItemIndex = -1;
}
推荐答案
Remove Comment from Galleryset function in OnEditCommandEvent, mean Rebind datalist with database Fore Example <pre lang="c#">Galleryset();
这篇关于asp.net中DataList中的更新错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文