Devart Forums

Alexey

Any kind of commands combining in Oracle is impossible. You can use either PL/SQL blocks or execute command with DML array parameters. For more information read the documentation for Oracle server and OraDirect .NET.
If you still have questions concerning OraDirect .NET, specify your question.

Alexey

Yes. MySQLDirect .NET Data Provider can be used in the same way as the SQL Server .NET or the OLE DB .NET Data Provider.

Alexey

MySql Developer Tools 1.70 beta is available from the registered user page on our site. We do not have problems downloading it. As for the problem with 2 buttons, it has been already fixed. Look forward to next release.

Alexey

Please specify the version you installed. And standard or professional?

Alexey

Hopefully, in the middle of the week

Alexey

Hi.
The problem is that you create parameters collection twice. Moreover, when you assign any value to a parameter use their names without colon (":"). E.g.:

Code: Select all

MySqlInsertCommand1.Parameters("state_id").Value = TextBox1.Text

Or you can do it by the number of the parameter in the collection. The following statements are equal:

Code: Select all

MySqlInsertCommand1.Parameters("state_id").Value = TextBox1.Text
MySqlInsertCommand1.Parameters(0).Value = TextBox1.Text

(Don't forget that parameters collection is zero-based)

Take a look at your code corrected accordingly to preceding notices:

Code: Select all

        Me.MySqlInsertCommand1.CommandText = "INSERT INTO state(state_id, state_descrioption) VALUES (:state_id, :state_descrioption)"
        Me.mySqlInsertCommand1.Connection = Me.MySqlConnection1
        Me.mySqlInsertCommand1.Name = "mySqlInsertCommand1"
        Me.mySqlInsertCommand1.Parameters.Add(New CoreLab.MySql.MySqlParameter("state_id", CoreLab.MySql.MySqlType.VarChar, 2, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, ""))
        Me.mySqlInsertCommand1.Parameters.Add(New CoreLab.MySql.MySqlParameter("state_descrioption", CoreLab.MySql.MySqlType.VarChar, 2, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, ""))
        Me.mySqlInsertCommand1.UpdatedRowSource = System.Data.UpdateRowSource.None
        MySqlInsertCommand1.Parameters("state_id").Value = TextBox1.Text
        MySqlInsertCommand1.Parameters("state_descrioption").Value = TextBox2.Text

        Try
            MySqlConnection1.Open()
            mySqlInsertCommand1.ExecuteNonQuery()
            MySqlConnection1.Close()
        Catch myerror As CoreLab.MySql.MySqlException
            MsgBox("There was an error creating record: " & myerror.Message)
        End Try

Good luck

Alexey

Hi.
Actually, Bit is supported as well. Have a look:

Code: Select all

      cmd.Parameters.Add("IdType", MySqlType.Int);
      cmd.Parameters["IdType"].Direction = ParameterDirection.Input;
      cmd.Parameters["IdType"].Value = comp.IdType;

      cmd.Parameters.Add("Name", MySqlType.VarChar);
      cmd.Parameters["Name"].Direction = ParameterDirection.Input;
      cmd.Parameters["Name"].Value = comp.Name;

      cmd.Parameters.Add("State", MySqlType.Bit);
      cmd.Parameters["State"].Direction = ParameterDirection.Input;
      cmd.Parameters["State"].Value = comp.State; 

      cmd.CommandText = "INSERT into Components (Type_id, Name, State) VALUES (:IdType, :Name, :State)";

Good luck

Alexey

We have fixed this problem for the MySQLDirect .NET.
Look forward to the next build.

Alexey

In Visual Studio you can do that as simple as in Delphi. Just drop DataGrid component onto the form, create DataSource using the wizard accessible form Properties window and you are done.
For more information take a look at our Samples

Alexey

MySqlDirect 3.20 doesn't support DataSource component (so you cannot perform same steps on 3.20).
We are going to make new release with the bug addressed this week.

Alexey

We have reproduced the problem. Now we are investigating it.
To solve the problem right now perform the following steps:
1. Go to the UpdateQuery property of the SqlDataSource component by clicking "..." in Properties window.
2. In "Command and Parameter Editor" click on "Show advanced properties" link.
3. Choose any column from the "Parameters:" listbox by simply clicking on it and in "Properties:" listbox correct its type to actual.
As you can see, the problem is that the type by default is "Object".

Alexey

Use Ping() method of the MySqlConnection component to determine whether connection to MySQL server is valid.

Search found 2757 matches