|
If you are trying to have the webservice provide a typed-dataset to the client you will need to write a function on the webservice to return one. You will need to first create a dataset in the webservice project (right-click the project name, select 'Add new item', select 'Dataset', and configure it to your liking). You can then write a function to return that dataset; for example:
<Webmethod()> _
Public Function GetTypedDataset() as myDataset
Dim TableAdapter1 as myDatasetTableAdapters.TableAdapter1
Dim TableAdapter2 as myDatasetTableAdapters.TableAdapter2
Dim returnDataset as new myDataset
TableAdapter1.Fill(returnDataset.Table1)
TableAdapter2.Fill(returnDataset.Table2)
Return returnDataset
In your client project, you can select 'Add a new datasource', select 'Web Service', and follow the Wizard to select your web service.
The typed-dataset will then be useable in your client application. To fill it, you would call the function demonstrated above. You would also need to write methods on the webservice to handle updating, and call them from your client as needed.
Hope this helps,
Keith
-- modified at 0:06 Wednesday 9th August, 2006
|
|
|
|
|
Thats a great help - thanks 
|
|
|
|
|
I'm using Visual Studio 2003 - are tableadapters available in 2003 ? Or should I use an alternative approach ?
Thanks
|
|
|
|
|
Suppose i have two buttons btn1 and btn2 and i have created a click event function of btn1. now if i want to call btn1 click event function when user click btn2 please tell me soon
|
|
|
|
|
|
Another method is to have the same event handler handle the Click event of both buttons. Look at the end of the event handler declaration for one of the buttons Click events and you'll find a Handles clause:
Private Sub Button1_Click(blah, blah) Handles Button1.Click
You can have a single handler handle the Click events of more than one button by doing this:
Private Sub MyClickHandler(blah, blah) Handles Button1.Click, Button2.Click
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Button1_Click(nothing,nothing)
U Xux
|
|
|
|
|
I am writing a VBA macro in Excel, and have declared 2 global string arrays.
I am manipulating these arrays in a couple of function without passing them as params -since they are global- however when I return from the first function my array is losing its elements. Is this code error, or am I missing something with arrays.
|
|
|
|
|
Ok the problem is because when I was debugging I added a watch for the array variables via the array var in the procedure, which would give it a out of context value when out of the proc. So lesson is when using globals to add watches on the global declaration not the var within a proc to ensure you have the value of the global representation.
|
|
|
|
|
Hi,
How to put checkbox in datagrid through DataGridColoumnStyle.
Plz help me.
|
|
|
|
|
You need to add a DataGridBoolColumn to your grid's column collection.
Steve
|
|
|
|
|
When DataGridBoolColumn is used the checkboxes are displayed as disabled,
does not allow editing.
|
|
|
|
|
Is your column bound to a table column?
These checkboxes have three states, checked(True), unchecked(False) and DBNull.Value
What is the code you have used to set up the column?
Steve
|
|
|
|
|
Hi,
I'm creating an app that polls a folder (source folder) for files and moves them to another folder (destination folder). I've identified two main reasons that the move may cause an exception to be thrown.
1. The file is still being copied into the source folder by another process. Therefore the file is locked, and I need to try again later.
2. The file already exists in the destination folder.
In my catch block I need to differentiate between the two errors and handle them differently. I realise that I should perhaps be checking that the destination file does not exist before doing the move which would stop 2. happening, but it raised an interesting question for me.
What is the "proper" way do distinguish between the two errors? Obviously the IOException.message is different, but is that the way to do it?
Thanks
Ant
|
|
|
|
|
The documentation doesn't say what exception you get if the file is locked. Do you get an IOException for that too?
---
b { font-weight: normal; }
|
|
|
|
|
Thanks for the replies. Yes, I get the IOException for both.
I understand the concept of multiple catch blocks but in both situations I get an IOException and can only think to use the message string as the differentiator.
|
|
|
|
|
Use the Err.Number as the differentiator...
Catch ex As IOException
Select Case Err.Number
Case 123
'code to handle error 123
Case 234
'code to handle error 234
End Select
Catch ex As Exception
' code to handle unexpected/unhandled errors
Steve
|
|
|
|
|
Great. Thanks for your help.
|
|
|
|
|
You can have multiple 'Catch' blocks within Try/End Try.
Start with specific errors and catch each err.number in a different catch block.
Your last Catch block should just catch a general 'Exception' to alert you of any unhandled errors that may occur. For example
Try
'Your implementation code
Catch ex As IOException
'Handle error here
Catch ex As Exception
'Alert unhandled error here
End Try
Steve
|
|
|
|
|
Exceptions are expensive to throw, so try to avoid using them for logic decisions. The proper way to do this would be to check to see if the destination exists before you try to copy the file to it.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Dave Kreskowiak wrote: Exceptions are expensive to throw
What do you mean?
|
|
|
|
|
He means its probably not the best way to deal with this. For example you know that there is a potential for an exception to be thrown (in this case a locked file) so it would be better to check for a locked file before trying to access it (thus preventing the possibility of the exception) rather than simply letting it throw an exception and dealing with it then.
|
|
|
|
|
Johnathan is essentially correct. The point behind it is that Exceptions take a long time to execute compared to just checking if the file exists.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
How to make validation of individual cell in a datagrid?
|
|
|
|
|
What do you want to validate?
There is a certain amount of validation built into DataGrid controls.
For example, grid columns bound to number type columns in the bound table will not allow letters (A-Z) etc.
Validation is best handled at the table level when working with DataGrids.
Add a handler for the table's OnRowChanging or OnColumnChanging events, check the 'proposed value' and set an error on the row if it does not pass your validation. The grid will respond to this.
Steve
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
