C#执行查询的几种方法

最新推荐文章于 2023-11-15 20:37:23 发布

落单枫叶

最新推荐文章于 2023-11-15 20:37:23 发布

阅读量1.1k

点赞数

CC 4.0 BY-SA版权

分类专栏： C# 心得 Access C#+Access

本文链接：https://blog.youkuaiyun.com/luwq168/article/details/39025885

C# 同时被 3 个专栏收录

61 篇文章

订阅专栏

心得

12 篇文章

订阅专栏

C#+Access

8 篇文章

订阅专栏

本文详细介绍了使用C#进行数据库操作的四种方法：通过dataSet、创建DataRow对象、格式化文本和传递参数。每种方法都提供了具体的实现代码，包括如何通过dataSet更新数据、如何创建和填充数据集、如何格式化文本进行插入、以及如何传递参数以增强灵活性。

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

</pre><pre name="code" class="csharp">//C#执行查询的几种方法
//1、交给dataSet
private void Savebutton_Click(object sender, EventArgs e)
{
    try{
        int ret = 0;
        this.Validate();
        this.db_TestBindingSource.EndEdit();
        ret = this.tableAdapterManager.UpdateAll(this.DataSet1);
        MessageBox.Show("添加成功！");
        }
    catch (System.Exception ex)
        {
            MessageBox.Show("添加失败 " + ex.ToString());
        }
}

//2、创建DataRow对象
private void Savebutton_Click(object sender, EventArgs e)
{
    OleDbConnection conn = null;
    string strConnection = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\db_Test.mdb";
    conn = new OleDbConnection(strConnection);
	OleDbDataAdapter da ＝ new OleDbDataAdapter(@"select * from tb_Test", conn);
    DataSet ds = new DataSet();
    da.Fill(ds);
    DataRow drx = da.Tables[0].NewRow();
    drx["Id"] = this.idTextBox.Text;
    drx["values"] = this.valuesTextBox.Text;
    ds.Tables[0].Rows.Add(drx);
    da.Update(ds);
}



//3、格式化文本 
private void Savebutton_Click(object sender, EventArgs e)
        {
            OleDbConnection conn = null;
            string strConnection = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\db_Test.mdb";
            conn = new OleDbConnection(strConnection);
            string sql = string.Format("insert into  tb_Test (Id,value) values ('{0}', '{1}')", this.idTextBox.Text,this.valuesTextBox.Text);
            OleDbCommand cmd = new OleDbCommand(sql, conn);
            conn.Open();
            try
            {
                int rowCount = cmd.ExecuteNonQuery();
                if (rowCount == 1)
                {
 
                    MessageBox.Show("添加成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                else
                {
                    MessageBox.Show("添加失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
            catch (Exception ex)
            {
                conn.Close();  
                MessageBox.Show(ex.Message);
            }
            
	}
//4、传递参数
private void Savebutton_Click(object sender, EventArgs e)
        {
            OleDbConnection conn = null;
            string strConnection = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\db_Test.mdb";
            conn = new OleDbConnection(strConnection);
           string sql = "insert into  tb_Test (Id,value) values (@Id, @value)";
            OleDbCommand cmd = new OleDbCommand();
            cmd.Connection = conn
            cmd.CommandType = Text;
            cmd.CommandText = sql
            cmd.Parameters.Add(new OleDbParameter(@Id, this.idTextBox.Text)); // cmd.Parameters.AddwithValue(@Id, this.idTextBox.Text)
            cmd.Parameters.Add(new OleDbParameter(@value, this.valueTextBox.Text));//cmd.Parameters.AddwithValue(@value, this.valueTextBox.Text)
            try
            {
                int rowCount = cmd.ExecuteNonQuery();
                if (rowCount == 1)
                {
 
                    MessageBox.Show("添加成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                else
                {
                    MessageBox.Show("添加失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
            catch (Exception ex)
            {
                conn.Close();
                MessageBox.Show(ex.Message);
            }

	}