Note:First Add Linq file from right click on Solution Explorer
and click on add new item and select Linq
file
Drag the Tables from database which are
required in your
progrmme & Drop into Linq file which is
you added.
public
partial class _Default : System.Web.UI.Page
{
static int i;
DataClassesDataContext dc = new DataClassesDataContext();
public
void showgrid()
{
GridView1.DataSource = from v in dc.v_demos select v;
GridView1.DataBind();
}
protected
void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
showgrid();
}
}
protected
void Button1_Click(object sender, EventArgs e)
{
if (Button1.Text == "Add")
{
v_demo dt = new v_demo();
dt.name = TextBox1.Text;
dt.city = TextBox2.Text;
dt.phone_no = TextBox3.Text;
dc.v_demos.InsertOnSubmit(dt);
dc.SubmitChanges();
showgrid()
}
else
{
var update = from x in dc.v_demos where x.id ==i select x;
foreach (v_demo x in update)
{
x.name = TextBox1.Text;
x.city = TextBox2.Text;
x.phone_no = TextBox3.Text;
}
dc.SubmitChanges();
showgrid();
ModalPopupExtender1.Show();
TextBox1.Text = "";
TextBox2.Text = "";
TextBox3.Text = "";
Button1.Text = "Add";
}
}
protected void edit_Click(object sender, EventArgs e)
{
Button1.Text = "Update";
LinkButton lb = (LinkButton)sender;
GridViewRow gr = (GridViewRow)lb.NamingContainer;
HiddenField id = (HiddenField)gr.FindControl("HiddenField1");
Label nm = (Label)gr.FindControl("Label1");
Label ct = (Label)gr.FindControl("Label2");
Label ph = (Label)gr.FindControl("Label3");
TextBox1.Text = nm.Text;
TextBox2.Text = ct.Text;
TextBox3.Text = ph.Text;
i = Convert.ToInt32(id.Value);
}
protected void delete_Click(object sender, EventArgs e)
{
LinkButton lb = (LinkButton)sender;
GridViewRow gr = (GridViewRow)lb.NamingContainer;
HiddenField id = (HiddenField)gr.FindControl("HiddenField1");
int id1 = Convert.ToInt32(id.Value);
var del = (from d in dc.v_demos
where d.id == id1
select d).Single();
dc.v_demos.DeleteOnSubmit(del);
dc.SubmitChanges();
showgrid();
}
