I Want to return JSON webservice from Sql Server using Asp.net c#

Question

0.00/5 (No votes)

See more:

, +

I Want to return Json Webservice From Sql Server in Asp.net Using C# I Want. Especially I want Selecting Querry

This Is Return Webservice:

JavaScript

{ "Cargo": [ { "status": "pickup", "datetime": "" }, { "status": "InTransit",

"datetime": "" }, { "status": "ReachedBLR", "datetime": "" }, { "status":

"StartedDEL", "datetime": "" }, { "status": "InTransit", "datetime": "" }, { "status": "ReachedDEL", "datetime": "" }] }..

Please help me by giving code
Thanks In advance..

Posted 1-Apr-14 2:44am

Member 10556609

Updated 1-Apr-14 4:41am

Prasad Khandekar

v4

Add a Solution

Comments

Sergey Alexandrovich Kryukov 1-Apr-14 8:49am

What does it mean, "return a service"? :-)
—SA

Member 10556609 1-Apr-14 9:22am

Sorry Sir Now I Changed..

joshrduncan2012 1-Apr-14 9:26am

Please reply to comment instead of creating a new comment, otherwise, the person will not get notified that you responded.

Member 10556609 1-Apr-14 9:31am

i Want to Create JSON Webservice In Asp.Net USing C# .The data will Get From SQl Server. I want webService Response LIke This.
{ "Cargo": [ { "status": "pickup", "datetime": "" }, { "status": "InTransit",

"datetime": "" }, { "status": "ReachedBLR", "datetime": "" }, { "status":

"StartedDEL", "datetime": "" }, { "status": "InTransit", "datetime": "" }, { "status": "ReachedDEL", "datetime": "" }] }..

ZurdoDev 1-Apr-14 9:26am

What is your question?

Member 10556609 1-Apr-14 9:31am

i Want to Create JSON Webservice In Asp.Net USing C# .The data will Get From SQl Server. I want webService Response LIke This.
{ "Cargo": [ { "status": "pickup", "datetime": "" }, { "status": "InTransit",

"datetime": "" }, { "status": "ReachedBLR", "datetime": "" }, { "status":

"StartedDEL", "datetime": "" }, { "status": "InTransit", "datetime": "" }, { "status": "ReachedDEL", "datetime": "" }] }..

Member 10556609 1-Apr-14 9:33am

Especially i Want format to Select command query..

ZurdoDev 1-Apr-14 9:44am

Are you saying you want all the code then? No thank you. I doubt anyone will give you all the code.

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prasad Khandekar · Answer 1 · 2014-04-01T04:46:00

Solution 1

Hello,

Here is a simple trick to get the answer. Click here[^].

Still can't get then have a look at this[^].

Regards,

Posted 1-Apr-14 4:46am

Prasad Khandekar

gagandeep.pratihar · Answer 2 · 2014-04-01T19:54:00

[WebMethod]
public static string GetDistrictByRegionID(string regionID)
{
string jsonString = string.Empty;
try
{
DealerSalesBO objDealerSalesBO = new DealerSalesBO();
DataSet ds = objDealerSalesBO.GetDistrictByRegionID(companyId, regionID);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
jsonString = JsonHelper.GetJson(ds.Tables[0]);
}
}
catch (Exception ex)
{
jsonString = "[{\"ErrorMessage\":\"" + ex.Message + "\"}]";
}

return jsonString;
}

public class DealerSalesBO
{
string KIAS_ConnectionString = ConfigurationManager.ConnectionStrings["KIAS_ConnectionString"].ConnectionString;

public DealerSalesBO()
{

}

public DataSet GetDistrictByRegionID(int companyID, string regionID)
{
DataSet objDS = null;
try
{
objDS = new DataSet();
string spName = "sps_DistrictRpt";

SqlParameter[] arParms = new SqlParameter[2];
arParms[0] = new SqlParameter("@Company_ID", SqlDbType.Int);
arParms[0].Value = companyID;

arParms[1] = new SqlParameter("@RegionID", SqlDbType.VarChar);
arParms[1].Value = regionID;

SqlHelper.FillDataset(KIAS_ConnectionString, CommandType.StoredProcedure, spName, objDS, new string[] { "T_DistrictMST" }, arParms);
}
catch (Exception ex)
{
throw ex;
}

return objDS;
}
}

public static class JsonHelper
{
public static string GetJson(DataTable dt)
{
string jsonString = string.Empty;
try
{
if (dt == null)
{
throw new Exception("DataTable is null...");
}

JavaScriptSerializer serializer = new JavaScriptSerializer();
ArrayList lstArrayList = new ArrayList();
foreach (DataRow dr in dt.Rows)
{
Dictionary<string,> objDictionary = new Dictionary<string,>();
foreach (DataColumn col in dt.Columns)
{
objDictionary.Add(col.ColumnName.Trim(), dr[col]);
}

lstArrayList.Add(objDictionary);
}

jsonString = serializer.Serialize(lstArrayList);
}
catch (Exception ex)
{
throw ex;
}
return jsonString;
}

}

Kornfeld Eliyahu Peter · Answer 3 · 2014-04-01T19:57:00

Solution 3

Please do not repost - see answers here:I Want to return JSON webservice using Asp.net c#[^]

Posted 1-Apr-14 19:57pm

Kornfeld Eliyahu Peter