If anyone was considering helping, thanks anyway - found a way into the problem by looping through the dataset and doing the required work before binding the dataset to the table.
On Jan 27, 2:41 pm, Jon <[email protected]> wrote: > On Jan 27, 1:53 pm, Cerebrus <[email protected]> wrote: > > > Your question is profound... or maybe I should say profoundly unclear. > > Well, that's unfortunate... sorry for that. > > > > > You haven't told us what control binds to the database, for instance. > > Without that information, all answers would be guesses. You'll have to > > give us much more detail... show us some markup, for instance. > > Here's the datagrid control: > > <asp:DataGrid ID="IssueTable" runat="server" Width="100%" > AutoGenerateColumns="False" > OnDeleteCommand="IssueTable_DeleteCommand" > OnCancelCommand="IssueTable_CancelCommand" > OnEditCommand="IssueTable_EditCommand" > OnUpdateCommand="IssueTable_UpdateCommand" > AllowSorting="True" OnSortCommand="IssueTable_Sorting" > OnPageIndexChanged="IssueTable_PageIndexChanged"> > <Columns> > <asp:BoundColumn DataField="DescriptionShort" > HeaderText="Description" SortExpression="DescriptionShort" > > <HeaderStyle HorizontalAlign="Left"></HeaderStyle> > <ItemStyle HorizontalAlign="Left" Width="35%"></ > ItemStyle> > </asp:BoundColumn> > ..........and so on, to close it. > > in the codebehind: > public DataSet dsGetFilterData; > > protected void LoadData() > { > dsGetFilterData = DBGetDefects([a bunch of parameters]); > IssueTable.DataSource = dsGetFilterData;//drGetfilterData; > if (dsGetFilterData.Tables.Count > -1) > { > Session["IssuerTable"] = dsGetFilterData.Tables[0]; > } > IssueTable.DataBind(); > > } > > public DataSet DBGetDefects([parameters]) > { > > DataSet myDS = new DataSet(); > SqlDataAdapter temp = new SqlDataAdapter(); > SqlConnection conn = new SqlConnection(connectionString); > string sqlString = [a SELECT statement SQL string that > returns both "DescriptionShort" and "DescriptionLong"]; > temp.SelectCommand = new SqlCommand(sqlString, conn); > temp.Fill(myDS); > return myDS; > > } > > This works perfectly well, however inelegant the design may or may not > be. > > I just don't see a place where I can do what I need to do - where I > can step in and insert DescriptionLong (along with the reference to > the hide/show JavaScript) into the DescriptionShort bound column. (Or > do I have to do it after the table is already built?) > > Thanks for any help, Cerebrus or others... > > -Jon
