RadGrid, DataTable And Caption Problem

[KlimUser]

Well my problem is the next buddies
I have a GridView, well Actually a RagGrid From telerik control
I get the data executing a StoreProcedure and storing in a Datatable
the I just use the next code

DataTable dtListValues = null; //this is my DataTable where i'm going to store the Data
dtListValues = LoValues.oListValues(Values.PKValue); //this is the method to get the Data, that returns a DataTable
this.rgValues.DataSource = dtListValues; //Choosing  a DataSource for the RadGrid
this.rgValues.DataBind(); //binding!! hehehe!  ;P

and then the page ends with this

NameColumns     PKValue  NameValue  isActive

but!! I don't want to use this names!!  :sigh:
And to "fix" this I try to use this

dtListValues.Columns[0].Caption = "Code";
dtListValues.Columns[1].Caption = "Name";
dtListValues.Columns[2].Caption = "Active";

I already used this code after and before executing the DataBind
But!!!! It doesn't work!!! =(
Could someone Tell Me where I'm wrong :( ?
I hope you can help me please
thanks in advanced
Greetings!!!

[Shinu]

Hi,

Try setting the HeaderText for the GridColumns in the ItemDataBound event using the ColumnUniqueName property.

CS:

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
    {
        if (e.Item is GridHeaderItem)
        {
            GridHeaderItem header = (GridHeaderItem)e.Item;
            string strtxt = header["columnUniqueName"].Text.ToString();
            if (strtxt == "PKValue  ")
            {
                header["columnUniqueName"].Text = "Code";
            }

        }
   }

Thanks
Shinu.

[KlimUser]

Hey Shinu!!
too Many Many many Thx!!!!
Your Help waas great!!
Rigth now The RadGrid Use the names I Want in Execution Time!!
too Much Tnks
And an apologize to answer until now but I was developing the rest of the pages and i left to the last this "issue" =)
Very Thankfully!!!
Greetings From Mexico!!!

[Shinu]

Hi Friend,

I hope you will interested to go through the following help articles.

Accessing cells and rows
Using columns

Shinu.

[KlimUser]

Thnks again Shinu!
I was reading the help =$ I think I should reading more berofe post =$

Now I'm even more thankful. =)
Gretings!!!