Databases
StackOverflow2013
Postsdbo
POUpdate in sql Ce in window phone 7
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUpdate in sql Ce in window phone 7
    text
    copied!<p>In project i user SQL CE, i have Table:</p> <pre><code>[Table] public class Article : INotifyPropertyChanged, INotifyPropertyChanging { // Define _cid: private field, public property, and database column. private int _aid; [Column(DbType = "INT NOT NULL IDENTITY", IsDbGenerated = true, IsPrimaryKey = true)] public int aid { get { return _aid; } set { NotifyPropertyChanging("aid"); _aid = value; NotifyPropertyChanged("aid"); } } // Define nameColor name: private field, public property, and database column. private int _rid; [Column] public int rid { get { return _rid; } set { NotifyPropertyChanging("rid"); _rid = value; NotifyPropertyChanged("rid"); } } private string _title; [Column] public string title { get { return _title; } set { NotifyPropertyChanging("title"); _title = value; NotifyPropertyChanged("title"); } } private string _thumnail; [Column] public string thumnail { get { return _thumnail; } set { NotifyPropertyChanging("thumnail"); _thumnail = value; NotifyPropertyChanged("thumnail"); } } private string _DesScription; [Column(DbType = "NTEXT")] public string DesScription { get { return _DesScription; } set { NotifyPropertyChanging("DesScription"); _DesScription = value; NotifyPropertyChanged("DesScription"); } } private int _orderID; [Column] public int orderID { get { return _orderID; } set { NotifyPropertyChanging("orderID"); _orderID = value; NotifyPropertyChanged("orderID"); } } private string _pubDate; [Column] public string pubDate { get { return _pubDate; } set { NotifyPropertyChanging("pubDate"); _pubDate = value; NotifyPropertyChanged("pubDate"); } } private string _linkURL; [Column] public string linkURL { get { return _linkURL; } set { NotifyPropertyChanging("linkURL"); _linkURL = value; NotifyPropertyChanged("linkURL"); } } #region INotifyPropertyChanged Members public event PropertyChangedEventHandler PropertyChanged; // Used to notify that a property changed private void NotifyPropertyChanged(string propertyName) { if (PropertyChanged != null) { PropertyChanged(this, new PropertyChangedEventArgs(propertyName)); } } #endregion #region INotifyPropertyChanging Members public event PropertyChangingEventHandler PropertyChanging; // Used to notify that a property is about to change private void NotifyPropertyChanging(string propertyName) { if (PropertyChanging != null) { PropertyChanging(this, new PropertyChangingEventArgs(propertyName)); } } #endregion } </code></pre> <p>when i Update Colum Thumnail , i have erros :</p> <p><strong>SQL Server does not handle comparison of NText, Text, Xml, or Image data types</strong></p> <p>because of special characters into database insert sequence trogn should I use BbType = "NTEXT"</p> <p>Please Help me !</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

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