I'm storing multilingual data in a database whose model is language normalized (like this).
For this particular problem
the key for
the table in question consists of a value entered by
the user and a language from
the language table. I'd like to dynamically generate a form with input fields for all available languages.
The user inputs a key value then goes down a list of field sets filling out
the information in each language. In this case there are two fields for every language, a name and a value (the value is language dependent.)
I have all existing information displayed on
the page with a gridview, below which I have a formview that is always in insert mode allowing
the user to enter new data.
Within the formview I have a repeater with an SQLDataSource that gets a list of available languages:
<asp:Repeater ID="SessionLocaleRepeater" runat="server"
DataSourceID="LocaleSQLDataSource"
EnableViewState="false">
<ItemTemplate>
<tr>
<th scope="row"><%# DataBinder.Eval(Container.DataItem, "LocaleName") %></th>
<td>Name:</td>
<td><asp:TextBox ID="TextBox1" runat="server" Text="" /></td>
<td>Number:</td>
<td><asp:TextBox ID="TextBox2" runat="server" Text="" /></td>
</tr>
</ItemTemplate>
</asp:Repeater>
I figured that in order to insert this data I'd have to execute my sql server insert stored procedure for each item in
the repeater; I am trying to use
the formview inserting event.
The problem is that
the repeater isn't databound to
the SQLDataSource until after
the formview inserting event (inserting event is in PostBackEvent and databind is in PreRender), which means
the controls and data are not available when
the inserting event is fired.
I tried databinding
the repeater during
the formview inserting event;
the controls were available but
the data was not. Would this have something to do with how/when
the viewstate information is re-added to
the controls? From what I've read, Viewstate is one of
the first things to be restored.
Given
the order of events how can I get
the data I need for
the insert?
I'm open to other solutions to creating dynamic input
controls, but they will have to query
the database to determine how many sets of
controls to create.
