Hello,
Below is the code for web api, I wanted to consume/call the web api in xamarin forms and bind the result to the picker.
- [System.Web.Http.HttpGet]
- public HttpResponseMessage GetNames()
- {
-
- string client1 = ConfigurationManager.ConnectionStrings["client_db1"].ConnectionString;
- string client2 = ConfigurationManager.ConnectionStrings["client_db2"].ConnectionString;
- string client3 = ConfigurationManager.ConnectionStrings["client_db3"].ConnectionString;
-
- SqlConnection con = new SqlConnection(client1);
- SqlDataAdapter da1 = new SqlDataAdapter("select provider_name,Id from Provider_details", con);
- DataSet ds1 = new DataSet();
- da1.Fill(ds1);
- con = new SqlConnection(client2);
- da1.SelectCommand.Connection = con;
- DataSet ds2 = new DataSet();
- da1.Fill(ds2);
- con = new SqlConnection(client3);
- da1.SelectCommand.Connection = con;
- DataSet ds3 = new DataSet();
- da1.Fill(ds3);
-
- ds1.Merge(ds2);
- ds1.Merge(ds3);
- return Request.CreateResponse(HttpStatusCode.OK, ds1);
- }
Please help me,
Thanks