LNHS Alumni Batch 04 Shirt Design

Here you go guys...

I made this simple design for us. It can be printed on a white shirt or as what you can see... Co'z I'm tired of paying for a high price and not getting what i want(selfish :p). I will print this and wear it on our upcoming alumni. Weeeeee more power to Lamitan National High School (L.N.H.S).

Some Codes that might comes in handy

I want to share some of the codes i used for my Database migration tool. Here's some codes that you might need for your are creating a simple application.


Try
                    Dim di As DirectoryInfo = New DirectoryInfo("C:\tmpCLSWOBR")
                    di.Create()
                    System.IO.File.Copy(TextBox5.Text, "C:\tmpCLSWOBR\dbs_import.sql", True)
                    Dim csqlFile As New StreamWriter("C:\tmpCLSWOBR" & "\" & TextBox4.Text & ".sql")
                    csqlFile.WriteLine("drop database if exists " & TextBox4.Text & ";")
                    csqlFile.WriteLine("create database " & TextBox4.Text & ";")
                    csqlFile.WriteLine("use " & TextBox4.Text & ";")
                    csqlFile.Close()
                    Dim TextFile As New StreamWriter("C:\tmpCLSWOBR\create.bat")
                    TextFile.WriteLine("""C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql.exe"" -h " & TextBox1.Text & " -u " & TextBox2.Text & " --password=" & TextBox3.Text & " < C:\tmpCLSWOBR\" & TextBox4.Text & ".sql""")
                    TextFile.WriteLine("""C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql.exe"" -h " & TextBox1.Text & " -u " & TextBox2.Text & " --password=" & TextBox3.Text & " " & TextBox4.Text & " < C:\tmpCLSWOBR\dbs_import.sql""")
                    TextFile.Close()
                    Process.Start("C:\tmpCLSWOBR\create.bat")
                    MsgBox("SUCCESSFUL!")
Catch ex As Exception
                    MsgBox(ex.Message)
End Try

 Dim di As DirectoryInfo = New DirectoryInfo("C:\tmpCLSWOBR")

 di.Create()

- This line of code will create a folder named tmpCLSWOBR in drive C:

Dim TextFile As New StreamWriter("C:\tmpCLSWOBR\create.bat")
- This line of code is to create a .bat file. For some purposes...:)

TextFile.WriteLine("You Text in Here")
- This will be the line of input(text) that your going to insert in your .bat file
- To add newline in your .bat file you can just add the code above...(in short 2 codes 2 lines of text)...

Database Tools

I updated some of the code in my application called "database migration tool for MySQL 5.1". I have changed some code structure to be able to add new features such as:

- allowing to switch MySQL versions (currently on 5.1)

- view progress on the application (current is just a message box)

Created using vs.net 2010 (visual basic code). This simple application simply allows you to migrate your .sql database into a new one. I know that there is such tool existed but i wanted to try and create one that i can easily use.

Using some file manipulation code like creating a bat file on runtime for MySQL command and folder creation.

I'll be posting some of the codes soon! :)


You can download the Installer(demo) here.

This is my blog...

I kept on changing designs (templates) of my blog that fits me. But i guess i have to customize some of it. I hope i can find some tutorials on how to and hopefully its not that complicated. Wazzza! wish me luck!