使用Linq成功插入值，但GridView中的值不会更新... [英] Using Linq the values are inserted successfully, but values are not updated in GridView...
问题描述
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-";
}
使用以下代码，
当我们给出输入时，数据在Gridview中成功插入。
但是GridView中的值未成功更新。
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();
}
使用上面的代码，不会更新Gridview中的数据
这是我的GridView。 ..
这是我的.aspx页面...
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....
Using Linq the values are inserted successfully, but values are not updated...
Kindly intimate me where i did the mistake in the above code....
推荐答案
Hai U did mistake
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.SelectedI tem.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();
}
\"regg\" record that u want update ,but u r updating Table object , Change Regg to regg it will work
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();
}
Hai U did mistake
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();
}
"regg" record that u want update ,but u r updating Table object , Change Regg to regg it will work
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();
}
protected void GridView1_RowCommand(obje ct 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();
Bt n_Save.Text = \"Update\";
grid();
}
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
}
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)
{
}
protected void Btn_Save_Click(object sender, EventArgs e)
{
DataClassesDataContext ss = new DataClassesDataContext();
{
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();
}
protected void Btn_Save_Click(object sender, EventArgs e)
{
DataClassesDataContext ss = new DataClassesDataContext();
{
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();
}
This is my linq updation code... .
Updation is not done by using the above piece of code...
How to solve...
Thank you in Advance...
This is my linq updation code....
Updation is not done by using the above piece of code...
How to solve...
Thank you in Advance...
这篇关于使用Linq成功插入值，但GridView中的值不会更新...的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
