WPF以access为数据库，简单实现一个显示数据和更新数据的实例

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了WPF以access为数据库，简单实现一个显示数据和更新数据的实例，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含4592字，纯文字阅读大概需要7分钟。

内容图文

1.0" encoding="utf-8" ?> <configuration> <startup> <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5.1" /> </startup> <connectionStrings> <add name="conn" connectionString ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db.mdb;Persist Security Info=False" /> </connectionStrings> </configuration>

3、创建连接数据库的类

    public class DbHelper
    {
        public static OleDbConnection getCon(){
            string strcon = System.Configuration.ConfigurationManager.ConnectionStrings["conn"].ToString();
            return new OleDbConnection(strcon);
        }
       
    }

4、创建Model类

public class Person
    {
        public string username { get; set; }
        public string pwd { get; set; }
        public int age { get; set; }
        public DateTime createdate { get; set; }
        public DateTime updatedate { get; set; }
        public string classroom { get; set; }
        public int id { get; set; }
    }

5、在mainwindow.cs类中添加数据和绑定数据

        private Random rnd = new Random();
        private ObservableCollection<Person> list { get; set; }
        public MainWindow()
        {
            InitializeComponent();
            add();//添加数据
            BindData();//绑定数据
            cr.ItemsSource = new List<string> { "一班", "二班", "三班" };
        }
       
        public void BindData()
        {
            using (var conn = DbHelper.getCon())
            {
                list = new ObservableCollection<Person>(conn.Query<Person>("select * from users").ToList<Person>());
            }
            this.DataContext = list;
        }
        
        public void add()
        {
            using (var db = DbHelper.getCon())
            {
                for (int i = 0; i < 10; i++)
                {
                    db.Execute("insert into users(username,pwd,age,createDate,classroom) values(@username,@pwd,@age,@createDate,@classroom)", new
                    {
                        username = "张三",
                        pwd = "123",
                        age = rnd.Next(20),
                        createDate=DateTime.Now.ToString(),
                        classroom = "一班"
                    });
                }
            }
        }

6、界面设计：

<Window x:Class="WpfApplication3.MainWindow"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        Title="MainWindow" Height="350" Width="525">
    <Grid>
        <Grid.RowDefinitions>
            <RowDefinition Height="auto"/>
            <RowDefinition Height="*"/>
            <RowDefinition Height="auto"/>
            <RowDefinition Height="22"/>
        </Grid.RowDefinitions>
        <TextBlock Text="access数据基本读写操作"></TextBlock>
        <DataGrid Grid.Row="1" Name="dg" ItemsSource="{Binding}"  CanUserAddRows="False" AutoGenerateColumns="False">
            <DataGrid.Columns>
                <DataGridTextColumn Header="姓名" Binding="{Binding username}" Width="100"></DataGridTextColumn>
                <DataGridTextColumn Header="密码" Binding="{Binding pwd}"></DataGridTextColumn>
                <DataGridTextColumn Header="年龄" Binding="{Binding age}"></DataGridTextColumn>
                <DataGridTextColumn Header="添加时间" Binding="{Binding createdate}"></DataGridTextColumn>
                <DataGridTextColumn Header="更新时间" Binding="{Binding updatedate}"></DataGridTextColumn>
                <DataGridComboBoxColumn x:Name="cr" Header="班级" SelectedItemBinding="{Binding classroom}"></DataGridComboBoxColumn>
            </DataGrid.Columns>
        </DataGrid>
        <WrapPanel Grid.Row="2" DataContext="{Binding ElementName=dg,Path=SelectedItem}">
            <StackPanel Orientation="Horizontal" HorizontalAlignment="Center" VerticalAlignment="Center">
                <TextBlock Text="姓名:"/>
                <TextBlock  MinWidth="100" Text="{Binding username}"/>
            </StackPanel>
            <StackPanel Orientation="Horizontal">
                <TextBlock Text="密码:"/>
                <TextBlock  MinWidth="100" Text="{Binding pwd}"/>

            </StackPanel>
            <StackPanel Orientation="Horizontal">
                <TextBlock Text="年龄:"/>
                <TextBlock  MinWidth="100" Text="{Binding age}"/>

            </StackPanel>
            <StackPanel Orientation="Horizontal">
                <TextBlock Text="添加时间:"/>
                <TextBlock  MinWidth="100" Text="{Binding createdate}"/>

            </StackPanel>
            <StackPanel Orientation="Horizontal">
                <TextBlock Text="更新时间:"/>
                <TextBlock  MinWidth="100" Text="{Binding updatedate}"/>

            </StackPanel>
            <StackPanel Orientation="Horizontal">
                <TextBlock Text="班级:"/>
                <TextBlock  MinWidth="100" Text="{Binding classroom}"/>

            </StackPanel>
        </WrapPanel>
        <StackPanel Orientation="Horizontal" HorizontalAlignment="Right" Grid.Row="3" >
            <Button Content="刷新" Height="22" VerticalAlignment="Top" Click="Button_Click" />
            <Button Content="更新" Click="Button_Click_1"/>
        </StackPanel>
    </Grid>
</Window>

7、对刷新 和更新按钮添加事件：

private void Button_Click(object sender, RoutedEventArgs e)
        {
            BindData();
        }

        private void Button_Click_1(object sender, RoutedEventArgs e)
        {
            var p=dg.SelectedItem as Person;
            if (p == null)
            {
               MessageBox.Show("请选择要更新的行");
               return;
            }
            using (var conn = DbHelper.getCon())
            {
                conn.Execute("update users set username=@username,pwd=@pwd,age=@age,createdate=@c,updatedate=@u,classroom=@classroom where id=@id", new
                {
                  username=p.username,pwd=p.pwd,age=p.age,c=p.createdate,u=p.updatedate,classroom=p.classroom ,id=p.id

                });
                MessageBox.Show("ok");
            }
        }

 

WPF以access为数据库，简单实现一个显示数据和更新数据的实例

标签：

本文系统来源：http://www.cnblogs.com/lunawzh/p/5936312.html

内容总结

以上是互联网集市为您收集整理的WPF以access为数据库，简单实现一个显示数据和更新数据的实例全部内容，希望文章能够帮你解决WPF以access为数据库，简单实现一个显示数据和更新数据的实例所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

---