using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.Linq;
public partial class linq : System.Web.UI.Page
{
DataClassesDataContext dc = new DataClassesDataContext();
Table1 t = new Table1();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
bind();
}
}
private void bind()
{
var a = dc.Table1s.ToList();
GridView1.DataSource = a;
GridView1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
t.Address = TextBox2.Text;
t.name = TextBox1.Text;
dc.Table1s.InsertOnSubmit(t);
dc.SubmitChanges();
/* if sp require
* dc.spinsert(TextBox2.Text,TextBox1.Text);
* leftouterjoin in linq*/
//var q = from t1 in dc.Table1s
// join t2 in dc.count_tbls on t1.id equals t2.id into t1t2
// from t2 in t1t2.DefaultIfEmpty()
// select new {t1.id,t1.name,t2.month};
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
bind();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
GridViewRow gd = GridView1.Rows[e.RowIndex];
int id1 = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value.ToString());
var h = dc.Table1s.Where(m => m.id == id1).Single<Table1>();
dc.Table1s.DeleteOnSubmit(h);
dc.SubmitChanges();
bind();
Response.Write("Delete");
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
bind();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow gd = GridView1.Rows[e.RowIndex];
int id1 = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value.ToString());
string t1 = ((TextBox)gd.Cells[3].Controls[0]).Text;
var h = dc.Table1s.Where(m=>m.id==id1).Single<Table1>();
h.name = t1;
dc.SubmitChanges();
GridView1.EditIndex = -1;
bind();
Response.Write("update");
}
}
/*source*/
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="linq.aspx.cs" Inherits="linq" %>
<!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:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
<asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click" />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="id"
OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating" OnRowCancelingEdit="GridView1_RowCancelingEdit"
OnRowDeleting="GridView1_RowDeleting">
<Columns>
<asp:CommandField ShowEditButton="True" />
<asp:CommandField ShowDeleteButton="True" />
<asp:BoundField DataField="id" HeaderText="id" Visible="false" />
<asp:BoundField DataField="name" HeaderText="Name" />
</Columns>
</asp:GridView>
</div>
</form>
</body>
</html>
No comments:
Post a Comment