桌面程序开发入门(WinForm with C#)

CREATE DATABASE TestDB
GO
USE TestDB
GO
CREATE TABLE Student
    (
      SID INT IDENTITY(1, 1)
              NOT NULL ,
      SName NVARCHAR(50) NOT NULL ,
      Sex NVARCHAR(2) NOT NULL ,
      Area NVARCHAR(20) NOT NULL ,
      Email NVARCHAR(50) NOT NULL
    )
ON  [PRIMARY]
GO
INSERT  INTO dbo.Student
        ( SName, Sex, Area, Email )
VALUES  ( N'风花雪月', N'男', N'北京', N'abc@qq.com'),
        ( N'泡椒田鸡', N'女', N'上海', N'abcd@qq.com'),
        ( N'红灯酒绿', N'男', N'天津', N'abc@qq.com');
GO
CREATE PROCEDURE getStudents @p_SID INT
AS
    BEGIN
        SET NOCOUNT ON;
        IF NOT EXISTS ( SELECT  SID
                        FROM    dbo.Student
                        WHERE   SID =@p_SID )
            PRINT 'The student does not exists.'ELSE
            SELECT  SID ,
                    SName ,
                    Sex ,
                    Area ,
                    Email
            FROM    dbo.Student
            WHERE   SID =@p_SID
    END
GO
--测试--
--EXEC dbo.getStudents @p_SID = 2 -- int
-->2    泡椒田鸡    女    上海    abcd@qq.com

private void useCommandToolStripMenuItem_Click(objectsender, EventArgs e)
        {
            formCommandProc form = newformCommandProc();
            form.MdiParent = this;
            form.Show();
        }

        private void useDataAdapterToolStripMenuItem_Click(objectsender, EventArgs e)
        {
            formDataAdapterProc form = newformDataAdapterProc();
            form.MdiParent = this;
            form.Show();
        }

        private void createXMLToolStripMenuItem_Click(objectsender, EventArgs e)
        {
            formXMLCreate form = newformXMLCreate();
            form.MdiParent = this;
            form.Show();
        }

        private void readXMLToolStripMenuItem_Click(objectsender, EventArgs e)
        {
            formXMLRead form = newformXMLRead();
            form.MdiParent = this;
            form.Show();
        }

        private void exitToolStripMenuItem_Click(objectsender, EventArgs e)
        {
            Application.Exit();
        }

usingSystem;
usingSystem.Collections.Generic;
usingSystem.ComponentModel;
usingSystem.Data;
usingSystem.Drawing;
usingSystem.Linq;
usingSystem.Text;
usingSystem.Threading.Tasks;
usingSystem.Windows.Forms;
usingSystem.Data.SqlClient;

namespaceProcedure
{
    public partial classformCommandProc : Form
    {
        publicformCommandProc()
        {
            InitializeComponent();
        }

        private void btnGet_Click(objectsender, EventArgs e)
        {
            try{
                //接受到的学号文本类型转换为整型int
Convert.ToInt32(tbxSID.Text);
            }
            catch{
                tbxGetStudent.Text += "The student ID does not exists.";
                tbxGetStudent.Text += "
";
                return;
            }

            //这句要引用System.Configuration.dll
            string strConnect = System.Configuration.ConfigurationManager.ConnectionStrings["TestDBConnectionString"].ToString();
            //这句需要添加 using System.Data.SqlClient;
            SqlConnection objConnect = newSqlConnection(strConnect);

            SqlCommand objCommand = new SqlCommand("getStudents", objConnect);
            objCommand.Parameters.Add("@p_SID", SqlDbType.Int);
            objCommand.Parameters["@p_SID"].Value =tbxSID.Text;
            objCommand.CommandType =CommandType.StoredProcedure;
            try{
                if (objConnect.State ==ConnectionState.Closed)
                {
                    objConnect.Open();
                }
                SqlDataReader objDataReader =objCommand.ExecuteReader();
                if (objDataReader.HasRows ==false)
                {
                    tbxGetStudent.Text += "The student does not exists.";
                    tbxGetStudent.Text += "
";
                }
                else{
                    while(objDataReader.Read())
                    {
                        tbxGetStudent.Text += objDataReader.GetValue(0).ToString() + "";
                        tbxGetStudent.Text += objDataReader.GetValue(1).ToString() + "";
                        tbxGetStudent.Text += objDataReader.GetValue(2).ToString() + "";
                        tbxGetStudent.Text += objDataReader.GetValue(3).ToString() + "";
                        tbxGetStudent.Text += "
";
                    }
                }
                objDataReader.Close();
            }
            catch(Exception exp)
            {
                tbxGetStudent.Text +=exp.Message;
                tbxGetStudent.Text += "
";
            }
            finally{
                if(objConnect.State ==ConnectionState.Open)
                {
                    objConnect.Close();
                }
            }

        }
    }
}