Hi i have a code runing into my local computer when i uplode to the server it is giving me an error asking parameter @datecreated but i am not using in the @datecretaed parameter in that update store procedure please help me with this here is my code:
[/CODE]
Code:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlTypes;
using System.Data.SqlClient;
using System.Text ;
namespace Employee_Nomination
{
/// <summary>
/// Summary description for Winner.
/// </summary>
public class Winner : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DropDownList drpMonth;
protected System.Web.UI.WebControls.DataGrid gvEmployee;
protected System.Web.UI.WebControls.Label lblMassage;
protected System.Web.UI.WebControls.RequiredFieldValidator Month;
protected System.Web.UI.WebControls.DropDownList drpYear;
protected System.Web.UI.WebControls.Button cmdbutton;
protected System.Web.UI.WebControls.Label lblMassage1;
private void Page_Load(object sender, System.EventArgs e)
{
//Put user code to initialize the page here
if(this.IsPostBack==false)
{
this.DisplayData();
}
else
this.DisplayChecked();
string EomNomid;
EomNomid = Request.QueryString["EomNomid"];
if((EomNomid != string.Empty) && (EomNomid != null))
{
SqlConnection oConn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["oConn"]);
SqlCommand objCmd = new SqlCommand("up_updatewinner",oConn);
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.Add(new SqlParameter("@EmployeeNominationID",EomNomid));
oConn.Open();
objCmd.ExecuteNonQuery();
oConn.Close();
this.lblMassage1.Text="You have successfully edit this winner";
}
}
void DisplayData()
{
}
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.drpMonth.SelectedIndexChanged += new System.EventHandler(this.drpMonth_SelectedIndexChanged);
this.drpYear.SelectedIndexChanged += new System.EventHandler(this.drpYear_SelectedIndexChanged);
this.cmdbutton.Click += new System.EventHandler(this.cmdbutton_Click);
this.Load += new System.EventHandler(this.Page_Load);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void DisplayChecked()
{
}
private void cmdbutton_Click(object sender, System.EventArgs e)
{
HtmlInputHidden objreason;
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")));
objreason=((HtmlInputHidden)(item.FindControl("hidreasonid")));
if (!(rdoButton == null & !(objHidden == null)&!(objreason==null)))
{
if (rdoButton.Checked == true)
{
string employee=objHidden.Value;
string reason=objreason.Value;
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("@reasonid",reason));
oConn.Open();
objCmd.ExecuteNonQuery();
oConn.Close();
this.lblMassage.Text="This is Employee of the Month";
}
}
}
}
public void drpMonth_SelectedIndexChanged(object sender, System.EventArgs e)
{
SqlConnection oConn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["oConn"]);
SqlDataAdapter da = new SqlDataAdapter("usp_employeenominations",oConn);
DataSet ds = new DataSet();
da.SelectCommand.CommandType = CommandType.StoredProcedure;
if (drpMonth.SelectedItem.Value.ToString ()!="")
{
da.SelectCommand.Parameters.Add(new SqlParameter("@Month",drpMonth.SelectedItem.Value));
}
if(drpYear.SelectedItem.Value.ToString ()!="")
{
da.SelectCommand.Parameters.Add(new SqlParameter("@Year", drpYear.SelectedItem.Value));
}
oConn.Open();
da.SelectCommand.ExecuteNonQuery();
oConn.Close();
da.Fill(ds);
this.gvEmployee.DataSource = ds;
this.DataBind();
da.Dispose();
}
private void drpYear_SelectedIndexChanged(object sender, System.EventArgs e)
{
SqlConnection oConn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["oConn"]);
SqlDataAdapter da = new SqlDataAdapter("up_Nominations",oConn);
DataSet ds = new DataSet();
da.SelectCommand.CommandType = CommandType.StoredProcedure;
if (drpYear.SelectedItem.Value.ToString () !="")
{
da.SelectCommand.Parameters.Add(new SqlParameter("@Year",drpYear.SelectedItem.Value));
}
if (drpMonth.SelectedItem.Value.ToString ()!="")
{
da.SelectCommand.Parameters.Add(new SqlParameter("@Month",drpMonth.SelectedItem.Value));
}
}
}
}
And the store procedur is
[CODE]
CREATE PROCEDURE [dbo].[up_updateEmployeeNominations]
(
@EmployeeNominationID int,
@reasonid int
)
as
update Reason -- EmployeeNominations
set EmployeeSelected='1'
from reason
where
reason.EmployeeNominationID=@EmployeeNominationID and reason.reasonid=@reasonid
GO
[/CODE]
Comment