ASP.NET

12-Oct-10 20:14

I wanna run outlook on client,just like input "D:\PROGRA~1\MICROS~4\Office12\OUTLOOK.EXE" into run.
I don't want to use "mailto:",how can I do?

Brij12-Oct-10 20:56

Brij

12-Oct-10 20:56

magichi wrote:
I wanna run outlook on client,just like input "D:\PROGRA~1\MICROS~4\Office12\OUTLOOK.EXE" into run.

Are you working on web application. And want to run outlook on client machine. You can not. Because browser does not have suffcient permission to run an exe on a machine.

Cheers!!
Brij
Visit my Blog: http://brijbhushan.net

Check my latest Article :ViewState - Various ways to reduce performance overhead

Sneha Bisht12-Oct-10 22:53

Sneha Bisht

12-Oct-10 22:53

Try this

using System.Diagnostics;

Process.Start("outlook.exe");

magichi12-Oct-10 22:56

12-Oct-10 22:56

I tried it,but it doesn't work.
somebody says the reason is it's server code,not client code,so it doesn't work

Sneha Bisht12-Oct-10 23:03

Sneha Bisht

12-Oct-10 23:03

Another one

function go()
{
w = new ActiveXObject("WScript.Shell");
w.run('notepad.exe');
return true;
}

onLoad="go();" event in form

magichi13-Oct-10 16:50

13-Oct-10 16:50

I tried it,but it based on the security of IE option.It based on setting low security.Customs could not set same security of IE.

Pete O'Hanlon12-Oct-10 23:18

Pete O'Hanlon

12-Oct-10 23:18

magichi wrote:
I don't want to use "mailto:

Why?

magichi wrote:
I wanna run outlook on client,just like input "D:\PROGRA~1\MICROS~4\Office12\OUTLOOK.EXE" into run

Think about it - what happens if the user doesn't have Outlook installed? What if it's installed to a different location?

You are writing a web based application, which users expect to honour the security sandbox. Solutions like shelling out using ActiveX scripting have the effect of giving users and experience they wouldn't expect, probably wouldn't like, and certainly won't work on none Microsoft operating systems.

I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be

Forgive your enemies - it messes with their heads

My blog | My articles | MoXAML PowerToys | Onyx

magichi13-Oct-10 16:43

13-Oct-10 16:43

yeah,somebody have suggest me to use ActiveX,do u have any example?

Anurag Gandhi13-Oct-10 0:17

Anurag Gandhi

13-Oct-10 0:17

You might be looking into <a href="mailto:email@domain.com">open outlook new mail window</a>

For details, click here[^]

Anurag Gandhi.
http://www.gandhisoft.com
Life is a computer program and every one is the programmer of his own life.
My latest article: Group GridView Data

fjdiewornncalwe13-Oct-10 3:42

fjdiewornncalwe

13-Oct-10 3:42

Like Pete said... Respect the security sandbox.

That being said, I have in a closed intranet setting implemented solutions that intertwine both client based binaries and server based web pages. But only in a closed intranet setting where that can be properly administered and controlled would that be something to be considered.

If the purpose is to launch the user's outlook, that is what the mailto directive was created for. A safe way to launch a user's email system from a web app.

magichi13-Oct-10 16:56

13-Oct-10 16:56

Customs wanna open outlook just like run outlook on their client.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 outlook.How could I do?

Update all gridview rows at once

fjdiewornncalwe14-Oct-10 13:15

fjdiewornncalwe

14-Oct-10 13:15

magichi wrote:
Customs wanna

Please use full words when you write here. It's truly painful for some of us older guys to read stuff like this.

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

If they are using outlook and an exchange server, just have the exchange server admins activate the webmail front end??? I think that is what you want.

amina8912-Oct-10 1:47

12-Oct-10 1:47

Hi,

when I execute this code i get the following error:Incorrect syntax near the keyword When.

StringBuilder sb = new StringBuilder();
             foreach (GridViewRow row in GridView1.Rows)
        {
            
            string note1 = (row.FindControl("note1") as TextBox).Text.Replace(",", ".");
            string note2 = (row.FindControl("note2") as TextBox).Text.Replace(",", ".");
            string userID = (row.FindControl("lblUserID1") as Label).Text;
 
            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);
 
        }
</pre>

Geoff Williams12-Oct-10 3:06

Geoff Williams

12-Oct-10 3:06

You need to enclose your CASE statement in brackets:

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

I would also recommend using a parameterised update query - that way you only need to create the query once and you can pass the row-specific values (note1, note2, userId) as parameters.

Re: Update all gridview rows at once [modified]

phil.o12-Oct-10 4:23

phil.o

12-Oct-10 4:23

You cannot have CR/LF in strings. Thus you have to concatenate your strings if you want to write them on several lines :

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);

An even better option would be to use a parameterized query :

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);
...

Edit : I replied to the wrong post. Sorry Frown | :(

amina8914-Oct-10 0:02

14-Oct-10 0:02

Hi; Thak you phil.o Smile | :)

I tried using a parameterized query but it does not work:It update with zero all marks

 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 />
        }

modified on Thursday, October 14, 2010 6:21 AM

phil.o14-Oct-10 5:35

phil.o

14-Oct-10 5:35

Hi,

Try to use the correct types when you assign your parameter : here you define float parameters but you assign them string values.

Try instead :

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();
}

Several points here :
- Try to obtain your values in the type you will need them in your database (note1, note2, num).
- I removed the concatenations in the query string for higher simplicity.
- When you define your parameters, defines variables of type SqlParameter (as in my previous example) ; it will exhaust you from having to find them out using an array accessor.
- The '@' sign for parameters must only be present in the SQL query string, not in the declaration of the SqlParameter objects.
- It's better to open your connection before the loop, and close it after ; opening connection is time-consuming, and you'd better avoid it if you can. And, as SqlConnection implements IDisposable interface, it's even better to use it with an 'using' statement (which will take care of disposing the connection when not needed anymore).

If this still doesn't work, start a debug session and watch for the content of all your variables, you should see there what's the issue.

Hope it'll help Wink | ;)

amina8917-Oct-10 3:35

17-Oct-10 3:35

Hi,
Thank you very much phil.
the program does not read TexBox of the gridview it returns me this message 'The format of the input string is incorrect.'
for this line : note1 = float.Parse(((TextBox)row.FindControl("note1")).Text);
when I debug I found that the value of note1 is 0.0 while I typed 13.
Thanks.

amina8921-Oct-10 0:04

21-Oct-10 0:04

Hi,

the program does not read Cry | :((

TextBox)row.FindControl("note2")).Text;
it reads ((Label)row.FindControl("lblUserID1")).Text;

I think the problem come from there but I do not know how to correct that.

Thanks

amina8922-Oct-10 15:24