Re: XML to Excel parsing [modified] - C# Discussion Boards

window services in VS2008 [modified]

Aisha sharma21-Aug-11 21:12

21-Aug-11 21:12

hello everyone,
i don't know much about service application,
i want to know dat can we create window services in VS2008
using c# ?

i didn't find window service template in my VS2008 professional edition.
and Is this possible that my window app which is develop in
c# VS2008 can work as window service on vista.

thank you.....

-- Modified Monday, August 22, 2011 3:20 AM

Re: window services in VS2008

Richard MacCutchan21-Aug-11 21:38

Richard MacCutchan

21-Aug-11 21:38

As far as I know the template is only available for C++. However, you may find some reasonable ideas here[^].

Unrequited desire is character building. OriginalGriff

Re: window services in VS2008

Paul E Davies21-Aug-11 22:07

Paul E Davies

21-Aug-11 22:07

It's available in the Windows section of the c# project types and is called "Windows Service", although I'm not sure if it's installed by default in all versions of VS but would have thought it was in the professional edition.

Re: window services in VS2008

Aisha sharma22-Aug-11 0:29

Aisha sharma

22-Aug-11 0:29

yes i found it thank you...... Smile | :)

but can i call my app exe in window service.

Re: window services in VS2008 [modified]

Paul E Davies22-Aug-11 2:56

Paul E Davies

22-Aug-11 2:56

I've re-read you question.

Yes you can use your application as a service but not without some modification. If most of the functionality is in class libraries then your application (be it a console application or a windows service) acts as an entry point to your functionality.

You will need to do some extra work around error reporting and service specific things like startup options but a basic introduction to windows services via google will help with this.

modified on Monday, August 22, 2011 9:17 AM

XML to Excel parsing

yoni.kess21-Aug-11 4:15

yoni.kess

21-Aug-11 4:15

Hi All,
First of all I would like to thank you for the support. I am new in coding and need assistance in getting a specific xml content to an excel spreadsheet or to a datagridview.

the XML file is not a standard one (i think and below is a sample).
what i need from this xml file is the following data:

the name (Towers xxx] of the alert and the gps points (dont need the utm)

this is the xml
[code]

XML

<?xml version="1.0" encoding="UTF-16"?>
<layer>
    <name>
        SF Zones
    </name>
    <alert_area_object>
        <creation_time>
            1303889594
        </creation_time>
        <name>
            Tower 1
        </name>
        <description>
            Fence Alert
        </description>
        <event_types num="1">
            <event_type>
                11111
            </event_type>
        </event_types>
        <event_severity>
            2
        </event_severity>
        <event_override_flag>
            false
        </event_override_flag>
        <identities num="0"/>
        <categories num="0"/>
        <groups num="0"/>
        <target_appear_in_area>
            true
        </target_appear_in_area>
        <target_enter_area>
            true
        </target_enter_area>
        <target_leave_area>
            true
        </target_leave_area>
        <from_hour>
            0
        </from_hour>
        <from_minute>
            0
        </from_minute>
        <to_hour>
            23
        </to_hour>
        <to_minute>
            59
        </to_minute>
        <from_speed>
            0
        </from_speed>
        <to_speed>
            98.8889
        </to_speed>
        <weighting>
            <weight>
                <type>
                    2
                </type>
                <value>
                    99
                </value>
            </weight>
            <weight>
                <type>
                    204
                </type>
                <value>
                    99
                </value>
            </weight>
            <weight>
                <type>
                    205
                </type>
                <value>
                    99
                </value>
            </weight>
        </weighting>
        <visual_feedback>
            true
        </visual_feedback>
        <sound_repeats>
            -1
        </sound_repeats>
        <wave_file>
            C:\4C\RunTime\OWP\Sounds\sirenwawa.wav
        </wave_file>
        <utm_zone>
            40
        </utm_zone>
        <shape type="ClosedPolygon">
            <num_of_alloc_points>
                22
            </num_of_alloc_points>
            <num_of_points>
                5
            </num_of_points>
            <geo_position lat="40.76876678920284" long="-73.98097831075269"/>
            <geo_position lat="40.76869191861909" long="-73.98078254132794"/>
            <geo_position lat="40.76839192572469" long="-73.97999998924834"/>
            <geo_position lat="40.76749000414105" long="-73.97804528571041"/>
            <geo_position lat="40.76643902004108" long="-73.97593868227233"/>
            <utm_points x="132131" y="132131"/>
            <utm_points x="132131" y="132131"/>
            <utm_points x="132131" y="132131"/>
            <utm_points x="132131" y="132131"/>
            <utm_points x="132131" y="132131"/>
        </shape>
    </alert_area_object>
    <alert_area_object>
        <creation_time>
            1303890003
        </creation_time>
        <name>
            Towers 1 to 4
        </name>
        <description>
            Fence Alert
        </description>
        <event_types num="1">
            <event_type>
                11111
            </event_type>
        </event_types>
        <event_severity>
            2
        </event_severity>
        <event_override_flag>
            false
        </event_override_flag>
        <identities num="0"/>
        <categories num="0"/>
        <groups num="0"/>
        <target_appear_in_area>
            true
        </target_appear_in_area>
        <target_enter_area>
            true
        </target_enter_area>
        <target_leave_area>
            true
        </target_leave_area>
        <from_hour>
            0
        </from_hour>
        <from_minute>
            0
        </from_minute>
        <to_hour>
            23
        </to_hour>
        <to_minute>
            59
        </to_minute>
        <from_speed>
            0
        </from_speed>
        <to_speed>
            98.8889
        </to_speed>
        <weighting>
            <weight>
                <type>
                    2
                </type>
                <value>
                    99
                </value>
            </weight>
            <weight>
                <type>
                    204
                </type>
                <value>
                    99
                </value>
            </weight>
            <weight>
                <type>
                    205
                </type>
                <value>
                    99
                </value>
            </weight>
        </weighting>
        <visual_feedback>
            true
        </visual_feedback>
        <sound_repeats>
            -1
        </sound_repeats>
        <wave_file>
            C:\4C\RunTime\OWP\Sounds\sirenwawa.wav
        </wave_file>
        <utm_zone>
            40
        </utm_zone>
        <shape type="ClosedPolygon">
            <num_of_alloc_points>
                22
            </num_of_alloc_points>
            <num_of_points>
                6
            </num_of_points>
            <geo_position lat="40.76876678920284" long="-73.98097831075269"/>
            <geo_position lat="40.76869191861909" long="-73.98078254132794"/>
            <geo_position lat="40.76839192572469" long="-73.97999998924834"/>
            <geo_position lat="40.76749000414105" long="-73.97804528571041"/>
            <geo_position lat="40.76643902004108" long="-73.97593868227233"/>
            <utm_points x="132131" y="132131"/>
            <utm_points x="132131" y="132131"/>
            <utm_points x="132131" y="132131"/>
            <utm_points x="132131" y="132131"/>
            <utm_points x="132131" y="132131"/>
        </shape>
    </alert_area_object>
</layer>

[/code]

thanks again

Re: XML to Excel parsing

Not Active21-Aug-11 6:47

Not Active

21-Aug-11 6:47

Use XSLT to transform the XML and extract the data you need into the proper format.

I know the language. I've read a book. - _Madmatt

"The OP herself was not sure about her question"
"The OP is from India and I know what she meant." - Shameel

Re: XML to Excel parsing [modified]

yoni.kess23-Aug-11 9:31

yoni.kess

23-Aug-11 9:31

Hi,
this is the code i currently have but it parse the xml but is missing some nodes and is not exactly what i need.
i need that it will get the name of the alert and all the gps poings while with this code it takes most of the data except the gps points

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Xml;

namespace WindowsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            XmlDataDocument xmlDatadoc = new XmlDataDocument();
            xmlDatadoc.DataSet.ReadXml(@"C:\Desktop\Book Application\zone.xml");
            DataSet ds = new DataSet("book DataSet");
            ds = xmlDatadoc.DataSet;
            dataGridView1.DataSource = ds.DefaultViewManager;
            dataGridView1.DataMember = "alert_area_object";
        }
    }
}

thanks

modified on Thursday, August 25, 2011 3:04 AM

Re: XML to Excel parsing

Not Active23-Aug-11 9:53

Not Active

23-Aug-11 9:53

Edit this and use the code block toolbar item to properly format the code snippet.

I know the language. I've read a book. - _Madmatt

"The OP herself was not sure about her question"
"The OP is from India and I know what she meant."

Re: XML to Excel parsing

yoni.kess24-Aug-11 21:06

yoni.kess

24-Aug-11 21:06

anyone?

Pass object from an app to another

mehrdadc4820-Aug-11 23:50

mehrdadc48

20-Aug-11 23:50

I have a win app and a web app developed in .Net Framework 3.5.
I want to pass an object from web to win app.
I want the receiver app be notified from coming object and recive it.
What are the solutions?

Best wishes

Re: Pass object from an app to another

#realJSOP21-Aug-11 2:56

#realJSOP

21-Aug-11 2:56

Your options:

0) Write a web service that you then access from your desktop app (not kowing the specific details of the data being requested, or why it's being requested, this is the way I'd do it)

1) Write a new page on your web site that you can browse to that returns the data you want, and use the HTTPWebRequest object to browse to that web page.

You can't "push" to the desktop app because web services and web sites are request-driven, meaning the data is only returned when that data is requested.

".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass." - Dale Earnhardt, 1997

Re: Pass object from an app to another [modified]

Manfred Rudolf Bihy21-Aug-11 3:32

Manfred Rudolf Bihy

21-Aug-11 3:32

Please look into the Bayeux Protocol[^]. It was based on the idea of inverting the usual client request / server response paradigm. Of course the client still has to connect to the server and keep that connection open, but after that the server can push notifications/data to the client.
I'm not sure if there are any client side APIs that would let you use this in a WinForm application, but you could circumvent this by using a webbrowser control inside your WinForm application.

Best Regards,

—MRB

"With sufficient thrust, pigs fly just fine."

Ross Callon, The Twelve Networking Truths, RFC1925

modified on Monday, August 22, 2011 10:58 AM

Re: Pass object from an app to another

Keith Barrow21-Aug-11 9:23

Keith Barrow

21-Aug-11 9:23

This is an interesting answer (hence my vote of 5)! I was 404'd on the link, but this works: http://svn.cometd.com/trunk/bayeux/bayeux.html[^] the URL just needed an "l" on the ".html"

Sort of a cross between Lawrence of Arabia and Dilbert.[^]
-Or-
A Dead ringer for Kate Winslett[^]

Re: Pass object from an app to another

Manfred Rudolf Bihy21-Aug-11 20:50

Manfred Rudolf Bihy

21-Aug-11 20:50

Thanks Keith. It looks as if deep linking isn't allowed. I pasted in the link from the google page and now it works.

Cheers!

"With sufficient thrust, pigs fly just fine."

Ross Callon, The Twelve Networking Truths, RFC1925

TIP: Autosetting properties in C# using DefaultValue attributes

Itai Basel20-Aug-11 14:53

Itai Basel

20-Aug-11 14:53

Don't have the attention span to post as article - but thought this might be interesting:

Automatic properties are great but the annoyance of not being able to set them automatically defers a lot of people from using them.
What we (read - I) want to be able to do something like this:

double MyPie { get; set; } = "3.141";
string MyLove { get; set; } = "Pizza";

The default value attribute in System.ComponentModel is of no help there, though a lot of us (read - me) tried that in the beginning:

[DefaultValue(0.3141)]
double MyPie { get; set; }

[DefaultValue("Pizza")]
string MyLove { get; set; }

Initializing the properties one by one in the constructor is at least as annoying as simply doing this:

double _myPie = 0.3141;
double MyPie { get { return _myPie; } set { _myPie = value; } }

double _myLove = "Pizza";
double MyLove { get { return _myLove; } set { _myLove = value; } }

Luckily the nice little feature of extension methods allows us something not exactly optimal or fully elegant - but functional and a good exercise in C# clockwork.
So with just a bit of hammering we can enable automatic reset properties to their declared System.ComponentModel.DefaultValueAttribute if any was specified.
Test code:

using System;
using System.ComponentModel;
using System.Text;
using System.Windows.Forms;

using CSharpUtils;
namespace MyAppNamespace
{
  public class TestClass
  {
    [DefaultValue(0.3141)]
    public double MyPie { get; set; }

    [DefaultValue("Pizza")]
    public string MyLove { get; set; }

    public TestClass()
    {
      MessageBox.Show(string.Format("MyPie = {0}, MyLove = {1}", MyPie, MyLove == null ? "null" : MyLove));
      int ret = (this as Object).ResetPropsUsingDefaultAttributes(false);
      MessageBox.Show(string.Format("MyPie = {0}, MyLove = {1}. {2} properties we set", MyPie, MyLove == null ? "null" : MyLove, ret));
      MyLove = "My dear wife";
      MessageBox.Show(string.Format("MyPie = {0}, MyLove = {1}", MyPie, MyLove == null ? "null" : MyLove));
      ret = (this as Object).ResetPropsUsingDefaultAttributes(false);
      MessageBox.Show(string.Format("MyPie = {0}, MyLove = {1}. {2} properties we set", MyPie, MyLove == null ? "null" : MyLove, ret));
    }
  }
}

This (as you may have already guessed) is done using an extension method to the System.
You will need a public static class to define the extension method in. here's the basic implementation source (feel free to use the code and extend it's functionality):

using System;
using System.Text;
using System.Reflection;
using System.ComponentModel;

namespace CSharpUtils
{
  static class CSharpUtilsExtensionMethods
  {
    public static int ResetPropsUsingDefaultAttributes(this Object oThis, bool initInheritedProperties)
    {
      int count = 0;
      //BindingFlags.Static
      Type oType = oThis.GetType();
      PropertyInfo[] infos = oType.GetProperties(BindingFlags.NonPublic | BindingFlags.Public | BindingFlags.Instance);
      foreach (PropertyInfo inf in infos)
      {
        if (initInheritedProperties || inf.DeclaringType.Equals(oType))
        {
          object[] oDefAtts = inf.GetCustomAttributes(typeof(DefaultValueAttribute), initInheritedProperties);
          if (oDefAtts.Length > 0)
          {
            DefaultValueAttribute defAtt = oDefAtts[oDefAtts.Length - 1] as DefaultValueAttribute;
            if (defAtt != null && defAtt.Value != null && !defAtt.Value.Equals(inf.GetValue(oThis, BindingFlags.GetProperty, null, null, null)))
            {
              inf.SetValue(oThis, defAtt.Value, BindingFlags.SetProperty, null, null, null);
              count++;
            }
          }
        }
      }
      return count;
    }
  }
}

All that's left now is use out test class (here again - with no message box and other nonsense

using System;
using System.ComponentModel;
using System.Text;
using System.Windows.Forms;

using CSharpUtils;
namespace MyAppNamespace
{
  public class TestClass
  {
    [DefaultValue(0.3141)]
    public double MyPie { get; set; }

    [DefaultValue("Pizza")]
    public string MyLove { get; set; }


    public void ResetProps()
    {
      (this as Object).ResetPropsUsingDefaultAttributes(false);
    }
    public TestClass()
    {
      ResetProps();
    }
  }
}

Notes:
- To use the extension method - the .cs file making the call must have a 'using' declaration of namespace where the extension method resides in.
- Passing true for parameter initInheritedProperties also initializes any parent class properties - at the expense of possibly resetting already initialized properties. you can always extend the extension method to try and account for these cases.
- Resetting the properties in this manner works also outside constructor - anywhere in the program with the proper access.
- There's still the annoyance of having to add a line in the constructor - but it is just one line and will no require additional modifications if properties are added, removed or their type/default value is changed.

There you go,
have fun

Yours,
<><<br mode="hold" />Itai

Re: TIP: Autosetting properties in C# using DefaultValue attributes

Mycroft Holmes20-Aug-11 16:48

Mycroft Holmes

20-Aug-11 16:48

Itai Basel wrote:
Don't have the attention span to post as article

Then post it as a Tip/Trick[^]

where do these people come from?

[edit]
I see from the profile - a lurker for 8 years with never a message, impressive. Must have been a bitch trying to find your old password Poke tongue | ;-P

Do use the tip/trick area as it is specifically designed for those with limited attention spans and good ideas. They do get vetted and need to be released by a gold member but this one would have no problem at all. Keep it up!
[/edit]

Never underestimate the power of human stupidity
RAH

Re: TIP: Autosetting properties in C# using DefaultValue attributes

Itai Basel20-Aug-11 19:58

Itai Basel

20-Aug-11 19:58

Thanks.
I always plan to post cool stuffs but never do due to having to go through all that publishing a web-page for it.. Never been much of a writer and am not a native English speaker so I always find out afterward that I written something funny too.
I'll go look where the tips&tricks area is.

Yours,
<><<br mode="hold" />Itai

Re: TIP: Autosetting properties in C# using DefaultValue attributes

Itai Basel20-Aug-11 20:09

Itai Basel

20-Aug-11 20:09

And about remembering the password - no worries - since I need it to download sources.
Anyway - I posted as top/trick. now I need to change the awkward signature since it's got html symbols in it and looks weird after it's posted Smile | :)

Yours,
<><<br mode="hold" />Itai

Re: TIP: Autosetting properties in C# using DefaultValue attributes

Mycroft Holmes20-Aug-11 22:35

Mycroft Holmes

20-Aug-11 22:35

I'm just glad you weren't discouraged by a grumpy old bugger on a Sunday morning!

There is a definite warm, fuzzy feeling when you see your contribution put to use by others, it's the main reason why this site works I think, people actually do want to help.

Never underestimate the power of human stupidity
RAH

Re: TIP: Autosetting properties in C# using DefaultValue attributes

PIEBALDconsult20-Aug-11 19:57

PIEBALDconsult

20-Aug-11 19:57

I second it as a tip/trick, or at least as a blog entry.

Thumbs Up | :thumbsup:

Re: TIP: Autosetting properties in C# using DefaultValue attributes

thatraja20-Aug-11 21:40

thatraja

20-Aug-11 21:40

Agree with others. Based on length better post it as a blog post. If possible attach download for the source code.

Off Topic:
I found broken text in your signature.

thatraja

My Tip/Tricks
My Dad had a Heart Attack on this day so don't...

All these are my opinions. Different people. different way of thinking. I am no one to judge others - Chandru

Showing Picture in Crystal Reports from Table

M Riaz Bashir20-Aug-11 11:26

M Riaz Bashir

20-Aug-11 11:26

hi all

I have uploaded a picture into table but i am stuck, that how may I show the picture in Crystal Reports from table.

I used following codes to upload the picture it works fine

// load the file that we want to upload into memory
fileStream = new System.IO.FileStream(strFile, System.IO.FileMode.Open, System.IO.FileAccess.Read);
reader = new System.IO.BinaryReader(fileStream);
data = reader.ReadBytes((int)fileStream.Length);

// open the connection to the database
//conn = new System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + AccessFile.Text);
//conn.Open();

// determine if the file already exists.  If the file does not already
// exist, add the file to the table.
cmd = new OleDbCommand();
cmd.Connection = Module.objConnection;
string strQuery =
    "SELECT * FROM PICTURES WHERE " +
    "STCODE="+ textBox1.Text +" AND " +
    "STSEQ="+ dataGridView1["STSEQ",dataGridView1.CurrentCell.RowIndex].Value.ToString() +"  ";
cmd.CommandText = strQuery;
dr = cmd.ExecuteReader();
if (dr.HasRows == false)
{
    dr.Close();
    cmd.CommandText = "INSERT INTO PICTURES (STCODE,STRNO,STSEQ,FILENAME,FILESIZE,FILETYPE) " +
        "VALUES(" + textBox1.Text + ", " +
        "" + dataGridView1["STRNO", dataGridView1.CurrentCell.RowIndex].Value.ToString() + ", " +
        "" + dataGridView1["STSEQ", dataGridView1.CurrentCell.RowIndex].Value.ToString() + ", " +
        "'" + fileName + "'," + data.Length + ",'" + type + "') ";
    //cmd.CommandText = "INSERT INTO PICTURES (STCODE,STRNO,STSEQ,FILENAME,FILETYPE) " +
    //    "VALUES(" + textBox1.Text + ", " +
    //    "" + dataGridView1["STRNO", dataGridView1.CurrentCell.RowIndex].Value.ToString() + ", " +
    //    "" + dataGridView1["STSEQ", dataGridView1.CurrentCell.RowIndex].Value.ToString() + ",'" + textBox1.Text.Trim() + "_" + textBox2.Text.Trim() + "." + type + "') ";
    //    //"'" + fileName + "'," + data.Length + ",'" + type + "') ";

    cmd.ExecuteNonQuery();

(Riaz)

Re: Showing Picture in Crystal Reports from Table

thatraja20-Aug-11 21:35

thatraja

20-Aug-11 21:35

Already answered similar question in Q/A section here before, see that.

Crystal Report - Images[^]
Printing photo on crystal report[^]
Dynamically setting picture path in crystal report[^]
Crystal Report Reading Picture file from path c: directory[^]

thatraja

My Tip/Tricks
My Dad had a Heart Attack on this day so don't...

All these are my opinions. Different people. different way of thinking. I am no one to judge others - Chandru

How to decode Certificate Signing Request (CSR) in XP [modified]

Petri Luoto20-Aug-11 9:03

Petri Luoto

20-Aug-11 9:03

I need to decode CSR message (pkcs#10) to solve different kind of broblems in it.

The following piece of code works fine, but unfortunately only in vista and windows7, which uses Certenroll.lib. My code will be used also in XP, why I have included Xenroll.lib into my code as well. But what is the respective piece of code using xenroll to decode pkcs#10 request?

if (Environment.OSVersion.Version.Major >= 6)
            {
CX509CertificateRequestPkcs10 request = new CX509CertificateRequestPkcs10();
request.InitializeDecode(txtP10.Text, EncodingType.XCN_CRYPT_STRING_BASE64_ANY);                    request.CheckSignature(Pkcs10AllowedSignatureTypes.AllowedKeySignature);
lblSubject.Text = "Subject:" + (((CX500DistinguishedName)request.Subject).Name);
lblKeyLenght.Text = "Key length:" + (request.PublicKey.Length);
lblAlgorithm.Text = "Algorithm:" + (request.HashAlgorithm.FriendlyName);
}
else
{ // how to decode pkcs#10 in XP?
}

Thanks for any help!

modified on Wednesday, August 24, 2011 1:44 PM

Last Visit: 31-Dec-99 18:00 Last Update: 13-May-24 7:40

Refresh

ᐊ Prev 1...2424 2425 2426 242724282429 2430 2431 2432 2433 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.