datagrid用法

   private void mfrm_Load(object sender, EventArgs e)
        {
            MainGrid.AutoGenerateColumns = false;
            MainGrid.InitDataGrid("select * from V_stock_Init");         
           
            Plan_State.DataSource =
                   ado.ExeDataTable("select S_Subcode,S_Subname from T_Public_Sort_detail where S_COde='Plan_OrderState'");
            Plan_State.ValueMember= "S_Subcode";
            Plan_State.DisplayMember = "S_Subname";
            Audit_State.DataSource = ado.ExeDataTable("select S_Subcode,S_Subname from T_Public_Sort_detail where S_Code='Audit_State'");
            Audit_State.ValueMember = "S_Subcode";
            Audit_State.DisplayMember = "S_SubName";
            if (tabControl1.SelectedTab.Tag.ToString() =="1")
            {
                SaveBut.Enabled = false;
            }

        }

        private void toolStripButton2_Click(object sender, EventArgs e)
        {
            this.Close();
        }
/// <summary>
/// 主从表关联
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
        private void MainGrid_RowEnter(object sender, DataGridViewCellEventArgs e)
        {
            //绑定采购结清操作界面的域

            if (MainGrid.Rows.Count > 0)
            {
                string ID = MainGrid.Rows[e.RowIndex].Cells["Stock_MCODE"].Value.ToString();
                SubGrid.AutoGenerateColumns = false;
                SubGrid.InitDataGrid("select * from V_Stock_DetailInit where stock_code='" + ID + "'");
                eStock_CODE.DataBindings.Clear();
                eStock_CODE.DataBindings.Add("Text", SubGrid.DataSource, "Stock_CODE");
                eStock_ItemCode.DataBindings.Clear();
                eStock_ItemCode.DataBindings.Add("Text", SubGrid.DataSource, "Stock_ItemCode");
                eSP_Id.DataBindings.Clear();
                eSP_Id.DataBindings.Add("Text", SubGrid.DataSource, "SP_Id");
                eG_Code.DataBindings.Clear();
                eG_Code.DataBindings.Add("Text", SubGrid.DataSource, "G_Code");
                eG_HelpCode.DataBindings.Clear();
                eG_HelpCode.DataBindings.Add("Text", SubGrid.DataSource, "G_HelpCode");
                eGu_Code.DataBindings.Clear();
                eGu_Code.DataBindings.Add("Text", SubGrid.DataSource, "Gu_Code");
                eG_Name.DataBindings.Clear();
                eG_Name.DataBindings.Add("Text", SubGrid.DataSource, "G_Name");
                eG_Spec.DataBindings.Clear();
                eG_Spec.DataBindings.Add("Text", SubGrid.DataSource, "G_Spec");
                eS_NumBer.DataBindings.Clear();
                eS_NumBer.DataBindings.Add("Text", SubGrid.DataSource, "S_NumBer");
                eS_OrderType.DataBindings.Clear();
                eS_OrderType.DataBindings.Add("Text", SubGrid.DataSource, "S_OrderType");
                eP_Startdate.DataBindings.Clear();
                eP_Startdate.DataBindings.Add("Text", SubGrid.DataSource, "P_Startdate");
                eS_UPrice.DataBindings.Clear();
                eS_UPrice.DataBindings.Add("Text", SubGrid.DataSource, "S_UPrice");
                eS_SPrice.DataBindings.Clear();
                eS_SPrice.DataBindings.Add("Text", SubGrid.DataSource, "S_SPrice");
                eS_tax.DataBindings.Clear();
                eS_tax.DataBindings.Add("Text", SubGrid.DataSource, "S_tax");
                eS_GetDate.DataBindings.Clear();
                eS_GetDate.DataBindings.Add("Text", SubGrid.DataSource, "S_GetDate");
                eS_TempNum.DataBindings.Clear();
                eS_TempNum.DataBindings.Add("Text", SubGrid.DataSource, "S_TempNum");
                eS_RecNum.DataBindings.Clear();
                eS_RecNum.DataBindings.Add("Text", SubGrid.DataSource, "S_RecNum");
                eAccept_Date.DataBindings.Clear();
                eAccept_Date.DataBindings.Add("Text", SubGrid.DataSource, "Accept_Date");
                eS_CallNum.DataBindings.Clear();
                eS_CallNum.DataBindings.Add("Text", SubGrid.DataSource, "S_CallNum");
                eCancel_Bale.DataBindings.Clear();
                eCancel_Bale.DataBindings.Add("Text", SubGrid.DataSource, "Cancel_Bale");
                eCancel_date.DataBindings.Clear();
                eCancel_date.DataBindings.Add("Text", SubGrid.DataSource, "Cancel_date");
                eMemo.DataBindings.Clear();
                eMemo.DataBindings.Add("Text", SubGrid.DataSource, "Memo");
                eS_Error.DataBindings.Clear();
                eS_Error.DataBindings.Add("Checked", SubGrid.DataSource, "S_Error");
                IDtxt.DataBindings.Clear();
                IDtxt.DataBindings.Add("Text", SubGrid.DataSource, "ID");
                eS_Close.DataBindings.Clear();
                eS_Close.DataBindings.Add("Checked", SubGrid.DataSource, "S_Close");
                                          
            }
         
            Int32 rowcount = SubGrid.Rows.Count;
            for (int i = 0; i < rowcount; i++)
            {
                if (! (bool)(((DataRowView)SubGrid.Rows[i].DataBoundItem).Row["S_Close"]))                      
                {
                    //SubGrid.CurrentRow.DefaultCellStyle.BackColor = Color.FromArgb(255, 0, 0);
                    SubGrid.Rows[i].DefaultCellStyle.BackColor = Color.FromArgb(255, 0, 0);               
                }
            }

        }