Наши проекты:
Журнал · Discuz!ML · Wiki · DRKB · Помощь проекту |
||
ПРАВИЛА | FAQ | Помощь | Поиск | Участники | Календарь | Избранное | RSS |
[3.138.141.202] |
|
Сообщ.
#1
,
|
|
|
Здравствуйте! Не могу сохранить данные из TextBox который находится в ListView. Для сохранения данных использую функцию Update ListView.
<asp:ListView ID="lv_ShowPhoto" runat="server" ItemPlaceholderID="PlaceHolder1" OnItemEditing="EditListViewItem" OnItemCanceling="CancelListViewItem" OnItemUpdating="UpdateListViewItem" DataKeyNames="id" OnPagePropertiesChanging="PagePropertiesChanging" OnItemInserting="InsertListViewItem" InsertItemPosition="LastItem" OnItemDeleting="DeleteListViewItem" border="0.01px" > <LayoutTemplate> <table width="100%" cellpadding="4" cellspacing="0" style="background-color: #FFFFDF" > <tr > <th style="width: 70%;"> <!--<asp:LinkButton ID="lnkSort1" runat="server" CommandName="Sort" CommandArgument="Name" Text="Name" />--> </th> </tr> <asp:PlaceHolder ID="PlaceHolder1" runat="server"></asp:PlaceHolder> </table> </LayoutTemplate> <ItemTemplate > <tr > <td > <asp:Label ID="lb_id" runat="server" Text='<%# Eval("id") %>' Visible="False"></asp:Label><br/> </td> </tr> <tr > <td > <asp:Image ID="Image1" runat="server" height="300px" weight="300px" ImageUrl='<%# Eval("NamePhoto") %>'/><br/> </td> </tr> <tr > <td > <asp:Label ID="Label2" runat="server" Text='<%# Eval("Comment") %>'></asp:Label><br/> </td> </tr> <tr > <td > <asp:LinkButton ID="LinkButton1" runat="server" Text="Изменить" CommandName="Edit" /> </td> </tr> <tr > <td > <span onclick="return confirm('Вы желаете удалить фото?')"> <asp:LinkButton ID="LinkButton3" runat="server" Text="Удалить" CommandName="Delete" ForeColor="Brown"/> </span> </td> </tr> </ItemTemplate> <EditItemTemplate> <tr > <td> <asp:Label ID="lb_id" runat="server" Text='<%# Eval("id") %>' Visible="False"></asp:Label><br/> </td> </tr> <tr > <td> <asp:Image ID="Image2" runat="server" height="300px" weight="300px" ImageUrl='<%# Eval("NamePhoto") %>'/><br/> </td> </tr> <tr > <td> <asp:TextBox ID="TextBox1" runat="server" Height="50px" TextMode="MultiLine" Width="300px"></asp:TextBox><br /> </td> </tr> <tr > <td> <asp:CheckBox ID="CheckBox1" Text="Сделать главной" runat="server" /><br/> </td> </tr> <tr > <td> <span onclick="return confirm('Вы хотите внести изменения?')"> <asp:LinkButton ID="LinkButton2" runat="server" Text="Сохранить" CommandName="Update" /> </span> </td> </tr> <tr > <td> <asp:LinkButton ID="LinkButton5" runat="server" Text="Закрыть" CommandName="Cancel" /> </td> </tr> </EditItemTemplate> <InsertItemTemplate> <tr > <td> <!--<asp:Label ID="lb_id" runat="server" Text='<%# Eval("id") %>' Visible="False"></asp:Label><br/>--> <!--<asp:Image ID="im" runat="server" height="300px" weight="300px" ImageUrl='<%# Eval("NamePhoto")%>'/><br/>--> <!--<asp:TextBox ID="lb_Comment" runat="server" Text='<%# Eval("Comment") %>'></asp:TextBox><br/>--> <!--<asp:CheckBox ID="cb_MainPhoto" Text="Сделать главной" runat="server" /><br/>--> </td> <td> <!--<span onclick="return confirm('Are you sure to insert?')">--> <!--<asp:LinkButton ID="btnInsert" runat="server" Text="Insert" CommandName="Insert" />--> </span> </td> </tr> </InsertItemTemplate> </asp:ListView> protected void EditListViewItem(object sender, ListViewEditEventArgs e) { lv_ShowPhoto.EditIndex = e.NewEditIndex; string SelectId = SqlClass.SelectCommand("SELECT id From Users WHERE Login = '" + Session["E"].ToString() + "' or Email = '" + Session["E"].ToString() + " '"); SqlDataAdapter da = new SqlDataAdapter("Select * From UsersPhotos where idReg=" + SelectId, SqlClass.GetConnectionString()); DataTable dt = new DataTable(); da.Fill(dt); lv_ShowPhoto.DataSource = dt; DataBind(); } protected void CancelListViewItem(object sender, ListViewCancelEventArgs e) { lv_ShowPhoto.EditIndex = -1; string SelectId = SqlClass.SelectCommand("SELECT id From Users WHERE Login = '" + Session["E"].ToString() + "' or Email = '" + Session["E"].ToString() + " '"); SqlDataAdapter da = new SqlDataAdapter("Select * From UsersPhotos where idReg=" + SelectId, SqlClass.GetConnectionString()); DataTable dt = new DataTable(); da.Fill(dt); lv_ShowPhoto.DataSource = dt; DataBind(); } protected void UpdateListViewItem(object sender, ListViewUpdateEventArgs e) { ListViewItem item = lv_ShowPhoto.Items[e.ItemIndex]; int autoID = int.Parse(lv_ShowPhoto.DataKeys[e.ItemIndex].Value.ToString()); TextBox tComment = (TextBox)item.FindControl("tb_Comment"); string SelectId = SqlClass.SelectCommand("SELECT id From Users WHERE Login = '" + Session["E"].ToString() + "' or Email = '" + Session["E"].ToString() + " '"); SqlDataAdapter da = new SqlDataAdapter("update UsersPhotos set Comment = '" + tComment.Text.Trim() + "' where idReg=" + SelectId + " and id = " + autoID, SqlClass.GetConnectionString()); DataTable dt = new DataTable(); da.Fill(dt); lv_ShowPhoto.DataSource = dt; DataBind(); CancelListViewItem(null,null); // insert records into database lv_ShowPhoto.EditIndex = -1; } |
Сообщ.
#2
,
|
|
|
в разметке lb_Comment, в коде tb_Comment
|