Dataset Query

Posted on 2012-09-07
Last Modified: 2012-09-22

I'm using and the dataset designer to get data from a mysql database.

In the dataset designer, I've added a query to the datatable, I'd like to know if I can programmatically change the sql query that's stored in this datatable at run time.

Currently to get the data I'm using :

            cliTableAdapter2 = New simplyDataSetTableAdapters.DataTable2TableAdapter
            cliDataSet2 = New simplyDataSet
            Return cliDataSet2

        Catch ex As Exception
            Throw ex
        End Try

Open in new window

I've tried using a wildcard in the SQL statement to use a parameter at run time but it gives me the following error : No mapping exists from dbType Object to a known OdbcType.

I'd like to know If I can change that sql string at runtime to something else.

Thank you
Question by:FCapo
    LVL 96

    Expert Comment

    by:Bob Learned
    I don't understand what you are looking for, and what that exception means...

    How would you like to change the SQL string?

    Accepted Solution

    Thank you but I found an alternative to doing this, sorry for wasted time

    Author Closing Comment

    The question wasn't well formulated and I found a solution through different means!

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    Article by: jpaulino
    XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should.  An XML Literal is like a String ( Literal, only instead of starting and ending with w…
    Article by: Kraeven
    Introduction Remote Share is a simple remote sharing tool, enabling you to see, add and remove remote or local shares. The application is written in VB.NET targeting the .NET framework 2.0. The source code and the compiled programs have been in…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now