Dynamic Update

[kliz0328]

I am trying to admin a database that has multiple profiles. What I want to do is on the page load list all of the Profiles, with textboxes containing their information. I then want to make any changes and update all of the profiels all at once. My only problem is that I do not know how to differentiate the textboxes for each profile so when I do my SQL update I call the correct textbox for the correct profile, I tried to put the <%#Container.DataItem("ProfileID")%> in the ID attribute, but I got an error. Any suggestions

 

[ca8msm]

You could load the details into a GridView and bind the data to it (then you just have to call the relevant Update command).


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[kliz0328]

would I be able to push 1 update button and update every profile all at once?

 

[ca8msm]

Yes, if the details are loaded into an object that allows that.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[kliz0328]

Well I have this so far but nothing will show up in my <EditItemTemplate> tag, the table cells are there but they are all empty. HOw do I get the text boxes to appear?

<asp:Datagrid
ID="Players"
HeaderStyle-Font-Name="Arial"
HeaderStyle-Font-Bold="True"
HeaderStyle-BackColor="AliceBlue"
ItemStyle-Font-Name="Arial"
ItemStyle-Font-Size="10pt"
AutoGenerateColumns="False"
AlternatingItemStyle-BackColor="Silver"
Runat="Server">
<Columns>
<asp:BoundColumn
	HeaderText="Name"
	DataField="FullName"
	ReadOnly="True" />
<asp:TemplateColumn>
<EditItemTemplate>
<asp:TextBox
ID="Hitting"
Text='<%#Container.DataItem("HittingDesc")%>'
Runat="Server"/>
</EditItemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:Datagrid>

 

[ca8msm]

Try following the example from:

http://www.developer.com/db/article.php/3314411

____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.