第一个ADO.NET连接SQl server数据库

ado.net连接sql server2008本机数据库

1.只连接数据库，然后做简单查询

微软文档SqlConnecttion ：http://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqlconnection.aspx

               SqlCommand：http://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqlcommand(v=vs.110).aspx

 using (SqlConnection conn = new SqlConnection("Data Source=127.0.0.1; Initial Catalog=MyTest;User ID=sa;Password=123456"))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                 {
                      Console.WriteLine("代码运行到了这里，连接成功！！");
                      Console.ReadKey();
                }
             }

 

 

2.能完成一般的数据库连接，实现增删改查基本功能

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>
    /// MainWindow.xaml 的交互逻辑
    /// </summary>
    public partial class MainWindow : Window
    {
        public MainWindow()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, RoutedEventArgs e)
        {
            //IDisposible
            //using(类型 d = new ....)
            //{.....................}

            //SqlConnection为建立和数据库连接的对象
            //using (SqlConnection conn = new SqlConnection(
            //    "Data Source=127.0.0.1; Initial Catalog=MyTest;User ID=sa;Password=123456"))
            //{
            //    conn.Open();//打开连接
            //    //通过连接创建一个向数据库发命令（Command）的对象SqlCommand
            //    using (SqlCommand cmd = conn.CreateCommand())
            //    {
            //        //CommandText为要执行的SQL语句

            //        cmd.CommandText = "Insert into T_Student(Name,Age) values('元芳',2100)";
            //        cmd.ExecuteNonQuery();//执行
            //    }                
            //}

            //ExecuteNonQuery一般用来执行Update、Delete、Insert语句

            using (SqlConnection conn = new SqlConnection("Data Source=127.0.0.1; Initial Catalog=MyTest;User ID=sa;Password=123456"))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    //cmd.CommandText = "select count(*) from T_Student where Age<100";
                    //int i =  (int)cmd.ExecuteScalar();
                    //MessageBox.Show(i+"条数据");

                    //cmd.CommandText = "select 'aaa'";
                    ////ExecuteScalar一般用来执行有且只有一行一列返回值的SQL语句
                    //string s = (string)cmd.ExecuteScalar();
                    //MessageBox.Show(s);

                    //获得自增字段的值
                    //cmd.CommandText = "insert into T_Student(Name,Age) values('aaa',123) ;select @@identity";
                   // cmd.CommandText = "insert into T_Student(Name,Age) output inserted.Id values('aaa',123) ";
                    long i = (long)cmd.ExecuteScalar();//bigint→long
                    MessageBox.Show(i.ToString());
                }
            }

            //MessageBox.Show("执行完成");
        }
    }
}