Tagged Questions

1
vote
2answers
2k views

How to connect mysql to DevExpress ASPxScheduler without SqlDataSource

I have an ASP.net project I'm looking at and they want to use MySQL. I'm used to SQL server but using mySQL shouldn't be a problem. Normally the control would like a SqlDataSource to bind to but ...
0
votes
1answer
389 views

Syntax error using INNER JOIN and SqlDataSource with MySQL

I am trying to write an update command that joins 2 tables using an SqlDataSource. I have it working with 1 table, but when I put my INNER JOIN syntax in I get thrown an error. It says "My syntax is ...
0
votes
1answer
323 views

Missing parameter error after running MySql query

I'm completely new to MySql and haven't used SqlDataSource with UpdateParameters before, so I'm probably missing something very obvious. When trying to update a record, the update does happen but ...
0
votes
2answers
2k views

SqlDataSource set SelectCommand dynamicly

I'm using a SqlDataSource and to avoid writing long queries directly in my code I thought I could make a Query class that returns the query I want as a string. I tried the code below but I just get ...
0
votes
1answer
35 views

How to Update GridView by changing SelectCommand string in SqlDataSource

OK - I think this should be simple/basic but I looked through many posts with similar issues but it is still not clear how to do this. Basic setup is as follows - I have a TextBox called "product" ...
0
votes
0answers
55 views

Error only using JSTL (No suitable driver found for dataSource)

I'm using this code in Servlets to use the Database: Class.forName("com.mysql.jdbc.Driver"); DriverManager.getConnection("jdbc:mysql://localhost/petshop", user, password); And it works fine. Now ...
0
votes
0answers
110 views

ASP.NET Using MySQL

OK, I have been trying to write a fairly simple app for days! My background: I've been a programmer for 30 years, but when it comes to ASP.NET, all I have is a class I took years ago, and even though ...