C# MySqlDataAdapter、DataBingSource数据绑定

 ComS.Myconn.Close(); ComS.Myconn.Open();


                    dataSet1.Clear();
                    //日期格式问题比较重要，要进一步处理               
                    Myadapter = new MySqlDataAdapter(strSql, ComS.Myconn);
                    //如果不指定表名，则系统自动生成一个默认的表名            
              
                    Myadapter = new MySqlDataAdapter("select id,name,case UsedFlag when 1 then '" + ComS._InUsed + "' else '" + ComS._Nullify + "' end as state,UsedFlag from Branch order by id", ComS.Myconn);
                    Myadapter.Fill(dataSet1,"Branch");
                    bsBranch.DataMember = "Branch"; bsBranch.DataSource = dataSet1;
                    bnBranch.BindingSource = bsBranch;
                    dataGridView5.AutoGenerateColumns = false;
                    dataGridView5.DataSource = bsBranch;

                    ComS.Myconn.Close();

    try
            {
                s = "select * "
                    + "  from  ReCharge1  where EditFlag between '{0}' and '{1}' " +s;


                if (dataSet1.Tables.Contains("ListTable"))
                    dataSet1.Tables.Remove("ListTable");
                DateTime dtBegin = new DateTime(dtpBeginDate.Value.Year, dtpBeginDate.Value.Month, dtpBeginDate.Value.Day, dtpSTime.Value.Hour, dtpSTime.Value.Minute, dtpSTime.Value.Second);
                DateTime dtEnd = new DateTime(dtpEndDate.Value.Year, dtpEndDate.Value.Month, dtpEndDate.Value.Day, dtpETime.Value.Hour, dtpETime.Value.Minute, dtpETime.Value.Second);
             
                s = string.Format(s, dtBegin, dtEnd);
                ComS.Myconn.Close();
                ComS.Myconn.Open();
                Myadapter = new MySqlDataAdapter(s, ComS.Myconn);
                //如果不指定表名，则系统自动生成一个默认的表名            
                Myadapter.Fill(dataSet1, "ListTable");


                bsList.DataMember = "";
                bsList.DataSource = null;
                bsList.DataMember = "ListTable";
                bsList.DataSource = dataSet1;
                decimal p = 0, r = 0, pOut = 0, rOut = 0;
                int get5coin = 0, get10coin = 0, get1paper = 0, get5paper = 0, get10paper = 0,get20paper=0,out5coin=0,out10coin=0;
                bsList.MoveFirst();
                for (int i = 1; i <= bsList.Count; i++)
                {
                    //关于金额
                    p = p + Convert.ToDecimal((bsList.Current as DataRowView).Row["amountreceivable"].ToString());
                    r = r + Convert.ToDecimal((bsList.Current as DataRowView).Row["realreceivable"].ToString());
                    pOut = pOut + Convert.ToDecimal((bsList.Current as DataRowView).Row["outchange"].ToString());
                    rOut = rOut + Convert.ToDecimal((bsList.Current as DataRowView).Row["realchange"].ToString());
                    //关于关于数量
                    get5coin = get5coin + Convert.ToInt32((bsList.Current as DataRowView).Row["coin5receivable"].ToString());
                    get10coin = get10coin + Convert.ToInt32((bsList.Current as DataRowView).Row["coin10receivable"].ToString());
                    get1paper = get1paper + Convert.ToInt32((bsList.Current as DataRowView).Row["paper1receivable"].ToString());
                    get5paper = get5paper + Convert.ToInt32((bsList.Current as DataRowView).Row["paper5receivable"].ToString());
                    get10paper = get10paper + Convert.ToInt32((bsList.Current as DataRowView).Row["paper10receivable"].ToString());
                    get20paper = get20paper + Convert.ToInt32((bsList.Current as DataRowView).Row["paper20receivable"].ToString());
                    out5coin = out5coin + Convert.ToInt32((bsList.Current as DataRowView).Row["out5change"].ToString());
                    out10coin = out10coin + Convert.ToInt32((bsList.Current as DataRowView).Row["out10change"].ToString());
                    bsList.MoveNext();
                }


                bsList.AddNew();
                (bsList.Current as DataRowView).Row["plate"] = "合计";
                (bsList.Current as DataRowView).Row["amountreceivable"] = p;
                (bsList.Current as DataRowView).Row["realreceivable"] = r;
                (bsList.Current as DataRowView).Row["outchange"] = pOut;
                (bsList.Current as DataRowView).Row["realchange"] = rOut;


                (bsList.Current as DataRowView).Row["coin5receivable"] = get5coin;
                  (bsList.Current as DataRowView).Row["coin10receivable"] = get10coin;
                  (bsList.Current as DataRowView).Row["paper1receivable"] = get1paper;
                  (bsList.Current as DataRowView).Row["paper5receivable"] = get5paper;
                  (bsList.Current as DataRowView).Row["paper10receivable"] = get10paper;
                  (bsList.Current as DataRowView).Row["paper20receivable"] = get20paper;
                  (bsList.Current as DataRowView).Row["out5change"] = out5coin;
                  (bsList.Current as DataRowView).Row["out10change"] = out10coin;
                  bsList.EndEdit();


                dataGridView1.DataSource = bsList;


            }
            catch (Exception err)
            {
                MessageBox.Show(err.Message, ComS._Prompt);
            }