c#链接数据库，查找数据信息

using System;
using System.Collections.Generic;
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;
using System.Data;
using System.Data.SqlClient;

namespace WpfApplication12
{
    /// <summary>
    /// MainWindow.xaml 的交互逻辑
    /// </summary>
    public partial class MainWindow : Window
    {
        public MainWindow()
        {
            InitializeComponent();
        }

public object SqlConnection{get；private set；}

private void button_Click(object sender, RoutedEventArgs e)

{

SqlConnection con=new SqlConnection("database=demo1;server=.;uid=sa;password=123456");

con.Open();

string sql="insert intoTabel1(booknumber,author,publication)values('"+booknumber.Text+"','"+author.Text+"','"+publication_date.Text+"')";

SqlCommand com=new SqldCommand(sql,con);

com.ExecureNonQuery();

}

private void button1_Click(object sender, RoutedEventArgs e)

{

SqlConnection con=new SqlConnection（"database=demo1;server=.;uid=sa;password=123456"）；

con.Open();

string sql="select * from Tabel1 where booknumber='"+booknumber.Text+"'";

SqlDataAdapter adapter=new SqlDataAdapter（sql,con）；

DataSet dataset =new DataSet();

adapter.Fill(dataset);

grid.ItemSource=dataset.Tables[0].DefaultView();

if(dataset.Tables[0].Rows.Count>0)

{

string aa=dataset.Tables[0].Rows[0]["booknumber"].ToString();

MessageBox.Show(aa）；

}

else

{

MessageBox.Show("无此书");

}

巴特西

c#链接数据库，查找数据信息

最新文章

热门文章