Continuous Display or Data From DataTable

[jpskiller]

Hi,

I could do with some help pointers on this.

Using a for each on a data table which contains notes for the parent record, I would like to build a continuous display up.

I could use a grid but thats not really suitable.

I am currently using a Tab Control and this information will be under its own tab - chose to use this as it is scrollable

I need to display it in following fashion or similar



Lable = name of person

TextBox = Note

Buttons, Delete & Add New etc

and then adds same set of controls for each record below at runtime

help apprecated

[dday9]

I have a few questions for you:

1. How will you know which name and note to display when the form loads?
2. Are you populating the data into a DataTable from a database?
3. Are you just not comfortable with SQL commands or do you not know how to use them?

[jpskiller]

I have a few questions for you:

1. How will you know which name and note to display when the form loads?
2. Are you populating the data into a DataTable from a database?
3. Are you just not comfortable with SQL commands or do you not know how to use them?

Hi,



Should have said I'm using VB 2010 Windows Form

I am using table adapters:

I have no issues getting the data into the adapters using SQL I just wont to know if can do a kinda continous form to display the data.

ie as a DGV is not really suitable, I would like to add the controls, kinda like how a forum works.

i.e

Show note 1 details

--------------------

Show note 2 details

etc

[dday9]

OK, so I created a simple database. It contains 1 data table named Details and 3 columns:

1. ID - Primary Key - Auto-Generated Number
2. PersonName - Short Text
3. Note - Long Text

In the Data Sources window(shift+alt+d), I expanded the Details table, changed the Details table to show details rather than the DataGridView, changed the PersonName column to Label, and then drag/dropped the Details table onto the Form.

From there I deleted the following controls:

• The label that shows "ID" for the ID column
• The TextBox that gets/sets value for the ID column
• The label that shows "Person Name" for the PersonName column
• The label that shows "Note" for the Note column

I then docked the Label that gets the value for the PersonName column to Top and changed the AutoSize property to True. Next I docked the TextBox that gets/sets the value for the Note column to Fill and changed the Multiline property to True. I also had to right-click the TextBox and click on "bring to front" in order for the docking to act the way I wanted it to.

Not only does this give me the control layout that you want, but it also give me the BindingNavigator with add/delete/save buttons.

[TnTinMN]

From the your description in post #1, it sounds like you want the functionality of the Visual Basic Power Packs DataRepeater Control

VisualBasic PowerPack missing from Visual Studio 2013?

[jpskiller]

From the your description in post #1, it sounds like you want the functionality of the Visual Basic Power Packs DataRepeater Control

VisualBasic PowerPack missing from Visual Studio 2013?

Yes this is exactly what I was looking for.

dday9 thank you showing how I change layout of datasource before dragging

[jpskiller]

Next daft question

If I put on a button in the DataRepeater from the click event on the button how would I get the reference to the row I was on so I could then reference the data in textboxes etc.

[TnTinMN]

Next daft question

If I put on a button in the DataRepeater from the click event on the button how would I get the reference to the row I was on so I could then reference the data in textboxes etc.

I'll answer with more questions. Have you considered reading the documentation for the DataRepeater? If not, why not?

[jpskiller]

Thanks got it working now

I dragged my Datasource on to the DataRepeater and that works fine, so I added a button and in the button On Click Event I added

  Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
        Dim Product As String = DataRepeater1.CurrentItem.Controls("ProductNameTextBox").Text

        MessageBox.Show(Product)

    End Sub

[TnTinMN]

Thanks got it working now

Glad to know that you worked it out.