Connecting to mySQL database from ASP.Net (vb)

Question

HI, I am a fairly experienced ASP developer making the move to ASP.net.

I am trying to open a database connection to a MySQL database but I am finding it overly complicated and not at all user friendly.

Is there no way to open a database connection, get a recordset and Move, Insert, and Delete on the fly? Is there no .AddNew, .MoveNext or .Update functionality?

At the moment I am using the MySQLDataAdapter to fill a Dataset but I can't see how to update changes back to the Table.

Do I really have to construct INSERT and UPDATE sqlCommands and execute them?

Any example code (in VB) would be gratefully received.

Ta01 · Accepted Answer · 2010-01-20 16:07:04Z

3

As you are transitioning from classic ASP, I would recommend getting familiar with ADO.NET basics, this article on MSDN will answer a lot of your questions. This article in particular will help a lot. I know it might seem like a wall of text, but coming from classic asp and Recordsets, etc, these links will prove beneficial.

answered Jan 20, 2010 at 16:07

Ta01

31.7k13 gold badges74 silver badges100 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Yeodave · Accepted Answer · 2010-01-21 14:47:26Z

3

After reading some very dull MSDN Articles I managed to do it.

    Dim dbConnection As New MySqlConnection("server=xxx; user id=xxx; password=xxx; database=xxx; pooling=false;")
    Dim dbDataAdapter As New MySqlDataAdapter("SELECT * FROM table", dbConnection)
    Dim dbDataSet As DataSet = New DataSet
    dbDataAdapter.Fill(dbDataSet, "table")

    Dim dbNewRow As DataRow = dbDataSet.Tables("table").NewRow
    dbNewRow("data1") = "Some Data"
    dbNewRow("data2") = "Some More Data"
    dbNewRow("data3") = "Even More Data"

    dbDataSet.Tables("table").Rows.Add(dbNewRow)

    dbDataAdapter.InsertCommand = New MySqlCommand("INSERT into table(data1, data2, data3) VALUES (@data1, @data2, @data3)", dbConnection)
    dbDataAdapter.InsertCommand.Parameters.Add("data1", MySqlDbType.VarChar, 25, "data1")
    dbDataAdapter.InsertCommand.Parameters.Add("data2", MySqlDbType.VarChar, 25, "data2")
    dbDataAdapter.InsertCommand.Parameters.Add("data3", MySqlDbType.VarChar, 25, "data3")

    dbDataAdapter.Update(dbDataSet, "table")

Thanks to everyone for their help.

answered Jan 21, 2010 at 14:47

Yeodave

9881 gold badge8 silver badges15 bronze badges

1 Comment

Yeodave Over a year ago

It won't let me accept my own answer for 24hours but thanks for the reminder.

George Johnston · Accepted Answer · 2010-01-20 16:03:36Z

1

You need to download the mySQL adapter. It functions very similar to how the .NET MSSQL adapter functions.

mySQL .NET Adapter

answered Jan 20, 2010 at 16:03

George Johnston

32.3k29 gold badges130 silver badges177 bronze badges

Comments

yojimbo87 · Accepted Answer · 2010-01-20 16:06:42Z

1

If you want simplicity (and abstract layer) then you can use ADO.NET Entity framework with MySQL .Net connector.

answered Jan 20, 2010 at 16:06

yojimbo87

68.8k26 gold badges128 silver badges133 bronze badges

Comments

ram · Accepted Answer · 2010-01-20 16:00:33Z

-1

Though not a full answer( sorry I do not know VB, but bet there are a lot of articles around and some one here might point you to the right one ), you might want to have a handy reference to connectionstrings.

answered Jan 20, 2010 at 16:00

ram

11.7k16 gold badges68 silver badges89 bronze badges

Collectives™ on Stack Overflow

Connecting to mySQL database from ASP.Net (vb)

5 Answers 5

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related