Okay, the issue looks as though it's probably to do with the names that you have allocated to things. Try changing it to this:
string s = "INSERT INTO [Students Records] (Name,Age,Class,Gender,[Guardian's Name],[Contact.No],Address,Email-Address) VALUES(@Name,@Age,@Class,@Gender,@Guardian,@Contact,@Address,@Email-Address)";
SqlConnection con = new SqlConnection(cs);
SqlCommand cmd = new SqlCommand(s,con);
cmd.Connection = con;
cmd.Parameters.AddWithValue("@Name", textBox1.Text);
cmd.Parameters.AddWithValue("@Age", textBox2.Text);
cmd.Parameters.AddWithValue("@Class", textBox3.Text);
cmd.Parameters.AddWithValue("@Gender", textBox4.Text);
cmd.Parameters.AddWithValue("@Guardian", textBox5.Text);
cmd.Parameters.AddWithValue("@Contact", textBox6.Text);
cmd.Parameters.AddWithValue("@Address", textBox7.Text);
cmd.Parameters.AddWithValue("@Email-Address", textBox8.Text);