第六周学习笔记，vc各类控件的输入输出

USE master;

IF DB_ID(‘EduBaseDemo‘) IS NOT NULL

BEGIN

ALTER DATABASE EduBaseDemo

SET SINGLE_USER

WITH ROLLBACK IMMEDIATE;

DROP DATABASE EduBaseDemo;

END

CREATE DATABASE EduBaseDemo

ON

(NAME=‘Datafile‘

,FILENAME=‘C:\DataFile.mdf‘)

LOG ON

(NAME=‘Logfile‘

,FILENAME=‘C:\Logfile.ldf‘);

GO

USE EduBaseDemo;

--创建表；

----班级表

CREATE TABLE tb_stock

(No

INT

NOT NULL

PRIMARY KEY

,Name

VARCHAR(20)

NOT NULL)

INSERT tb_stock

(No,Name)

VALUES

(1,‘A馆‘)

,(2,‘B馆‘)

,(3,‘C馆‘)

,(4,‘D馆‘);

----学生表；

CREATE TABLE tb_book

(No

CHAR(10)

NOT NULL

PRIMARY KEY

,Name

VARCHAR(20)

NOT NULL

,inorout

BIT

NOT NULL

,publishDate

DATE

NOT NULL

,stockNo

INT

NOT NULL

,Speciality

VARCHAR(100)

NULL);

INSERT tb_book

(No,Name,inorout,publishDate,stockNo,Speciality)

VALUES

(‘09187756‘,‘内科学‘,1,‘1991-10-15‘,2,‘收藏‘);

 

select * from tb_book

select  * from tb_stock

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
                                                                                 //添加调用：
using System.Data.SqlClient;                                                      //包含访问SQL Server所需的各类对象；

namespace lizi6w
{
    
    public partial class frm_booktInfo : Form
    {

        /// <summary>
        /// 公有方法：构造函数；
        /// </summary>
        public frm_bookInfo()
        {
            InitializeComponent();
            this.StartPosition = FormStartPosition.CenterScreen;                          //本窗体启动位置设为屏幕中央； 
        }

        /// <summary>
        /// 私有方法：点击载入按钮；
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btn_Load_Click(object sender, EventArgs e)
        {
            SqlConnection sqlConnection = new SqlConnection();                                                         
　　　　　　　 sqlConnection.ConnectionString =
                "Server=(local);Database=EduBaseDemo;Integrated Security=sspi";                
　　　　　　　　SqlCommand sqlCommand = new SqlCommand();                                                                   
　　　　　　　　SqlCommand sqlCommand2 = new SqlCommand();                                                                  
　　　　　　　　sqlCommand.Connection = sqlConnection;                                                                      
sqlCommand2.Connection = sqlConnection;                                                                     
sqlCommand.CommandText = "SELECT * FROM tb_stock;";                                                         
sqlCommand2.CommandText = "SELECT * FROM tb_book WHERE No=@No;";                                     
sqlCommand2.Parameters.AddWithValue("@No", "09187756");                                                   
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter();                                           
sqlDataAdapter.SelectCommand = sqlCommand;                                                                 
 DataTable classTable = new DataTable();                                                                    
 sqlConnection.Open();                                                                                       
sqlDataAdapter.Fill(classTable);                                                                           
 this.cmb_stock.DataSource = classTable;                                                                     
this.cmb_stock.DisplayMember = "Name";                                                                      
this.cmb_stock.ValueMember = "No";                                                                          
SqlDataReader sqlDataReader = sqlCommand2.ExecuteReader();                                                  

if (sqlDataReader.Read())                                                                                  
 {
                this.txb_No.Text = sqlDataReader["No"].ToString();                                                         
　　　　　　　　　 this.txb_Name.Text = sqlDataReader["Name"].ToString();
                this.rdb_inorout.Checked = (bool)sqlDataReader["inorout"];
                this.rdb_inorout.Checked = !(bool)sqlDataReader["inorout"];
                this.dtp_publishDate.Value = (DateTime)sqlDataReader["publishDate"];
                this.cmb_stock.SelectedValue = (int)sqlDataReader["stockNo"];
                this.txb_Speciality.Text = sqlDataReader["Speciality"].ToString();
            }
            sqlDataReader.Close();                                                    //关闭数据阅读器（同时关闭连接）；
        }
    }                                                                                                    
}