public class DbDataContext : DataContext { public DbDataContext() : base("Data Source=isostore:/MainDb.sdf") { if (false == this.DatabaseExists()) this.CreateDatabase(); } public Table<S_List> FigureList; } [Table] public class S_List { [Column(IsPrimaryKey = true, IsDbGenerated = true, DbType = "INT NOT NULL Identity", CanBeNull = false, AutoSync = AutoSync.OnInsert)] public int Id { get; set; } [Column] public int s_publicfigureid { get; set; } [Column] public string s_name { get; set; } [Column] public Uri s_imageurl { get; set; } }
private void wish_Checked(object sender, RoutedEventArgs e) { ToggleImageButton tgl = sender as ToggleImageButton; var selectedItem = tgl.DataContext as User; mydb.FigureList.InsertOnSubmit(new S_List { s_publicfigureid = selectedItem.publicfigureid, s_name = selectedItem.name, s_imageurl = selectedItem.imageurl, }); mydb.SubmitChanges(); }
mydb.SubmitChanges();
// Submit the change to the database. try { mydb.SubmitChanges(); } catch (Exception d) { Console.WriteLine(d); // Make some adjustments. // ... // Try again. mydb.SubmitChanges(); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)