Convert vb.net String to Json Object?

Question

I am new in vb.net, I am developing a webservice. I want to send a response in a json object. I have only one string in response.

public string GetUser(String IMEI)
{
    string msg = "";
    string SQL1 = "Select Email from [Customer] where [Vehicle]='" + IMEI + "'";
    DataTable dt = dbcom.GetDataTable(SQL1);
    if (dt.Rows.Count > 0)
    {
        msg = dt.Rows[0]["Email"].ToString();
        //CV(username, IMEI);
        //vehiclechk(IMEI);
    }
    return msg;
}

This send xml string. How we convert msg string in to json.

Take a look at Json.NET

valverij
– valverij

2014-05-20 13:20:25 +00:00
Commented May 20, 2014 at 13:20 — valverij
– valverij, Commented May 20, 2014 at 13:20

Holger Brandt · Accepted Answer · 2014-05-20 13:32:33Z

6

I guess there are two ways to do it. Since this is a simple string, you can just brute force it:

 Dim jsonMsg = "{""msg"":""" & msg & """}"

A more sophisticated way is put it into a class and serialize it.

Public Class MyMessage
  Public Property Msg As String
  Public Sub New(myMsg as String)
    Msg = myMsg
  End Sub
End Class

Dim myMsg As New MyMessage(msg)
Dim serializer as new JavaScriptSerializer
Dim jsonMsg = serializer.Serialize(myMsg)

You need a reference to System.Runtime.CompilerServices.

answered May 20, 2014 at 13:32

Holger Brandt

4,3541 gold badge22 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Convert vb.net String to Json Object?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related