Databases
StackOverflow2013
Postsdbo
POConsuming own webservice for windows phone
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POConsuming own webservice for windows phone
    primarykey
    data
    text
    <p>I have created my own web services to consume. I added service reference. However at the store_getProducts , an error occured at XDocument xReturn = XDocument.Load(e.Result); it says the string was not recognized as a valid uri. parameter name inputuri. Can someone tell me what is the problem</p> <pre><code>SvcRefstore.ServiceSoapClient storeclient = new SvcRefstore.ServiceSoapClient(); storeclient.getProductsAllCompleted += new EventHandler&lt;SvcRefstore.getProductsAllCompletedEventArgs&gt;(store_getProducts); storeclient.getProductsAllAsync(); storeclient.setItemsarrayAsync(itemarray); </code></pre> <p>store_getProducts </p> <pre><code> void store_getProducts(object sender, SvcRefstore.getProductsAllCompletedEventArgs e) { XDocument xReturn = XDocument.Load(e.Result); IEnumerable&lt;Products&gt; myQuote = from item in xReturn.Descendants("Products") select new Products { Name = Convert.ToString(item.Element("Name").Value), unitPrice = Convert.ToString(item.Element("unitPrice").Value), }; Products thisQuote = myQuote.ElementAt(0); textBlock1.Text = thisQuote.Name.ToString(); } </code></pre> <p>below is the getProducts method i created to consume</p> <pre><code> public string getProductsAll() { storeDBCon dbConn; dbConn = new storeDBCon(); DataSet idataset = new DataSet(); string products = ""; SqlConnection db = dbConn.GetConnection(); SqlCommand cmd; string sqlRetrieve = "SELECT * FROM Product WHERE Name = @Name"; db.Open(); try { for (int i = 0; i &lt; itemsarray.Length; i ++ ) // foreach (String item in itemsarray) { cmd = new SqlCommand(sqlRetrieve, db); cmd.Parameters.AddWithValue("@Name", itemsarray[i]); SqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows == true) { reader.Read(); //_userId = reader.GetInt32(0); productID = reader.GetInt32(0); pname = reader.GetString(1); pDesc = reader.GetString(2); unitPrice = reader.GetString(3); imagefilename = reader.GetString(4); products = productID + "," +pname + "," + pDesc + "," + unitPrice + "," + imagefilename + ""; } else products = "Null"; } } catch (Exception ex) { errMsg = ex.Message; } finally { db.Close(); } return products; } </code></pre> <p>below is the setItemsarray method</p> <pre><code>public void setItemsarray(string[] _str) { itemsarray = _str; } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USFredHomme
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COAnd what is the value of `inputuri`?
      singulars
      1. POConsuming own webservice for windows phone
      1. USPaul Turner
    2. COWhere is your call to `store_getProducts`? What does that look like?
      singulars
      1. POConsuming own webservice for windows phone
      1. USethorn10
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload