Hello,
When running any sql commands we get an error message. When we run the webform locally connected to the remote sql database that hosts our web apps the webform runs great. You can try running this page using this link and clicking on submit or clear to see the message.(http://srftcdtata.com/quotes/wfquotebasic.aspx)
Thank you,
Andrew
Ticket
Q316232
Visible to All Users
Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.
Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.
Hello,
Wanted parphrase my previous message.
When running any sql commands in a webform (WFQuoteBasic.aspx) with an aspxgrid we get an error message after calling DataBind(). When we run this webform locally connected to the remote sql database that hosts our web apps the webform runs great. You can try running this page using this link and clicking on submit or clear to see the message.(http://srftcdtata.com/quotes/wfquotebasic.aspx)
Thanks,
Andrew
Hi Andrew,
I see the problem on that page, but this information does not allow me to precisely detect its cause. However, we were told about these problems in the past (http://search.devexpress.com/?q=%22ArrayConverter+cannot+convert+from%22&p=T4|P5|57). Please try to set the ASPxGridView.EnableRowsCache property to "false", and let me know if this helps.
Regards,
Serge
P.S. You may be interested to read the following blog post to learn more about this property:
How To Cache Rows In DevExpress ASP.NET GridView
Hi Serge,
That fixed it! You guys are the best!
Just curious…will turning this off affect perfomance in that its a cacheing setting.
Best,
Andrew
Hi Andrew,
Thank you for informing us that the problem is resolved. We are glad that our assistance was helpful.
If you need any further help on this subject, please feel free to reactivate this ticket.
About your question: Switching the option off may affect performance if you work with a slow DB connection, because this scenario will require ASPxGridView to always reload data. Your can use a sort of profiling tool to check for possible bottlenecks.
Thanks,
Serge