I have to return a lot of values back to my windows application from my webService. But how would I return more than just a single string/int/boolean from my WebService to myApplication. How would I return a collection, keyValuePair, or even better, a DataSet? Or is this just imposible?
View 4 RepliesHow would I return a base64Binary type back from a VB.net web service request? I would like to return the base64Binary of a PDF document from the binary datatype from SQL Server 2008. Is base64Binary the same as Byte? Do I have to convert the Byte to Base64 then to String?
View 1 RepliesI have the following code to return a one-object JSON array,
Imports System.ServiceModel
Imports System.ServiceModel.Activation
Imports System.ServiceModel.Web
[code]....
The returned data is :
{id:1,Text:"TText test"}
How to make it returns :
[{id:1,Text:"Text 1"},{id:2,Text:"Text 2"}]
We are developing a webservice for a client. We are not supose to throw SoapExceptions, so instead, we catch every exception server side, and return a custom Exception class.
Public Class Order
...
End Class
[Code]....
The problem now is, that since my webmethod is returning the type [Object]. The wdsl that is generated does not contain the order, or the exception.
I can change the [Object] to [Order] Or [MyException], but only one of them is generated in the wsdl.
I want both the MyException type and the Order type in my wsdl, but i just cant get it working.
This is the function that I use in web service for getting current windows user.
<WebMethod()> _
Function User() As String
Dim p() As String = Split(My.User.Name, "")
[code].....
Trying to find some code to assist with accessing a web service. I am a newbie when it comes to web services and don't quite get the whole how to submit the request and then read the results. I know from searches that people request a copy of the WSDL file so I have attached (SystemManagementService.wsdl)
[Code]...
I'm new to LINQ and am having a problem getting proper results from a simple (working) stored procedure that takes no parameters and returns a single Integer. When calling this sproc with LINQ its returnvalue is always 0. When run using tableadapter or directly on the sql server it works, returning 6 digit values like 120123.
Here is my LINQ code:
Dim MeetingManager As New MeetingManagerDataContext
Dim MeetingID As Integer = MeetingManager.NewMeetingID().ReturnValue Here is the NewMeetingID procedure:
ALTER PROCEDURE [dbo].[NewMeetingID]
AS
SET NOCOUNT ON
BEGIN
[Code]...
Ok, just needing a 2nd set of eyes looking at this to make sure the error isn't something else other than my LINQ code here. Here's the function class itself:
Public Function GetJacketByPolicyID(ByVal jacketID As Int32) As tblPolicy
Dim db As New DEVDataContext()
Dim j As tblPolicy = db.tblPolicies.Single(Function(p) p.policyNumber = jacketID)
Return j
End Function
and here is the code which calls this class function in the web control form itself:
Dim p As tblPolicy
Dim j As New Jackets()
p = j.GetJacketByPolicyID(3000050)
For some reason it's flagging the 2nd line in the GetJacketByPolicyID function saying the specified cast is not valid. So I'm guessing it's something I'm doing wrong. I'm sure the tblPolicy/tblPolicies class works right since I can create a new instance of a tblPolicy and set a few variables by hand and return it, so that's not it. I've also checked the datarow I'm fetching and there's no null values in the record, so that shouldn't be it either.
I am trying the following to select a long date, but becase the value is stored in SQL database as DateTime I am unable to return any results unless minutes and seconds match perfectly...I then tried to use 2 calendars and have the same issue with the DateTime format..
CODE:
I am using a Strongly Typed Dataset as DAL. I want to return a single column from my table for that i wrote the code as
SELECT DISTINCT Floor
FROM Room
WHERE (Building = @Building)
But when i previewed the data, it shows me all the columns of the table with Null Value and the column with primary key has -1 value. This condition raise an Exception when i link this query to a ComboBox ..
cmbFloor.DataSource = da.GetFloorByBuilding(cmbBuilding.Text)
cmbFloor.DisplayMember = "Floor"
Error: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
Say I have a code with 3 methods that do some pretty intensive work. Would executing these methods on 3 seperate threads be faster then executing them one after the other on a single core cpu? And what if it's a dual core or HT?
View 8 RepliesI am trying to make a list, separated by a comma, of entries from a single column in a SQL database. I have been spending the last several days searching for a way to do this, but every thing I found either didn't work, or wasn't exactly what I was looking for.
The query will pull all the email address that are not null. What I need to know is how to take the result of that query and make it look like this:
email0@address.com, email1@address.com, email2@address.com, etc, etc, ...
I feel like I should know this, but for the life of me, I can't remember nor can I find it in any of the textbooks I have.
I am using Visual Basic 2010 and SQL Server 2005. I also have access to Visual Basic 2005 if needed.
I use SqlParameters when executing database statements. I know that I can replace a single quote with two single quotes... but in the past SqlParameters took care of this for me. I have two projects.. in one, the SqlParameter does this and it handles single quotes fine, in another, it does not and I'm at a loss why (I even copied and pasted the code):
[Code]...
I am trying to use the DGV to view various properties from a variety of different class instances. Is it possible to bind each cell individually?
View 9 RepliesI am trying to update a row or a single cell in ms access through vb.net. But when i update the text box named NRIC, say for example i want to update "s4522147B" to "tr4521856C" and mean while leaving the other fields the same.
But the thing is when i make the changes in nric.text (textbox), the dataset actually updates the whole column in the table instead of the selected textbox.
Below is my code for the update part
[Code].....
I have to send a request to Webservice and I have a working PHP solution, that I have to translate in VB.net
Here's the code working in PHP
//fill in the details of the contacts.userId is obtained from loginResult.
$contactData = array('lastname'=>'Valiant', 'assigned_user_id'=>$userId);
//encode the object in JSON format to communicate with the server.
[code]....
Naturally I imported a reference to a Json library and Imported (Imports Newtonsoft.Json)?
I use this code to return records in a DataGridView:
[Code]....
I'm working up a system where I plan on using RealProxy objects to enable intercepting method calls against a set of objects, handling the call, and then returning appropriate results. This works just find for simple return types like strings or ints, but I can't seem to return objects from the RealProxy.Invoke method. Everything works. I get no errors, but the returned value is always NOTHING, instead of an object.
I've worked up the smallest sample code I could, and have included it below. Essentially, just call RPtest and single step through. The code creates a simple object, RPTestA, with a string field and an object valued field It then retrieves the string
[Code]...
I have a few problems i need to solve. Firstly, I am looking for a piece of code i can use to display a picture from a bank of pictures. It will work on the basis of generating a random number and loading a picture that corresponds to that number.
i.e. Dim RandNumber As Integer
Dim RandClass As New Random
RandNumber = RandClass.next(1, 10)
If RandNumber = 1 Then
Picturebox1.image = picture1
[Code]...
Secondly, can I then use subsequent picture boxes to display pictures from the same bank of images, without displaying the same image? Finally, I then need to be able to click the picture or a button beneath the picture to select it as an answer to a question and then the whole process starts again.
we had developed a webservice in vb.net,framework 2.0. We would need to rewrite this websevice in WCF with framework 3.5. Please provide some guidance regarding this and also there are many othersystems consuming our webservice url. Will this conversion have impact on the source system or does it involve any build activity for the source system to consume the url that will be developed with WCF method?
View 3 RepliesI have a search engine that will use a webservice to search through my database to find 3 specific things. I don't even know if it will work like this, but I have a dropdown list on my main page to select Product, Feature, Description. From what the user selects, the webservice should then go to an if statement to use the correct SELECT statement and find results for the search.
Will someone help me figure out how to fix what I've written to make it work? Please don't be too critical, I don't have a lot of experience. I have also been researching SQL Injection because I have a lot of code that is vulnerable so keep that in mind when you look at my code.
I can't get the blue squiggly lines to go away that are underneath the DropdownList1.Value instances on the WebService page.
WebService:
<WebMethod()> _
Public Function GetCompletionList(ByVal prefixText As String, ByVal count As Integer) As String()
Dim Feature As String = DropDownList1.Value
Dim Description As String = DropDownList1.Value
Dim Product As String = DropDownList1.Value
[CODE]..........................
Default.aspx page - Here I need the dropdownlist to tie to the database somehow.
<asp:ScriptManager ID="ScriptManager1" runat="server">
<Services>
[CODE]........................
I am trying to get subsonic to run work in a webservice I am not sure how to return the data. I only get the word Object in my results when It return anything instead of values. What am I missing?
<WebMethod(Description:="Method to retrieveCptCode subsonic List")> _
Public Function GetSubCptCodes() As CPTCodeCollection
Dim coll As CPTCodeCollection = New CPTCodeCollection()
Dim qry As Query = New Query(CPTCode.Schema)
coll.LoadAndCloseReader(qry.ExecuteReader())
Return coll
End Function
I am invoking a webservice and got this error..Do anyone know what is the exact problem..System.ServiceModel.Security.MessageSecurityException: An unsecured or incorrectly secured fault was received from the other party. See the inner FaultException for the fault code and detail. ---> System.ServiceModel.FaultException: An error occurred when verifying security for the message.
[Code]...
I have a webservice created using classic ASP which i am trying to get working in .Net.
Currently i am using the following ASP to post an XML file to [URL] . This then sends back an XML response.
Code:
I am trying to emulate this in VB.Net so that i can receive an XML response from the xml_url.
However i get an error warnign me that the following cannot be created:
Code:
I want to get access of php webservice from vb.net
View 1 RepliesAs in the title, How to get the session value from asp.net web-service ?
View 1 RepliesIs there an easy way to schedule a webservice that was created in vb.net. Would I need to create a .asmx file or do I create an executable in vb that calls a webservice?I have created a webservice using SOAPUI 3.6.1. would it be easier to schedule that instead of creating a vb app.
View 5 RepliesSetting timeout on a vb.net webservice.
View 2 RepliesI created a website that contains a Webservice that transfers data to a windows application Using a collection, however, I get this Error that says that anything that inherits the ICOllection, it must implement Add(System.Object)
View 2 RepliesWriting a VB app that uses a webservice. The URL for this webservice will change based on where the app is running from so I need to change it at runtime. I see that by default the web reference URL has its behavior set to "Dynamic" which means I should be able to change it at runtime, but at the same time the app.config file has the Scope set to "Application," which means it's read-only at runtime. I'm looking to use My.Settings.WebServiceURL = "new url" but in order to do this the scope has to be set to User... I think. But if that's the case then what does the "Dynamic" behavior do for me? Can someone give me a code example of how I can change this at runtime?
View 2 Replies