DataSet OP DBServer

           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");