title: How to Update SQL in ASP.Net?
body: <p>I have an <code>UPDATE</code> SQL Server stored procedure <code>XemDiem_Upate</code>. Now if I only have 1 parameter like <code>@month_1</code>, how can I update using ASP.NET?</p>
  
  <pre><code>CREATE PROCEDURE XemDiem_Update
      (@month_1 NVARCHAR(MAX),
       @month_2 NVARCHAR(MAX),
       @month_3 NVARCHAR(MAX),
       @month_4 NVARCHAR(MAX),
       @month_5 NVARCHAR(MAX),
       @month_6 NVARCHAR(MAX),
       @month_7 NVARCHAR(MAX),
       @month_8 NVARCHAR(MAX),
       @month_9 NVARCHAR(MAX),
       @month_10 NVARCHAR(MAX),
       @month_11 NVARCHAR(MAX),
       @month_12 NVARCHAR(MAX),
       @user_id INT)
  AS
  BEGIN
      UPDATE XemDiem 
      SET month_1 = @month_1, month_2 = @month_2, 
          month_3 = @month_3, month_4 = @month_4, 
          month_5 = @month_5, month_6 = @month_6, 
          month_7 = @month_7, month_8 = @month_8, 
          month_9 = @month_9, month_10 = @month_10, 
          month_11 = @month_11, month_12 = @month_12 
      WHERE user_id = @user_id
  END
  </code></pre>