2011. 11. 3. 09:21
Parameter Fields 사용시에는 {?name} 이다.
이것이 갑자기 생각 안나서..
기억력 감퇴..ㅡㅡ;;
'프로그래밍'에 해당되는 글 98건
- 2011.11.03 C# Crystal Report - Parameter Fields
- 2011.10.21 Creating Reports in C# - Part 2 of 2
- 2011.10.21 C#에서 MySql 연결 후 DataTableTableAdapter 문제
- 2011.10.21 Creating Reports in C# - Part 1 of 2
- 2011.10.21 Part 1 of 5: Adding data to SQL Server with C# and ADO.Net
Parameter Fields 사용시에는 {?name} 이다.
이것이 갑자기 생각 안나서..
기억력 감퇴..ㅡㅡ;;
2011. 10. 21. 08:33
출처: http://www.youtube.com/watch?v=nQvWNAldA1E&feature=related
2011. 10. 21. 08:22
We faced the same problem with VS 2005 typed datasets.
Error:
Generated SELECT statement.
Error in WHERE clause near '@'
Unable to parse query text
The problem is the syntax of the datasource used for query.
For SQL Server versions, you should use @parametername syntax to define a parameter.
However, for Access database, your should put ? for parameter definition.
Example;
SQL Server version:
SELECT *
FROM Projeler
WHERE (proje_id = @projectID)
Ms Access version and MySql:
SELECT *
FROM Projeler
WHERE (proje_id = ?)
출처: http://social.msdn.microsoft.com/forums/en-US/Vsexpressvb/thread/0c17511e-38a8-4040-b400-ac8eb103bd07/
2011. 10. 21. 08:05
Crystal Report 작성법..
mysql 연결하려면 ODBC 사용하면 됨..
mysql 연결하려면 ODBC 사용하면 됨..
mysql-connector-odbc-5.1.9-win32.msi
http://dev.mysql.com/downloads/connector/odbc/2011. 10. 21. 07:19
출처: http://www.youtube.com/watch?v=OJfYSZzZOP8&feature=related
