How to Assign a data column value to specific word uisng C#
<p>I have a field in my table in which I would like to set a string  like “COMPLETE”.   Initially the field is empty  and I want to set it some kind of text like “COMPLETE”  Here is what I have so far…</p>

<pre><code>   string ID = GV_Action.Rows[0].Cells[1].Text;

    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString);

    SqlCommand cmd = new SqlCommand("sp_Update", con);
    cmd.CommandType = CommandType.StoredProcedure;

    cmd.Parameters.Add("@ID", SqlDbType.VarChar).Value = ID;

    cmd.Connection = con;
    con.Open();
    cmd.ExecuteNonQuery();
    con.Close();
</code></pre>

<p>in my Strored procedure below i am using a default ID but would like to pass the paramter ID  and not use the fixed value how can i do that?
here is how i created the proc
CREATE PROC sp_Update</p>

<p>AS</p>

<p>EXEC msdb.dbo.sp_start_job N'UpdateField';</p>

<p>GO</p>

<p>EXEC sp_Update</p>

<p>and here is job that i am calling when the procedure kicks off
update MyTable</p>

<p>set Status = 'Complete'
  where Post_ID = 303</p>
