Databases
StackOverflow2013
Postsdbo
POUnable to cast object of type 'System.Int32' to type 'System.String'
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUnable to cast object of type 'System.Int32' to type 'System.String'
    primarykey
    data
    text
    <p>I am trying to create a very basic connection to an SQLServer 2008 database via a WCF service application for testing purposes. I am receiving the following error when trying to access the service remotely.</p> <blockquote> <p>Unable to cast object of type 'System.Int32' to type 'System.String'</p> </blockquote> <p>Here is my code:</p> <pre><code>[AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)] [ServiceBehavior(InstanceContextMode = InstanceContextMode.PerCall)] public class GetCustomers : IGetCustomers { // TODO: Implement the collection resource that will contain the SampleItem instances public List&lt;Customer&gt; GetCusts() { List&lt;Customer&gt; mylist = new List&lt;Customer&gt;(); using (SqlConnection conn = new SqlConnection("server=(local);database=BillingTest; Integrated Security=true;")) { conn.Open(); string cmdStr = String.Format("select firstname, lastname, address from Customers");//, lastname, address, city, state,zipcode,phone, email SqlCommand cmd = new SqlCommand(cmdStr, conn); SqlDataReader rd = cmd.ExecuteReader(); if (rd.HasRows) { Customer cust = new Customer(); while (rd.Read()) cust.setCustomer(rd.GetString(0), rd.GetString(1), rd.GetString(2)); mylist.Add(cust); } conn.Close(); } return mylist; } } public class Customer { public string firstname { get; set; } public string lastname { get; set; } public string street { get; set; } public void setCustomer(string first, string last, string street) { // TODO: Complete member initialization this.firstname = first; this.lastname = last; this.street = street; } } </code></pre> <p>This is my first attempt at working with WCF services and sql and I am un-aware of what exactly might be the problem. The firstname, lastname, and address columns of the database are all varchar(50) and I am not trying to access any Int32 columns so I am confused as to where the error is coming from</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USabatishchev
    1. USScottyLa
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COOn which line do you get the error? Does this not happen if you access the service from the local machine?
      singulars
      1. POUnable to cast object of type 'System.Int32' to type 'System.String'
      1. USDan Puzey
    2. CO@DanPuzey It works fine when testing on the local machine and it looks like the error might be on the line where I call the `rd.GetString()`. Thanks
      singulars
      1. POUnable to cast object of type 'System.Int32' to type 'System.String'
      1. USScottyLa
    3. CO@ScottyLa, First this is not a WCF issue. The simplest way to debug this is to copy paste your SQL accessing code into a console application and try debugging it. Set a break point on the line where you access the variable rd and try to see the types of individual columns. This certainly looks like a column data type returned is Int32.
      singulars
      1. POUnable to cast object of type 'System.Int32' to type 'System.String'
      1. USPraburaj
 

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