Using Linq the values are inserted successfully, but values are not updated in GridView...

Question

1.00/5 (3 votes)

See more:

SQL-Server-2008R2

C#

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.

C#

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...

ASP.NET

<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>

C#

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....

Posted 16-May-14 4:07am

M.Thiyagaraja

Updated 16-May-14 20:50pm

Herman<T>.Instance

v2

Add a Solution

Comments

[no name] 16-May-14 10:15am

Do you really think that people are going to read this?

joshrduncan2012 16-May-14 11:32am

1) Please format your code to where it's readable.
2) This is too large of a code dump for people to read.
3) What is your question?
4) Are you getting any errors, if so, what line is it pointing to?

Herman<T>.Instance 17-May-14 2:52am

If you need to show so much code to unnotice you forgot to not show the lines of code for method grid(); you cannot expect an answer. Better narrow your search on where you thought the grid should be reloaded and debug there why it didn't.

2 solutions

Solution 1

Quote:
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)
{

}

Quote:
Quote:
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...

Posted 16-May-14 21:36pm

M.Thiyagaraja

Comments

Sergey Alexandrovich Kryukov 12-Jun-14 15:55pm

Not an answer. Please stop posting fake "answers"; this is considered as abuse.
—SA

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Phanindra Baddula · Accepted Answer · 2014-05-19T20:54:00

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();

}