מתכונת 5 במדעי המחשב - תכנות באינטרנט 899372

<table border="1">
  <tr>
    <td>שם</td>
    <td>ציון</td>
  </tr>
  <tr>
    <td>דנה</td>
    <td>95</td>
  </tr>
</table>

<table border = '1'><tr><td>7</td><td>60</td><td>5</td><td>Tik</td><td>3</td><td>20</td><td>1</td></tr></table>

<td colspan="2"><a href="Pages/meron.html">הר מירון</a></td>

<!DOCTYPE html>
<html lang="he">
  <meta charset="utf-8"/>
  <table style="width:240px" border="2" dir="rtl">
    <tr>
      <td colspan="3">שמורות טבע בצפון</td>
    </tr>
    <tr>
      <td rowspan="2">נחלים</td>
      <td>תל דן</td>
      <td>בניאס</td>
    </tr>
    <tr>
      <td>נחל עמוד</td>
      <td>נחל כזיב</td>
    </tr>
    <tr>
      <td>הרים</td>
      <td colspan="2"><a href="Pages/meron.html">הר מירון</a></td>
    </tr>
    <tr>
      <td colspan="3" align="center">
        <img src="Images/mountain.png" />
      </td>
    </tr>
  </table>
</html>

protected void showVolunteers(string connectionString, string city)
{
    string html = "";
    int total = 0;
    DataSet ds = new DataSet();
    SqlConnection conn = new SqlConnection(connectionString);
    SqlCommand cmd = new SqlCommand();
    cmd.CommandText = "SELECT FullName, Hours FROM Volunteers WHERE City = '" + city + "' ORDER BY Hours DESC";
    cmd.Connection = conn;
    SqlDataAdapter adapter = new SqlDataAdapter(cmd);
    conn.Open();
    adapter.Fill(ds, "vol");
    conn.Close();
    DataTable t = ds.Tables["vol"];
    html += "<table border='1'><tr><th>שם המתנדב</th><th>שעות</th></tr>";
    for (int i = 0; i < t.Rows.Count; i++)
    {
        DataRow row = t.Rows[i];
        html += "<tr><td>" + row["FullName"] + "</td><td>" + row["Hours"] + "</td></tr>";
        total = total + (int)row["Hours"];
    }
    html += "<tr><td>סך הכול</td><td>" + total + "</td></tr>";
    html += "</table>";
    Response.Write(html);
}

protected void showVolunteers(string connectionString, string city)
{
    string html = "";
    int total = 0;
    DataSet ds = new DataSet();
    SqlConnection conn = new SqlConnection(connectionString);
    SqlCommand cmd = new SqlCommand();
    cmd.CommandText = "SELECT FullName, Hours FROM Volunteers WHERE City = '" + city + "' ORDER BY Hours DESC";
    cmd.Connection = conn;
    SqlDataAdapter adapter = new SqlDataAdapter(cmd);
    conn.Open();
    adapter.Fill(ds, "vol");
    conn.Close();
    DataTable t = ds.Tables["vol"];
    html += "<table border='1'><tr><th>שם המתנדב</th><th>שעות</th></tr>";
    for (int i = 0; i < t.Rows.Count; i++)
    {
        DataRow row = t.Rows[i];
        html += "<tr><td>" + row["FullName"] + "</td><td>" + row["Hours"] + "</td></tr>";
        total = total + (int)row["Hours"];
    }
    html += "<tr><td>סך הכול</td><td>" + total + "</td></tr>";
    html += "</table>";
    Response.Write(html);
}

// פעולת עזר: מחזירה את מספר הספרות של מספר חיובי
public int CountDigits(int num)
{
    int count = 0;
    while (num > 0)
    {
        count++;
        num = num / 10;
    }
    return count;
}

// פעולת עזר: מחזירה את סכום הספרות של מספר חיובי
public int SumDigits(int num)
{
    int sum = 0;
    while (num > 0)
    {
        sum = sum + num % 10;
        num = num / 10;
    }
    return sum;
}

public bool IsTwins(int num1, int num2)
{
    return CountDigits(num1) == CountDigits(num2) && SumDigits(num1) == SumDigits(num2);
}

// פעולת עזר: מחזירה את מספר הספרות של מספר חיובי
public int CountDigits(int num)
{
    int count = 0;
    while (num > 0)
    {
        count++;
        num = num / 10;
    }
    return count;
}

// פעולת עזר: מחזירה את סכום הספרות של מספר חיובי
public int SumDigits(int num)
{
    int sum = 0;
    while (num > 0)
    {
        sum = sum + num % 10;
        num = num / 10;
    }
    return sum;
}

public bool IsTwins(int num1, int num2)
{
    return CountDigits(num1) == CountDigits(num2) && SumDigits(num1) == SumDigits(num2);
}

public void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        Session["items"] = 0;
        Session["total"] = 0;
    }
}
void Bread_Click(object sender, EventArgs e)
{
    Session["total"] = (int)Session["total"] + 12;
    Session["items"] = (int)Session["items"] + 1;
}
void Cake_Click(object sender, EventArgs e)
{
    Session["total"] = (int)Session["total"] + 45;
    Session["items"] = (int)Session["items"] + 1;
}

<div runat="server" id="div1">
    פריטים בסל: <% =Session["items"] %> , לתשלום: <% =Session["total"] %> ש"ח
</div>

public void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        Session["items"] = 0;
        Session["total"] = 0;
    }
}
void Bread_Click(object sender, EventArgs e)
{
    Session["total"] = (int)Session["total"] + 12;
    Session["items"] = (int)Session["items"] + 1;
}
void Cake_Click(object sender, EventArgs e)
{
    Session["total"] = (int)Session["total"] + 45;
    Session["items"] = (int)Session["items"] + 1;
}

DataRow row = ds.Tables[0].NewRow();
row["fullName"] = runner;
row["distance"] = int.Parse(dist);
row["city"] = city;
ds.Tables[0].Rows.Add(row);

protected void AddRunner(string connectionString)
{
    SqlConnection connection = new SqlConnection(connectionString);
    SqlCommand command = new SqlCommand();
    command.CommandText = "Select * From runners";
    command.Connection = connection;
    connection.Open();
    SqlDataAdapter adapter = new SqlDataAdapter(command);
    SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
    DataSet ds = new DataSet();
    adapter.Fill(ds);
    string runner = Request.Form["runner"];
    string dist = Request.Form["dist"];
    string city = Request.Form["city"];

    // ---- הקוד החסר ----
    DataRow row = ds.Tables[0].NewRow();
    row["fullName"] = runner;
    row["distance"] = int.Parse(dist);
    row["city"] = city;
    ds.Tables[0].Rows.Add(row);
    // --------------------

    adapter.Update(ds);
    connection.Close();
}

protected void showQuickDesserts(string connectionString)
{
    string resultStr = "";
    DataSet ds = new DataSet();
    SqlConnection connection = new SqlConnection(connectionString);
    SqlCommand cmd = new SqlCommand();
    cmd.CommandText = "SELECT * FROM RecipesTable WHERE category = 'קינוח' AND minutes < 40";
    cmd.Connection = connection;
    connection.Open();
    SqlDataAdapter adapter = new SqlDataAdapter(cmd);
    adapter.Fill(ds);
    connection.Close();
    resultStr += "<table border='1'><tr><th>שם המתכון</th><th>זמן הכנה</th><th>קלוריות</th></tr>";

    foreach (DataRow dr in ds.Tables[0].Rows)
    {
        resultStr += "<tr>";
        resultStr += "<td>" + dr["name"] + "</td>";
        resultStr += "<td>" + dr["minutes"] + "</td>";
        resultStr += "<td>" + dr["calories"] + "</td>";
        resultStr += "</tr>";
    }
    resultStr += "</table>";
    Response.Write(resultStr);
}

protected void showQuickDesserts(string connectionString)
{
    string resultStr = "";
    DataSet ds = new DataSet();
    SqlConnection connection = new SqlConnection(connectionString);
    SqlCommand cmd = new SqlCommand();
    cmd.CommandText = "SELECT * FROM RecipesTable WHERE category = 'קינוח' AND minutes < 40";
    cmd.Connection = connection;
    connection.Open();
    SqlDataAdapter adapter = new SqlDataAdapter(cmd);
    adapter.Fill(ds);
    connection.Close();
    resultStr += "<table border='1'><tr><th>שם המתכון</th><th>זמן הכנה</th><th>קלוריות</th></tr>";

    foreach (DataRow dr in ds.Tables[0].Rows)
    {
        resultStr += "<tr>";
        resultStr += "<td>" + dr["name"] + "</td>";
        resultStr += "<td>" + dr["minutes"] + "</td>";
        resultStr += "<td>" + dr["calories"] + "</td>";
        resultStr += "</tr>";
    }
    resultStr += "</table>";
    Response.Write(resultStr);
}