我想使用Asp.net c＃从Sql Server返回JSON webservice [英] I Want to return JSON webservice from Sql Server using Asp.net c#

问题描述

我想使用C＃我想从Asp.net中的Sql Server返回Json Webservice。 特别是我想选择Querry



这是返回Web服务：

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:

{ "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..

推荐答案

你好，



这是一个简单的诀窍来得到答案。点击此处 [< a href =http://www.codeproject.com/search.aspx?q=SQL+WebService&doctypeid=1%3b2%3b3%3b13%3b14%3b9%3b10> ^ ]。



仍然无法看到 this [ ^ ]。



问候，

Hello,

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

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

Regards,

[WebMethod]

公共静态字符串GetDistrictByRegionID（字符串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（例外情况）

{

jsonString =[{\ErrorMessage \：\+ ex.Message +\}];

}



返回jsonString;

}



公共类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] =新的SqlParameter（@ RegionID，SqlDbType.VarChar）;

arParms [1] .Value = regionID;



SqlHelper.FillDataset（KIAS_ConnectionString，CommandType.StoredProcedure，spName，objDS，new string [] {T_DistrictMST}，arParms）;

}

catch （例外情况）

{

抛出ex;

}



返回objDS;

}

}



公共静态类JsonHelper

{

公共静态字符串GetJson（DataTable dt）

{

string jsonString = string.Empty;

try

{

if（dt == null）

{

抛出新的异常（DataTable为null ... ）;

}



JavaScriptSerializer序列化器=新的JavaScriptSerial izer（）;

ArrayList lstArrayList = new ArrayList（）;

foreach（dt.Rows中的DataRow dr）

{

Dictionary< string，> objDictionary = new Dictionary< string，>（）;

foreach（dt.Columns中的DataColumn col）

{

objDictionary.Add（ col.ColumnName.Trim（），dr [col]）;

}



lstArrayList.Add（objDictionary）;

}



jsonString = serializer.Serialize（lstArrayList）;

}

catch（异常） ex）

{

抛出ex;

}

返回jsonString;

}



}

[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;
}

}

请不要重新发布 - 请在此处查看答案：我想使用Asp.net返回JSON webservice c＃ [ ^ ]

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

这篇关于我想使用Asp.net c＃从Sql Server返回JSON webservice的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！