frmfengmian.cs

一个图书馆管理系统

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace BookManage
{
    public partial class frmfengmian : Form
    {
        int d;
        private SqlConnection objSqlConnection;
        private SqlDataAdapter objSqlDataAdapter;
        private SqlParameter objSqlParameter;
        private SqlCommand objSqlCommand;
        private DataSet objDataSet;
        public frmfengmian(int a)
        {
            InitializeComponent();
            d = a;
        }

        private void btnClose_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void btnxiougai_Click(object sender, EventArgs e)
        {
            if (this.openFileDialog1.ShowDialog() == DialogResult.OK)
            {
                this.txtlujin.Text = openFileDialog1.FileName.ToString();
            }
        }

        private void frmfengmian_Load(object sender, EventArgs e)
        {
            objSqlConnection = new SqlConnection("server=(local);database=Book;Integrated Security=SSPI;");
            objDataSet = new DataSet();
            objSqlDataAdapter = new SqlDataAdapter("select * from bookInfo", objSqlConnection);
            objSqlDataAdapter.Fill(objDataSet, "bookInfo");
            txtlujin.Text = objDataSet.Tables[0].Rows[d]["BookPic"].ToString();
            picname.ImageLocation = txtlujin.Text;
        }

        private void btnUpdate_Click(object sender, EventArgs e)
        {
            picname.ImageLocation = txtlujin.Text;
            objDataSet.Tables[0].Rows[d]["BookPic"] = txtlujin.Text;
            string p = "update bookInfo set BookPic=@BookPic where BookID=@BookID";
            objSqlDataAdapter.UpdateCommand = new SqlCommand(p, objSqlConnection);
            objSqlParameter = new SqlParameter();
            objSqlParameter = objSqlDataAdapter.UpdateCommand.Parameters.Add("@BookPic", SqlDbType.VarChar);
            objSqlParameter.SourceColumn = "BookPic";
            objSqlParameter.SourceVersion = DataRowVersion.Current;
            objSqlParameter = objSqlDataAdapter.UpdateCommand.Parameters.Add("@BookID", SqlDbType.BigInt);
            objSqlParameter.SourceColumn = "BookID";
            objSqlParameter.SourceVersion = DataRowVersion.Original;
            objSqlDataAdapter.Update(objDataSet, "bookInfo");
            MessageBox.Show("更改成功");
        }
    }
}