|
|
![](/forums/images/Darkness/misc/spacer.gif) |
![](/forums/images/Darkness/misc/spacer.gif) |
![](/forums/images/Darkness/misc/spacer.gif) |
![](/forums/images/Darkness/misc/q1.jpg) |
|
![](/forums/images/Darkness/misc/q1-1.jpg) |
![](/forums/images/Darkness/misc/q4.jpg) |
|
![](/forums/images/Darkness/misc/q4-1.jpg) |
![](/forums/images/Darkness/misc/a1.jpg) |
|
![](/forums/images/Darkness/misc/a1-1.jpg) |
|
Development::GeorgeS's Tools A forum just for GeorgeS's tools |
![Old](/forums/images/Darkness/statusicon/post_old.gif)
05-18-2007, 06:12 AM
|
Discordant
|
|
Join Date: Sep 2006
Location: Subsection 185.D354 C.12
Posts: 346
|
|
VB.NET Programmers
Are there any VB.Net Programmers on this board?
__________________
If at first you don't succeed destroy all evidence that you ever tried.
God doesn't give second chances... Hell, he sets you up the first time.
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
06-05-2007, 11:29 PM
|
Fire Beetle
|
|
Join Date: Dec 2006
Location: Cincinnati, OH
Posts: 4
|
|
*raises hand*
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
06-07-2007, 07:26 AM
|
![Amra's Avatar](image.php?s=48fd6c1b43d57dafaa4666607f850833&u=65025&dateline=1412918436) |
Hill Giant
|
|
Join Date: May 2006
Posts: 117
|
|
I just started using 2005. But as of now I don't know crap. ;p Any plans to release the source?
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
06-07-2007, 07:35 AM
|
Discordant
|
|
Join Date: Sep 2006
Location: Subsection 185.D354 C.12
Posts: 346
|
|
Something a little bit more advanced than that. Wanna join an open source team?
__________________
If at first you don't succeed destroy all evidence that you ever tried.
God doesn't give second chances... Hell, he sets you up the first time.
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
05-25-2008, 08:53 PM
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,475
|
|
Just to bring this old thread to current - I just installed the free version of vb.net 08 and am trying it out now. I will do some benchmarks and see how much better it is for what I do. Right now I'mm trying to figure out how you do mysql programing and how do you access the DB? (with a dll?)
GeorgeS
![Very Happy](http://www.eqemulator.net/forums/images/smilies/icon_biggrin.gif)
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
05-25-2008, 09:41 PM
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,475
|
|
Just tried the 08 version and the syntax to write and read text files is entirely different, and very hard. Is this something that's different in 08 over the 05 version? Can't believe it's that different. Might as well start learning VC++
GeorgeS
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
06-16-2008, 03:39 PM
|
Sarnak
|
|
Join Date: May 2008
Location: Midwest
Posts: 72
|
|
Quote:
Originally Posted by GeorgeS
Just tried the 08 version and the syntax to write and read text files is entirely different, and very hard. Is this something that's different in 08 over the 05 version? Can't believe it's that different. Might as well start learning VC++
GeorgeS
|
George, congratulations on picking up .Net!
Coming from VB you'll have a bit of a learning curve, but once you're past that you'll be good. MSFT has plenty of stuff out there to get you up to speed coming from VB.
As a side note, if you really don't want to leave VB6, isn't MSFT continuing support for the foreseeable future?
Good luck either way!
|
![](/forums/images/Darkness/misc/a4.gif) |
|
![](/forums/images/Darkness/misc/a6.gif) |
![Old](/forums/images/Darkness/statusicon/post_old.gif)
06-16-2008, 08:00 PM
|
I built it I will Support it!
|
|
Join Date: Jun 2005
Location: Michigan
Posts: 214
|
|
Quote:
Originally Posted by GeorgeS
Just tried the 08 version and the syntax to write and read text files is entirely different, and very hard. Is this something that's different in 08 over the 05 version? Can't believe it's that different. Might as well start learning VC++
GeorgeS
|
Reading and writing files is not that hard and is done the same way in 08 as 05.
Writing to a simple text file is as easy as:
Code:
Dim oWriter As StreamWriter
oWriter = File.AppendText(Filename)
oWriter.WriteLine(Message)
oWriter.Close()
You will need to add:
to you the top of your file if it is not already there as well.
As for accessing MySql you will need to download the MySql.Net connector from http://www.mysql.com
This connector functions exactly like any ADO.Net connector so any tutorial on ADO.Net will give you how it works, you just need to change the varaible types to the appropriate MySql connector types such as:
MySqlDataReader
MySqlDataAdapter
as opposed to:
SqlDataReader
SqlDataAdapter
DataTables and DataSets are all the same whether you use MySql or any other DB.
|
![](/forums/images/Darkness/misc/a1.gif) |
|
![](/forums/images/Darkness/misc/a3.gif) |
![Old](/forums/images/Darkness/statusicon/post_old.gif)
06-19-2008, 10:26 PM
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,475
|
|
I am using the 05 version since there are still non-depreciated commands. Over the next few weeks I'll dip deeper in the syntax, although in all honesty, I'm leaning towards C++
Does anyone have the mysql connection syntax (i.e an example)?
GeorgeS
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
06-19-2008, 11:15 PM
|
Dragon
|
|
Join Date: Feb 2007
Posts: 659
|
|
Quote:
Originally Posted by GeorgeS
I am using the 05 version since there are still non-depreciated commands. Over the next few weeks I'll dip deeper in the syntax, although in all honesty, I'm leaning towards C++
Does anyone have the mysql connection syntax (i.e an example)?
GeorgeS
|
Try here, George.
http://tangentsoft.net/mysql++/doc/html/refman
and
http://tangentsoft.net/mysql++/doc/h...man/index.html
might at least get you started...
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
06-20-2008, 06:20 AM
|
Banned
|
|
Join Date: Jun 2008
Location: planet earth
Posts: 137
|
|
Actually, I think c#.net would be a better choice for database apps, I have had great success with it in the past and it is far far easier to work with as well.
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
06-20-2008, 07:26 AM
|
I built it I will Support it!
|
|
Join Date: Jun 2005
Location: Michigan
Posts: 214
|
|
I would recommend C# as well.
As for an example of how to use the MySql.Net Connector:
I have one posted here using C#, if you would like something in VB.net I can convert it over; however, since they are both .Net the object structure and design is all the same only the syntax changes.
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
06-20-2008, 09:13 AM
|
Discordant
|
|
Join Date: Oct 2004
Location: In a house
Posts: 377
|
|
Hey GeorgeS,
Once you have MySQL Connector.Net 5.1.6 installed,
add a reference to it (MySQL.Data)
Code:
Imports MySql.Data.MySqlClient
Public Class MyClass
Private mydb As New MySqlConnection()
Private con_str As String = ""
Private reader As MySqlDataReader
Public Sub New()
con_str = "server=SERVER_IP;Port=3306;user id=root;password=PASSWORD_HERE;database=DATABASE_NAME;persist security info=True"
mydb.ConnectionString = con_str
mydb.Open()
Dim sql_cmd as String = "SELECT * FROM variables"
Dim cmd As New MySqlCommand(sql_cmd, mydb)
reader = cmd.ExecuteReader
While reader.Read
For i As Integer = 0 To reader.FieldCount - 1
debug.WriteLine(reader.Item(i).ToString)
Next
End While
reader.Close()
reader = Nothing
mydb.Close()
mydb.Dispose()
End Sub
End Class
Last edited by Kayot; 06-21-2008 at 04:32 AM..
Reason: Always use code brackets, its the polite way to post code XD
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
06-20-2008, 09:28 AM
|
Discordant
|
|
Join Date: Oct 2004
Location: In a house
Posts: 377
|
|
I have a transactional database interface class that i wrote, that if you're comfortable with array lists, then it'll probably be a big help.
|
![](/forums/images/Darkness/misc/a4.gif) |
|
![](/forums/images/Darkness/misc/a6.gif) |
![Old](/forums/images/Darkness/statusicon/post_old.gif)
06-20-2008, 08:42 PM
|
Discordant
|
|
Join Date: Sep 2006
Location: Subsection 185.D354 C.12
Posts: 346
|
|
I'm really happy that theres posting going on in my little corner of the Forum, but since it's in regard to GeargeS's tools; could all posts for GeargeS please be placed in GeargeS's section. I'm sure that would make his day.
Also, C#, J#, and VB.net are all the same engine. Anything done in one can be done in the others so long as there is a library for that particular syntax. Other wise the programmer would need to make a wrapper class which is a pain and why I only have three 3D engines available.
As for C++, enjoy Windows API and long compile times. I use VB.net because it's easy for me to read (Though I wish I could use C#/C++ comment methods, /* */ is cool for block comment.) and all the .net compile at a sickinly fast pace.
__________________
If at first you don't succeed destroy all evidence that you ever tried.
God doesn't give second chances... Hell, he sets you up the first time.
|
![](/forums/images/Darkness/misc/a1.gif) |
|
![](/forums/images/Darkness/misc/a3.gif) |
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 09:45 AM.
|
|
![](/forums/images/Darkness/misc/s1.jpg) |
|
![](/forums/images/Darkness/misc/s1-1.jpg) |
|
|
|
![](/forums/images/Darkness/misc/z1.jpg) |
|
![](/forums/images/Darkness/misc/z1-1.jpg) |
|
![](/forums/images/Darkness/misc/side3.jpg) |