returning dataset from webservice

  • Thread starter Thread starter Guest
  • Start date Start date
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 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.
--------------------
 
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...
 
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...
 
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...
 
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...
 
Back
Top