In my code shows error message like,
Error:
MySql.Data.MySqlClient.MySqlException (0x80004005): Column 'contactno' cannot be null
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force) at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader() at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at registration.Button1_Click(Object sender, EventArgs e) in c:\Users\elcot\Documents\Visual Studio 2010\WebSites\studentstafff\sfs\admin\registration.aspx.cs:line 86
and c# code for insert
protected void Button1_Click(object sender, EventArgs e)
{
        if (temp == 0)
        {
            try
            {
                //Guid newGUID = Guid.NewGuid();
                MySqlConnection conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString);
                conn.Open();
                string insertquery = "INSERT INTO students(name,email,password,course_id,contactno,doj,designation) VALUES(@username,@email,@password,@course,@mobileno,@dateofjoining,@designation)";
                MySqlCommand com = new MySqlCommand(insertquery, conn);
                //com.Parameters.AddWithValue("@ID", newGUID.ToString());
                com.Parameters.AddWithValue("@username", username.Text);
                com.Parameters.AddWithValue("@email", email.Text);
                com.Parameters.AddWithValue("@password", CreateMD5(password.Text));
                //com.Parameters.AddWithValue("@confirmpassword", Confirm Password.Text);
                com.Parameters.AddWithValue("@course", DropDownListcourse.SelectedItem.Value);
                com.Parameters.AddWithValue("@mobileno ", mobileno.Text);
                com.Parameters.AddWithValue("@dateofjoining", dateofjoining.Text);
                com.Parameters.AddWithValue("@designation", DropDownListDesignation.SelectedItem.Value);
                //execute 
                com.ExecuteNonQuery();
                //redirect to otherpage 
                //Response.Redirect("~/admin/admin.aspx");
                //some message
                Response.Write("Registration Successful");
                conn.Close();
                //Response.Write(" You registration is sucessfully completed!!!");
            }
            catch (Exception ex)
            {
                Response.Write("Error:" + ex.ToString());
            }
        }
    }
what is the problem in this code?
User contributions licensed under CC BY-SA 3.0