dimanche 28 juin 2015

Error in Updating a Record

Hello Everyone I'm new in here. I am currently making an asp.net project monitoring module. At this moment I am in the process of editing the project form and adding resources to the selected task in a project.

I'm having a problem in saving the record. Everytime I save the record it says "Column name or number of supplied values does not match table definition."

In my ProjectTasks Table I have RefNo(PK), TaskID(FK), Name and Description

Name - refers to the Task Name

Description - refers to the Task Description

What I want to happen is that my Resource Tables TaskID(FK) will be updated when I clicked the save button. As of now when I add a Resource from a task the TaskID = 0.


protected void btnSave_Click(object sender, EventArgs e)
{
    con.Open();
    SqlCommand cmd = new SqlCommand();
    cmd.Connection = con;
    cmd.CommandText = "INSERT INTO ProjectTasks VALUES (@Name, @Description); " +
    "SELECT TOP 1 TaskID FROM ProjectTasks ORDER BY TaskID DESC;";
    cmd.Parameters.AddWithValue("@Name", txtName.Text);
    cmd.Parameters.AddWithValue("@Description", txtDescription.Text);
    int taskID = (int)cmd.ExecuteScalar();
    con.Close();

    con.Open();
    cmd.CommandText = @"UPDATE Resource_Materials SET TaskID=@TaskID WHERE TaskID=0; " +
                        "UPDATE Resource_Equipments SET TaskID=@TaskID WHERE TaskID=0; " +
                        "UPDATE Resource_Vehicles SET TaskID=@TaskID WHERE TaskID=0; " +
                        "UPDATE Resource_Contractors SET TaskID=@TaskID WHERE TaskID=0;";
    cmd.Parameters.AddWithValue("@TaskID", taskID);
    cmd.ExecuteNonQuery();
    con.Close();
    Helper.AddLog("1", "Add", "Assigned Resources to Task");
    Response.Redirect("~/Projects/Default.aspx");
}


Sorry about my grammar I'm just a student.

Aucun commentaire:

Enregistrer un commentaire