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("执行完成");
}
}
}