ASP.NET

magichi wrote:

Customs wanna

magichi wrote:

They don't wanna see the send mail box,they wanna see the number of unread mails,or other information that could see when they open the outloo

UPDATE EXAMEN
SET NOTE = 
  ( CASE 
    WHEN CODE_MATIERE = '111' THEN '{0}'
    WHEN CODE_MATIERE = '112' THEN '{1}'
  END )
WHERE NUM_INSCRIPTION = {2};

sb.AppendFormat(
   @"UPDATE EXAMEN "
   + "SET NOTE = "
   + "(CASE "
   + "WHEN CODE_MATIERE = '111' then {0} "
   + "WHEN CODE_MATIERE = '112' then {1} "
   + "END) "
   + "WHERE NUM_INSCRIPTION = {2};"
   , note1, note2, userID);

SqlCommand cmd = new SqlCommand();
cmd.CommandText = "UPDATE EXAMEN "
   + "SET NOTE = "
   + "(CASE "
   + "WHEN CODE_MATIERE = '111' then @note1 "
   + "WHEN CODE_MATIERE = '112' then @note2 "
   + "END) "
   + "WHERE NUM_INSCRIPTION = @numinsc;"
SqlParameter param1 = new SqlParameter("note1", note1);
cmd.Parameters.Add(param1);
SqlParameter param2 = new SqlParameter("note2", note2);
cmd.Parameters.Add(param2);
SqlParameter param3 = new SqlParameter("numinsc", userID);
cmd.Parameters.Add(param3);
...

 foreach (GridViewRow row in GridView1.Rows)<br />
        {<br />
            TextBox notem1 = row.FindControl("note1") as TextBox;<br />
            TextBox notem2 = row.FindControl("note2") as TextBox;<br />
            Label num = row.FindControl("lblUserID1") as Label;<br />
            SqlConnection myConnection = new SqlConnection(ConnectionString);<br />
<br />
            SqlCommand myCommand = new SqlCommand(<br />
"UPDATE EXAMEN "<br />
   + "SET NOTE = "<br />
   + "(CASE "<br />
   + "WHEN CODE_MATIERE = '111' then @note1 "<br />
   + "WHEN CODE_MATIERE = '112' then @note2 "<br />
   + "END) "<br />
   + "WHERE NUM_INSCRIPTION = @num;"<br />
<br />
<br />
       , myConnection);<br />
<br />
            myCommand.Parameters.Add(new SqlParameter("@num", SqlDbType.VarChar, 4));<br />
<br />
            myCommand.Parameters["@num"].Value = num.Text;<br />
            myCommand.Parameters.Add(new SqlParameter("@note1", SqlDbType.Float, 2));<br />
<br />
            myCommand.Parameters["@note1"].Value = notem1.Text.Replace(",", ".");<br />
<br />
<br />
            myCommand.Parameters.Add(new SqlParameter("@note2", SqlDbType.Float, 2));<br />
<br />
            myCommand.Parameters["@note2"].Value = notem2.Text.Replace(",", ".");<br />
            myConnection.Open();<br />
           <br />
           myCommand.ExecuteNonQuery();<br />
<br />
            myConnection.Close();<br />
          <br />
        }

string cmd = "UPDATE EXAMEN SET NOTE = (CASE WHEN CODE_MATIERE = '111' then @note1 WHEN CODE_MATIERE = '112' then @note2 END) WHERE NUM_INSCRIPTION = @num;";
float note1, note2;
string num;
SqlCommand myCommand;
SqlParameter param1, param2, param3;

using (SqlConnection myConnection = new SqlConnection(ConnectionString))
{
   myConnection.Open();

   foreach (GridViewRow row in GridView1.Rows)
   {
      note1 = float.Parse(((TextBox)row.FindControl("note1")).Text);
      note2 = float.Parse(((TextBox)row.FindControl("note2")).Text);
      num = ((Label)row.FindControl("lblUserID1")).Text;

      myCommand = new SqlCommand(cmd, myConnection);

      param1 = new SqlParameter("num", SqlDbType.VarChar, 4);
      param1.Value = num;
      myCommand.Parameters.Add(param1);

      param2 = new SqlParameter("note1", SqlDbType.Float, 2);
      param2.Value = note1;
      myCommand.Parameters.Add(param2);

      param3 = new SqlParameter("note2", SqlDbType.Float, 2);
      param3.Value = note2;
      myCommand.Parameters.Add(param3);

      myCommand.ExecuteNonQuery();
   }

   myConnection.Close();
}

Thanusree Duth wrote:

How to maximise the panel contol when the page is loaded in web application

        function maximizePanel()
        {
            var screenHeight = window.screen.availHeight;
            var screenWidth = window.screen.availWidth;
            document.getElementById('<% =Panel1.ClientID %>').style.width = screenWidth - 10;
            document.getElementById('<% =Panel1.ClientID %>').style.height = screenHeight - 10;
        }    
<body onload="maximizePanel()">
    <form id="form1" runat="server">
    <div>
        <asp:Panel ID="Panel1" runat="server" Height="50px" Width="125px" BorderWidth="2">
        </asp:Panel>
    
    </div>
    </form>
</body>
</html>