private void RefAutCom() { var AutCom = new AutoCompleteStringCollection(); using (var en = new Entities1()) { var query = from dt in en.Persons where dt.Type == false select dt; foreach (var ed in query) { AutCom.Add(ed.Name.ToString()); } } textBox1.AutoCompleteCustomSource = AutCom; }
private void button1_Click(object sender, EventArgs e) { using (var cmx = new Entities1()) { var PhoneNumber = Convert.ToInt64(textBox1.Text); var d = new Person() { Name = textBox2.Text, Phone_Number = PhoneNumber, Email = textBox3.Text, Type = false }; cmx.Persons.Add(d); if (cmx.SaveChanges() == 1) { MessageBox.Show("تم اضافة عميل بنجاح"); DoReload = true; } } }