背景:#EDF0F5 #FAFBE6 #FFF2E2 #FDE6E0 #F3FFE1 #DAFAF3 #EAEAEF 默认  
阅读内容

C#中XML的写入方法

[日期:2008-07-21] 来源:  作者: [字体: ]
       using System;
        using System.Data;
        using System.Data.OleDb;
        namespace ConsoleDataSet
        {
            /// <summary>
            /// Class1 的摘要说明。
            /// </summary>
            class DataSetClass
            {
                /// <summary>
                /// 应用程序的主入口点。
                /// </summary>
                [STAThread]
                static void Main(string[] args)
                {
                    string strCon = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=DataBase.mdb";
                    // 定义连接
                    OleDbConnection MyCon = new OleDbConnection(strCon);
                    try
                    {
                        // 打开连接
                        MyCon.Open();
                        string strSQL = @"select * from ADODemo";
                        OleDbDataAdapter MyDataAdapter = new OleDbDataAdapter();
                        MyDataAdapter.SelectCommand = new OleDbCommand(strSQL, MyCon);
                        // 将数据填充到DataSet中
                        DataSet MyDataSet = new DataSet();
                        MyDataAdapter.Fill(MyDataSet, "ADODemo");
                        // 从DataSet中获取DataTable
                        DataTable MyDataTable = MyDataSet.Tables["ADODemo"];
                        // 设置“姓名”字段不能为空
                        MyDataTable.Columns["姓名"].AllowDBNull = false;
                        // 修改第一行的姓名
                        MyDataTable.Rows[0]["姓名"] = "赵六";
                        MyDataTable.Rows[0]["姓名"] = "张三";
                        // 添加一条新记录
                        DataRow NewRow = MyDataTable.NewRow();
                        NewRow["姓名"] = "赵六";
                        NewRow["年龄"] = 22;
                        MyDataTable.Rows.Add(NewRow);
                        foreach (DataRow row in MyDataTable.Rows)
                        {
                            Console.WriteLine("姓名:{0} 年龄:{1}", row["姓名"].ToString(), row["年龄"].ToString());
                        }
                        // 将DataSet中的数据更新到数据库中
                        OleDbCommandBuilder MyCommandBuilder = new OleDbCommandBuilder(MyDataAdapter);
                        MyDataAdapter.Update(MyDataSet, "ADODemo");
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine("{0}", ex.ToString());
                    }
                    finally
                    {
                        MyCon.Close();
                    }
                    Console.ReadLine();
                }
            }
        }
阅读:
录入:dm

推荐 】 【 打印
相关新闻      
本文评论       全部评论
发表评论
  • 尊重网上道德,遵守中华人民共和国的各项有关法律法规
  • 承担一切因您的行为而直接或间接导致的民事或刑事法律责任
  • 本站管理人员有权保留或删除其管辖留言中的任意内容
  • 本站有权在网站内转载或引用您的评论
  • 参与本评论即表明您已经阅读并接受上述条款


点评: 字数
姓名:
内容查询