changing data before sending to datagrid

geocodes · Apr 28, 2012

IS there a way to change the wording of some data before sending to the datagrid. What I mean is I have a database field called dept which has the shortname version of the dept. Ex. IT i want to change to Information Technology before displaying to the user. There is not much data showing (max 6 rec on a page). I am looking for the best way to accomplish this. MattIf I understand correctly, you have a database field named Ex.IT. You should be able to set the datagrid HeaderText property to Information Technology as follows: <ASP:BoundColumn HeaderText = "Information Technology" DataField = "Ex.IT" /> This would give you the heading you want but still bind the correct dataset column. Tom Thmm I was looking to change the individual items themselves but I do not think you can do that with a datagrid. The heading is going to be called Department. Mattif i understand your question, you would like to manipulate some data in 1 of your columns on each row.. maybe with select case or something.. I'm by no means an expert.. but to me, the easiest way would be to capture your dataset/recordset to an array, loop through the array making your changes.. then bind the array to your datagrid.. i'm sure there's a better way.. but to my < expert brain, that seems the easiest.. If what you want to do is change a value in your dataset before binding it to the datagrid, then you can: 1. Load the dataset and table from your database. 2. Loop through each item in the column you want to change using a for/next loop. If the item selected equals to the one you want to change (Ex.IT) then you can change it in the dataset before binding to the grid. If you DO NOT want these changes reflected back in you database don't do any updates. Here's a basic loop: For i = 0 to objDataSet.Tables("Scores").Rows.Count -1 intSearch = objDataSet.Tables("Scores").Rows(i)(0) If intSearch = "Ex.IT" then objDataSet.Tables("Scores").Rows(i)(0)= "IT Department" End If Next MyDataGrid.DataSource = ObjDataSet("Scores") MyDataGrid.DataBind() If you have multiple names you want to change in the column, then a Select Case statement could be used instead of the if/then. I hope this helps with what you're trying to do. Tom T

changing data before sending to datagrid

geocodes

New Member