Repeating tables and views

sshines — Tue, 23 Jun 2009 13:47:46 GMT

Thank you so much for getting back to me. I really need some help with this. I am having a problem with my main data connection - not my secondary data connection. I have three tables in my main data connection Table1, Table2 and Table 3. Table 3 is a repeating tables.

Here are the steps that I am taking and my code:

On my first view I am querying a username field by clicking a button. Here is the code behind my button:

Public Sub QueryEmployee_Clicked(ByVal sender As Object, ByVal e As ClickedEventArgs)

Dim myNav As XPathNavigator = Me.MainDataSource.CreateNavigator()

Dim SelectedEmployee As String

Dim myADOConnection As AdoQueryConnection = DirectCast(Me.DataConnections("MainConnect"), AdoQueryConnection)

Dim LoggedinUser As String

SelectedEmployee = myNav.SelectSingleNode(

"/dfs:myFields/dfs:queryFields/q:Employee/@UserName", Me.NamespaceManager).ToString

If SelectedEmployee = "" Then

MessageBox.Show(

"Please enter a Username for searching.")

Exit Sub

End If

Select Case Me.UserRole

Case "General"

LoggedinUser = System.Environment.UserName

If LoggedinUser <> SelectedEmployee Then

MessageBox.Show(

"You can only search for your own contact information. Please enter YOUR username.")

myNav.SelectSingleNode(

"/dfs:myFields/dfs:queryFields/q:Employee/@UserName", Me.NamespaceManager).SetValue("")

Exit Sub

End If

End Select

myADOConnection.Command =

"select EmpID, PrefFirstName, PrefMidName, PrefLastName, OfficeID, CellPhone, UserName from Employee where Employee.UserName = " + "'" + SelectedEmployee.ToString + "'"

myADOConnection.Execute()

End Sub

After this query runs and I am now looking at the second view and my repeating table is collapsed. There is no data in it and there shouldn't be yet, but I want the table expanded so you users can easily see that this information needs to be filled in. The Default Values are there - what am I missing?

Repeating tables and Views

sshines — Tue, 23 Jun 2009 13:38:22 GMT

I really need some help with this. I am having a problem with my main data connection - not my secondary data connection. I have three tables in my main data connection Table1, Table2 and Table 3. Table 3 is a repeating tables.

Here are the steps that I am taking and my code:

On my first view I am querying a username field by clicking a button. Here is the code behind my button:

Public Sub QueryEmployee_Clicked(ByVal sender As Object, ByVal e As ClickedEventArgs)

Dim myNav As XPathNavigator = Me.MainDataSource.CreateNavigator()

Dim SelectedEmployee As String

Dim myADOConnection As AdoQueryConnection = DirectCast(Me.DataConnections("MainConnect"), AdoQueryConnection)

Dim LoggedinUser As String

SelectedEmployee = myNav.SelectSingleNode(

"/dfs:myFields/dfs:queryFields/q:Employee/@UserName", Me.NamespaceManager).ToString

If SelectedEmployee = "" Then

MessageBox.Show(

"Please enter a Username for searching.")

Exit Sub

End If

Select Case Me.UserRole

Case "General"

LoggedinUser = System.Environment.UserName

If LoggedinUser <> SelectedEmployee Then

MessageBox.Show(

"You can only search for your own contact information. Please enter YOUR username.")

myNav.SelectSingleNode(

"/dfs:myFields/dfs:queryFields/q:Employee/@UserName", Me.NamespaceManager).SetValue("")

Exit Sub

End If

End Select

myADOConnection.Command =

"select EmpID, PrefFirstName, PrefMidName, PrefLastName, OfficeID, CellPhone, UserName from Employee where Employee.UserName = " + "'" + SelectedEmployee.ToString + "'"

myADOConnection.Execute()