DataSet OP DBServer

最新推荐文章于 2025-04-16 10:11:35 发布

原创最新推荐文章于 2025-04-16 10:11:35 发布 · 400 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#dataset #string #security

本文介绍了一个使用 C# 进行 SQL 数据操作的例子，包括连接数据库、填充数据集、更新数据等步骤，并展示了如何将数据集序列化到文件及从文件反序列化。

string Op = "";

System.Data.DataSet dbset = new DataSet();

            string linkstr = @"Integrated Security=SSPI;server=127.0.0.1";
            System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(linkstr);
            con.Open();

            string sqlstr = "select top 0 * from mytest.dbo.info";
            System.Data.SqlClient.SqlDataAdapter adp = new System.Data.SqlClient.SqlDataAdapter(sqlstr, con);
            System.Data.SqlClient.SqlCommandBuilder cb = new System.Data.SqlClient.SqlCommandBuilder(adp); //关键语句

adp.Fill(dbset);
dbset.Tables[0].TableName = "基本信息表";

            //System.IO.FileStream Fsc = new System.IO.FileStream(Application.StartupPath + @"/data.dat", System.IO.FileMode.Open);
            //System.Runtime.Serialization.Formatters.Binary.BinaryFormatter Fc = new System.Runtime.Serialization.Formatters.Binary.BinaryFormatter();
            //dbset = Fc.Deserialize(Fsc) as DataSet;
            //Fsc.Close();

            DataRow row = dbset.Tables[0].NewRow();
            row["姓名"] = "李四";
            dbset.Tables[0].Rows.Add(row);

            if (Op == "LocalSave")
            {
                System.IO.FileStream Fsd = new System.IO.FileStream(Application.StartupPath + @"/data.dat", System.IO.FileMode.Create);
                System.Runtime.Serialization.Formatters.Binary.BinaryFormatter Fd = new System.Runtime.Serialization.Formatters.Binary.BinaryFormatter();
                Fd.Serialize(Fsd, dbset);
                Fsd.Close();
            }
            else
            {
                adp.Update(dbset, "基本信息表");
            }

            adp.Dispose();
            con.Close();
            con.Dispose();

MessageBox.Show("Complete");