欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

WPF操作SQL SERVER 数据库实例讲解

程序员文章站 2022-04-16 09:08:29
wpf操作sql server 实例讲解 using system; using system.collections.generic; using system.data.sqlcli...

wpf操作sql server 实例讲解

using system; 
using system.collections.generic; 
using system.data.sqlclient; 
using system.linq; 
using system.text; 
using system.threading.tasks; 
using system.windows; 
using system.windows.controls; 
using system.windows.data; 
using system.windows.documents; 
using system.windows.input; 
using system.windows.media; 
using system.windows.media.imaging; 
using system.windows.navigation; 
using system.windows.shapes;

namespace demo_sql 
{ 
/// 
/// mainwindow.xaml 的交互逻辑 
/// 
public partial class mainwindow : window 
{ 
public mainwindow() 
{ 
initializecomponent(); 
windowstartuplocation = windowstartuplocation.centerscreen; 
}
    private void add_click(object sender, routedeventargs e)
    {
        string strconn = "server=(localdb)\\mssqllocaldb;database=studentdb;integrated security=true";
        sqlconnection sqlconn = new sqlconnection(strconn);
        try
        {
            sqlconn.open();
            //messagebox.show("连接数据库成功");
            string sqladd = "insert into student(name, password) values ('" +name.text + "', '" + password.text + "')";
            sqlcommand sqlcmd = new sqlcommand(sqladd, sqlconn);
            sqlcmd.executenonquery();
            messagebox.show("插入成功");
        }
        catch (exception ex)
        {
            messagebox.show("数据库打开失败,详细信息:" + ex.tostring());
        }
        finally
        {
            sqlconn.close();
        }
    }

    private void modify_click(object sender, routedeventargs e)
    {
        string strconn = "server=(localdb)\\mssqllocaldb;database=studentdb;integrated security=true";
        sqlconnection sqlconn = new sqlconnection(strconn);
        try
        {
            sqlconn.open();
            string strmodify = "update student set password='" + password.text + "'" + " where name=" + "'" + name.text + "'";
            sqlcommand sqlcmd = new sqlcommand(strmodify, sqlconn);
            sqlcmd.executenonquery();
            messagebox.show("修改成功");
        }
        catch (exception ex)
        {
            messagebox.show("连接错误" + ex.message);
        }
        finally
        {
            sqlconn.close();
        }
    }

    private void delete_click(object sender, routedeventargs e)
    {
        string strconn = "server=(localdb)\\mssqllocaldb;database=studentdb;integrated security=true";
        sqlconnection sqlconn = new sqlconnection(strconn);
        try
        {
            sqlconn.open();
            string strdelete = "delete from student where name='" + name.text + "'";
            sqlcommand sqlcmd = new sqlcommand(strdelete, sqlconn);
            sqlcmd.executenonquery();
            messagebox.show("删除成功");
        }
        catch (exception ex)
        {
            messagebox.show("连接错误"+ex.message);
        }
        finally
        {
            sqlconn.close();
        }
    }

    private void search_click(object sender, routedeventargs e)
    {
        int flag = 1;
        string strconn = "server=(localdb)\\mssqllocaldb;database=studentdb;integrated security=true";
        sqlconnection sqlconn = new sqlconnection(strconn);
        try
        {
            sqlconn.open();
            //messagebox.show("连接数据库成功");
            string sqlsearch = "select * from student where name='" + name.text + "'";
            sqlcommand sqlcmd = new sqlcommand(sqlsearch, sqlconn);
            sqldatareader reader = sqlcmd.executereader();
            //读取数据 
            while (reader.read())
            {
                // 可以使用数据库中的字段名,也可以使用角标访问
                if(reader["password"].tostring()==password.text )
                {
                    flag = 0;
                    break;
                }
            }
            if(flag == 1)
                messagebox.show("用户不存在");
            else
                messagebox.show("存在用户");
        }
        catch (exception ex)
        {
            messagebox.show("数据库打开失败,详细信息:" + ex.tostring());
        }
        finally
        {
            sqlconn.close();
        }
    }
}

}