?? query.cs
字號:
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(72, 16);
this.label2.TabIndex = 4;
this.label2.Text = "選擇查詢項(xiàng)";
//
// label3
//
this.label3.Location = new System.Drawing.Point(240, 24);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(72, 16);
this.label3.TabIndex = 5;
this.label3.Text = "選擇查詢條件";
//
// label4
//
this.label4.Location = new System.Drawing.Point(320, 24);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(72, 16);
this.label4.TabIndex = 6;
this.label4.Text = "輸入指定值";
//
// textValue
//
this.textValue.Location = new System.Drawing.Point(320, 48);
this.textValue.Name = "textValue";
this.textValue.Size = new System.Drawing.Size(88, 21);
this.textValue.TabIndex = 7;
this.textValue.Text = "";
//
// dataGrid1
//
this.dataGrid1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
| System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.dataGrid1.DataMember = "";
this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGrid1.Location = new System.Drawing.Point(16, 128);
this.dataGrid1.Name = "dataGrid1";
this.dataGrid1.Size = new System.Drawing.Size(504, 223);
this.dataGrid1.TabIndex = 8;
//
// btnClear
//
this.btnClear.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.btnClear.Location = new System.Drawing.Point(456, 8);
this.btnClear.Name = "btnClear";
this.btnClear.Size = new System.Drawing.Size(64, 24);
this.btnClear.TabIndex = 9;
this.btnClear.Text = "重置";
this.btnClear.Click += new System.EventHandler(this.btnClear_Click);
//
// btnExit
//
this.btnExit.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.btnExit.Location = new System.Drawing.Point(456, 72);
this.btnExit.Name = "btnExit";
this.btnExit.Size = new System.Drawing.Size(64, 24);
this.btnExit.TabIndex = 10;
this.btnExit.Text = "退出";
this.btnExit.Click += new System.EventHandler(this.btnExit_Click);
//
// btnQuery
//
this.btnQuery.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.btnQuery.Location = new System.Drawing.Point(456, 40);
this.btnQuery.Name = "btnQuery";
this.btnQuery.Size = new System.Drawing.Size(64, 23);
this.btnQuery.TabIndex = 11;
this.btnQuery.Text = "查詢";
this.btnQuery.Click += new System.EventHandler(this.btnQuery_Click);
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "workstation id=localhost;packet size=4096;integrated security=SSPI;data source=lo" +
"calhost;persist security info=False;initial catalog=BookManager";
//
// sqlDataAdapterReader
//
this.sqlDataAdapterReader.DeleteCommand = this.sqlDeleteCommand1;
this.sqlDataAdapterReader.InsertCommand = this.sqlInsertCommand1;
this.sqlDataAdapterReader.SelectCommand = this.sqlSelectCommand1;
this.sqlDataAdapterReader.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Reader", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ReaderID", "ReaderID"),
new System.Data.Common.DataColumnMapping("ReaderName", "ReaderName"),
new System.Data.Common.DataColumnMapping("ReaderPassword", "ReaderPassword"),
new System.Data.Common.DataColumnMapping("ReaderPhoneNo", "ReaderPhoneNo"),
new System.Data.Common.DataColumnMapping("ReaderEmail", "ReaderEmail"),
new System.Data.Common.DataColumnMapping("ReaderBorrowedbooks", "ReaderBorrowedbooks")})});
this.sqlDataAdapterReader.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = @"DELETE FROM Reader WHERE (ReaderID = @Original_ReaderID) AND (ReaderBorrowedbooks = @Original_ReaderBorrowedbooks OR @Original_ReaderBorrowedbooks IS NULL AND ReaderBorrowedbooks IS NULL) AND (ReaderEmail = @Original_ReaderEmail OR @Original_ReaderEmail IS NULL AND ReaderEmail IS NULL) AND (ReaderName = @Original_ReaderName OR @Original_ReaderName IS NULL AND ReaderName IS NULL) AND (ReaderPassword = @Original_ReaderPassword OR @Original_ReaderPassword IS NULL AND ReaderPassword IS NULL) AND (ReaderPhoneNo = @Original_ReaderPhoneNo OR @Original_ReaderPhoneNo IS NULL AND ReaderPhoneNo IS NULL)";
this.sqlDeleteCommand1.Connection = this.sqlConnection1;
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ReaderID", System.Data.SqlDbType.VarChar, 6, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ReaderID", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ReaderBorrowedbooks", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ReaderBorrowedbooks", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ReaderEmail", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ReaderEmail", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ReaderName", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ReaderName", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ReaderPassword", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ReaderPassword", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ReaderPhoneNo", System.Data.SqlDbType.VarChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ReaderPhoneNo", System.Data.DataRowVersion.Original, null));
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = @"INSERT INTO Reader(ReaderID, ReaderName, ReaderPassword, ReaderPhoneNo, ReaderEmail, ReaderBorrowedbooks) VALUES (@ReaderID, @ReaderName, @ReaderPassword, @ReaderPhoneNo, @ReaderEmail, @ReaderBorrowedbooks); SELECT ReaderID, ReaderName, ReaderPassword, ReaderPhoneNo, ReaderEmail, ReaderBorrowedbooks FROM Reader WHERE (ReaderID = @ReaderID)";
this.sqlInsertCommand1.Connection = this.sqlConnection1;
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ReaderID", System.Data.SqlDbType.VarChar, 6, "ReaderID"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ReaderName", System.Data.SqlDbType.VarChar, 20, "ReaderName"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ReaderPassword", System.Data.SqlDbType.VarChar, 10, "ReaderPassword"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ReaderPhoneNo", System.Data.SqlDbType.VarChar, 15, "ReaderPhoneNo"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ReaderEmail", System.Data.SqlDbType.VarChar, 50, "ReaderEmail"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ReaderBorrowedbooks", System.Data.SqlDbType.Int, 4, "ReaderBorrowedbooks"));
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT ReaderID, ReaderName, ReaderPassword, ReaderPhoneNo, ReaderEmail, ReaderBo" +
"rrowedbooks FROM Reader";
this.sqlSelectCommand1.Connection = this.sqlConnection1;
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = @"UPDATE Reader SET ReaderID = @ReaderID, ReaderName = @ReaderName, ReaderPassword = @ReaderPassword, ReaderPhoneNo = @ReaderPhoneNo, ReaderEmail = @ReaderEmail, ReaderBorrowedbooks = @ReaderBorrowedbooks WHERE (ReaderID = @Original_ReaderID) AND (ReaderBorrowedbooks = @Original_ReaderBorrowedbooks OR @Original_ReaderBorrowedbooks IS NULL AND ReaderBorrowedbooks IS NULL) AND (ReaderEmail = @Original_ReaderEmail OR @Original_ReaderEmail IS NULL AND ReaderEmail IS NULL) AND (ReaderName = @Original_ReaderName OR @Original_ReaderName IS NULL AND ReaderName IS NULL) AND (ReaderPassword = @Original_ReaderPassword OR @Original_ReaderPassword IS NULL AND ReaderPassword IS NULL) AND (ReaderPhoneNo = @Original_ReaderPhoneNo OR @Original_ReaderPhoneNo IS NULL AND ReaderPhoneNo IS NULL); SELECT ReaderID, ReaderName, ReaderPassword, ReaderPhoneNo, ReaderEmail, ReaderBorrowedbooks FROM Reader WHERE (ReaderID = @ReaderID)";
this.sqlUpdateCommand1.Connection = this.sqlConnection1;
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ReaderID", System.Data.SqlDbType.VarChar, 6, "ReaderID"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ReaderName", System.Data.SqlDbType.VarChar, 20, "ReaderName"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ReaderPassword", System.Data.SqlDbType.VarChar, 10, "ReaderPassword"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ReaderPhoneNo", System.Data.SqlDbType.VarChar, 15, "ReaderPhoneNo"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ReaderEmail", System.Data.SqlDbType.VarChar, 50, "ReaderEmail"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ReaderBorrowedbooks", System.Data.SqlDbType.Int, 4, "ReaderBorrowedbooks"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ReaderID", System.Data.SqlDbType.VarChar, 6, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ReaderID", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ReaderBorrowedbooks", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ReaderBorrowedbooks", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ReaderEmail", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ReaderEmail", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ReaderName", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ReaderName", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ReaderPassword", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ReaderPassword", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ReaderPhoneNo", System.Data.SqlDbType.VarChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ReaderPhoneNo", System.Data.DataRowVersion.Original, null));
//
// sqlDataAdapterBook
//
this.sqlDataAdapterBook.DeleteCommand = this.sqlDeleteCommand2;
this.sqlDataAdapterBook.InsertCommand = this.sqlInsertCommand2;
this.sqlDataAdapterBook.SelectCommand = this.sqlSelectCommand2;
this.sqlDataAdapterBook.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Book", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("BookID", "BookID"),
new System.Data.Common.DataColumnMapping("BookName", "BookName"),
new System.Data.Common.DataColumnMapping("BookWriter", "BookWriter"),
new System.Data.Common.DataColumnMapping("BookPublish", "BookPublish"),
new System.Data.Common.DataColumnMapping("BookPublishDate", "BookPublishDate"),
new System.Data.Common.DataColumnMapping("BookPrice", "BookPrice"),
new System.Data.Common.DataColumnMapping("BookSort", "BookSort"),
new System.Data.Common.DataColumnMapping("BookAmount", "BookAmount"),
new System.Data.Common.DataColumnMapping("BookRemain", "BookRemain")})});
this.sqlDataAdapterBook.UpdateCommand = this.sqlUpdateCommand2;
//
// sqlDeleteCommand2
//
this.sqlDeleteCommand2.CommandText = @"DELETE FROM Book WHERE (BookID = @Original_BookID) AND (BookAmount = @Original_BookAmount OR @Original_BookAmount IS NULL AND BookAmount IS NULL) AND (BookName = @Original_BookName OR @Original_BookName IS NULL AND BookName IS NULL) AND (BookPrice = @Original_BookPrice OR @Original_BookPrice IS NULL AND BookPrice IS NULL) AND (BookPublish = @Original_BookPublish OR @Original_BookPublish IS NULL AND BookPublish IS NULL) AND (BookPublishDate = @Original_BookPublishDate OR @Original_BookPublishDate IS NULL AND BookPublishDate IS NULL) AND (BookRemain = @Original_BookRemain OR @Original_BookRemain IS NULL AND BookRemain IS NULL) AND (BookSort = @Original_BookSort OR @Original_BookSort IS NULL AND BookSort IS NULL) AND (BookWriter = @Original_BookWriter OR @Original_BookWriter IS NULL AND BookWriter IS NULL)";
this.sqlDeleteCommand2.Connection = this.sqlConnection1;
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_BookID", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "BookID", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_BookAmount", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "BookAmount", System.Data.DataRowVersion.Original, null));
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -