public void AddCalligrapher() { Calligraphyer calligraphyer = new Calligraphyer(); calligraphyer.Name = "努力学习"; calligraphyer.Description = "天天向上"; calligraphyer.Status = DatabaseTest.Entity.EntityBase.Statuses.New; ((ObservableCollection<Calligraphyer>)_viewSource.Source).Add(calligraphyer); }
public static void Update(Calligraphyer c) { var cnn = Database.CreateConnection(); string sql=@"update DatabaseTable set Description=@Description where ID=@ID"; SqlCommand cmmd = new SqlCommand(sql, cnn); cmmd.Parameters.Add(new SqlParameter("ID", c.Id)); //cmmd.Parameters.Add(new SqlParameter("Name", c.Name)); cmmd.Parameters.Add(new SqlParameter("Description", c.Description)); cnn.Open(); cmmd.ExecuteNonQuery(); cnn.Close(); }
public static void Insert(Calligraphyer c) { var cnn = Database.CreateConnection(); string sql = @"insert into DatabaseTable (Name,Description) values (@Name,@Description)"; SqlCommand cmmd = new SqlCommand(sql, cnn); cmmd.Parameters.Add(new SqlParameter("Name", c.Name)); cmmd.Parameters.Add(new SqlParameter("Description", c.Description)); cnn.Open(); cmmd.ExecuteNonQuery(); cnn.Close(); }
public static ObservableCollection<Calligraphyer> Load() { ObservableCollection<Calligraphyer> calligraphyers = new ObservableCollection<Calligraphyer>(); var cnn = Database.CreateConnection(); string sql = "select * from DatabaseTable"; SqlCommand cmmd = new SqlCommand(sql,cnn); cnn.Open(); var reader = cmmd.ExecuteReader(); while (reader.Read()) { Calligraphyer c = new Calligraphyer((int)reader["ID"], (string)reader["Name"], (string)reader["Description"]); calligraphyers.Add(c); } cnn.Close(); return calligraphyers; }