Update database from gridview

[newguy]

I have a GridView that gets its data from a Microsoft SQL database.

The Person table inside of my database has a few columns
ID, Name ,Surname, Age, Address and Status

The GridView only has 2 columns that get populated 'Name' and 'Status' from my Person table in the database.
The Status can either be 'Active' or 'Inactive'.

Then an additional update column was added to my grid view.
My gridView columns look like the following

<telerik:GridBoundColumn DataField="Name" HeaderText="First Name"
meta:resourcekey="GridBoundColumnResource1" UniqueName="fName" Resizable="False" />

<telerik:GridBoundColumn DataField="Status" HeaderText="Status"
meta:resourcekey="GridBoundColumnResource2" UniqueName="currentStatus" Resizable="False" />

<telerik:GridTemplateColumn UniqueName="TemplateUpdateColumn">
<ItemTemplate>
<asp:LinkButton ID="Update" runat="server" AutoPostBack="true" " Text="Update" ><img src="../icons/update.ico"/></asp:LinkButton>
</ItemTemplate>
</telerik:GridTemplateColumn>

Each row that gets added into my GridView it will also have an update button.

All that i need to happen is that when i click on the update button for that specific item in the GridView the corrasponding item in my database my be set from active to Inactive.

i am using C# asp.net and linq.

[Princy]

hi,

Please try the following code snippet i tried.

C#:

protected void Update_Click(object sender, EventArgs e)
{
    LinkButton btn = (LinkButton)sender;
    GridDataItem ditem = (GridDataItem)btn.NamingContainer;
    if (ditem["currentStatus"].Text == "Active")
    {
        //Update in dataBase
        RadGrid1.Rebind();
    }
}

Thanks,
Princy.

[newguy]

I'm sorry i got completely wrong, in my GridView i have the following columns 'Name' and 'Surname' the Status Column doesn't get shown.

How would i access the ID of a specific person now ?
I cannot use the Name+surname text values of the the items populates on the gridview.

ditem["currentStatus"].Text == "Active"

is there any other way to find out what the current ID for that specific record is in the gridView so i can update the database accordingly

[newguy]

Cant something like this be done

protected void Grid1_ItemCreated(object sender, GridItemEventArgs e)
{
         if (e.Item is GridDataItem)
          {
                   LinkButton UpdateButton = (LinkButton)e.Item.FindControl("Update");
                   UpdateButton .Attributes["href"] = "#";
                   UpdateButton .Attributes["onclick"] =  ??????????
          }
}

[Princy]

Hi,

I am not sure about your requirement . I guess you can set the ID as the DatakeyName in RadGrid and access the DataKeyValue in Update button key as follows.

ASPX:

<MasterTableView CommandItemDisplay="Top" DataKeyNames="ID">

C#:

protected void Update_Click(object sender, EventArgs e)
{
    LinkButton btn = (LinkButton)sender;
    GridDataItem ditem = (GridDataItem)btn.NamingContainer;
    if (ditem["currentStatus"].Text == "Active")
    {
        string datakey = ditem.GetDataKeyValue("ID").ToString();
        //Update in dataBase
        RadGrid1.Rebind();
    }
}

Please elaborate your scenario if it doesn't help.

Thanks,
Princy.