getting the probelm with updating the database

[preeti13]

i have a two tables employeenominations and reason if someone storing a data first time it will store into the employeenominations table if name is already exist it will store into the reason table and i an dispaly the data by my month the probelm i sthat if i try to update the data from auguest month its updating the same employee who is nominated in next month as well because the person has a same id now i am trying to get the date into the url so it can pick the person for updating by date but it is not passing the date what should i do please help me .my code is look like this.

private void cmdbutton_Click(object sender, System.EventArgs e)
        {
 
          //
            HtmlInputHidden objHid;
            HtmlInputHidden objHidden; 
            HtmlInputRadioButton rdoButton; 
            DataGridItem item; 
            for (int counter = 0; counter <= this.gvEmployee.Items.Count - 1; counter++) 
            { 
                item = gvEmployee.Items[counter]; 
                rdoButton = ((HtmlInputRadioButton)(item.FindControl("rdoEmployeeNominationID"))); 
                objHidden = ((HtmlInputHidden)(item.FindControl("hidEmployeeNominationID"))); 
               objHid = ((HtmlInputHidden)(item.FindControl("hidDatecreated"))); 
                if (!(rdoButton == null & !(objHidden == null)& !(objHid==null))) 
                { 
//                    if (rdoButton.Checked == true) 
//                    { 
//                        Response.Write(objHidden.Value); 
//                        Response.Write("This is the Employee Of the Month");
//                        return; 
 
                    if (rdoButton.Checked == true) 
                    { 
                        //this.lblMassage .Text="This is Employee of the Month";
 
                        string date=objHid.Value ;
                        string employee=objHidden.Value;
                        string datecreated;
                        datecreated=Request.QueryString["datecreated"];
 
 
                        SqlConnection oConn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["oConn"]); 
 
                        SqlCommand objCmd = new SqlCommand("up_updateEmployeeNominations",oConn);
                        objCmd.CommandType = CommandType.StoredProcedure;
                        objCmd.Parameters.Add(new SqlParameter("@EmployeeNominationID",employee));
                        objCmd.Parameters.Add(new SqlParameter("@datecreated",datecreated));
                            oConn.Open();
                        objCmd.ExecuteNonQuery();
                        oConn.Close();
 
 
                    this.lblMassage.Text="This is Employee of the Month";
                    }
 
        }
 
 
    } 
} 
 

And the store procedure is like this:

CREATE  PROCEDURE [dbo].[up_updateEmployeeNominations]
(
 
 @EmployeeNominationID int
@datecreated varchar(50)
)
as
 
update EmployeeNominations
set  EmployeeSelected='1'
from employeenominations,reason
where
   dbo.employeenominations. EmployeeNominationID=@EmployeeNominationID and  datepart (m,dbo.reason.datecreated)=@datecreated
GO