//提交
private void button1_Click(object sender, EventArgs e)
{
const string ConnectionString = @"Data Source=(localdb)\mssqllocaldb;Initial Catalog=contacts_data;Integrated Security=true;";
Contacts aNewContact = new Contacts {
name = name1, telephone = telephone1, organization = organization1, email = email1, remarks = remarks1
};
using (contact_dataDataContext aDataContext = new contact_dataDataContext(ConnectionString))
{
aDataContext.Contacts.InsertOnSubmit(aNewContact);
aDataContext.SubmitChanges();
this.Close();
}
}
private void Ondelete(object sender, ExecutedRoutedEventArgs e)
{
try
{
const string ConnectionString = @"Data Source=(localdb)\mssqllocaldb;Initial Catalog=contacts_data;Integrated Security=true;";
string id = Interaction.InputBox("请输入要删除的联系人id", "删除", "例如，输入：3");
using (contact_dataDataContext aDataContext = new contact_dataDataContext(ConnectionString))
{
Contacts aExistContact = (from r in aDataContext.Contacts where r.id == int.Parse(id) select r).FirstOrDefault();
if (aExistContact != null)
{
aDataContext.Contacts.DeleteOnSubmit(aExistContact);
aDataContext.SubmitChanges();
}
}
_Model = new MainModel();
this.DataContext = _Model;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public MainModel()
{
DataContext = new contact_dataDataContext(ConnectionString);
}