急救各位仁兄帮忙呀（ado.net问题）。。

C# SQL 数据操作

最新推荐文章于 2025-08-24 12:00:00 发布

原创最新推荐文章于 2025-08-24 12:00:00 发布 · 255 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#dataset #login #string #object #security #table

本文介绍了一个使用 C# 进行 SQL 数据库操作的应用实例，包括数据表的创建、数据的增删改查等功能，并详细展示了如何通过 DataSet 和 SqlDataAdapter 在 Windows 应用程序中与 SQL Server 数据库进行交互。

using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace WindowsApplication1
{
    public partial class Form1 : Form
    {

        DataSet objDataSet;
       SqlDataAdapter objSqlDataAdapter;
        SqlConnection objSqlConnection;
        DataColumn column;
        string str = "server=.;database=text;Integrated Security=sspi";
        public Form1()
        {
            InitializeComponent();
            DataTable table = new DataTable("login");
            column = new DataColumn("id");
            column.AutoIncrement = true;
            column.AutoIncrementSeed = 1;
            column.AutoIncrementStep = 1;
            column.ReadOnly = true;
            table.Columns.Add(column);

            column = new DataColumn("name");
            column.DataType=typeof(System.String);
            table.Columns.Add(column);

            column = new DataColumn("sex");
            column.DataType=typeof(System.String);
            column.DefaultValue = "男";
            column.AllowDBNull = false;
            table.Columns.Add(column);

            column = new DataColumn("age");
            column.DataType=typeof(System.Int32);
            table.Columns.Add(column);

            table.PrimaryKey = new DataColumn[]
           {
               table.Columns["id"]
           };
            objDataSet = new DataSet();
            objDataSet.Tables.Add(table);
        }

        private void Form1_Load(object sender, EventArgs e)
        {

           using(objSqlConnection = new SqlConnection(str))
           {
            objSqlDataAdapter = new SqlDataAdapter("select * from login", objSqlConnection);
            objSqlDataAdapter.Fill(objDataSet, "login");
           }
        }

        private void btnInsert_Click(object sender, EventArgs e)
        {
            string name = this.txtName.Text;
            string sex = this.txtsex.Text;
            if (sex == "" || sex == null)
            {
                sex = "男";
            }
            int age = Convert.ToInt32(this.txtage.Text);

            using (objSqlDataAdapter = new SqlDataAdapter())
            {
                objSqlDataAdapter.InsertCommand = objSqlConnection.CreateCommand();
                string secmd = string.Format("insert into login values('{0}','{1}','{2}')", name, sex, age);
                objSqlDataAdapter.InsertCommand.CommandText = secmd;

                DataRow row = objDataSet.Tables[0].NewRow();
                row["name"] = name;
                row["sex"] = sex;
                row["age"] = age;
                objDataSet.Tables[0].Rows.Add(row);
                MessageBox.Show("添加成功！");
            }


            this.bangding();
        }

        private void bangding()
        {
            dataGridView1.DataSource = objDataSet.Tables["login"];
        }

        private void btnSelect_Click(object sender, EventArgs e)
        {

            string name = this.txtSelectName.Text;
            DataView view = new DataView(objDataSet.Tables["login"]);
             string str=string.Format("name like '%{0}%'",name);
            view.RowFilter=str;
            dataGridView1.DataSource =view;
        }

        private void btnUpdate_Click(object sender, EventArgs e)
        {
            int id=Convert.ToInt32(this.txtid.Text);
            string name = this.txtName.Text;
            string sex = this.txtsex.Text;
            int age = Convert.ToInt32(this.txtage.Text);
            DataRow row = objDataSet.Tables["login"].Rows.Find(id);
            row["name"] = name;
            row["sex"] = sex;
            row["age"] = age;
            this.bangding();
        }

        private void btnDelete_Click(object sender, EventArgs e)
        {
            int id = Convert.ToInt32(this.txtid.Text);
            objDataSet.Tables["login"].Rows.RemoveAt(id-1);
            bangding();
        }

        private void btnClose_Click(object sender, EventArgs e)
        {
            //这块不知道怎么写了
                objSqlDataAdapter.Update(objDataSet, "login");

        }

}
}

我是这么想的在添加数据时不去马上更新数据库只在 dataset中添加更新删除也是等都做完了在把整个 dataset 更新会库里有些地方不太会写帮个忙了