Re: Is it possible to set xsd-schema during serialization? - C# Discussion Boards

netJP12L1-Mar-07 5:06

1-Mar-07 5:06

Put "Like" keyword in your select query and pass different parameters i.e syntax may not be write: Select * from Like="AAA",Like"BBB";

Re: help me with search code

luckyve1-Mar-07 5:18

luckyve

1-Mar-07 5:18

netJP12L wrote:
Put "Like" keyword in your select query and pass different parameters i.e syntax may not be write: Select * from Like="AAA",Like"BBB";

sorry I didnt understand ...
What does "like" do ??
What is "AAA" or "BBB" ...?
I want this search form to work with any word...like codeporject's search ...
plz help me

Re: help me with search code

luckyve1-Mar-07 5:14

luckyve

1-Mar-07 5:14

Yes,Sorry I forgot to say..
My Database is SQLServer 2000
plz help

Re: help me with search code

netJP12L1-Mar-07 8:16

netJP12L

1-Mar-07 8:16

You need to set a criteria for how a particular thing will be searched out in your database.
Like is a keyword that tells the query look for something that i am passing in the parameter. Like keyword is different than Equal or ==. As Obvisouly, equal mean look exactly what I need to search.

SELECT *
FROM QUESTION_PARENT
WHERE (PTYPE LIKE 'searchCriteria')

Is it possible to set xsd-schema during serialization?

Ptmk1-Mar-07 2:34

Ptmk

1-Mar-07 2:34

Is it possible to set xsd-schema during serialization?

The problem is:

1. I have xsd-schema, for example

<<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementformdefault="qualified" attributeformdefault="unqualified">
<<xs:element name="Mass">
<<xs:complextype>
<<xs:sequence>
<<xs:element name="Gross">
<<xs:simpletype>
<<xs:restriction base="xs:decimal">
<<xs:totaldigits value="12">
<<xs:fractiondigits value="3">
<
<
<
<<xs:element name="Net">
<<xs:simpletype>
<<xs:restriction base="xs:decimal">
<<xs:totaldigits value="7">
<<xs:fractiondigits value="4">
<
<
<
<
<
<
<

In this schama two elements are of decimal type, and they have a template for fractional part.

2. Generate class by schema:

public partial class Mass {<br />
<br />
    private decimal grossField;<br />
    private decimal netField;<br />
<br />
    public decimal Gross <br />
    {<br />
        get {return this.grossField;}<br />
        set {this.grossField = value;}<br />
    }<br />
<br />
    public decimal Net <br />
    {<br />
        get {return this.netField;}<br />
        set {this.netField = value;}<br />
    }<br />
}

3. Do the serialization:

	public void Test()<br />
	{<br />
		Mass mass = new Mass();<br />
		mass.Gross = 100.1M;<br />
		mass.Net = 7.7M;<br />
<br />
		XmlSerializer serializer = new XmlSerializer(typeof(Mass));<br />
		TextWriter writer = new StreamWriter("res.xml");<br />
		serializer.Serialize(writer, mass);<br />
		writer.Close();<br />
	}

4. Get the result:

<<mass xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<<gross>100.1
<<net>7.7
<

The problem is:
I need the elements of decimal type would correspond the template.
That is I need the result as:

<<mass xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<<gross>100.100
<<net>7.7000
<
That is I need the elements have the fractional part as indicated in the xsd-schema.

May be it is possible to solve the problem by using special attributes for elements?

Thanks in Advance
Victor

Re: Is it possible to set xsd-schema during serialization?

Stefan Troschuetz1-Mar-07 2:58

Stefan Troschuetz

1-Mar-07 2:58

I pretty sure you need to implement the IXmlSerializable interface to achieve what you want.

"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook

www.troschuetz.de

Re: Is it possible to set xsd-schema during serialization?

Ptmk1-Mar-07 18:37

Ptmk

1-Mar-07 18:37

>>I pretty sure you need to implement the IXmlSerializable interface to achieve what you want.

It seems to be that I want!

Thanks a lot!

Re: Is it possible to set xsd-schema during serialization?

Ennis Ray Lynch, Jr.1-Mar-07 6:37

Ennis Ray Lynch, Jr.

1-Mar-07 6:37

I don't think the fractional parts is a requirement but a restriction. 4, 4.0, 4.00, 4.000, and 4.000 would all be valid according to the XSD schema.

If you are really picky add some attributes to the Gross property

System.Xml.Serialization.XmlElement("Gross")
System.Xml.Serialization.XmlType("decimal")

and then modify the property as required (ie return a string)

BTW, I keep saying this because I am an ass but xml elements should be camelCase.

File Not Found

Re: Is it possible to set xsd-schema during serialization?

Ptmk1-Mar-07 18:38

Ptmk

1-Mar-07 18:38

Surely values 4, 4.0, 4.00, 4.000 would all be valid according to the XSD schema.
But I need formatting according XSD schema Smile | :)

Unfortunately, I can't change the type from decimal to string - type of elements must be decimal.

Thanks for help!

You misunderstand

Ennis Ray Lynch, Jr.1-Mar-07 18:43

Ennis Ray Lynch, Jr.

1-Mar-07 18:43

Changing the type of the property but adding the name and type attributes allows you additional formatting over the type. You can return a string and tell the serializer it is a decimal and it will believe you.

File Not Found

Re: You misunderstand

Ptmk1-Mar-07 19:52

Ptmk

1-Mar-07 19:52

Yes! It works!
I can't change the type of the values of object Mass,
but I can add other values for serialization only.
As a result, I can use values of decimal type inside my code,
but when I need serialization I will use wrap-properties for my decimal values.

public partial class Mass<br />
{<br />
	private decimal grossField;<br />
	private decimal netField;<br />
<br />
	[XmlIgnore]<br />
	public decimal Gross<br />
	{<br />
		get{return this.grossField;}<br />
		set{this.grossField = value;}<br />
	}<br />
<br />
	[XmlElement("Gross")]<br />
	public string GrossAsString<br />
	{<br />
		get{return Utils.DecimalToString(this.grossField,3);}<br />
		set{this.grossField = Convert.ToDecimal(value);}<br />
	}<br />
<br />
	[XmlIgnore]<br />
	public decimal Net<br />
	{<br />
		get{return this.netField;}<br />
		set{this.netField = value;}<br />
	}<br />
<br />
	[XmlElement("Net")]<br />
	public string NetAsString<br />
	{<br />
		get {return Utils.DecimalToString(this.netField, 4);}<br />
		set {this.netField = Convert.ToDecimal(value);}<br />
	}<br />
}

public class Utils
{
	private const string PATTERN = "########################################.";

	public static string DecimalToString(decimal d, int precision)
	{
		return d.ToString(PATTERN.PadRight(PATTERN.Length + precision, '0'));
	}
}

Thanks a lot!

Re: You misunderstand

Ennis Ray Lynch, Jr.1-Mar-07 20:01

Ennis Ray Lynch, Jr.

1-Mar-07 20:01

d.ToString("#.0000") should work with d as a decimal

File Not Found

Re: You misunderstand

Ptmk2-Mar-07 0:17

Ptmk

2-Mar-07 0:17

Thanks

Opening an application on remote machine ....

Saaaaz1-Mar-07 2:26

Saaaaz

1-Mar-07 2:26

I actually want to open Notepad on a remote machine.

By writing the following code, I am able to run it, but the problem is that is runs in background. I can only see it by opening up the windows task manager.

ConnectionOptions objConnectionOptions = new ConnectionOptions();<br />
objConnectionOptions.Impersonation = ImpersonationLevel.Impersonate;<br />
objConnectionOptions.EnablePrivileges = true;<br />
objConnectionOptions.Username = strUserName;<br />
objConnectionOptions.Password = strPassword;<br />
ManagementScope objManagementScope = new ManagementScope(@"\\remote-computer-name\ROOT\CIMV2", objConnectionOptions);<br />
objManagementScope.Connect();<br />
            <br />
ManagementClass processClassFinal = new ManagementClass(objManagementScope, new ManagementPath("Win32_Process"), null);<br />
ManagementBaseObject inParamsFinal = processClassFinal.GetMethodParameters("Create");<br />
inParamsFinal["CommandLine"] = @"c:\windows\notepad.exe";<br />
ManagementBaseObject outParamsFinal = processClassFinal.InvokeMethod("Create", inParamsFinal, null);

Is there anyone who could help me in sorting out this problem

Thanks.

Sarfraz

Re: Opening an application on remote machine ....

Dave Kreskowiak1-Mar-07 6:39

Dave Kreskowiak

1-Mar-07 6:39

I already told you[^] WMI cannot be used to launch a remote interactive process. It's a huge security risk.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Form holding

hiremath711-Mar-07 2:23

hiremath71

1-Mar-07 2:23

hi,

I don no how to frame a question for this problem.

e,g.I am having two forms like fr1,fr2 and one button bt1.

through fr1 bt1 click event i wil open fr2.

my question is unless I close the fr2 i should get acees to fr1.

Pls help me..

With Regards
Prasad Smile | :)

Re: Form holding

Obaid ur Rehman1-Mar-07 2:31

Obaid ur Rehman

1-Mar-07 2:31

hiremath71 wrote:
my question is unless I close the fr2 i should get acees to fr1.

Instead of using fr2object.Show() method use fr2object.ShowDialog(this)

Re: Form holding

Stefan Troschuetz1-Mar-07 2:32

Stefan Troschuetz

1-Mar-07 2:32

I'm not sure I really understood what you want, but I'll give it a try.
In case, you want the user to be able to access form1 while form2 is open, use the Show method to open form2. Otherwise use the ShowDialog method.

Getting the screen resolution

Icarus1231-Mar-07 2:09

Icarus123

1-Mar-07 2:09

I am using C# together with ASP.net.

I need to check if the screen resolution is equal or bigger than 1024 x 768, if not so, the page wil display a message that wil inform the user to change his res.

Thanks
Icarus

Re: Getting the screen resolution

Stefan Troschuetz1-Mar-07 2:29

Stefan Troschuetz

1-Mar-07 2:29

This question has better chances to be answered in the ASP.NET forum.

Re: Getting the screen resolution

Scott Dorman1-Mar-07 16:07

Scott Dorman

1-Mar-07 16:07

I don't think this is going to work as the C# code is going to be running on the server, not the client. You need to look at one of the client side scripting technologies, like JavaScript, but I'm not sure it's possible.

The better question is why does your web app require that high of a resolution?

-----------------------------
In just two days, tomorrow will be yesterday.

read from file

shereem khaleel1-Mar-07 1:56

shereem khaleel

1-Mar-07 1:56

i have an RMS file 7-bit
how i can read it ???????????

Re: read from file

Colin Angus Mackay1-Mar-07 2:03

Colin Angus Mackay

1-Mar-07 2:03

With a FileStream... However, your problem will be how to interpret it.

Upcoming events:
* Glasgow: Geek Dinner (5th March)
* Edinburgh: Web Security Conference Day for Windows Developers (12th April)

My: Website | Blog | Photos

Querry regarding DirListBox control

s_123451-Mar-07 1:34

s_12345

1-Mar-07 1:34

Hi,
I have one c# application in which I am using a DirListBox control.Its working finely but I am not getting a way for retrieving the elements of the control.Like - If I want some ith element from the DirListBox to compare it with some string and then continue with some action.Any idea would be helpful to me.

Events in an interface

jdkulkarni1-Mar-07 1:10

jdkulkarni

1-Mar-07 1:10

One simple question,
if an event is declared like a field of delegate type, except that the keyword event precedes the event declaration how can an interface contain a type declaration?

Jayant D. Kulkarni

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