WDSL Jagged array problem C# .net - C# Discussion Boards

SessionStateItemCollection.Dirty

4-Sep-07 23:38

This will help you: http://www.codeproject.com/dotnet/NGif.asp
As for movie, you will need DirectX as I guess but I'm not sure as I'm not experienced in that field

#region signature
my articles
#endregion

73amit4-Sep-07 23:17

73amit

4-Sep-07 23:17

Hi,
I want to check that any of the property on from related to controls is changed or not.
How can i do it in C#.
Plz mail as soon as possible.

Amit Verma
73amit@gmail.com

WDSL Jagged array problem C# .net

sander BB4-Sep-07 23:09

sander BB

4-Sep-07 23:09

Hello,

i have a problem with retrieving a jagged array from my webservice the array looks like this:

Array ( [0] => Array ( [0] => id [1] => int(11) [2] => YES [3] => [4] => ) [1] => Array ( [0] => name [1] => varchar(255) [2] => YES [3] => [4] => ) )

SyncITSoap SyncITSoap = new SyncITSoap();

object columns = SyncITSoap.getColumns("", "", "syncit","test");

error message when the methode is called getColumns = {"The specified type was not recognized: name='Columns', namespace='http://server.e-ss.nl:8100/service', at <columns xmlns=''>."}

can somebody help me out? thx in advance

wdsl is this:

WDSL Jagged array problem

<?xml version="1.0" encoding="utf-8"?>
<definitions
name="SyncIT"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/"
xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/"
targetNamespace="http://server.e-ss.nl:8100/service"
xmlns:tns="http://server.e-ss.nl:8100/service"
xmlns="http://schemas.xmlsoap.org/wsdl/">

<types>
<xsd:schema targetNamespace="http://server.e-ss.nl:8100/service" xmlns:impl="http://server.e-ss.nl:8100/service" xmlns="http://www.w3.org/2001/XMLSchema">
<xsd:complexType name="Database">
<xsd:all>
<xsd:element name="name" type="xsd:string"/>
</xsd:all>
</xsd:complexType>
<xsd:complexType name="DatabaseArray">
<xsd:complexContent mixed="false">
<xsd:restriction base="soapenc:Array">
<xsd:attribute foobar:arrayType="tns:Database[]" ref="soapenc:arrayType" xmlns:foobar="http://schemas.xmlsoap.org/wsdl/"/>
</xsd:restriction>
</xsd:complexContent>
</xsd:complexType>
<xsd:complexType name="Table">
<xsd:all>
<xsd:element name="name" type="xsd:string"/>
</xsd:all>
</xsd:complexType>
<xsd:complexType name="TableArray">
<xsd:complexContent mixed="false">
<xsd:restriction base="soapenc:Array">
<xsd:attribute foobar:arrayType="tns:Table[]" ref="soapenc:arrayType" xmlns:foobar="http://schemas.xmlsoap.org/wsdl/"/>
</xsd:restriction>
</xsd:complexContent>
</xsd:complexType>
<xsd:complexType name="Columns">
<xsd:complexContent mixed="false">
<xsd:restriction base="soapenc:Array">
<xsd:attribute foobar:arrayType="xsd:string[]" ref="soapenc:arrayType" xmlns:foobar="http://schemas.xmlsoap.org/wsdl/"/>
</xsd:restriction>
</xsd:complexContent>
</xsd:complexType>
<xsd:complexType name="ColumnArray">
<xsd:complexContent mixed="false">
<xsd:restriction base="soapenc:Array">
<xsd:attribute foobar:arrayType="tns:Columns[]" ref="soapenc:arrayType" xmlns:foobar="http://schemas.xmlsoap.org/wsdl/"/>
</xsd:restriction>
</xsd:complexContent>
</xsd:complexType>
</xsd:schema>
</types>

<message name="getDatabasesRequest">
<part name="login" type="xsd:string"/>
<part name="password" type="xsd:string"/>
</message>

<message name="getDatabasesResponse">
<part name="databases" type="tns:DatabaseArray"/>
</message>

<message name="getTablesRequest">
<part name="login" type="xsd:string"/>
<part name="password" type="xsd:string"/>
<part name="db" type="xsd:string"/>
</message>

<message name="getTablesResponse">
<part name="tables" type="tns:TableArray"/>
</message>

<message name="getColumnsRequest">
<part name="login" type="xsd:string"/>
<part name="password" type="xsd:string"/>
<part name="db" type="xsd:string"/>
<part name="table" type="xsd:string"/>
</message>

<message name="getColumnsResponse">
<part name="columns" type="tns:ColumnArray"/>
</message>

<portType name="SyncITPort">
<operation name="getDatabases">
<input message="tns:getDatabasesRequest"/>
<output message="tns:getDatabasesResponse"/>
</operation>
<operation name="getTables">
<input message="tns:getTablesRequest"/>
<output message="tns:getTablesResponse"/>
</operation>
<operation name="getColumns">
<input message="tns:getColumnsRequest"/>
<output message="tns:getColumnsResponse"/>
</operation>
</portType>

<binding name="SOAP" type="tns:SyncITPort">
<soap:binding style="rpc" transport="http://schemas.xmlsoap.org/soap/http"/>
<operation name="getDatabases">
<soap:operation soapAction="urn:syncitsoap#getDatabases"/>
<input>
<soap:body use="encoded" namespace="urn:syncitsoap" encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"/>
</input>
<output>
<soap:body use="encoded" namespace="urn:syncitsoap" encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"/>
</output>
</operation>
<operation name="getTables">
<soap:operation soapAction="urn:syncitsoap#getTables"/>
<input>
<soap:body use="encoded" namespace="urn:syncitsoap" encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"/>
</input>
<output>
<soap:body use="encoded" namespace="urn:syncitsoap" encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"/>
</output>
</operation>
<operation name="getColumns">
<soap:operation soapAction="urn:syncitsoap#getColumns"/>
<input>
<soap:body use="encoded" namespace="urn:syncitsoap" encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"/>
</input>
<output>
<soap:body use="encoded" namespace="urn:syncitsoap" encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"/>
</output>
</operation>
</binding>

<service name="SyncITSoap">
<port name="SyncITPort" binding="tns:SOAP">
<soap:address location="http://server.e-ss.nl:8100/service/service.php"/>
</port>
</service>

</definitions>

Region

Assaf824-Sep-07 23:03

Assaf82

4-Sep-07 23:03

How to create region in C#

Assaf

Re: Region

Giorgi Dalakishvili4-Sep-07 23:14

4-Sep-07 23:14

Region myregion=new Region();

#region signature
my articles
#endregion

Re: Region

hotcodeking5-Sep-07 1:48

hotcodeking

5-Sep-07 1:48

Region can be created easily
u can use the following code

#region "TestRegion"

Codes - Methods and functions

#end region

Gokul - MCSD:MCAD:MCP - Technical Lead - GFT INDIA

exporting data to excel

lourensG4-Sep-07 23:01

4-Sep-07 23:01

hi everyone I want to export data on my form that I got from a database to excel, I am working in C#. I have checked an example on code project but it doesnt help me. Thanks

Giorgi Dalakishvili4-Sep-07 23:16

4-Sep-07 23:16

Did you have a look at this: ExportToExcel[^]

#region signature
my articles
#endregion

lourensG4-Sep-07 23:42

4-Sep-07 23:42

thank you but isnt there an easier way? I dont want to work with xml files. thanks again

Giorgi Dalakishvili4-Sep-07 23:51

4-Sep-07 23:51

You can use excel object library to convert the generated file to excel native format

#region signature
my articles
#endregion

lourensG5-Sep-07 0:04

5-Sep-07 0:04

I dont know how to do that sorry Im still new with programming so I dont know alot can you maybe send me some code if its possible please. Thanks again

Giorgi Dalakishvili5-Sep-07 0:13

5-Sep-07 0:13

You can use that article to generate xml file and then convert it to xls using this piece of code:

 <br />
private void savetoexcelformat(string currentpath, string pathtosave)<br />
{<br />
object missing = System.Reflection.Missing.Value;<br />
<br />
Excel.Application app = new Excel.Application();<br />
app.Visible = false;<br />
<br />
app.Workbooks.OpenXML(currentpath, missing,missing).SaveAs(pathtosave, Excel.XlFileFormat.xlWorkbookNormal, missing, missing,<br />
missing, missing, Excel.XlSaveAsAccessMode.xlNoChange, missing, missing, missing, missing, missing);<br />
app.Quit();<br />
<br />
}

#region signature
my articles
#endregion

lourensG5-Sep-07 0:16

how to assign a Shortcut key for an Application ONLY in C#?

5-Sep-07 0:16

Thanks for your help Ill try that. kind regards

txtBox_Leave

Assaf824-Sep-07 22:56

Assaf82

4-Sep-07 22:56

The leave event occure when i push the tab button
What happen with me is when i put the first digit the leave event is called

this the code:
private void txtNewExpDate3_Leave(object sender, EventArgs e)
{
string val = this.txtNewExpDate3.Text;
if (this.txtNewExpDate3.TextLength.Equals(1))
this.txtNewExpDate3.Text = "0" + val;
}
and the MaxLength for the txtNewExpDate3 is 2

I do the same code is the same event in other textbox and it work properly.

Thanks in advance

Assaf

Re: txtBox_Leave

I.explore.code5-Sep-07 0:05

I.explore.code

5-Sep-07 0:05

Hi Assaf

I tried to recreate the bug you stated...but on my machine the code given by u works just fine..i.e. only when u press "TAB" key, does the leave event fire and not in any other case..please retest your code.

thanks and regards

pdoy07084-Sep-07 22:21

pdoy0708

4-Sep-07 22:21

Hello sir/s, im pj.. how can i assign a shortcut key on a certain button, instead of putting an Ampersand ("&") besides the text of the button.. For exampe.. instead of pressing ALT + (the access key) for a button.. i would like only a single key.. like "ENTER" key to be associated with a certain button.. please Give me a sample code or any directions.. Thank you so much..

Giorgi Dalakishvili4-Sep-07 22:28

4-Sep-07 22:28

Trap the key you are interested in and invoke the event handler for the button or menu item

#region signature
my articles
#endregion

pdoy07084-Sep-07 22:34

pdoy0708

4-Sep-07 22:34

Sir, Thank you so much for replying on my message. Can you give me a sample code? I'm really having a hard time figuring out the event handlers, because i tried putting up some codes on the "KeyPress" event, but i only ended up having more errors. Thank you again sir.

Giorgi Dalakishvili4-Sep-07 22:44

4-Sep-07 22:44

What errors are you getting? You can check it like this:

<br />
private void Form1_KeyPress(object sender, KeyPressEventArgs e)<br />
       {<br />
           if (e.KeyChar == (char)Keys.A)<br />
           {<br />
             //A was pressed<br />
           }<br />
<br />
           if (e.KeyChar == (char)Keys.B)<br />
           {<br />
             //B was pressed<br />
           }<br />
       }<br />

#region signature
my articles
#endregion