JAVA Programing, MySQL, Database, java swing, java printer, ASP.NET, C#.NET, Android, GPhone, iphone, blackberry
Saturday, November 10, 2007
Monday, October 8, 2007
Thai language on MySQL with C# .NET
If you want to INSERT, UPDATE, SELECT in thai language on ODBC connection with MySQL, you should set CHAR SET = utf8 or any more (on MySQL). But you must set Character Set = tif620 (on Connector/ODBC of MySQL). After that you should set Initial Statement = SET NAMES 'tis620'. According, you can execute any command with thai language.
Sunday, October 7, 2007
C#.NET connect with MySQL
1. Download and install the latest .NET Framework SDK.
2. Install Microsoft Data Access Components (MDAC) 2.6 or later. MDAC 2.8 is the latest and is recommended.
3. Install the ODBC.NET Provider. Note that this step is only necessary if you are building applications using .NET 1.0. The ODBC provider comes standard with .NET 1.1. S;q319243.
4. Install MySQL Server. For more information on how to install and setup the MySQL Server, refer to the Installation chapter of the MySQL Reference Manual.
5. Now install MySQL ODBC Driver-MyODBC 3.51; and for installation instructions, refer to the Installation section of the Connector/ODBC documentation.
6. Setup an MyODBC DSN to be used for connecting to MySQL by following the instructions in the "DSN on Windows" section of the Connector/ODBC documentation.
http://dev.mysql.com/tech-resources/articles/dotnet/
For example source code to connect MySQL on C#
using System.Data.Odbc;
OdbcConnection MyConnection = new OdbcConnection("DSN=MyDNSName");
MyConnection.Open();
// If you want to customize your new DNS use this example code
string MyConString = "DRIVER={MySQL ODBC 3.51 Driver};" + "SERVER=localhost;" + "DATABASE=test;" + "UID=venu;" + "PASSWORD=venu;" + "OPTION=3";
OdbcConnection MyConnection = new OdbcConnection(MyConString);
MyConnection.Open();
link http://dev.mysql.com/tech-resources/articles/dotnet/
simple example query link
http://www.easysoft.com/developer/languages/csharp/ado-net-odbc.html#example
2. Install Microsoft Data Access Components (MDAC) 2.6 or later. MDAC 2.8 is the latest and is recommended.
3. Install the ODBC.NET Provider. Note that this step is only necessary if you are building applications using .NET 1.0. The ODBC provider comes standard with .NET 1.1. S;q319243.
4. Install MySQL Server. For more information on how to install and setup the MySQL Server, refer to the Installation chapter of the MySQL Reference Manual.
5. Now install MySQL ODBC Driver-MyODBC 3.51; and for installation instructions, refer to the Installation section of the Connector/ODBC documentation.
6. Setup an MyODBC DSN to be used for connecting to MySQL by following the instructions in the "DSN on Windows" section of the Connector/ODBC documentation.
http://dev.mysql.com/tech-resources/articles/dotnet/
For example source code to connect MySQL on C#
using System.Data.Odbc;
OdbcConnection MyConnection = new OdbcConnection("DSN=MyDNSName");
MyConnection.Open();
// If you want to customize your new DNS use this example code
string MyConString = "DRIVER={MySQL ODBC 3.51 Driver};" + "SERVER=localhost;" + "DATABASE=test;" + "UID=venu;" + "PASSWORD=venu;" + "OPTION=3";
OdbcConnection MyConnection = new OdbcConnection(MyConString);
MyConnection.Open();
link http://dev.mysql.com/tech-resources/articles/dotnet/
simple example query link
http://www.easysoft.com/developer/languages/csharp/ado-net-odbc.html#example
Wednesday, September 12, 2007
Getting Start Struts2.0 vs NetBeans
Make WebApplication on Netbeans with struts2.0 follow this link It will show the tutorial
http://essentialtechjunks.blogspot.com/2007/01/first-struts-20-application-with.html
http://essentialtechjunks.blogspot.com/2007/01/first-struts-20-application-with.html
Wednesday, September 5, 2007
Using TemplateFields in the GridView Control
n Visual Studio 2005(ASP, C#), I build my website and I want to add FormView to GridView, I can find the answer in http://msdn2.microsoft.com/en-us/library/bb288032.aspx.
If you understand in this tutorial you can add every component to GridView and bind data to its.
If you understand in this tutorial you can add every component to GridView and bind data to its.
Thursday, August 30, 2007
Text to Postscript in JAVA
Refference from http://www.java2s.com/Code/Java/2D-Graphics-GUI/TexttoPostscript.htm
this is an example code that write in JAVA to canvert from string to PostScript format.
this is an example code that write in JAVA to canvert from string to PostScript format.
Monday, August 27, 2007
How to create mutiple site on IIS (Windows XP & 2000)
On windows XP you can create only one site in one server(IIS), but you can do this
http://www.xoc.net/works/tips/multiple-iis-sites-professional.asp
http://www.xoc.net/works/tips/multiple-iis-sites-professional.asp
Subscribe to:
Posts (Atom)