Renaming a Column of a Table in a Dataset+Sourabh.

[Dot Net Jantu]

Hi All, I have a Dataset, in which there is a table and in that table i want to rename a column.. how? dsSave.Tables["FA_ASSET_DEP"].Columns["BASE_AMT"]; dsSave is Dataset. FA_ASSET_DEP is table BASE_AMT is the column to be converted to DEP_AMT ?????? HELP

Thanks and Regards,

[Imran Khan Pathan]

You can convert column name in your query string. for example

"select BASE_AMT as DEP_AMT from FA_ASSET_DEP"

bEst rEgard pAthAn

please don't forget to vote on the post that helped you.

[Dot Net Jantu]

Hi, This is also a good way if you dont want to change your column name while retrieving. dsSave.Tables["FA_ASSET_DEP"].Columns["BASE_AMT"].ColumnName = "DEP_AMT" I have got this with intense research and development...:laugh:

Thanks and Regards,

[Imran Khan Pathan]

good job

please don't forget to vote on the post that helped you.