I am using the following code and SQL Profiler shows no activity when I step
through the .update line. Do you see a syntax error?
Thanks!

using (SqlConnection cn = new SqlConnection(cnStr))
{
SqlCommand updCmd = new SqlCommand
("sp_web_edit_manager_update", cn);

SqlDataAdapter adpt = new SqlDataAdapter(updCmd);

updCmd.UpdatedRowSource = UpdateRowSource.None;
updCmd.Parameters.Add("@entity", SqlDbType.VarChar,10,
dtOnlyChanges.Columns[0].ColumnName);
updCmd.Parameters.Add("@edit_id", SqlDbType.Int, 4,
dtOnlyChanges.Columns[1].ColumnName);
updCmd.Parameters.Add("@edit_override", SqlDbType.VarChar, 1,
dtOnlyChanges.Columns[2].ToString());
updCmd.Parameters.Add("@biller_cd", SqlDbType.VarChar, 20,
dtOnlyChanges.Columns[3].ToString());
updCmd.Parameters.Add("@include_in_stats", SqlDbType.VarChar,
1, dtOnlyChanges.Columns[4].ToString());

adpt.UpdateCommand = updCmd;

// Set the Batch Size. 0 means all; default is 1.
adpt.UpdateBatchSize = 10;

// Send the new rows and the changed rows to the database
adpt.Update(dtOnlyChanges);

}

--
Message posted via http://www.dotnetmonster.com

probably no changed (rowstate == modified) rows in the dataset to update.

-- bruce (sqlwork.com)

"andy6" <u9025@uwe> wrote in message news:61cf9e8450e76@uwe...
>I am using the following code and SQL Profiler shows no activity when I
>step
> through the .update line. Do you see a syntax error?
> Thanks!
>
> using (SqlConnection cn = new SqlConnection(cnStr))
> {
> SqlCommand updCmd = new SqlCommand
> ("sp_web_edit_manager_update", cn);
>
> SqlDataAdapter adpt = new SqlDataAdapter(updCmd);
>
> updCmd.UpdatedRowSource = UpdateRowSource.None;
> updCmd.Parameters.Add("@entity", SqlDbType.VarChar,10,
> dtOnlyChanges.Columns[0].ColumnName);
> updCmd.Parameters.Add("@edit_id", SqlDbType.Int, 4,
> dtOnlyChanges.Columns[1].ColumnName);
> updCmd.Parameters.Add("@edit_override", SqlDbType.VarChar,
> 1,
> dtOnlyChanges.Columns[2].ToString());
> updCmd.Parameters.Add("@biller_cd", SqlDbType.VarChar, 20,
> dtOnlyChanges.Columns[3].ToString());
> updCmd.Parameters.Add("@include_in_stats",
> SqlDbType.VarChar,
> 1, dtOnlyChanges.Columns[4].ToString());
>
> adpt.UpdateCommand = updCmd;
>
> // Set the Batch Size. 0 means all; default is 1.
> adpt.UpdateBatchSize = 10;
>
> // Send the new rows and the changed rows to the database
> adpt.Update(dtOnlyChanges);
>
> }
>
> --
> Message posted via http://www.dotnetmonster.com

Good catch! Thank you.

I ended up with this code.

using (SqlConnection cn = new SqlConnection(DBConnectionString))
{
using (SqlCommand updCmd = new SqlCommand
("sp_web_edit_manager_update", cn))
{
SqlDataAdapter adpt = new SqlDataAdapter(updCmd);
updCmd.CommandType = CommandType.StoredProcedure;
updCmd.CommandTimeout = Convert.ToInt32
(ConfigurationSettings.AppSettings["dbCommandTimeout"]);

updCmd.UpdatedRowSource = UpdateRowSource.None;
updCmd.Parameters.Add("@entity", SqlDbType.VarChar, 10,
dtOnlyChanges.Columns[0].ColumnName);
updCmd.Parameters.Add("@edit_id", SqlDbType.Int, 4,
dtOnlyChanges.Columns[1].ColumnName);
updCmd.Parameters.Add("@edit_override", SqlDbType.VarChar,
1, dtOnlyChanges.Columns[2].ToString());
updCmd.Parameters.Add("@biller_cd", SqlDbType.VarChar, 20,
dtOnlyChanges.Columns[3].ToString());
updCmd.Parameters.Add("@include_in_stats", SqlDbType.
VarChar, 1, dtOnlyChanges.Columns[4].ToString());

adpt.UpdateCommand = updCmd;

// Set the Batch Size. 0 means all; default is 1.
adpt.UpdateBatchSize = 0;

foreach(DataRow b in dtOnlyChanges.Rows)
{
b.SetModified();
}

cn.Open();

// send the changed rows("modified") to the database
adpt.Update(dtOnlyChanges);
}
}

--
Message posted via http://www.dotnetmonster.com