(1)界面显示
(2)
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace 显示数据库表中的数据
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
//SqlConnection表示一个到sqlserver数据库的打开的连接。
SqlConnection myConnection = new SqlConnection();
//ConnectionString获取用于打开数据库的字符串
myConnection.ConnectionString = "server=localhost;uid=sa;pwd=root;database=xsgl";
// SqlCommand对象用来对SQL Server数据库执行操作命令。
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Connection = myConnection;
sqlCommand.CommandType = CommandType.Text;
sqlCommand.CommandText = "select * from course";
myConnection.Open();//打开数据库
//SqlDataReader是个数据读取器,向前不可后退、每次只读取一条。速度快,现代项目里面用它用得最多。
SqlDataReader dreader = sqlCommand.ExecuteReader(CommandBehavior.CloseConnection);//数据读取器关闭时,连接对象自动关闭。
string s = "";
while(dreader.Read()){
s += dreader["courseID"].ToString() + "\t"
+ dreader["courseName"].ToString() + "\t"
+ dreader["teacher"].ToString() + "\r\n";
}
textBox1.Text = s;
dreader.Close();
}
}
}