Text box

[George]

On my form one of the fields gets automatically filled in
by getting its value from a combo Box. Is there a way to
send that field's value to the Table that created the form.
Thanks - George

[Rick Brandt]

"George" <gwilliamsiii@hotmail.com> wrote in message
news:038e01c35235$7a746aa0$a501280a@phx.gbl...

> On my form one of the fields gets automatically filled in
> by getting its value from a combo Box. Is there a way to
> send that field's value to the Table that created the form.
> Thanks - George

Instead of a ControlSource like. . .

[ComboBoxName].Column(n)

Use a ControlSource that is the name of the field in the table you want to store
the value in. Then in the AfterUpdate event of the ComboBox have code similar
to. . .

Me![ControlName] = Me![ComboBoxName].Column(n)

[anonymous]

I have the following dataset I am trying to dynamically
generate text boxes
based on a dataset results.
How do I do this?
Dim myReader As DataSet = SqlHelper.ExecuteDataset
(ConfigurationSettings.AppSettings("DBConnInfo"),
CommandType.StoredProcedure, "Details", storedParams)

[Scott Mitchell [MVP]]

anonymous wrote:

> I have the following dataset I am trying to dynamically
> generate text boxes
> based on a dataset results.
> How do I do this?
> Dim myReader As DataSet = SqlHelper.ExecuteDataset
> (ConfigurationSettings.AppSettings("DBConnInfo"),
> CommandType.StoredProcedure, "Details", storedParams)

Could you clarify your question a bit? Are you wanting to display this
data in a DataGrid, where a certain column (or columns) in the DataGrid
are displayed as TextBoxes with the data from their respective DataSet
columns as the Text of the TextBoxes?

???


--

Scott Mitchell
[email]mitchell@4guysfromrolla.com[/email]
[url]http://www.4GuysFromRolla.com[/url]
[url]http://www.ASPFAQs.com[/url]
[url]http://www.ASPMessageboard.com[/url]

* When you think ASP, think 4GuysFromRolla.com!

[anonymous]

I wanted to dispay the data in text boxes, not in a grid.
The text boxed I would like dynamicly created based on a
results from dataset.

[Scott Mitchell [MVP]]

anonymous wrote:

> I wanted to dispay the data in text boxes, not in a grid.
> The text boxed I would like dynamicly created based on a
> results from dataset.

Consider using the Repeater control, as it does not place the contents
in a grid, but in whatever HTML markup / Web Controls you specify. It
might look something like:

<asp:Repeater runat="server">
<ItemTemplate>
<asp:TextBox runat="server" Text='<%#
DataBinder.Eval(Container.DataItem, "SomeDBField") %>' /><br />
</ItemTemplate>
</asp:Repeater>

For more on the differences between the DataGrid, DataList, and Repeater
controls, check out my article:

Deciding When to Use the DataGrid, DataList or Repeater
[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnaspp/html/aspnet-whenusedatawebcontrols.asp[/url]

Happy Programming!

--

Scott Mitchell
[email]mitchell@4guysfromrolla.com[/email]
[url]http://www.4GuysFromRolla.com[/url]
[url]http://www.ASPFAQs.com[/url]
[url]http://www.ASPMessageboard.com[/url]

* When you think ASP, think 4GuysFromRolla.com!