Why can't I use reference a TableAdaptor that I've created.

Question

Why can't I use reference a TableAdaptor that I've created.

Robert Barnes 101

I am trying to write a simple ASP.NET application to send out a newsletter, using data from a SQL Server database. To access the database I created a tableadaptor in object Group.xss. This .xss (data designer) window looks as I would expect. I have tested this table adaptor from this window. it is connected to the (remote) database and returns exactly the three records that it is supposed to in my initial test. I then returned to my ASP.NET page and tried to define the table adaptor with my usual template of defining the Table Adaptor, Table, and Row with statements like this

    Dim taGroupAdmin As New GroupTableAdaptors.GroupAdminsTableAdapter   '  Used for Test emails
    Dim tbGroupadmin As Group.GroupAdminsDataTable = Nothing
    Dim trGroupAdmin As Group.GroupAdminsRow

intending to use later code to fill the table and process its rows. However I can't get past the definition of taGroupAdmin. With the other two statements commented out leaving only Dim taGroupAdmin ... The Dim statement gives error: - GroupTableAdaptors.GroupAdminsTableAdapter' is not defined and there is also a message from Group.xss (line 1): - Custom tool error: The source was not found, but some or all event logs could not be searched. To create the source, you need permission to read all event logs to make sure that the new source name is unique. Inaccessible logs: Security This is on my own PC, for which I am the admin. I tried to find the answer from the internet, the examples talked of setting a registry key setting for "MyApp". Would my equivalent of MyApp be the name of my program ("Default"), the name of the .xss object ("Group"), or something else. I'm using Visual Studio 2019, and SQL Server 15.0.2000. Thank you, Robert Barnes

Robert Barnes 101 Reputation points

2023-04-07T05:19:58.7333333+00:00

Sorry about the crappy layout. What happened to the ability to review and end your post?
Erland Sommarskog 128.9K Reputation points MVP Volunteer Moderator

2023-04-07T21:30:50.2833333+00:00

Since the new version of the Q&A forums uses a WYSIWYG editor, we don't need any Review button. Or at least that is the theory.

But alas, there is some issue with the editor currently. If you slide the button View Markdown you will see that there are no blank lines between your intended paragraph breaks. They are needed for the paragrahs to display. Yeah, that is not a fantastic experience.
Bruce (SqlWork.com) 82,061 Reputation points Volunteer Moderator

2023-04-07T21:51:05.4966667+00:00

in markdown (the format used on this website). its 2 spaces and a line return to force a line break
jlinsey628 0 Reputation points

2023-04-08T03:11:37.73+00:00

You are trying to create an ASP.NET application to send out a newsletter, using data from a SQL Server database. You have created a table adapter in the object Group.xss to access the database. The table adapter is connected to the remote database and returns the expected records when tested from the Group.xss window. However, when you try to define the table adapter in your ASP.NET page using statements like "Dim taGroupAdmin As New GroupTableAdaptors.GroupAdminsTableAdapter", you get an error message that says "GroupTableAdaptors.GroupAdminsTableAdapter' is not defined." Additionally, you receive a message from Group.xss saying "Custom tool error: The source was not found, but some or all event logs could not be searched." You have searched for a solution online and found examples that talk about setting a registry key setting for "MyApp." You are unsure if your equivalent of "MyApp" should be the name of your program ("Default"), the name of the .xss object ("Group"), or something else. To solve this issue, you could try the following steps: nullnullnullnullnullnull

Regarding the registry key setting for "MyApp," this would typically refer to the name of your application, so in this case, it would be "Default" if that is the name of your ASP.NET application.

1 answer

Your answer

Robert Barnes 101 Reputation points

2023-04-07T05:19:58.7333333+00:00

Sorry about the crappy layout. What happened to the ability to review and end your post?
Erland Sommarskog 128.9K Reputation points MVP Volunteer Moderator

2023-04-07T21:30:50.2833333+00:00

Since the new version of the Q&A forums uses a WYSIWYG editor, we don't need any Review button. Or at least that is the theory.

But alas, there is some issue with the editor currently. If you slide the button View Markdown you will see that there are no blank lines between your intended paragraph breaks. They are needed for the paragrahs to display. Yeah, that is not a fantastic experience.
Bruce (SqlWork.com) 82,061 Reputation points Volunteer Moderator

2023-04-07T21:51:05.4966667+00:00

in markdown (the format used on this website). its 2 spaces and a line return to force a line break
jlinsey628 0 Reputation points

2023-04-08T03:11:37.73+00:00

You are trying to create an ASP.NET application to send out a newsletter, using data from a SQL Server database. You have created a table adapter in the object Group.xss to access the database. The table adapter is connected to the remote database and returns the expected records when tested from the Group.xss window. However, when you try to define the table adapter in your ASP.NET page using statements like "Dim taGroupAdmin As New GroupTableAdaptors.GroupAdminsTableAdapter", you get an error message that says "GroupTableAdaptors.GroupAdminsTableAdapter' is not defined." Additionally, you receive a message from Group.xss saying "Custom tool error: The source was not found, but some or all event logs could not be searched." You have searched for a solution online and found examples that talk about setting a registry key setting for "MyApp." You are unsure if your equivalent of "MyApp" should be the name of your program ("Default"), the name of the .xss object ("Group"), or something else. To solve this issue, you could try the following steps: nullnullnullnullnullnull

Regarding the registry key setting for "MyApp," this would typically refer to the name of your application, so in this case, it would be "Default" if that is the name of your ASP.NET application.

Answer 1

Lan Huang-MSFT 30,206 Microsoft External Staff

Hi @Robert Barnes, You need to initialize. You can refer to my code below, I did a simple test with gridview.

Dim a As Group = New Group()
        Dim taGroupAdmin As GroupTableAdapters.GroupAdminsTableAdapter = New GroupTableAdapters.GroupAdminsTableAdapter()
        Dim itemRow As Group.GroupAdminsRow = taGroupAdmin.GetData(0)

        Dim dt As DataTable = New DataTable()
        dt = taGroupAdmin.GetData()
        GridView1.DataSource = dt
        GridView1.DataBind()

User's image

Best regards,
Lan Huang

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Robert Barnes 101 Reputation points

2023-04-07T22:56:00.9266667+00:00
Lan, thank you for your response. But it seems to be a reply for a Windows Form project, not an ASP.NET project. I tried this with my project: I copied these statements from your example into mine: -

Dim a As Group = New Group() Dim taGroupAdmin As GroupTableAdapters.GroupAdminsTableAdapter = New GroupTableAdapters.GroupAdminsTableAdapter()

But this produced error messages.
BC30517 Overload resolution failed because no 'New' is accessible. BC30002 Type 'GroupTableAdapters.GroupAdminsTableAdapter' is not defined BC30002 Type 'GroupTableAdapters.GroupAdminsTableAdapter' is not defined. The first message applies to "Dim a ...", the other two to "Dim taGroupAdmin ...". If New is removed from the 1st Statement, the 1st message is changed to this, but there are no changes in the other expression. BC30109 'Group' is a class type and cannot be used as an expression. So I'm still stuck, unable to use tableadaptors.
Robert Barnes 101 Reputation points

2023-04-07T23:01:45.49+00:00

Sorry about the crappy layout again. I've only just received the comments above, next time I'll try with Space Space Newline and see if that helps.
Robert Barnes 101 Reputation points

2023-04-07T23:46:25.4733333+00:00

This seems to be helpful. I clicked on the red wavy line under the statements, clicked on "Show Potential Fixes", and it showed me this: -
![image](/api/attachments/e9f9437d-d17a-47a2-9fec-b2bb59a2fae2?platform=Qn A)

I clicked Preview Changes and applied them, and the problem disappeared, at least with this statement. Now I'll see if I can fixed the able and Row definitions, and get on with using them.
Robert Barnes 101 Reputation points

2023-04-08T02:05:03.3133333+00:00
Since the graphic doesn't seem to have worked, Show Potential Fixes showed
Adding 'GroupAdminsTableAtapters.vb; to 'FNewsLtr' with Content:

Namespace GroupTableAdapters Friend Class GroupAdminsTableAdapter Public Sub New() End Sub End Class End Namespace

Clicking Preview showed me the display copied below (I hope), that I think told me that [Apply] was going to generate class 'GroupAdminsTableAdapter" in a new file, containing the above namespace.

I clicked [Apply] and this display disappeared, however the error remained. I couldn't see any new objects added to my project (called FNewsLtr).
Lan Huang-MSFT 30,206 Reputation points Microsoft External Staff

2023-04-10T01:39:54.1433333+00:00

Hi @Robert Barnes, The project I tested is Asp.Net project - Asp.Net Webform. The code runs correctly in my project.What specific project are you using?

Share via

Why can't I use reference a TableAdaptor that I've created.

1 answer

Your answer