Setting Parameters

[Guest]

When setting parameters, I get the error:

System.IndexOutOfRangeException: Invalid index -1

With Me.MySqlCommand1
.Parameters("@FileName").Value = sFileName
.ExecuteNonQuery()
End With


The insert statement is:

INSERT INTO management (FileName) VALUES (@FileName)

Any ideas what's gone wrong?

 

[Quentin Personeni]

Hi,

You must create the parameter before setting its value, declaring the
parameter in the SQL query doesn't make it available in the Parameters
collection.

In C# this is somthing like this (I'm not familiar with VB.net) :

SqlParameter param=new SqlParameter("@FileName",SqlDbType.String);
Param.Value = sFileName;
MySqlCommand1.Parameters.Add(param);
MySqlCommand1.ExecuteNonQuery();

Hope this will help you.

Kant


Le 7/08/05 13:07, dans (e-mail address removed),