C# 从数据库中删除，插入，修改 索引选中条目

概述一。删除1.while (usrListView.SelectedIndex != -1){var currentSelectIndex = usrListView.SelectedIndex;var item = usrView[currentSelectIndex];using (StockManageDataContext smDataContext = new StockManageDataContext()){try{smDataContext.ExecuteCommand("DELETE FROM USERS WHERE ID={0}", item.ID);usrView.RemoveAt(currentSelectIndex);}catch (Exception ex){MessageBox.Show(ex.Message);}}}2.private void MenuItemDelete_Click(object sender, RoutedEventArgs e){if (AddressList.SelectedIndex == -1){MessageBox.Show("请选择一项!");return;}if (MessageBox.Show("确认删除所选定的供应商信息？", "提示", MessageBoxButton.OKCancel) == MessageBoxResult.OK){while (AddressList.SelectedIndex != -1){var currentSelectIndex = AddressList.SelectedIndex;SHDZ selectedAddress = (SHDZ)AddressList.SelectedValue;using (WJKCDataContext wjkc = new WJKCDataContext()){try{wjkc.ExecuteCommand("DELETE FROM SHDZ WHERE CODE={0}", selectedAddress.CODE);addressView.RemoveAt(currentSelectIndex);}catch (Exception ex){MessageBox.Show(ex.Message);}}return;}}}}3.var item = smDataContext.Suppliers.SingleOrDefault(c => c.ID == (int)hl.Tag);if (item != null){try2016-04-04{smDataContext.Suppliers.DeleteOnSubmit(item);smDataContext.SubmitChanges();MessageBox.Show("删除成功！");GetSupplierData();}catch (Exception ex){MessageBox.Show("删除时发生错误！错误信息："+ex.Message);}}smDataContext.Dispose();}  二。插入1.try{using (StockManageDataContext smDataContext = new StockManageDataContext()){smDataContext.Users.InsertOnSubmit(new User { UserName = usrName.Text, Password = pwd, Permission = permissionLevel });smDataContext.SubmitChanges();MessageBox.Show("添加用户改成功！");usrView.Clear();GetData();usrName.IsEnabled = false;PasswordBox1.IsEnabled = false;PasswordBox2.IsEnabled = false;PermimissionLevels.IsEnabled = false;button1.IsEnabled = false;usrName.Text = string.Empty;PasswordBox1.Password = string.Empty;PasswordBox2.Password = string.Empty;PermimissionLevels.SelectedIndex = 0;}}2.try{wjkc.ExecuteCommand(" insert into SHDZ (CODE,DZ,DETAIL,ISTY) values({0},{1},{2},{3})",Code, txtAName.Text.Trim(), txtADetails.Text.Trim(), address.ISTY);lableMsg.Content = "信息添加成功！";lableMsg.Foreground = new SolidColorBrush(Color.FromRgb(0, 0, 255));ClearControls();winParent.Close();// AddressInfoWindow win = new AddressInfoWindow();// win.Show();}三  编辑1.确保 编辑的对象是所选对象，所以传入参数要注意，并且编辑时要先填充控件。 try{wjkc.ExecuteCommand("update SHDZ set DETAIL={0},DZ={1},ISTY={2} where CODE={3};", txtADetails.Text.Trim(), txtAName.Text.Trim(),address.ISTY,address.CODE);lblMsg.Content = "信息修改成功！";lblMsg.Foreground = new SolidColorBrush(Color.FromRgb(0, 0, 255));// this.Window_Closed();this.Close();}catch (Exception ex){MessageBox.Show(ex.Message);}2,。try{using (StockManageDataContext smDataContext = new StockManageDataContext()){string usrname = (this.Parent as LoginWindow).User;var s = smDataContext.Users.Single(c => c.UserName == usrname);s.Password = pwd;smDataContext.SubmitChanges();MessageBox.Show("密码添加成功！");this.NavigationService.Navigate(new Uri("LoginPage.xaml", UriKind.Relative));}}catch (Exception ex){MessageBox.Show(ex.Message);label_warning.Content = "提示：密码修改失败！";} 四，根据Index的值  来判断要编辑item还是要新增item。此步是获得index，前提是父窗口或者子窗口已经传入一个带参。public int Index { get; set; }public SupplierAM(int index){Index = index;InitializeComponent();if (Index > 0){header.Content = "修改供应商信息";StockManageDataContext smDataContext = new StockManageDataContext();var item = smDataContext.Suppliers.SingleOrDefault(c => c.ID == Index);textBox_name.Text = item.PsName;textBox_contacter.Text = item.PsContacter;textBox_tel.Text = item.PsTel;textBox_fax.Text = item.PsFax;}elseheader.Content = "添加供应商信息";}此步是提交按钮的事件。private void button_submit_Click(object sender, RoutedEventArgs e){StockManageDataContext smDataContext = new StockManageDataContext();if (Index > 0){var item = smDataContext.Suppliers.SingleOrDefault(c => c.ID == Index);item.PsName = textBox_name.Text;item.PsContacter = textBox_contacter.Text;item.PsTel = textBox_tel.Text;item.PsFax = textBox_fax.Text;}else{Supplier item = new Supplier();item.PsName = textBox_name.Text;item.PsContacter = textBox_contacter.Text;item.PsTel = textBox_tel.Text;item.PsFax = textBox_fax.Text;smDataContext.Suppliers.InsertOnSubmit(item);}try{smDataContext.SubmitChanges();MessageBox.Show(" *** 作成功！");DialogResult = true;Close();}catch (Exception ex){MessageBox.Show("发生错误！错误信息：" + ex.Message);}finally{smDataContext.Dispose();}} 

一。删除

1.

(usrListVIEw.Selectedindex != - currentSelectIndex = item = (StockManageDataContext smDataContext =

2.

MenuItemDelete_Click( </span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #0000ff;"&gt;if</span> (Address<a href="https://m.jb51.cc/tag/List/" target="_blank" >List</a>.Selecte<a href="https://www.jb51.cc/tag/dind/" target="_blank" >dind</a>ex == -<span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800080;"&gt;1</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000;"&gt;) { Message<a href="https://www.jb51.cc/tag/Box/" target="_blank" >Box</a>.Show(</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800000;"&gt;"</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800000;"&gt;请<a href="https://m.jb51.cc/tag/xuanze/" target="_blank" >选择</a>一项!</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800000;"&gt;"</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000;"&gt;); </span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #0000ff;"&gt;return</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000;"&gt;; } </span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #0000ff;"&gt;if</span> (Message<a href="https://www.jb51.cc/tag/Box/" target="_blank" >Box</a>.Show(<span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800000;"&gt;"</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800000;"&gt;确认<a href="https://www.jb51.cc/tag/shanchu/" target="_blank" >删除</a>所选定的供应商信息？</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800000;"&gt;"</span>,<span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800000;"&gt;"</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800000;"&gt;<a href="https://www.jb51.cc/tag/tishi/" target="_blank" >提示</a></span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800000;"&gt;"</span>,Message<a href="https://www.jb51.cc/tag/Box/" target="_blank" >Box</a><a href="https://m.jb51.cc/tag/button/" target="_blank" >button</a>.OKCancel) ==<span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000;"&gt; Message<a href="https://www.jb51.cc/tag/Box/" target="_blank" >Box</a>Res<a href="https://m.jb51.cc/tag/ul/" target="_blank" >ul</a>t.OK) { </span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #0000ff;"&gt;while</span> (Address<a href="https://m.jb51.cc/tag/List/" target="_blank" >List</a>.Selecte<a href="https://www.jb51.cc/tag/dind/" target="_blank" >dind</a>ex != -<span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800080;"&gt;1</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000;"&gt;){ </span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #0000ff;"&gt;var</span> currentSelectIndex =<span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000;"&gt; Address<a href="https://m.jb51.cc/tag/List/" target="_blank" >List</a>.Selecte<a href="https://www.jb51.cc/tag/dind/" target="_blank" >dind</a>ex; SHDZ selectedAddress </span>=<span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000;"&gt; (SHDZ)Address<a href="https://m.jb51.cc/tag/List/" target="_blank" >List</a>.SelectedValue; </span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #0000ff;"&gt;using</span> (WJK<a href="https://m.jb51.cc/tag/cda/" target="_blank" >cda</a>taContext wjkc = <span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #0000ff;"&gt;new</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000;"&gt; WJK<a href="https://m.jb51.cc/tag/cda/" target="_blank" >cda</a>taContext()) { </span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #0000ff;"&gt;try</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000;"&gt; { wjkc.ExecuteCommand(</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800000;"&gt;"</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800000;"&gt;DELETE FROM SHDZ WHERE CODE={0}</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800000;"&gt;"</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000;"&gt;,selectedAddress.CODE); addressV<a href="https://m.jb51.cc/tag/IE/" target="_blank" >IE</a>w.RemoveAt(currentSelectIndex); } </span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #0000ff;"&gt;catch</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000;"&gt; (Exception ex) { Message<a href="https://www.jb51.cc/tag/Box/" target="_blank" >Box</a>.Show(ex.Message); } } </span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #0000ff;"&gt;return</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000;"&gt;; } } } }</span></pre>

3.

item = smDataContext.suppliers.SingleOrDefault(c => c.ID == ( (item != +

 

 

二。插入

1.

(StockManageDataContext smDataContext = User { Username = usrname.Text,Password = pwd,Permission == = = = = = = = =

2.

= = SolIDcolorBrush(color.Fromrgb(,,

三  编辑

1.

确保 编辑的对象是所选对象，所以传入参数要注意，并且编辑时要先填充控件。

 

wjkc.ExecuteCommand(</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800000;"&gt;"</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800000;"&gt;update SHDZ set DETAIL={0},DZ={1},ISTY={2} where CODE={3};</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800000;"&gt;"</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000;"&gt;,address.ISTY,address.CODE); lblMsg.Content </span>= <span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800000;"&gt;"</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800000;"&gt;信息<a href="https://www.jb51.cc/tag/xiugai/" target="_blank" >修改</a>成功！</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800000;"&gt;"</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000;"&gt;; lblMsg.Foreground </span>= <span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #0000ff;"&gt;new</span> S<a href="https://m.jb51.cc/tag/ol/" target="_blank" >ol</a><a href="https://m.jb51.cc/tag/ID/" target="_blank" >ID</a><a href="https://m.jb51.cc/tag/color/" target="_blank" >color</a>B<a href="https://www.jb51.cc/tag/rush/" target="_blank" >rush</a>(<a href="https://m.jb51.cc/tag/color/" target="_blank" >color</a>.Fr<a href="https://www.jb51.cc/tag/omr/" target="_blank" >omr</a>gb(<span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800080;"&gt;0</span>,<span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800080;"&gt;255</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000;"&gt;)); </span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #008000;"&gt;//</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #008000;"&gt; this.Window_Closed();</span> <span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #0000ff;"&gt;this</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000;"&gt;.Close(); } </span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #0000ff;"&gt;catch</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000;"&gt; (Exception ex) { Message<a href="https://www.jb51.cc/tag/Box/" target="_blank" >Box</a>.Show(ex.Message); }</span></pre>

2,。

(StockManageDataContext smDataContext = usrname = (.Parent s = smDataContext.Users.Single(c => c.Username ===.NavigationService.Navigate( Uri(=

 四，根据Index的值  来判断要编辑item还是要新增item。

此步是获得index，前提是父窗口或者子窗口已经传入一个带参。

Index { ; supplierAM(= (Index > = = item = smDataContext.suppliers.SingleOrDefault(c => c.ID =======

此步是提交按钮的事件。

button_submit_Click(= (Index > item = smDataContext.suppliers.SingleOrDefault(c => c.ID ======= ===== +

 

总结

以上是内存溢出为你收集整理的C# 从数据库中删除，插入，修改 索引选中条目全部内容，希望文章能够帮你解决C# 从数据库中删除，插入，修改 索引选中条目所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。

欢迎分享，转载请注明来源：内存溢出

原文地址: http://outofmemory.cn/langs/1264017.html