示例#1
0
        public Form1()
        {
            InitializeComponent();
            db = new MooglenomicsDatabaseDataContext();
            try
            {
                User u = db.Users.SingleOrDefault(p => p.UserID == 1);
                if (u == null)
                {
                    User systemUser = new User();
                    systemUser.UserID = 1;
                    systemUser.UserName = "******";
                    systemUser.password = "******";
                    db.Users.InsertOnSubmit(systemUser);
                    db.SubmitChanges();
                }

                List<string> catNames = new List<string>();
                foreach (ItemCategory ic in db.ItemCategories.ToList())
                {
                    catNames.Add(ic.CategoryName);
                }
                category_Combobox.Items.AddRange(catNames.ToArray());

            }
            catch
            {
                MessageBox.Show("Database Connection Failed.  Exiting");
            }
        }
 partial void UpdateUser(User instance);
 partial void DeleteUser(User instance);
 partial void InsertUser(User instance);