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

发布时间：2020-12-15 04:38:43 所属栏目：百科来源：网络整理

导读：一。删除 1. (usrListView.SelectedIndex != - currentSelectIndex = item = (StockManageDataContext smDataContext = 2. MenuItemDelete_Click( /spanspan style="color: #0000ff;"gt;if/span (AddressList.SelectedIndex == -span style="color: #800080;

一。删除

(usrListView.SelectedIndex != - currentSelectIndex = item = (StockManageDataContext smDataContext =

MenuItemDelete_Click(

        </span><span style="color: #0000ff;"&gt;if</span> (AddressList.SelectedIndex == -<span style="color: #800080;"&gt;1</span><span style="color: #000000;"&gt;)
        {
            MessageBox.Show(</span><span style="color: #800000;"&gt;"</span><span style="color: #800000;"&gt;请选择一项!</span><span style="color: #800000;"&gt;"</span><span style="color: #000000;"&gt;);
            </span><span style="color: #0000ff;"&gt;return</span><span style="color: #000000;"&gt;;
        }
            </span><span style="color: #0000ff;"&gt;if</span> (MessageBox.Show(<span style="color: #800000;"&gt;"</span><span style="color: #800000;"&gt;确认删除所选定的供应商信息？</span><span style="color: #800000;"&gt;"</span>,<span style="color: #800000;"&gt;"</span><span style="color: #800000;"&gt;提示</span><span style="color: #800000;"&gt;"</span>,MessageBoxButton.OKCancel) ==<span style="color: #000000;"&gt; MessageBoxResult.OK)
            {
                </span><span style="color: #0000ff;"&gt;while</span> (AddressList.SelectedIndex != -<span style="color: #800080;"&gt;1</span><span style="color: #000000;"&gt;){
                </span><span style="color: #0000ff;"&gt;var</span> currentSelectIndex =<span style="color: #000000;"&gt; AddressList.SelectedIndex;
                SHDZ selectedAddress </span>=<span style="color: #000000;"&gt; (SHDZ)AddressList.SelectedValue;
                </span><span style="color: #0000ff;"&gt;using</span> (WJKCDataContext wjkc = <span style="color: #0000ff;"&gt;new</span><span style="color: #000000;"&gt; WJKCDataContext())
                {
                    </span><span style="color: #0000ff;"&gt;try</span><span style="color: #000000;"&gt;
                    {
                        wjkc.ExecuteCommand(</span><span style="color: #800000;"&gt;"</span><span style="color: #800000;"&gt;DELETE FROM SHDZ WHERE CODE={0}</span><span style="color: #800000;"&gt;"</span><span style="color: #000000;"&gt;,selectedAddress.CODE);
                        addressView.RemoveAt(currentSelectIndex);
                    }
                    </span><span style="color: #0000ff;"&gt;catch</span><span style="color: #000000;"&gt; (Exception ex)
                    {
                        MessageBox.Show(ex.Message);
                    }
                }
                </span><span style="color: #0000ff;"&gt;return</span><span style="color: #000000;"&gt;;
                }
            }
        }
    }</span></pre>

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

二。插入

(StockManageDataContext smDataContext = User { UserName = usrName.Text,Password = pwd,Permission == = = = = = = = =

= = SolidColorBrush(Color.FromRgb(,,

三? 编辑

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

                wjkc.ExecuteCommand(</span><span style="color: #800000;"&gt;"</span><span style="color: #800000;"&gt;update SHDZ set DETAIL={0},DZ={1},ISTY={2} where CODE={3};</span><span style="color: #800000;"&gt;"</span><span style="color: #000000;"&gt;,address.ISTY,address.CODE);
                lblMsg.Content </span>= <span style="color: #800000;"&gt;"</span><span style="color: #800000;"&gt;信息修改成功！</span><span style="color: #800000;"&gt;"</span><span style="color: #000000;"&gt;;
                lblMsg.Foreground </span>= <span style="color: #0000ff;"&gt;new</span> SolidColorBrush(Color.FromRgb(<span style="color: #800080;"&gt;0</span>,<span style="color: #800080;"&gt;255</span><span style="color: #000000;"&gt;));
               </span><span style="color: #008000;"&gt;//</span><span style="color: #008000;"&gt; this.Window_Closed();</span>
                <span style="color: #0000ff;"&gt;this</span><span style="color: #000000;"&gt;.Close();
            }
            </span><span style="color: #0000ff;"&gt;catch</span><span style="color: #000000;"&gt; (Exception ex)
            {
                MessageBox.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# 从数据库中删除，插入，修改索引选中条目