SQL && C# Help On A Button Click!!!

Hey Guys,

I'm not sure if anyone can help me with this but I am trying to achieve the following:

I have a row (In this case it is information on a fix) and on a button click I am trying to get it to "archive" it.  At the moment I have it so that it it takes the current information and adds it to the archive table adding an archive date.  The thing that I am struggling with is incrementing the version number. So, I need it to (in these steps I think) - Look for existance of the other entires of that ID, look for the version number that is related to the newest date of those knowledgeIDs and then add 1 to it.  If that knowledgeID doesnt exist then add it as one.

My current code is below:

Thanks in Advance =)

C# Codeprotected void Page_Load(object sender, EventArgs e)

{UserName = (string)Session["UserName"];

Label4.Text = UserName + " Is Current Logged In";UserType = (string)Session["UserType"];if ((Session["UserName"] != null) & (UserType == "Helpdesk"))

{Response.Redirect("Accessrights.aspx");

}else if (Session["UserName"] == null)

{Response.Redirect("Login.aspx");

}

FixName = "default";Description = "default";File = "default";

ADate = myCalendar.TodaysDate.ToShortDateString();

AddDate = Convert.ToDateTime(ADate);myConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=C:\inetpub\wwwroot\HOF\App_Data\HOF.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True;";

}protected void Button1_Click(object sender, EventArgs e)

{SqlConnection myConnection = new SqlConnection(myConnectionString);

try

{

FixName = TextBox1.Text;

 SqlCommand myCommand = new SqlCommand("select * from Knowledge WHERE FixName like '%" + FixName + "%'", myConnection);

myConnection.Open();SqlDataReader myReader = myCommand.ExecuteReader();if (myReader.HasRows)

{while (myReader.Read())

{

TextBox1.Text = myReader["FixName"].ToString();TextBox2.Text = myReader["Description"].ToString();

File = myReader["Location"].ToString();if (File != null)

{

TextBox3.Text = File;

}

else

{TextBox3.Text = "There is no script avaliable";

}KnowledgeID = myReader["KnowledgeID"].ToString();Add = myReader["DateAdded"].ToString();

}

myConnection.Close();

}

else

{TextBox1.Text = FixName + "Does not Exist. Please try again.";

}

}catch (Exception ex)

{

myConnection.Close();

}

try

Description = TextBox2.Text;File = Convert.ToString(FileUpload1.FileName);if (CheckBox1.Checked == true)

{SAPPS = "True";

}

else

{SAPPS = "False";

}

{SqlCommand mycommand2 = new SqlCommand("INSERT INTO Knowledge (FixName, Description, Location, DateAdded, DateArchived, Version, KnowledgeID) SET ('" + FixName + "','" + Description + "','" + File + "','" + Add + "','"+AddDate+"','" + SAPPS + "','"+I NEED A VALUE HERE+"','"+KnowledgeID+"')", myConnection);SqlDataAdapter myDataAdapter = new SqlDataAdapter(mycommand2);

sa = mycommand.ExecuteNonQuery();

myConnection.Close();

}catch (Exception ex)

{

myConnection.Close();

}

}