Hi all,
I was trying to return a result as Dataset in REST Web Api and consume in client application as Dataset .
Is it possible to return result as Dataset into Rest web api and am getting error "Additional text found in JSON string after finishing deserializing object." plz help.
public Dataset Getstudent(string schoolId) { try { SqlDataAdapter da = new SqlDataAdapter("Getstudent", con); DataTable ds = new DataTable(); con.Open(); da.SelectCommand.CommandType = CommandType.StoredProcedure; SqlParameter ret = new SqlParameter(); ret.Direction = ParameterDirection.ReturnValue; da.SelectCommand.Parameters.Add("@schoolId", SqlDbType.VarChar, 20).Value = schoolId; da.SelectCommand.Parameters.Add(ret); da.Fill(ds); return Ok(ds); } } private async Task StoredDataset() { DataSet ds = new DataSet(); var resultapi = client.GetAsync(builder.Uri).Result; if (resultapi.IsSuccessStatusCode) { var jsonString = await resultapi.Content.ReadAsStringAsync(); ds = JsonConvert.DeserializeObject(jsonString); } }