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
