473,320 Members | 1,982 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

dataset in a Web Service

Hi,
I have a web service. It works fine until it hits a
dataadapter.fill(dataset) Is it normal? it results in a "The page cannot be
displayed (HTTP 500)" page.

Dim dbMan As DBManager
Dim dbConn As IDbConnection
Dim dbDA As IDataAdapter
Dim dbCB As System.ComponentModel.Component
Dim dbds As DataSet
Dim dbRow As DataRow

dbType = MYSQL
dbParams = New DBParamMySQL
DirectCast(dbParams, DBParamMySQL).ServerName = <NotShown>
DirectCast(dbParams, DBParamMySQL).DBName = <NotShown>
DirectCast(dbParams, DBParamMySQL).Username = <NotShown>
DirectCast(dbParams, DBParamMySQL).Password = <NotShown>

'Get the DB Manager object setting the good db type and params
dbMan = New DBManager(dbType, dbParams)

dbConn = dbMan.GetNewConnection
dbDA = dbMan.GetNewDataAdapter("Select * From table1 where 0=1", dbConn)
dbCB = dbMan.GetNewCommandBuilder(dbDA)
dbDA.Fill(dbds) <--That's where is bugs

I have commented everything and tested and uncommented 1 line at a time and
everything works until I uncomment the Fill line...

Please help me, I'm lost.

Thanks
Nov 23 '05 #1
1 1124
problem solved, I had to define a New dataset (dim dbds as NEW dataset)
grrrrr, stupid error!!

Thanks anyways... ;)

"ThunderMusic" <NO.danlat.at.hotmail.com.SPAM> a écrit dans le message de
news: %2*******************@TK2MSFTNGP10.phx.gbl...
Hi,
I have a web service. It works fine until it hits a
dataadapter.fill(dataset) Is it normal? it results in a "The page cannot
be displayed (HTTP 500)" page.

Dim dbMan As DBManager
Dim dbConn As IDbConnection
Dim dbDA As IDataAdapter
Dim dbCB As System.ComponentModel.Component
Dim dbds As DataSet
Dim dbRow As DataRow

dbType = MYSQL
dbParams = New DBParamMySQL
DirectCast(dbParams, DBParamMySQL).ServerName = <NotShown>
DirectCast(dbParams, DBParamMySQL).DBName = <NotShown>
DirectCast(dbParams, DBParamMySQL).Username = <NotShown>
DirectCast(dbParams, DBParamMySQL).Password = <NotShown>

'Get the DB Manager object setting the good db type and params
dbMan = New DBManager(dbType, dbParams)

dbConn = dbMan.GetNewConnection
dbDA = dbMan.GetNewDataAdapter("Select * From table1 where 0=1", dbConn)
dbCB = dbMan.GetNewCommandBuilder(dbDA)
dbDA.Fill(dbds) <--That's where is bugs

I have commented everything and tested and uncommented 1 line at a time
and everything works until I uncomment the Fill line...

Please help me, I'm lost.

Thanks

Nov 23 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: geilen | last post by:
I'm trying to use a dataset returned from a web service in an unmanaged C++ (MFC) client. The dataset is returned as a BSTR, and I'm having trouble reading the BSTR into an XML document for...
2
by: Bob | last post by:
Hi, Can anyone tell me how to resolve this: I am calling a web service from a WinForm app and passing a typed dataset as a parameter. I have added the dataset to the web service project but I...
22
by: Arne | last post by:
How do I pass a dataset to a webservices? I need to submit a shoppingcart from a pocket PC to a webservice. What is the right datatype? II have tried dataset as a datatype, but I can't get it to...
5
by: moondaddy | last post by:
I'm writing an winforms app in vb.net 1.1 and am having trouble referencing a strongly typed dataset in the UI project. The dataset's source is behind a web service and the data project (client...
1
by: J. Askey | last post by:
I am implementing a web service and thought it may be a good idea to return a more complex class (which I have called 'ServiceResponse') in order to wrap the original return value along with two...
6
by: James | last post by:
I am writing a web service for a classic ASP application. I need to consume an ADO recordset and then send it to another web service for processing. I found an MSDN ariticle telling how to do this...
2
by: DB | last post by:
Hi I have a specific problem of Access to Internal IIS and therefore need to have two Web Services to return the Dataset from one of them. The Internal Web Service Returns a Dataset of Addresses...
7
by: David P. Donahue | last post by:
My experience with databases using C# has been pretty limited thus far. Mostly I just use a SELECT statement to populate a DataSet, which is just read-only (mostly for display on a web page), or...
5
by: vaj | last post by:
Hey, Im creating a system on a pocket pc based on win ce 4.2 and i need to tranfer three datasets to a remote server on the network.Could anyone tell me the easiest way to do this? cheers, -vaj
15
by: Joseph Geretz | last post by:
I'm a bit puzzled by the current recommendation not to send Datasets or Datatables between application tiers. http://support.microsoft.com/kb/306134 ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.