protected void btnsave_Click(object sender, EventArgs e)
{
try
{
using (SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
using (SqlCommand cmm = new SqlCommand())
{
cmm.Connection = cnn;
cmm.CommandType = CommandType.Text;
if (btnsave.Text == "Save")
{
cmm.CommandText = "INSERT INTO register_user([name],[email],[email_pass],[panel_pass],[dept])" + "VALUES(@name,@email,@email_pass,@panel_pass,@dept)";
cmm.Parameters.AddWithValue("@name", txtname.Text.Trim().ToString());
cmm.Parameters.AddWithValue("@email", txtemail.Text.Trim().ToString());
cmm.Parameters.AddWithValue("@email_pass", txtemailpass.Text.Trim().ToString());
cmm.Parameters.AddWithValue("@panel_pass", txtpass.Text.Trim().ToString());
cmm.Parameters.AddWithValue("@dept", ddldept.Text.Trim().ToString());
}
else
{
cmm.CommandText = "UPDATE [register_user] SET name=@name,email=@email,email_pass=@email_pass,panel_pass=@panel_pass,dept=@dept where id=" + ViewState["id"];
cmm.Parameters.AddWithValue("@name", txtname.Text.Trim().ToString());
cmm.Parameters.AddWithValue("@email", txtemail.Text.Trim().ToString());
cmm.Parameters.AddWithValue("@email_pass", txtemailpass.Text.Trim().ToString());
cmm.Parameters.AddWithValue("@panel_pass", txtpass.Text.Trim().ToString());
cmm.Parameters.AddWithValue("@dept", ddldept.Text.Trim().ToString());
}
cmm.Connection.Open();
cmm.ExecuteNonQuery();
cmm.Connection.Close();
ScriptManager.RegisterStartupScript(this, GetType(), "Success", "alert('Information Save Successfully.');", true);
gvbind();
clear();
}
}
catch (Exception ex)
{
Response.Redirect(ex.Message);
}
}
I am getting this error when my file is on server ,in localhost my code work fine. Please provide me solution for this