How To add reference entity framework (Click here)
Aspx page code:-
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Registration.aspx.cs" Inherits="entity_test_25_4.Registration" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<table>
<tr>
<td>Name:</td>
<td>
<asp:TextBox ID="Textname" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td>Gender:</td>
<td>
<asp:RadioButtonList ID="rblgender" runat="server" RepeatColumns="3">
<asp:ListItem Value="1" Text="Male"></asp:ListItem>
<asp:ListItem Value="2" Text="Female"></asp:ListItem>
<asp:ListItem Value="3" Text="Other"></asp:ListItem>
</asp:RadioButtonList></td>
</tr>
<tr>
<td>Country:</td>
<td>
<asp:DropDownList ID="ddlcountry" runat="server"></asp:DropDownList></td>
</tr>
<tr>
<td>Hobbies:</td>
<td>
<asp:CheckBoxList ID="cblhobbies" runat="server" RepeatColumns="3">
<asp:ListItem Value="1" Text="Cricket"></asp:ListItem>
<asp:ListItem Value="2" Text="Football"></asp:ListItem>
<asp:ListItem Value="3" Text="Music"></asp:ListItem>
<asp:ListItem Value="4" Text="Dancing"></asp:ListItem>
<asp:ListItem Value="5" Text="Swimming"></asp:ListItem>
<asp:ListItem Value="6" Text="Game"></asp:ListItem>
</asp:CheckBoxList></td>
</tr>
<tr>
<td>Age</td>
<td>
<asp:TextBox ID="Textage" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td>Address:</td>
<td>
<asp:TextBox ID="Textaddress" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td></td>
<td>
<asp:Button ID="btnsave" runat="server" Text="Save" OnClick="btnsave_Click" /></td>
</tr>
</table>
<table border="1" style="background-color:pink">
<tr>
<td></td>
<td><asp:GridView ID="grd" runat="server" AutoGenerateColumns="false" OnRowCommand="grd_RowCommand">
<Columns>
<asp:TemplateField HeaderText="Emp Name">
<ItemTemplate>
<%#Eval("Name") %>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Gender">
<ItemTemplate>
<%#Eval("Gender").ToString()=="1" ? "Male" :Eval("Gender").ToString()=="2" ? "Female" :"Other" %>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Country">
<ItemTemplate>
<%#Eval("Cname") %>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Hobbies">
<ItemTemplate>
<%#Eval("Hobbies") %>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Age">
<ItemTemplate>
<%#Eval("Age") %>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Address">
<ItemTemplate>
<%#Eval("Address") %>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Delete">
<ItemTemplate>
<asp:LinkButton ID="lnkbtndelete" runat="server" Text="Delete" CommandName="DEL" CommandArgument='<%#Eval("Empid") %>'></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Address">
<ItemTemplate>
<asp:LinkButton ID="lnkbtnedit" runat="server" Text="Edit" CommandName="EDT" CommandArgument='<%#Eval("Empid") %>'></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView></td>
</tr>
</table>
</div>
</form>
</body>
</html>
.CS page code C#:-
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
namespace entity_test_25_4
{
public partial class Registration : System.Web.UI.Page
{
entity_test_25_4Entities _obj = new entity_test_25_4Entities();
Employee _emp = new Employee();
Country ctr = new Country();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Fill_country();
data_bind();
}
}
public void clear()
{
Textname.Text = "0";
}
public void Fill_country()
{
var ctrcountry = (from tbl in _obj.Countries select tbl).ToList();
if(ctrcountry.Count>0)
{
ddlcountry.DataValueField = "Cid";
ddlcountry.DataTextField = "Cname";
ddlcountry.DataSource = ctrcountry;
ddlcountry.DataBind();
ddlcountry.Items.Insert(0, new ListItem("--select--", "0"));
}
}
public void data_bind()
{
var DB = (from tbl1 in _obj.Employees join tbl2 in _obj.Countries on tbl1.Country equals tbl2.Cid
select new{tbl1.Empid,tbl1.Name,tbl1.Gender,tbl1.Country,tbl1.Hobbies,tbl1.Age,tbl1.Address,tbl2.Cname}).ToList();
if(DB.Count>0)
{
grd.DataSource = DB;
grd.DataBind();
}
else
{
grd.DataSource = null;
grd.DataBind();
}
}
protected void btnsave_Click(object sender, EventArgs e)
{
string HOB = "";
for (int i = 0; i < cblhobbies.Items.Count; i++)
{
if (cblhobbies.Items[i].Selected == true)
{
HOB += cblhobbies.Items[i].Text + ',';
}
}
HOB = HOB.TrimEnd(',');
_emp.Name = Textname.Text;
_emp.Gender = int.Parse(rblgender.SelectedValue);
_emp.Country = int.Parse(ddlcountry.SelectedValue);
_emp.Hobbies = HOB;
_emp.Age = int.Parse(Textage.Text);
_emp.Address = Textaddress.Text;
if (btnsave.Text == "Save")
{
_obj.Employees.Add(_emp);
}
else if(btnsave.Text=="Update")
{
_emp.Empid = Convert.ToInt32(ViewState["EID"]);
_obj.Entry(_emp).State = EntityState.Modified;
}
_obj.SaveChanges();
btnsave.Text = "Save";
Response.Redirect(Request.Url.AbsoluteUri);
data_bind();
}
protected void grd_RowCommand(object sender, GridViewCommandEventArgs e)
{
int IDD = Convert.ToInt32(e.CommandArgument);
if(e.CommandName=="DEL")
{
var dd = _obj.Employees.Find(IDD);
_obj.Employees.Remove(dd);
_obj.SaveChanges();
data_bind();
}
else if (e.CommandName == "EDT")
{
var dt = (from tbl3 in _obj.Employees where tbl3.Empid == IDD select tbl3).ToList();
if (dt.Count > 0)
{
Textname.Text = dt[0].Name.ToString();
rblgender.SelectedValue = dt[0].Gender.ToString();
ddlcountry.SelectedValue = dt[0].Country.ToString();
string[] arg = dt[0].Hobbies.ToString().Split(',');
cblhobbies.ClearSelection();
for (int i = 0; i < cblhobbies.Items.Count; i++)
{
for (int j = 0; j < arg.Length; j++)
{
if (cblhobbies.Items[i].Text== arg[j])
{
cblhobbies.Items[i].Selected = true;
break;
}
}
}
Textage.Text = dt[0].Age.ToString();
Textaddress.Text = dt[0].Address.ToString();
btnsave.Text = "Update";
ViewState["EID"] = IDD;
}
}
}
}
}
No comments:
Post a Comment