using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.EnterpriseServices;
using System.Data.EntityModel;
using jayModel;
using System.Drawing.Text;
public partial class listview : System.Web.UI.Page
{
/*here listview1 or listview2
/*if any chid control data bind in listview so use Listview1_Itemcreated*/
jayEntities j = new jayEntities();
Table1 tt = new Table1();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
TextBox1.Text = Request.QueryString["id"].ToString();
Label2.Text = Session["id"].ToString();
bind();
bind1();
}
}
private void bind()
{
var v = j.spselect();
ListView1.DataSource = v;
ListView1.DataBind();
}
private void bind1()
{
var v = j.spselect();
ListView2.DataSource = v;
ListView2.DataBind();
}
protected void ListView1_ItemInserting(object sender, ListViewInsertEventArgs e)
{
string name = "";
TextBox txt = (e.Item.FindControl("EmpNameTextBox")) as TextBox;
if (txt != null)
name = txt.Text;
Table1 t1 = new Table1();
t1.name = name;
j.AddToTable1(t1);
j.SaveChanges();
ListView1.EditIndex = -1;
bind();
}
protected void ListView1_ItemUpdating(object sender, ListViewUpdateEventArgs e)
{
TextBox txt = (ListView1.Items[e.ItemIndex].FindControl("EmpNameTextBox")) as TextBox;
DropDownList dr = (ListView1.Items[e.ItemIndex].FindControl("Dropdownlist2")) as DropDownList;
int id1 = Convert.ToInt32(ListView1.DataKeys[e.ItemIndex].Value);
//var f = j.Table1.Where(m => m.id == id1).Single<Table1>();
Table1 tt = j.Table1.Where(m => m.id == id1).Single<Table1>();
tt.name = dr.SelectedItem.Text;
//tt.name = txt.Text;
j.SaveChanges();
ListView1.EditIndex = -1;
bind();
}
protected void ListView1_ItemCanceling(object sender, ListViewCancelEventArgs e)
{
ListView1.EditIndex = -1;
bind();
}
protected void ListView1_ItemDeleting(object sender, ListViewDeleteEventArgs e)
{
int id1 = Convert.ToInt32(ListView1.DataKeys[e.ItemIndex].Value);
var tt = j.Table1.Where(n => n.id == id1).ToList();
j.DeleteObject(tt);
j.SaveChanges();
ListView1.EditIndex = -1;
bind();
}
protected void ListView1_ItemEditing(object sender, ListViewEditEventArgs e)
{
ListView1.EditIndex = e.NewEditIndex;
bind();
}
protected void ListView1_ItemCreated(object sender, ListViewItemEventArgs e)
{
try
{
//if (e.Item.ItemType == ListViewItemType.InsertItem)
//{
DropDownList drp_town = (DropDownList)(e.Item.FindControl("Dropdownlist2"));
var s = j.spselect().ToList();
drp_town.DataSource = s;
drp_town.DataTextField = "name";
drp_town.DataValueField = "id";
drp_town.DataBind();
}
catch (Exception ex)
{
ex.Message.ToString();
}
}
protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)
{
}
protected void ListView1_ItemDataBound(object sender, ListViewItemEventArgs e)
{
//ListView objListView = (ListView)sender;
//// Only do this if we are editing the ListView
//// Only do this if we are editing this item
//if (objListView.EditIndex > -1)
//{
// if (e.Item.ID == objListView.EditItem.ID)
// {
// DropDownList Dropdownlist2 = (DropDownList)(e.Item.FindControl("Dropdownlist2"));
// Dropdownlist2.SelectedIndexChanged += new EventHandler(DropDownList2_SelectedIndexChanged);
// }
// //drp_town.Items.FindByText("jay").Selected = true;
// //drp_town.Items.FindByValue("Dropdownlist2").Selected = true;
//}
}
protected void ListView2_ItemEditing(object sender, ListViewEditEventArgs e)
{
ListView2.EditIndex = e.NewEditIndex;
bind1();
}
protected void ListView2_ItemInserted(object sender, ListViewInsertedEventArgs e)
{
}
protected void ListView2_ItemInserting(object sender, ListViewInsertEventArgs e)
{
string name = "";
TextBox txt = (e.Item.FindControl("nameTextBox")) as TextBox;
if (txt != null)
name = txt.Text;
Table1 t1 = new Table1();
t1.name = name;
j.AddToTable1(t1);
j.SaveChanges();
ListView2.EditIndex = -1;
bind1();
}
protected void ListView2_ItemUpdating(object sender, ListViewUpdateEventArgs e)
{
TextBox txt = (ListView2.Items[e.ItemIndex].FindControl("nameTextBox")) as TextBox;
int id1 = Convert.ToInt32(ListView1.DataKeys[e.ItemIndex].Value);
//var f = j.Table1.Where(m => m.id == id1).Single<Table1>();
Table1 tt = j.Table1.Where(m => m.id == id1).Single<Table1>();
tt.name = txt.Text;
j.SaveChanges();
ListView1.EditIndex = -1;
bind1();
}
protected void ListView2_ItemDeleting(object sender, ListViewDeleteEventArgs e)
{
int id1 = Convert.ToInt32(ListView2.DataKeys[e.ItemIndex].Value);
var tt = j.Table1.Where(n => n.id == id1).ToList();
j.DeleteObject(tt);
j.SaveChanges();
ListView2.EditIndex = -1;
bind1();
}
protected void Dropdownlist2_SelectedIndexChanged(object sender, EventArgs e)
{
}
}
//sourcepage
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="listview.aspx.cs" Inherits="listview" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:ListView ID="ListView1" runat="server" InsertItemPosition="LastItem" OnItemCanceling="ListView1_ItemCanceling"
OnItemDeleting="ListView1_ItemDeleting" OnItemInserting="ListView1_ItemInserting"
OnItemUpdating="ListView1_ItemUpdating" OnItemEditing="ListView1_ItemEditing"
DataKeyNames="id" OnItemCreated="ListView1_ItemCreated" OnItemDataBound="ListView1_ItemDataBound"
allowpaging="true">
<LayoutTemplate>
<table id="Table1" runat="server">
<tr id="Tr1" runat="server">
<td id="Td1" runat="server">
<table id="itemPlaceholderContainer" runat="server" border="1" style="">
<tr id="Tr2" runat="server" style="">
<th id="th1" runat="server">
</th>
<th id="Th2" runat="server">
Name
</th>
</tr>
<tr id="itemPlaceholder" runat="server">
</tr>
</table>
</td>
</tr>
</table>
<div style="clear: both;">
<asp:DataPager ID="DataPager1" runat="server" PageSize="3">
<Fields>
<asp:NextPreviousPagerField ButtonType="Button" ShowFirstPageButton="True" ShowLastPageButton="True" />
</Fields>
</asp:DataPager>
</div>
</LayoutTemplate>
<ItemTemplate>
<tr style="">
<td>
<asp:Button ID="Btnedit" runat="server" Text="Edit" CommandName="Edit" />
<asp:Button ID="Btndelete" runat="server" Text="Delete" CommandName="Delete" />
</td>
<td border="1" runat="server">
<%-- <asp:Label ID="Name" runat="server" Text='<%# Eval("Name") %>'></asp:Label>--%>
<%# Eval("Name") %>
<%-- <asp:DropDownList ID="DropDownList2" runat="server" selectedvalue='<%# Eval("id") %>'>
</asp:DropDownList>--%>
</td>
<td>
</td>
</tr>
</ItemTemplate>
<EditItemTemplate>
<tr style="">
<td>
<asp:Button ID="UpdateButton" runat="server" CommandName="Update" Text="Update" />
<asp:Button ID="CancelButton" runat="server" CommandName="Cancel" Text="Cancel" />
</td>
<td>
<%--<asp:TextBox ID="IDTextBox" runat="server" Text='<%# Bind("id") %>' />--%>
<asp:TextBox ID="EmpNameTextBox" runat="server" Text='<%# Bind("Name") %>' />
</td>
<td>
<%--<asp:TextBox ID="IDTextBox" runat="server" Text='<%# Bind("id") %>' />--%>
<asp:DropDownList ID="DropDownList2" runat="server" SelectedValue='<%# Eval("id") %>'
AutoPostBack="true" onselectedindexchanged="DropDownList2_SelectedIndexChanged">
</asp:DropDownList>
</td>
</tr>
</EditItemTemplate>
<InsertItemTemplate>
<tr style="">
<td>
<asp:Button ID="InsertButton" runat="server" CommandName="Insert" Text="Insert" />
<asp:Button ID="CancelButton" runat="server" CommandName="Cancel" Text="Clear" />
</td>
<td runat ="server" border="1">
<asp:TextBox ID="EmpNameTextBox" runat="server" Text='<%# ("Name") %>' />
</td>
<td>
<%--<asp:DropDownList ID="DropDownList2" runat="server" DataTextField="Name" >
</asp:DropDownList>--%>
</td>
</tr>
</InsertItemTemplate>
</asp:ListView>
<%--<asp:DataPager ID="data1" runat="server" PagedControlID="ListView1"
PageSize="2" >
<Fields>
<asp:NextPreviousPagerField ButtonType="Button" ShowFirstPageButton="True"
ShowLastPageButton="True" />
</Fields>
</asp:DataPager>--%>
<table>
<tr>
<%-- <td class="style1">
<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True">
</asp:DropDownList>
</td>--%>
<td>
You have
<asp:Label ID="Label1" runat="server" Text=""></asp:Label>
Entries
<br />
</td>
</tr>
</table>
</div>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<asp:Label ID="Label2" runat="server" Text="Label"></asp:Label>
<br />
<br />
<br />
<asp:ListView ID="ListView2" runat="server" InsertItemPosition="LastItem" DataKeyNames="id"
OnItemDeleting="ListView2_ItemDeleting" OnItemEditing="ListView2_ItemEditing"
OnItemInserted="ListView2_ItemInserted" OnItemInserting="ListView2_ItemInserting"
OnItemUpdating="ListView2_ItemUpdating">
<LayoutTemplate>
<table runat="server">
<tr runat="server">
<td runat="server">
<table id="itemPlaceholderContainer" runat="server" border="1" style="background-color: #FFFFFF;
border-collapse: collapse; border-color: #999999; border-style: none; border-width: 1px;
font-family: Verdana, Arial, Helvetica, sans-serif;">
<tr runat="server" style="background-color: #DCDCDC; color: #000000;">
<th runat="server">
</th>
<th runat="server">
id
</th>
<th runat="server">
name
</th>
<%--<th runat="server">
Address</th>--%>
</tr>
<tr id="itemPlaceholder" runat="server">
</tr>
</table>
</td>
</tr>
<tr runat="server">
<td runat="server" style="text-align: center; background-color: #CCCCCC; font-family: Verdana, Arial, Helvetica, sans-serif;
color: #000000;">
<asp:DataPager ID="DataPager1" runat="server">
<Fields>
<asp:NextPreviousPagerField ButtonType="Button" ShowFirstPageButton="True" ShowLastPageButton="True" />
</Fields>
</asp:DataPager>
</td>
</tr>
</table>
</LayoutTemplate>
<ItemTemplate>
<tr style="background-color: #DCDCDC; color: #000000;">
<td>
<asp:Button ID="DeleteButton" runat="server" CommandName="Delete" Text="Delete" />
<asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="Edit" />
</td>
<td>
<asp:Label ID="idLabel" runat="server" Text='<%# Eval("id") %>' />
</td>
<td>
<asp:Label ID="nameLabel" runat="server" Text='<%# Eval("name") %>' />
</td>
<%-- <td>
<asp:Label ID="AddressLabel" runat="server" Text='<%# Eval("Address") %>' />
</td>--%>
</tr>
</ItemTemplate>
<AlternatingItemTemplate>
<tr style="background-color: #FFF8DC;">
<td>
<asp:Button ID="DeleteButton" runat="server" CommandName="Delete" Text="Delete" />
<asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="Edit" />
</td>
<td>
<asp:Label ID="idLabel" runat="server" Text='<%# Eval("id") %>' />
</td>
<td>
<asp:Label ID="nameLabel" runat="server" Text='<%# Eval("name") %>' />
</td>
<%--<td>
<asp:Label ID="AddressLabel" runat="server" Text='<%# Eval("Address") %>' />
</td>--%>
</tr>
</AlternatingItemTemplate>
<EditItemTemplate>
<tr style="background-color: #008A8C; color: #FFFFFF;">
<td>
<asp:Button ID="UpdateButton" runat="server" CommandName="Update" Text="Update" />
<asp:Button ID="CancelButton" runat="server" CommandName="Cancel" Text="Cancel" />
</td>
<td>
<%--<asp:Label ID="idLabel1" runat="server" Text='<%# Eval("id") %>' />--%>
</td>
<td>
<asp:TextBox ID="nameTextBox" runat="server" Text='<%# Bind("name") %>' />
</td>
<%--<td>
<asp:TextBox ID="AddressTextBox" runat="server" Text='<%# Bind("Address") %>' />
</td>--%>
</tr>
</EditItemTemplate>
<EmptyDataTemplate>
<table runat="server" style="background-color: #FFFFFF; border-collapse: collapse;
border-color: #999999; border-style: none; border-width: 1px;">
<tr>
<td>
No data was returned.
</td>
</tr>
</table>
</EmptyDataTemplate>
<InsertItemTemplate>
<tr style="">
<td>
<asp:Button ID="InsertButton" runat="server" CommandName="Insert" Text="Insert" />
<asp:Button ID="CancelButton" runat="server" CommandName="Cancel" Text="Clear" />
</td>
<td>
<%--<asp:TextBox ID="idTextBox" runat="server" Text='<%# Bind("id") %>' />--%>
</td>
<td>
<asp:TextBox ID="nameTextBox" runat="server" Text='<%# Bind("name") %>' />
</td>
<%--<td>
<asp:TextBox ID="AddressTextBox" runat="server" Text='<%# Bind("Address") %>' />
</td>--%>
</tr>
</InsertItemTemplate>
<%-- <SelectedItemTemplate>
<tr style="background-color:#008A8C;font-weight: bold;color: #FFFFFF;">
<td>
<asp:Button ID="DeleteButton" runat="server" CommandName="Delete"
Text="Delete" />
<asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="Edit" />
</td>
<td>
<asp:Label ID="idLabel" runat="server" Text='<%# Eval("id") %>' />
</td>
<td>
<asp:Label ID="nameLabel" runat="server" Text='<%# Eval("name") %>' />
</td>
<td>
<asp:Label ID="AddressLabel" runat="server" Text='<%# Eval("Address") %>' />
</td>
</tr>
</SelectedItemTemplate>--%>
</asp:ListView>
<br />
<br />
</form>
</body>
</html>
No comments:
Post a Comment