Bug #48142 Could not change SQL command text within VB.NET with Connector.NET

• Submitted: 19 Oct 2009 9:02
• Modified: 19 Oct 2009 9:58
• Reporter: Doron Yaary
• Status: Not a Bug
• Category: Connector / NET
• Severity: S1 (Critical)
• Version: MySQL 5.0
• OS: Windows (Vista Ultimate SP1)
• CPU Architecture: Any
• Tags: Connector.NET VB.NET

[19 Oct 2009 9:02] Doron Yaary

Description:
Hello.
I am running a MySQL 5.0 Installed on an Ubuntu JeOS Server. I have another computer running Windows Vista SP1 and I`m developing programs using Visual Studio 2008 (VB.NET). Now, I have installed the Connector/NET and I can create datasources and relate fields to a standart visual studio report. Thats all right and well but if my SQL command text changes dynamically ? For example, I would like to change the command text (SQL) for a specific table in my datasource so I could only print my client`s invoice number '400' (for example). How do I do that using VB.NET ? With out knowing how to do that... My application could not work. However, it workd pretty much fine with MS-SQL and I realy (but I mean REALY) don`t want to rely on MS-SQL.

How to repeat:
I am hoping that you could give me the answer for this.

[19 Oct 2009 9:58] Tonci Grgin

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.

Explanation: Hi Doron and thanks for your question. Alas, the name of the place is BugsDB and I see no test case attached nor do I see any reference to a bug in your post. Please try above suggestions.