returning dataset from webservice

G

Guest

I am trying to return a dataset from webservice.The webservice is called from
WindowCE.Net application running on the emulator.when the dataset get
returned there is no data in the dataset.where as when i debug the webservice
there is data in dataset.

please help as it is very importnat to me.

the Webservice namespace and the Client application namespace is different,.

Regards
Farrukh
 
I

Ilya Tumanov [MS]

I would suspect you're eating an exception on a call to WS.

Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
 
G

Guest

i didnot get u
i am attaching the code of webservice and the client application

so please help me

code from Aplication

Service1 ser=new Service1();

DataSet d=new DataSet();

try
{
d=ser.GetTransactionDetails(CardDetails.getCardNumber());
}
catch(Exception e1)
{

}
TransactionGrid.DataSource=d.Tables["Transactions"];


code from webservice

SqlConnection myConnection = new
SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);

string encrptedcardno=Security.Encrypt(card_no);

string myquery="Select Transaction_time,Amount,Trans_Description from
Transactions where Card_no='"+encrptedcardno+"'";


SqlDataAdapter DA=new SqlDataAdapter(myquery,myConnection);

myConnection.Open();


DataSet ds=new DataSet();

DA.Fill(ds,"Transactions");

return ds;



Regards
Farrukh

"Ilya Tumanov [MS]" said:
I would suspect you're eating an exception on a call to WS.

Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
Thread-Topic: returning dataset from webservice
thread-index: AcShT8KpMsUmbLIbSACnZT+pmd1mVg==
X-WBNR-Posting-Host: 131.170.90.3
From: "=?Utf-8?B?ZmFycnVraCBuYWVlbQ==?=" <farrukh (e-mail address removed)>
Subject: returning dataset from webservice
Date: Thu, 23 Sep 2004 02:29:01 -0700
Lines: 11
Message-ID: <[email protected]>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.dotnet.framework.compactframework
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.compactframework:61863
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework

I am trying to return a dataset from webservice.The webservice is called from
WindowCE.Net application running on the emulator.when the dataset get
returned there is no data in the dataset.where as when i debug the webservice
there is data in dataset.

please help as it is very importnat to me.

the Webservice namespace and the Client application namespace is different,.

Regards
Farrukh
Click to expand...
Click to expand...
 
I

Ilya Tumanov [MS]

As I suspected, you are "eating" exception. You see, if WS throw for any
reason, your code would catch it and ignore it.
Exceptions are not warnings you could ignore, they usually are catastrophic
failures.
You should process the exception and take corrective action instead.
At least, print out exception type and error message if any to figure out
what's wrong.
Most likely you would get some sort of network error caused by incorrect
networking setup.

try
{
d=ser.GetTransactionDetails(CardDetails.getCardNumber());
}
catch(Exception e1)
{
// WRONG !!! Add error handling here.
}


Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
Thread-Topic: returning dataset from webservice
thread-index: AcSh2uc/KkPufBjZTwS1/EcdAYOSnw==
X-WBNR-Posting-Host: 210.23.132.208
From: "=?Utf-8?B?ZmFycnVraCBuYWVlbQ==?="
Click to expand...
References: <[email protected]>
Click to expand...
Subject: RE: returning dataset from webservice
Date: Thu, 23 Sep 2004 19:05:02 -0700
Lines: 101
Message-ID: <[email protected]>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.dotnet.framework.compactframework
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.compactframework:61927
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework

i didnot get u
i am attaching the code of webservice and the client application

so please help me

code from Aplication

Service1 ser=new Service1();

DataSet d=new DataSet();

try
{
d=ser.GetTransactionDetails(CardDetails.getCardNumber());
}
catch(Exception e1)
{

}
TransactionGrid.DataSource=d.Tables["Transactions"];


code from webservice

SqlConnection myConnection = new
SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);

string encrptedcardno=Security.Encrypt(card_no);

string myquery="Select Transaction_time,Amount,Trans_Description from
Transactions where Card_no='"+encrptedcardno+"'";


SqlDataAdapter DA=new SqlDataAdapter(myquery,myConnection);

myConnection.Open();


DataSet ds=new DataSet();

DA.Fill(ds,"Transactions");

return ds;



Regards
Farrukh

"Ilya Tumanov [MS]" said:
I would suspect you're eating an exception on a call to WS.

Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
Thread-Topic: returning dataset from webservice
thread-index: AcShT8KpMsUmbLIbSACnZT+pmd1mVg==
X-WBNR-Posting-Host: 131.170.90.3
From: "=?Utf-8?B?ZmFycnVraCBuYWVlbQ==?=" <farrukh (e-mail address removed)>
Subject: returning dataset from webservice
Date: Thu, 23 Sep 2004 02:29:01 -0700
Lines: 11
Message-ID: <[email protected]>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.dotnet.framework.compactframework
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.compactframework:61863
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework

I am trying to return a dataset from webservice.The webservice is
Click to expand...
called
from
WindowCE.Net application running on the emulator.when the dataset get
returned there is no data in the dataset.where as when i debug the webservice
there is data in dataset.

please help as it is very importnat to me.

the Webservice namespace and the Client application namespace is different,.

Regards
Farrukh
Click to expand...
Click to expand...
Click to expand...
 
G

Guest

actaully when i debug the it doesnot come in the catch block.

so what could be the problem

please help me
Regards
Farrukh

"Ilya Tumanov [MS]" said:
As I suspected, you are "eating" exception. You see, if WS throw for any
reason, your code would catch it and ignore it.
Exceptions are not warnings you could ignore, they usually are catastrophic
failures.
You should process the exception and take corrective action instead.
At least, print out exception type and error message if any to figure out
what's wrong.
Most likely you would get some sort of network error caused by incorrect
networking setup.

try
{
d=ser.GetTransactionDetails(CardDetails.getCardNumber());
}
catch(Exception e1)
{
// WRONG !!! Add error handling here.
}


Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
Thread-Topic: returning dataset from webservice
thread-index: AcSh2uc/KkPufBjZTwS1/EcdAYOSnw==
X-WBNR-Posting-Host: 210.23.132.208
From: "=?Utf-8?B?ZmFycnVraCBuYWVlbQ==?="
Click to expand...
References: <[email protected]>
Click to expand...
Subject: RE: returning dataset from webservice
Date: Thu, 23 Sep 2004 19:05:02 -0700
Lines: 101
Message-ID: <[email protected]>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.dotnet.framework.compactframework
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.compactframework:61927
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework

i didnot get u
i am attaching the code of webservice and the client application

so please help me

code from Aplication

Service1 ser=new Service1();

DataSet d=new DataSet();

try
{
d=ser.GetTransactionDetails(CardDetails.getCardNumber());
}
catch(Exception e1)
{

}
TransactionGrid.DataSource=d.Tables["Transactions"];


code from webservice

SqlConnection myConnection = new
SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);

string encrptedcardno=Security.Encrypt(card_no);

string myquery="Select Transaction_time,Amount,Trans_Description from
Transactions where Card_no='"+encrptedcardno+"'";


SqlDataAdapter DA=new SqlDataAdapter(myquery,myConnection);

myConnection.Open();


DataSet ds=new DataSet();

DA.Fill(ds,"Transactions");

return ds;



Regards
Farrukh

"Ilya Tumanov [MS]" said:
I would suspect you're eating an exception on a call to WS.

Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
Thread-Topic: returning dataset from webservice
thread-index: AcShT8KpMsUmbLIbSACnZT+pmd1mVg==
X-WBNR-Posting-Host: 131.170.90.3
From: "=?Utf-8?B?ZmFycnVraCBuYWVlbQ==?=" <farrukh
(e-mail address removed)>
Subject: returning dataset from webservice
Date: Thu, 23 Sep 2004 02:29:01 -0700
Lines: 11
Message-ID: <[email protected]>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.dotnet.framework.compactframework
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: cpmsftngxa06.phx.gbl
microsoft.public.dotnet.framework.compactframework:61863
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework

I am trying to return a dataset from webservice.The webservice is called
from
WindowCE.Net application running on the emulator.when the dataset get
returned there is no data in the dataset.where as when i debug the
webservice
there is data in dataset.

please help as it is very importnat to me.

the Webservice namespace and the Client application namespace is
different,.

Regards
Farrukh
Click to expand...
Click to expand...
Click to expand...
 
I

Ilya Tumanov [MS]

1. Add a dialog box into catch block which would print exception type and
message to make sure you do not have an exception.
2. Save received dataset to the XML with schema to see what exactly you're
getting from WS. Perhaps, table name is different.

Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
Thread-Topic: returning dataset from webservice
thread-index: AcSi/uCuOWqGfrY2TFSvYPcEuBmx9A==
X-WBNR-Posting-Host: 210.23.132.208
From: "=?Utf-8?B?ZmFycnVraCBuYWVlbQ==?="
Click to expand...
References: <[email protected]>
Click to expand...
<[email protected]>
Subject: RE: returning dataset from webservice
Date: Sat, 25 Sep 2004 05:55:04 -0700
Lines: 169
Message-ID: <[email protected]>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.dotnet.framework.compactframework
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.compactframework:61992
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework

actaully when i debug the it doesnot come in the catch block.

so what could be the problem

please help me
Regards
Farrukh

"Ilya Tumanov [MS]" said:
As I suspected, you are "eating" exception. You see, if WS throw for any
reason, your code would catch it and ignore it.
Exceptions are not warnings you could ignore, they usually are catastrophic
failures.
You should process the exception and take corrective action instead.
At least, print out exception type and error message if any to figure out
what's wrong.
Most likely you would get some sort of network error caused by incorrect
networking setup.

try
{
d=ser.GetTransactionDetails(CardDetails.getCardNumber());
}
catch(Exception e1)
{
// WRONG !!! Add error handling here.
}


Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
Thread-Topic: returning dataset from webservice
thread-index: AcSh2uc/KkPufBjZTwS1/EcdAYOSnw==
X-WBNR-Posting-Host: 210.23.132.208
From: "=?Utf-8?B?ZmFycnVraCBuYWVlbQ==?="
Click to expand...
References: <[email protected]>
Click to expand...
Subject: RE: returning dataset from webservice
Date: Thu, 23 Sep 2004 19:05:02 -0700
Lines: 101
Message-ID: <[email protected]>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.dotnet.framework.compactframework
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.compactframework:61927
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework

i didnot get u
i am attaching the code of webservice and the client application

so please help me

code from Aplication

Service1 ser=new Service1();

DataSet d=new DataSet();

try
{
d=ser.GetTransactionDetails(CardDetails.getCardNumber());
}
catch(Exception e1)
{

}
TransactionGrid.DataSource=d.Tables["Transactions"];


code from webservice

SqlConnection myConnection = new
SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);

string encrptedcardno=Security.Encrypt(card_no);

string myquery="Select Transaction_time,Amount,Trans_Description from
Transactions where Card_no='"+encrptedcardno+"'";


SqlDataAdapter DA=new SqlDataAdapter(myquery,myConnection);

myConnection.Open();


DataSet ds=new DataSet();

DA.Fill(ds,"Transactions");

return ds;



Regards
Farrukh

:

I would suspect you're eating an exception on a call to WS.

Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
Thread-Topic: returning dataset from webservice
thread-index: AcShT8KpMsUmbLIbSACnZT+pmd1mVg==
X-WBNR-Posting-Host: 131.170.90.3
From: "=?Utf-8?B?ZmFycnVraCBuYWVlbQ==?=" <farrukh
(e-mail address removed)>
Subject: returning dataset from webservice
Date: Thu, 23 Sep 2004 02:29:01 -0700
Lines: 11
Message-ID: <[email protected]>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.dotnet.framework.compactframework
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: cpmsftngxa06.phx.gbl
microsoft.public.dotnet.framework.compactframework:61863
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework

I am trying to return a dataset from webservice.The webservice is called
from
WindowCE.Net application running on the emulator.when the dataset get
returned there is no data in the dataset.where as when i debug the
webservice
there is data in dataset.

please help as it is very importnat to me.

the Webservice namespace and the Client application namespace is
different,.

Regards
Farrukh
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What to use dataset or xml in compact framework 1
datasets over webservice / size 10
Webservice error - please help 2
Yet another DataAdapter and Transaction problem 1
class to class 1
Get Back RowError with CF 1.0? 8
Listbox problems 5
PDA (WinCE 4.1) <---data---> WebService = low speed of data transf 4

Top