且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

本地数据库,我需要一些例子

更新时间:2023-02-03 22:37:37

根据你也可以考虑SQL CE的需求。我敢肯定的是,如果你想使用,或您的要求的数据库,如果你是乌苏雷你会得到连接字符串等适当的和实际的例子。

Depending on the needs you could also consider Sql CE. I'm sure that if you specified the database you're thinking of using, or your requirements if you're usure you would get proper and real examples of connection strings etc.

编辑:这里是code为SQLCE / SQL精简

Here's code for SqlCe / Sql Compact

    public void ConnectListAndSaveSQLCompactExample()
    {
        // Create a connection to the file datafile.sdf in the program folder
        string dbfile = new System.IO.FileInfo(System.Reflection.Assembly.GetExecutingAssembly().Location).DirectoryName + "\\datafile.sdf";
        SqlCeConnection connection = new SqlCeConnection("datasource=" + dbfile);

        // Read all rows from the table test_table into a dataset (note, the adapter automatically opens the connection)
        SqlCeDataAdapter adapter = new SqlCeDataAdapter("select * from test_table", connection);
        DataSet data = new DataSet();
        adapter.Fill(data);

        // Add a row to the test_table (assume that table consists of a text column)
        data.Tables[0].Rows.Add(new object[] { "New row added by code" });

        // Save data back to the databasefile
        adapter.Update(data);

        // Close 
        connection.Close();
    }

记住要添加一个引用System.Data.SqlServerCe

Remember to add a reference to System.Data.SqlServerCe