連鎖中心配送系統：連鎖店模塊的管理[2]

    ——此文章摘自《ASPNET +SQL Server網絡應用系統開發案例精解》定價￥　特價￥ 詳細>>http://tracklinktechcn/?m_id=dangdang&a_id=A&l=&l_type= width= height= border= nosave>

    （）響應編輯事件
    //單擊編輯按鈕所觸發的事件
    public void STmyGrid_edit(object source SystemWebUIWebControlsDataGridCommandEventArgs e)
    {
             //獲取DataGrid所要編輯的項的索引
             STmyGridEditItemIndex=(int)eItemItemIndex;
             BindGrid();
    }

    （）響應更新事件
    獲取編輯狀態下的文本框中的值並把它們賦值給更新語句的參數然後執行SQL語句退出編輯狀態並重新顯示數據
    //單擊更新按鈕所觸發的事件
    public void STmyGrid_update(object source SystemWebUIWebControlsDataGridCommandEventArgs e)
    {
             //創建更新連鎖店信息的sql語句
             string STstrsql=update STDep  set STDepName = @STDepName STDepMaster = @STDepMaster STDepInfo = @STDepInfo where STDepID = @STDepID;
             //創建數據庫的SqlCommand對象
             SqlCommand STcmd=new SqlCommand(STstrsqlSTconn);
             try
             {
                       //向SqlCommand對象添加參數
                       STcmdParametersAdd(new SqlParameter(@STDepIDSqlDbTypeInt));
                       STcmdParametersAdd(new SqlParameter(@STDepNameSqlDbTypeVarChar));
                       STcmdParametersAdd(new SqlParameter(@STDepMasterSqlDbTypeVarChar));
                       STcmdParametersAdd(new SqlParameter(@STDepInfoSqlDbTypeVarChar));
                       string stupdatetext=((TextBox)eItemCells[]Controls[])Text ;
                       //向參數賦值
                       STcmdParameters[@STDepName]Value=stupdatetext;
                       stupdatetext=((TextBox)eItemCells[]Controls[])Text;
                       STcmdParameters[@STDepMaster]Value=stupdatetext;
                       stupdatetext=((TextBox)eItemCells[]Controls[])Text;
                       STcmdParameters[@STDepInfo]Value=stupdatetext;

right>[http://developcsaicn/dotnet_ASP/htm>]  []  [http://developcsaicn/dotnet_ASP/htm>]  [http://developcsaicn/dotnet_ASP/htm>]  [http://developcsaicn/dotnet_ASP/htm>]  

From:http://tw.wingwit.com/Article/program/net/201311/15611.html