sqlUpdateCommand1

[CJ]

Here is the code and the error stops with the "executenonquery"

sqlUpdateCommand1.Parameters["@Id"].Value = Request.QueryString["id"];
sqlUpdateCommand1.Parameters["@filnavn"].Value = TextBox2.Text;
sqlUpdateCommand1.Connection.Open();
sqlUpdateCommand1.ExecuteNonQuery();
sqlUpdateCommand1.Connection.Close();

sqlDataAdapter1.Fill(dataSet11);
TextBox1.DataBind();

[CJ]

The problem is that a i only want to update one or two fields, not the hole
table.
I get an error message that tell me i must update the hole table.

"CJ" wrote:

Here is the code and the error stops with the "executenonquery"

sqlUpdateCommand1.Parameters["@Id"].Value = Request.QueryString["id"];
sqlUpdateCommand1.Parameters["@filnavn"].Value = TextBox2.Text;
sqlUpdateCommand1.Connection.Open();
sqlUpdateCommand1.ExecuteNonQuery();
sqlUpdateCommand1.Connection.Close();

sqlDataAdapter1.Fill(dataSet11);
TextBox2.DataBind();

[Brian Brown]

CJ,

To use the parameters you must specify a stored procedure for the command to
use or just explicitly write the update statement. For instance:

sqlUpdateCommand1.CommandText = "procnamegoeshere";
sqlUpdateCommand1..CommandType = CommandType.StoredProcedure;

OR

sqlUpdateCommand1.CommandText = "UPDATE TABLE1 SET Column1 = 'mytext'";
sqlUpdateCommand1..CommandType = CommandType.StoredProcedure;

I hope this helps.