Tagged Questions

1
vote
0answers
265 views

Visual Studio 2015 : SQL Data Source : Unable to retrieve schema. Ensure that the ConnectionString and SelectCommand properties are valid

I have the following development environment for ASP.Net WebPage VS 2015 Professional Version, using .Net Framework 4.0 MySQL Server 5.6, MySQL .Net Connector 6.9.5 MySQL for Visual Studio 2.0.2 ...
1
vote
1answer
21 views

SQL Show most current record for each task by date

I want to show the most recently updated record for each task. Currently I am only getting the most recent of all records no matter what task. Here is the front end code <asp:SqlDataSource ID="...
0
votes
0answers
25 views

Can't solve - C# SQL checking two tables and updating one

I'm trying to update a Modules table, when the user selects a course they're brought to a modules page, then they search for lecturer and select him/her. So I know it updates my table, (because I ...
0
votes
0answers
444 views

Can't use PreparedStatement with DataSource type connection

I don't quite seem to get the PreparedStatement work when I use a DataSource type connection while inserting values in a table. I tried type-casting: PreparedStatement preparedStatement = (...
0
votes
1answer
28 views

C#, In a Mysql connection proprety connection.Server and connection.DataSource are always equals or there is a case where are different?

In my program I can see these proprietes are always equals, can be different in some exceptional case?
0
votes
2answers
1k views

ASP.NET How to display sqldatasource row in a div?

I'm trying to display a row of data in a div rather than in a table if possible. So I want to control each of the td elements in a row, but without the table involved, so foreach row I'd put the ...
0
votes
1answer
86 views

How to get the DeleteParameter value in to the Code behind?

I have a ListView that enables deleting, I also use SQLDatasource as DataSource of the ListView, I have these 2 tables: News table that contains news_id, title, etc.. and Feedback table that ...
0
votes
2answers
1k views

I can not add MySql Data Provider to Visual Studio 2012

I want to create an .edmx file to my .net project. My database is MySql. As you can see the picture below, there is no MySql provider however I give the refference about MySql. I install ...
0
votes
1answer
604 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
745 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 i'm ...
0
votes
0answers
200 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 ...
0
votes
1answer
1k 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
412 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
3k 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 "...
1
vote
2answers
3k 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 ...