[C#学习] 利用LINQ TO SQL向数据库添加数据

//第一步 根据DataContext中的表AdminData创建一个新实例
private InspectionAdminDataContext InspectionData = new InspectionAdminDataContext();
AdminData adminData = new AdminData
            {
                date = dateEdit1.DateTime.Date,
                unit = comboBoxEdit1.Text,
                item = comboBoxEdit2.Text,
                itemcontent = comboBoxEdit3.Text,
                problem = comboBoxEdit4.Text,
                detail = memoEdit1.Text,
                person = textEdit2.Text,
                deal = memoEdit2.Text
            };

//第二步 向表的InsertOnSubmit添加该实例
            InspectionData.AdminData.InsertOnSubmit(adminData);

//第三步 DataContext提交变化SubmitChanges
            try
            {
                InspectionData.SubmitChanges();
                MessageBox.Show("数据已添加。", "通知", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            catch (Exception exception)
            {
                MessageBox.Show("There is an Error", "Error",MessageBoxButtons.OK, MessageBoxIcon.Error);
            }

 

转载于:https://www.cnblogs.com/AngryZe/p/7449468.html