Radgrid - Need to pass columnID to update cell value

[Kaushik]

Hello team,

 I am working on a requirement in my application, where I have to save the values from the grid. The grid looks like below
      

Period	Amount	Column1	Column2	Column3	Column4
January	33,445.00	textbox	textbox	textbox	textbox
February	22,000.00	textbox	textbox	textbox	textbox
March	12,000.00	textbox	textbox	textbox	textbox
April		textbox	textbox	textbox	textbox

The dataset the gets binded to the grid would contain periodID,periodname,amount,column1ID,column1value,column2ID,column2value,column3ID,column3value...
. The periodID would be the datakey value for the grid and the columns from column1  to column4 would be input text boxes. I want to bind the columnID values to the grid columns( column1ID to column1 , column2ID to column2....
).The users will enter some value in columns say column1 and I want to save the value entered in textbox to the database table. But the parameters I need to save would be periodID,textbox input and columnID.

I have two questions here , 

1. Can I bind columnIDs to columns (here in particular when it is having textbox)
2. If the columnIDs can be binded to the grid, can those values be retrieved when the text change event in the grid is called to save data.

I hope I am clear on the explanation. Could you please help me in this.

Thanks,
Kaushik

[Kaushik]

Can you please help me in this. I am eagerly waiting for your reply

[Princy]

Hi,

I guess you want to bind a DataField to the Textboxes and get its value in ontextchanged event. Please take a look into the following code snippet.

ASPX:

<telerik:GridTemplateColumn UniqueName="Column1">
    <ItemTemplate>
        <asp:TextBox ID="txtColumn1" runat="server" Text='<%#Eval("column1ID")%>' AutoPostBack="true"
            OnTextChanged="txtColumn1_TextChanged"></asp:TextBox>
    </ItemTemplate>
</telerik:GridTemplateColumn>

C#:

protected void txtColumn1_TextChanged(object sender, EventArgs e)
{
    TextBox txt = (TextBox)sender;
    string value = txt.Text;
    //your code to update database
}

Thanks,
Princy.

[Kaushik]

Thank you very much for your reply.

 I want to bind the columnID value but not to the text value of the textbox. I want to keep the textboxes for user input. And on the text changed event I want to pass the rowID, textbox value provided by user as input and columnID (which I don't want to show on the grid)

[Princy]

Hi Kaushik,

You can set ColumnID as the DataKeyNames and access it in the TextChanged event using GetDataKeyValue. Please try the following code snippet.

ASPX:

<telerik:RadGrid ID="RadGrid1" runat="server">
    <MasterTableView DataKeyNames="ColumnID">
        <Columns>
            <telerik:GridTemplateColumn UniqueName="Column1">
                <ItemTemplate>
                    <asp:TextBox ID="txtColumn1" runat="server" AutoPostBack="true" OnTextChanged="txtColumn1_TextChanged"></asp:TextBox>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
        </Columns>
    </MasterTableView>
</telerik:RadGrid>

C#:

protected void txtColumn1_TextChanged(object sender, EventArgs e)
 {
   TextBox txt = (TextBox)sender;
   string value = txt.Text;
   GridDataItem data = (GridDataItem)txt.NamingContainer;
   string columnId = data.GetDataKeyValue("ColumnID").ToString();
   //your code to update database
 }

Thanks,
Princy