利用DataGridView增加,修改,删除数据

最新推荐文章于 2021-03-26 14:04:05 发布

emailqjc

最新推荐文章于 2021-03-26 14:04:05 发布

阅读量3.3k

点赞数

分类专栏： c#技巧文章标签： string sql object 数据库 class

本文链接：https://blog.csdn.net/emailqjc/article/details/5349079

版权

c#技巧专栏收录该内容

35 篇文章

订阅专栏

本文介绍了一种通过SQL语句更新DataGridView中数据的方法，并详细解释了实现步骤，包括创建DataTable，建立SqlDataAdapter连接，执行SQL查询，更新DataGridView数据等关键步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1、保存DataGridView所做修改方法

       /// <summary>
        /// 保存DataGridView所做修改
        /// </summary>
        /// <param name="sql"></param>
        /// <param name="myConn"></param>
        /// <param name="dg"></param>
        /// <returns></returns>
        public bool UpdateDataGridView(string sql, SqlConnection myConn, DataGridView dg)
        {
            bool result = true;

            try
            {
                DataTable dt = new DataTable();

SqlDataAdapter ada = new SqlDataAdapter(sql, myConn);
SqlCommandBuilder cb = new SqlCommandBuilder(ada);

dt = ((DataTable)dg.DataSource).Copy();

                ada.Update(dt);
                dg.Update();
                dt.AcceptChanges();
            }
            catch
            {
                result = false;
            }
            return result;
        }
２、调用

public partial class frmExpInfoMangent : Form
{
        eCMy.DataAccessLibrary.Data.Database ecMy;
        SqlDataAdapter adpOrders;
        SMSMangent mySms = new SMSMangent();
        System.Data.Common.DbConnection myDbConn;

string strSql = "select [ExpenseID] as f_id,substring(cast([ExpenseID] as varchar),1,len([ExpenseID])-3) as f_front,expensemc as f_name,userid from eCBMExpense ";

        public frmExpInfoMangent()
        {
            InitializeComponent();

ecMy = eCMy.DataAccessLibrary.Data.DatabaseFactory.CreateDatabase();

myDbConn = ecMy.CreateConnection();
}

        private void BindData() //帮定数据库数据到DataGridView显示
        {
            this.dataGridView1.DataSource = ecMy.SimpleExecuteDataSet(" select [ExpenseID] as f_id,substring(cast([ExpenseID] as varchar),1,len([ExpenseID])-3) as f_front,expensemc as f_name,userid from eCBMExpense ").Tables[0];

}

        private void frmExpInfoMangent_Load(object sender, EventArgs e)
        {
            BindData();
        }
}