adonet基本示例分享(adonet銜接數據庫)

adonet基本示例分享(adonet銜接數據庫)。本站提示廣大學習愛好者：（adonet基本示例分享(adonet銜接數據庫)）文章只能為提供參考，不一定能成為您想要的結果。以下是adonet基本示例分享(adonet銜接數據庫)正文

---

adonet基本示例分享

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

namespace ADONET基本 {
    /// <summary>
    /// Window1.xaml 的交互邏輯
    /// </summary>
    public partial class Window1 : Window
    {
        public Window1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, RoutedEventArgs e)
        {
            ////using() 主動封閉數據庫，收受接管資本。
            ////SqlConnection為樹立和數據庫銜接的對象。
            //using (SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=myself;User Id=sa;Password=123;"))
            //{
            //    conn.Open();//翻開銜接
            //    //經由過程銜接，創立一個向數據庫發敕令的對象SqlCommand
            //    using (SqlCommand cmd = conn.CreateCommand())//釋放資本。
            //    {
            //        //CommandText為要履行的SQL的語句
            //        cmd.CommandText = "Insert into student(學號,姓名) values(110,'張五')";
            //        //ExecuteNonQuery普通用來履行Update Delete Insert 語句。
            //        cmd.ExecuteNonQuery();//履行下面的SQL語句。
            //    }
            //}

            using (SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=MyTest;User Id=sa;Password=123;"))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    //cmd.CommandText = "select count(*) from student where 退學成就<570";
                    //cmd.CommandText = "select count(*) from student where 退學成就<570";
                    ////ExecuteScalar普通用來履行有且只要一行一列前往值的SQL語句。
                    //int i = (int)cmd.ExecuteScalar();
                    //MessageBox.Show(i+"人成就小於570分");
                    cmd.CommandText = "Insert into T_Student(Name,Age) output inserted.Id values('張顧',18);";
                    long i = (long)cmd.ExecuteScalar();
                    MessageBox.Show("Id為"+i);
                }
            }
            MessageBox.Show("履行完成");
        }
    }
}