Why stored procedure not working by button

Aktham Mahmoud

6y752.NET

Greeting

I created a button, when an Admin click on it call stored procedure to do this step:

===> Modify Column value [Bit] from true to False when a records came old than 30 days.

What happen?

when I click on button a page refresh, but a rows in table not modfiy ( change column value)

Button code:

protected void SChJ_Click(object sender, EventArgs e)
{
string connectionString = @"Data Source=(local)\SQLEXPRESS;AttachDbFilename=|DataDirectory|\land.mdf;Integrated Security=True";
using (SqlConnection sqlcon = new SqlConnection(connectionString))
{
try
{
sqlcon.Open();
SqlCommand sqlcmd = new SqlCommand("get_expir_job_date", sqlcon);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@C_date", SqlDbType.DateTime);
sqlcmd.Parameters.AddWithValue("@JEnable", SqlDbType.Bit);
sqlcmd.ExecuteNonQuery();
sqlcon.Close();
}
catch (Exception ex)
{
JobFaUp.Text = ex.ToString();
}
}
}

Stored Procedure Code

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Aktham Mahmoud6y ago
Thanks to all for your ensthusiasm in answering.
To Mr.
Jignesh Kumar
Actually, I recorrect my code depends on your notes (I removed [@] sign.
And to Mr.
Nisha Regil and Mr.
Darshan Shah
I re-embed a button in Details View [Footer Template] and every thing going well now.

Thanks
Jignesh Kumar6y ago
Hi,

I think your update store procedure you are setting your parameter to 'False'. You need to set your table fieldname='Fales'
CREATE PROCEDURE [dbo].[get_expir_job_date]
    @C_date datetime,  //Create Date
    @JEnable bit  //JOb Status Enable or Disable
AS
BEGIN
SELECT * FROM [Jobs]
Update [Jobs] SET job_tatus='False'
WHERE
@C_date  >  DATEADD(DAY, +30, CURRENT_TIMESTAMP)
End
Darshan Shah6y ago
You may need to rebind the table on page refresh.
Nisha Regil6y ago
Please check that the procedure modifies your db table data as per your requirement.If yes, then after the logic of modifying the data you will have to write the logic of binding the UI table again with the server side code.Normally a button click event always does a post back.