public class Emp
{
public int eid { get; set; }
public string name { get; set; }
public string gender { get; set; }
public string email { get; set; }
public string uid { get; set; }
public string pwd { get; set; }
public string fname { get; set; }
public string mobno { get; set; }
public string adress { get; set; }
}
public List<emp> filldata()
{
DataClassesDataContext ss = new DataClassesDataContext();
var s = from mn in ss.Reg_Emps
select new Emp
{
eid= mn.eid,
name=mn.name,
gender=mn.gender,
email=mn.email,
uid=mn.uid,
pwd=mn.pwd,
fname=mn.fname,
mobno=mn.mobno,
adress=mn.adress
};
return s.ToList();
}
public void grid()
{
GridView1.DataSource = filldata();
GridView1.DataBind();
}
public void clear()
{
txt_Email.Text = "";
txt_Emp.Text = "";
txt_Fname.Text = "";
txt_Mob.Text = "";
txt_Pwd.Text = "";
txt_Uname.Text = "";
DDL_Address.SelectedItem.Text = "-Select-";
DDL_Gender.SelectedItem.Text = "-Select-";
}
By using the below code,
The data inserted successfully in the Gridview when we give the input.
But The values are not updated successfully in the GridView.
protected void Btn_Save_Click(object sender, EventArgs e)
{
DataClassesDataContext ss = new DataClassesDataContext();
if (Btn_Save.Text == "Save")
{
Reg_Emp Regg = new Reg_Emp();
if (Regg.eid == 0)
{
Regg.name = txt_Emp.Text;
Regg.gender = DDL_Gender.SelectedItem.Text;
Regg.email = txt_Email.Text;
Regg.uid = txt_Uname.Text;
Regg.pwd = txt_Pwd.Text;
Regg.fname = txt_Fname.Text;
Regg.mobno = txt_Mob.Text;
Regg.adress = DDL_Address.SelectedItem.Text;
ss.Reg_Emps.InsertOnSubmit(Regg);
lbl_Result.Text = "Employee " + txt_Emp.Text + " has been created";
ss.SubmitChanges();
clear();
grid();
}
}
else
{
int empid = Convert.ToInt32(Session["EID"]);
Reg_Emp regg = new Reg_Emp();
regg = ss.Reg_Emps.Where(s => s.eid == empid).FirstOrDefault();
if (regg != null)
{
Regg.name = txt_Emp.Text;
Regg.gender = DDL_Gender.SelectedItem.Text;
Regg.email = txt_Email.Text;
Regg.uid = txt_Uname.Text;
Regg.pwd = txt_Pwd.Text;
Regg.fname = txt_Fname.Text;
Regg.mobno = txt_Mob.Text;
Regg.adress = DDL_Address.SelectedItem.Text;
ss.SubmitChanges();
lbl_Result.Text = "Employee " + txt_Emp.Text + " has been updated successfully";
grid();
}
By using the above code , does not update the data in Gridview
This is my GridView...
This is my .aspx page...
<table cellpadding="2" class="style1">
<tr>
<td class="style2" colspan="2" style="text-align: center">
Employee Registration</td>
</tr>
<tr>
<td class="style3">
<asp:Label ID="Label1" runat="server" BorderStyle="Outset" Text="Employee Name">
</td>
<td>
<asp:TextBox ID="txt_Emp" runat="server" Width="180px" TabIndex="0">
</td>
</tr>
<tr>
<td class="style3">
<asp:Label ID="Label2" runat="server" BorderStyle="Outset" Text="Gender">
</td>
<td>
<asp:DropDownList ID="DDL_Gender" runat="server" Height="16px" Width="127px" TabIndex="1">
<asp:ListItem Value="0">-Select-
<asp:ListItem Value="1">Male
<asp:ListItem Value="2">Female
</td>
</tr>
<tr>
<td class="style3">
<asp:Label ID="Label3" runat="server" BorderStyle="Outset" Text="Email">
</td>
<td>
<asp:TextBox ID="txt_Email" runat="server" Width="180px" TabIndex="2">
</td>
</tr>
<tr>
<td class="style3">
<asp:Label ID="Label4" runat="server" BorderStyle="Outset" Text="UserName">
</td>
<td>
<asp:TextBox ID="txt_Uname" runat="server" Width="180px" TabIndex="3">
</td>
</tr>
<tr>
<td class="style3">
<asp:Label ID="Label5" runat="server" BorderStyle="Outset" Text="Password">
</td>
<td>
<asp:TextBox ID="txt_Pwd" runat="server" Width="180px" TextMode="Password" TabIndex="4">
</td>
</tr>
<tr>
<td class="style3">
<asp:Label ID="Label6" runat="server" BorderStyle="Outset" Text="First Name">
</td>
<td>
<asp:TextBox ID="txt_Fname" runat="server" Width="180px" TabIndex="5">
</td>
</tr>
<tr>
<td class="style3">
<asp:Label ID="Label7" runat="server" BorderStyle="Outset" Text="Mobile No">
</td>
<td>
<asp:TextBox ID="txt_Mob" runat="server" Width="180px" TabIndex="6">
</td>
</tr>
<tr>
<td class="style3">
<asp:Label ID="Label8" runat="server" BorderStyle="Outset" Text="Address">
</td>
<td>
<asp:DropDownList ID="DDL_Address" runat="server" Height="16px" Width="127px" TabIndex="7">
<asp:ListItem Value="0">-Select-
<asp:ListItem Value="1">Chennai
<asp:ListItem Value="2">Delhi
<asp:ListItem Value="3">Kolkatta
<asp:ListItem Value="4">Hydrabad
<asp:ListItem>
</td>
</tr>
<tr>
<td class="style3">
</td>
<td>
<asp:Button ID="Btn_Save" runat="server" Text="Save" onclick="Btn_Save_Click" />
<asp:Label ID="lbl_Result" runat="server">
</td>
</tr>
<tr>
<td class="style3">
</td>
<td>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
onrowcommand="GridView1_RowCommand" onrowdeleting="GridView1_RowDeleting"
onrowediting="GridView1_RowEditing" DataKeyNames="eid">
<columns>
<asp:BoundField DataField="name" HeaderText="Emp Name" ReadOnly="True" />
<asp:BoundField DataField="gender" HeaderText="Gender" ReadOnly="True" />
<asp:BoundField DataField="email" HeaderText="Email" ReadOnly="True" />
<asp:BoundField DataField="uid" HeaderText="User Name" ReadOnly="True" />
<asp:BoundField DataField="pwd" HeaderText="Password" ReadOnly="True" />
<asp:BoundField DataField="fname" HeaderText="First Name" ReadOnly="True" />
<asp:BoundField DataField="mobno" HeaderText="Mobile No" ReadOnly="True" />
<asp:BoundField DataField="adress" HeaderText="City" ReadOnly="True" />
<asp:TemplateField>
<itemtemplate>
<asp:LinkButton ID="LinkButton1" runat="server"
CommandArgument="<%# ((GridViewRow)Container).RowIndex %>"
CommandName="Edit" oncommand="Edit">Edit
<asp:LinkButton ID="LinkButton2" runat="server"
CommandArgument="<%# ((GridViewRow)Container).RowIndex %>"
CommandName="Delete" oncommand="Delete">Delete
</itemtemplate>
</columns>
</td>
</tr>
</table>
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Edit")
{
int index = Convert.ToInt32(e.CommandArgument);
Session["EID"] = GridView1.DataKeys[index].Value.ToString();
txt_Emp.Text = GridView1.Rows[index].Cells[0].Text.Trim();
DDL_Gender.SelectedItem.Text = GridView1.Rows[index].Cells[1].Text.Trim();
txt_Email.Text = GridView1.Rows[index].Cells[2].Text.Trim();
txt_Uname.Text = GridView1.Rows[index].Cells[3].Text.Trim();
txt_Pwd.Text = GridView1.Rows[index].Cells[4].Text.Trim();
txt_Fname.Text = GridView1.Rows[index].Cells[5].Text.Trim();
txt_Mob.Text = GridView1.Rows[index].Cells[6].Text.Trim();
DDL_Address.SelectedItem.Text = GridView1.Rows[index].Cells[7].Text.Trim();
Btn_Save.Text = "Update";
grid();
}
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
}
Using Linq the values are inserted successfully, but values are not updated...
Kindly intimate me where i did the mistake in the above code....