hi all
iam trying to retrieve data from database in json format
but data is not displaying in json
please correct my code
my code is
project name is: WCFdatabase
service.cs
private static Npgsql.NpgsqlConnection conn;
public DataSet SelectUserDetails()
{
string ConnStr = ConfigurationManager.ConnectionStrings["myConn"].ConnectionString;
conn = new Npgsql.NpgsqlConnection(ConnStr);
conn.Open();
Npgsql.NpgsqlCommand cmd = new Npgsql.NpgsqlCommand("Select district from district", conn);
Npgsql.NpgsqlDataAdapter sda = new Npgsql.NpgsqlDataAdapter(cmd);
DataSet ds = new DataSet();
sda.Fill(ds);
cmd.ExecuteNonQuery();
conn.Close();
return ds;
}
IService.cs
public interface IService
{
[OperationContract]
[WebInvoke(Method = "GET", UriTemp ...
Go to the complete details ...