Closing application when windows shuts down - C# Discussion Boards

21-Feb-10 1:25

Hi,

I have wriiten a little application that runs mainly in the background. There is a U.I. trhat can be accessed by double clicking its icon in the notification bar. The problem is when I try to restart or shut down my XP machine the application will not close. This appears to be not an issue on Windows 7 as it shutsdown fine, I suspect Vista could be ok also.

I checked the event viewer the event was to the effect The attempt to reboot PC failed. I have read a little and I added the following to my code

// 1. Global variable in main form<br />
private int WM_QUERYENDSESSION = 0x11;<br />
<br />
//2. Override WndProc<br />
 protected override void WndProc(ref Message m)<br />
{<br />
    if (m.Msg == WM_QUERYENDSESSION)<br />
    {<br />
       Application.ExitThread();               <br />
    }           <br />
    base.WndProc(ref m);                     <br />
 }

This works in as much as the application closes when I try to restart my machine, but the machine does not restart I have to tell to restart once more before it restarts. I feel it's almost there but I am not sure what is missing.

Help if you can, Dave.

davearias21-Feb-10 1:43

21-Feb-10 1:43

I have also added : Application.Exit(); to the above code to no effect

Geoff Williams21-Feb-10 2:40

Geoff Williams

21-Feb-10 2:40

I would guess that your problem is that your call to Application.ExitThread() means that the call to base.WndProc(ref m) never happens. What happens if you call the base function first?

davearias21-Feb-10 10:33

21-Feb-10 10:33

Tried what you suggested. Still have the same problem, in that the app closes but seems to stop the machine from closing down until I try to restart for the 2nd time.

Luc Pattyn21-Feb-10 2:44

Luc Pattyn

21-Feb-10 2:44

Hi,

AFAIK there is no need to override WndProc for this. Just add your handler to the SystemEvents.SessionEnding event and exit the application.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that.
All Toronto weekends should be extremely wet until we get it automated in regular forums, not just QA.

davearias21-Feb-10 10:36

21-Feb-10 10:36

Hi I read this link http://www.xtremedotnettalk.com/showthread.php?t=74820[^] that tried the approach you suggested and they seemed to think this would not work!

Magic Numbers File Type checking

Luc Pattyn21-Feb-10 10:44

Luc Pattyn

21-Feb-10 10:44

Why would SessionEnding, that has exactly the purpose you're after, not work, when Microsoft has offered it since day 1 of .NET?

May i suggest, when you read some stuff, you read it carefully, all the way to the bottom.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

Joezer BH20-Feb-10 22:09

Joezer BH

20-Feb-10 22:09

Houdy,

I need a class that checks/validates file types.
Of course this is needed in cases where you can't trust the extension to supply that info.

I thought about Magic Numbers as an option - does anyone have an already built app - any language will do
Also if you have ideas on how to accomplish this task (like MIME etc) in a better way I am all OMG | :OMG:

Surprising to see so few samples and sources for Magic Numbers on google...

Thanks a bunch

Tzumer

Return Dataset to Business Layer & SHOW in datagrid in Presentation Layer

shahramkeyboard20-Feb-10 20:58

Re: Return Dataset to Business Layer & SHOW in datagrid in Presentation Layer

20-Feb-10 20:58

hi
how i can return dataset to datagriedview
My business layer is memberBL Class
My Data Access Layer Is memberDA Class
My view Dataset Code in memberDL Class is:

public DataSet View(memberBL member)
        {
            DataSet ds = null;

            try
            {
                OpenCnn();
                
                String selectStr = "select * from " + thisTable + "'";
                
                OleDbDataAdapter da =new OleDbDataAdapter(selectStr, cnn);
                
                ds = new DataSet();
                
                da.Fill(ds, thisTable);
                
                CloseCnn();
            }
            catch (Exception e)
            {
                String Str = e.Message;
            }

            return ds;
        }

How I Can return Dataset in GriedView in Form?
hoW i can use in ds IN windows FORM?

Dan Mos20-Feb-10 21:02

Re: Return Dataset to Business Layer & SHOW in datagrid in Presentation Layer

20-Feb-10 21:02

well that's easy. Something like:

dataGridView1.DataSource = ds.Tables[0];//or ds.Tables["YourTableNameHere"];

shahramkeyboard20-Feb-10 21:07

Re: Return Dataset to Business Layer & SHOW in datagrid in Presentation Layer

20-Feb-10 21:07

program is layering & ds in not known in form
first ds come in business layer then view in datagried
it is not easy my dear friend Confused | :confused:

Dan Mos20-Feb-10 21:23

Re: Return Dataset to Business Layer & SHOW in datagrid in Presentation Layer

20-Feb-10 21:23

I'm sorry I don't understand.

what do you mean by "ds in not known in form"?

An by this "first ds come in business layer then view in datagried"?
Do you have problem returnig the dataset from your bussines layer to your UI?

shahramkeyboard20-Feb-10 21:55

20-Feb-10 21:55

yes
first ds to business layer then view in UI layer & form

Does this help?

Dan Mos20-Feb-10 22:25

20-Feb-10 22:25

I got that from your anteriour posts.

But what is your problem? Passing data from the BLogic to the UI
or just the UI part?

[EDIT]

OK suppose that your UI is in the MyUI namespace.
The BussinessLayer is in the MyLogic namespace.

in order to populate your UI with data do something like this inside a click event for example:

private void btn1_Click(object sender, EventArgs null){
     dataGridView1.DataSource = MyLogic.MemberBL.GetDataSet().Tables[0];
     //where the GetDataSet() returns the ds from the BussinessLayer;
}

Just like d@nish said if on a different project/dll just add a reference to it.

Re: Does this help?

shahramkeyboard21-Feb-10 1:46

Re: Does this help? [modified]

21-Feb-10 1:46

my business layer is:

using System;<br />
using System.Collections.Generic;<br />
using System.Linq;<br />
using System.Text;<br />
<br />
namespace Library_Project<br />
{<br />
    class memberBL<br />
    {<br />
                    //Book properties<br />
            private String membercode;<br />
            private String name;<br />
            private String family;<br />
            private String shsh;<br />
            private String melicode;<br />
            private String tavalod;<br />
            private String shoghl;<br />
            private String tel;<br />
            private String mobile;<br />
            private String adr;<br />
            private String trkhozv;<br />
<br />
            private memberDA memberData;<br />
<br />
       // BUSINESS LOGIC Member <br />
       public memberBL()            <br />
       {<br />
         <br />
           //Data access layer!<br />
     <br />
           memberData = new memberDA();<br />
<br />
       }<br />
       /// <SUMMARY><br />
       /// Property BookCode (String)<br />
       /// </SUMMARY><br />
       public String DatasetData<br />
       {<br />
           get<br />
           {<br />
               return this.DatasetData;<br />
           }<br />
           set<br />
           {<br />
               this.DatasetData = value;<br />
<br />
<br />
           }<br />
       }<br />
       /// <SUMMARY><br />
       /// Property BookCode (String)<br />
       /// </SUMMARY><br />
       public String Membercode<br />
       {<br />
           get<br />
           {<br />
               return this.membercode;<br />
           }<br />
           set<br />
           {<br />
               this.membercode = value;<br />
<br />
<br />
           }<br />
       }<br />
 <br />
            /// <SUMMARY><br />
            /// Property BooktName (String)<br />
            /// </SUMMARY><br />
            public String Name <br />
            {<br />
      <br />
                  get<br />
                  {<br />
                      return this.name;<br />
                  }<br />
                  set<br />
                  {<br />
                        try<br />
                        {<br />
                            this.name = value;<br />
<br />
                            if (this.name == "")<br />
                              {<br />
                                    throw new Exception(<br />
                                      "لطفا نام عضو را وارد نمایید");<br />
                              }<br />
                        }<br />
                        catch(Exception e)<br />
                        {<br />
                              throw new Exception(e.Message.ToString());<br />
                        }<br />
                  }<br />
            }<br />
 <br />
            /// <SUMMARY><br />
            /// Property ISBN (String)<br />
            /// </SUMMARY><br />
            public String Familly<br />
            {<br />
                  get<br />
                  {<br />
                        return this.family;<br />
                  }<br />
                  set<br />
                  {<br />
                        //could be more checkings here eg revmove ' chars<br />
                        //change to proper case<br />
                        //blah blah<br />
                        this.family = value;<br />
                        if (this.family == "")<br />
                        {<br />
                              throw new Exception("لطفا نام خانوادگی عضو رو وارد نمایید");<br />
                        }<br />
 <br />
                  }<br />
            }<br />
<br />
            /// <SUMMARY><br />
            /// Property Nasher (String)<br />
            /// </SUMMARY><br />
            public String Shsh<br />
            {<br />
                  get<br />
                  {<br />
                      return this.shsh;<br />
                  }<br />
                  set<br />
                  {<br />
                      this.shsh = value;<br />
<br />
                      if (this.shsh == "")<br />
                        {<br />
                              throw new Exception("لطفا شماره شناسنامه را وارد نمایید");<br />
                        }<br />
                  }<br />
            }<br />
            /// <SUMMARY><br />
            /// Property ISBN (String)<br />
            /// </SUMMARY><br />
            public String Melicode<br />
            {<br />
                  get<br />
                  {<br />
                        return this.melicode;<br />
                  }<br />
                  set<br />
                  {<br />
                        //could be more checkings here eg revmove ' chars<br />
                        //change to proper case<br />
                        //blah blah<br />
                        this.melicode = value;<br />
                        if (this.melicode == "")<br />
                        {<br />
                              throw new Exception("لطفا کد ملی عضو رو وارد نمایید");<br />
                        }<br />
 <br />
                  }<br />
            }<br />
            /// <SUMMARY><br />
            /// Property Nasher (String)<br />
            /// </SUMMARY><br />
            public String Tavalod<br />
            {<br />
                  get<br />
                  {<br />
                      return this.tavalod;<br />
                  }<br />
                  set<br />
                  {<br />
                      this.tavalod = value;<br />
<br />
                      if (this.tavalod == "")<br />
                        {<br />
                              throw new Exception("لطفا تاریخ تولد رو وارد نمایید");<br />
                        }<br />
                  }<br />
            }<br />
<br />
 <br />
            /// <SUMMARY><br />
            /// Property Mozoe Ketab (String)<br />
            /// </SUMMARY><br />
            public String Shoghl<br />
            {<br />
                  get<br />
                  {<br />
                      return this.shoghl;<br />
                  }<br />
                  set<br />
                  {<br />
                      this.shoghl = value;<br />
                      if (this.shoghl == "")<br />
                        {<br />
                              throw new Exception("لطفا شغل رو انتخاب کنید");<br />
                        }<br />
 <br />
                  }<br />
            }<br />
            /// <SUMMARY><br />
            /// Property Mozoe Ketab (String)<br />
            /// </SUMMARY><br />
            public String Tel<br />
            {<br />
                  get<br />
                  {<br />
                      return this.tel;<br />
                  }<br />
                  set<br />
                  {<br />
                      this.tel = value;<br />
                      if (this.tel == "")<br />
                        {<br />
                            throw new Exception("لطفا شماره  تلفن را وارد نمایید ");<br />
                        }<br />
 <br />
                  }<br />
            }<br />
            /// <SUMMARY><br />
            /// Property Mozoe Ketab (String)<br />
            /// </SUMMARY><br />
            public String Mobile<br />
            {<br />
                  get<br />
                  {<br />
                      return this.mobile;<br />
                  }<br />
                  set<br />
                  {<br />
                      this.mobile = value;<br />
                      if (this.mobile == "")<br />
                        {<br />
                            throw new Exception("لطفا شماره موبایل را وارد نمایید ");<br />
                        }<br />
 <br />
                  }<br />
            }<br />
            /// <SUMMARY><br />
            /// Property Mozoe Ketab (String)<br />
            /// </SUMMARY><br />
            public String Adr<br />
            {<br />
                  get<br />
                  {<br />
                      return this.adr;<br />
                  }<br />
                  set<br />
                  {<br />
                      this.adr = value;<br />
                      if (this.adr == "")<br />
                        {<br />
                            throw new Exception("لطفا آدرس را وارد نمایید");<br />
                        }<br />
 <br />
                  }<br />
            }<br />
            /// <SUMMARY><br />
            /// Property Mozoe Ketab (String)<br />
            /// </SUMMARY><br />
            public String Trkhozv<br />
            {<br />
                get<br />
                {<br />
                    return this.trkhozv;<br />
                }<br />
                set<br />
                {<br />
                    this.trkhozv = value;<br />
<br />
<br />
                }<br />
            }<br />
            /// <SUMMARY><br />
            /// Function Add new customer. Calls <br />
            /// the function in Data layer.<br />
            /// </SUMMARY><br />
            public void Add()<br />
            {<br />
                  memberData.Add(this);<br />
            }<br />
 <br />
 <br />
            /// <SUMMARY><br />
            /// Function Update customer details. <br />
            /// Calls the function in Data layer.<br />
            /// </SUMMARY><br />
            public void Update()<br />
            {<br />
                memberData.Update(this);<br />
            }<br />
<br />
            /// <SUMMARY><br />
            /// Function View Member details. <br />
            /// Calls the function in Data layer.<br />
            /// </SUMMARY><br />
         <br />
    }<br />
}

My data Layer IS :

using System;
using System.Data.OleDb;
using System.Data;
using System.Text;

namespace Library_Project
{
    class memberDA
    {
        private OleDbConnection cnn;
        //change connection string as per the 
        //folder you unzip the files
        private const string CnnStr = 
          "Provider=Microsoft.Jet.OLEDB.4.0;Data " +
          "Source= D:\\Data\\Library.mdb;"; 
            
        //local variables
        private String strTable="";
        private String strFields="";
        private String strValues="";
        private String insertStr="";
        
        //this needs to be changed based on Books 
        //table fields' Name of the database!
        private const String thisTable = "tblmembers";
        private const String member_code = "membercode";
        private const String member_name = "name";
        private const String member_family = "family";
        private const String member_shsh = "shsh";
        private const String member_melicode = "melicode";
        private const String member_tavalod = "tavalod";
        private const String member_shoghl = "shoghl";
        private const String member_tel = "tel";
        private const String member_mobile = "mobile";
        private const String member_adr = "adr";
        private const String member_trkhozv = "trkhozv";
        private memberBL memberLogic;

        public memberDA()
        {
           
        }

        public memberDA(memberBL member)
       
        {
            // A reference of the business object class
            memberLogic = new memberBL();
        }
        
        //standard dataset function that adds a new customer

        public void Add(memberBL member)
        {

            String str = BuildAddString(member);
            
            OpenCnn();

            //Open command option - cnn parameter is imporant
            OleDbCommand cmd = new OleDbCommand(str,cnn);


            //execute connection
            cmd.ExecuteNonQuery();
            
            // close connection
            CloseCnn();
            
        }
        
        //standard dataset function that updates 
        //details of a customer based on ID
        public void Update(memberBL member)
        {
            OpenCnn();
            
            String selectStr = "UPDATE " + thisTable +
                " set " + member_name + " = '" + member.Name + "'" +
                ", " + member_family + " = '" + member.Familly + "'" +
                ", " + member_shsh + " = '" + member.Shsh + "'" +
                ", " + member_melicode + " = '" + member.Melicode + "'" +
                ", " + member_tavalod + " = '" + member.Tavalod + "'" +
                ", " + member_shoghl + " = '" + member.Shoghl + "'" +
                ", " + member_tel + " = '" + member.Tel + "'" +
                ", " + member_mobile + " = '" + member.Mobile + "'" +
                ", " + member_adr + " = '" + member.Adr + "'" +
                " where member_code = '" + member.Membercode  + "'";

            OleDbCommand cmd = new OleDbCommand(selectStr,cnn);

            cmd.ExecuteNonQuery();
            
            CloseCnn();
        }
        
        //standard dataset function that finds and 
        //return the detail of a customer in a dataset
        public DataSet Find(String argStr)
        {
            DataSet ds=null;

            try
            {
                OpenCnn();
            
                String selectStr = "select * from " + thisTable + 
                              " where member_code = '" + argStr + "'";
                OleDbDataAdapter da = 
                       new OleDbDataAdapter(selectStr,cnn);
                ds = new DataSet();
                da.Fill(ds,thisTable);
            
                CloseCnn();

                
            }
            catch(Exception e)
            {
                String Str = e.Message;
            }

            return ds;
        }

        //standard dataset function that finds and 
        //return the detail of a customer in a dataset
        public DataSet View()
        {
            DataSet ds = null;

            try
            {
                OpenCnn();
                
                String selectStr = "select * from " + thisTable + "'";
                
                OleDbDataAdapter da =new OleDbDataAdapter(selectStr, cnn);
                
                ds = new DataSet();
                
                da.Fill(ds, thisTable);
                
                CloseCnn();
            }
            catch (Exception e)
            {
                String Str = e.Message;
            }

            return ds;
        }

        private void OpenCnn()
        {
            // initialise connection
            String cnnStr = CnnStr;
            cnn = new OleDbConnection(cnnStr);
            // open connection
            cnn.Open();
        }

        private void CloseCnn()
        {
            // 5- step five
            cnn.Close();
        }
        
        // just a supporting function that builds 
        // and return the insert string for dataset.
        private String BuildAddString(memberBL member)
        {
            // these are the constants as 
            // set in the top of this module.
            strTable="Insert into " + thisTable;
            strFields = " (" + member_code +
            "," + member_name +
            "," + member_family +
            "," + member_shsh +
            "," + member_melicode +
            "," + member_tavalod +
            "," + member_shoghl +
            "," + member_tel +
            "," + member_mobile +
            "," + member_adr +
            "," + member_trkhozv + ")";
            
            //these are the attributes of the 
            //customer business object.
            strValues = " Values ( '" + member.Membercode +
            "' , '" + member.Name +
            "' , '" + member.Familly +
            "' , '" + member.Shsh +
            "' , '" + member.Melicode +
            "' , '" + member.Tavalod +
            "' , '" + member.Shoghl +
            "' , '" + member.Tel +
            "' , '" + member.Mobile +
            "' , '" + member.Adr +
            "' , '" + member.Trkhozv + "' )";

            insertStr = strTable + strFields + strValues;
            
            return insertStr;
            
        }

    }
}

HOW Return ds to Form?

Dan Mos21-Feb-10 16:27

Re: Return Dataset to Business Layer & SHOW in datagrid in Presentation Layer

21-Feb-10 16:27

Somthing like this:

//in the business layer create a method or property that gets the
//data from the DataLayer. Something like this:
public DataSet GetDatas(){
     return memberData.View();
}

//Now in the UI do something like this
LibraryProject.MemberBL bl = new LibraryProject.MemberBL();

dataGridView1.DataSource = bl.GetDatas().Tables[0];

[Edit]Fixed pre tags[/EDIT]

modified on Sunday, February 21, 2010 10:58 PM

dan!sh 20-Feb-10 23:33

dan!sh

20-Feb-10 23:33

If everything is in same project, create an instance of your BL class and then call the method which returns the dataset.

If BL is in separate project, add a reference to that project in your UI project and then do the same.

Re: Return Dataset to Business Layer & SHOW in datagrid in Presentation Layer [modified]

shahramkeyboard21-Feb-10 2:30