using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
using System.Data;
namespace WindowsFormsApplication3
{
class DBHelper
{
private string connString = @"Data Source=.;Initial Catalog=assetsDB;Integrated Security=True";
// 数据库连接 Connection 对象
private SqlConnection connection;
/// <summary>
/// Connection对象
/// </summary>
public SqlConnection Connection
{
get
{
if (connection == null)
{
connection = new SqlConnection(connString);
}
return connection;
}
}
/// <summary>
/// 打开数据库连接
/// </summary>
public void OpenConnection()
{
if (Connection.State == ConnectionState.Closed)
{
Connection.Open();
}
else if (Connection.State == ConnectionState.Broken)
{
Connection.Close();
Connection.Open();
}
}
public void CloseConnection()
{
if (Connection.State == ConnectionState.Open || Connection.State == ConnectionState.Broken)
{
Connection.Close();
}
}
}
}
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace WindowsFormsApplication3
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void 增加固定管理ToolStripMenuItem_Click(object sender, EventArgs e)
{
Form2 f = new Form2();
f.MdiParent = this;
f.Show();
}
private void 查询固定资产ToolStripMenuItem_Click(object sender, EventArgs e)
{
Form3 f = new Form3();
f.MdiParent = this;
f.Show();
}
private void 退出ToolStripMenuItem_Click(object sender, EventArgs e)
{
this.Close();
}
}
}
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace WindowsFormsApplication3
{
public partial class Form2 : Form
{
public Form2()
{
InitializeComponent();
}
DBHelper db = new DBHelper();
public bool CheckInfo()
{
if (this.textBox1.Text.Trim().Equals(string.Empty))
{
MessageBox.Show("请完整填写信息","输入提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
this.textBox1.Focus();
return false;
}
else if (this.textBox2.Text.Trim().Equals(string.Empty))
{
MessageBox.Show("请完整填写信息", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.textBox2.Focus();
return false;
}
else if (this.textBox3.Text.Trim().Equals(string.Empty))
{
MessageBox.Show("请完整填写信息", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.textBox3.Focus();
return false;
}
else if (this.comboBox1.Text.Trim().Equals("请输入类型"))
{
MessageBox.Show("请完整填写信息", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.textBox1.Focus();
return false;
}
else
{
return true;
}
}
public void insertInfo()
{
try
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("INSERT assets (assetId,assetName,assteType,intoDate) ");
sql.AppendFormat(" VALUES ('{0}','{1}','{2}','{3}')", this.textBox1.Text, this.textBox2.Text, this.comboBox1.Text, this.textBox3.Text);
SqlCommand comm = new SqlCommand(sql.ToString(), db.Connection);
db.OpenConnection();
int result = comm.ExecuteNonQuery();
if (result == 1)
{
string sqlNo = "SELECT @@IDENTITY FROM Student";
comm.CommandText = sqlNo;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Form2_Load(object sender, EventArgs e)
{
}
private void button1_Click(object sender, EventArgs e)
{
if (CheckInfo())
{
insertInfo();
MessageBox.Show("新增成功!", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
}
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace WindowsFormsApplication3
{
public partial class Form3 : Form
{
public Form3()
{
InitializeComponent();
}
DBHelper db = new DBHelper();
DataSet ds = new DataSet();
SqlDataAdapter adapter = null;
public void GetInfo()
{
try
{
string sql = "SELECT * FROM assets";
adapter = new SqlDataAdapter(sql, db.Connection);
adapter.Fill(ds, "assets");
this.dataGridView1.DataSource = ds.Tables["assets"];
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void SearchInfo()
{
try
{
if (ds.Tables["assets"] != null)
{
ds.Tables["assets"].Clear();
}
StringBuilder sql = new StringBuilder();
sql.AppendLine("SELECT * FROM assets");
sql.AppendFormat(" WHERE assetId='{0}' OR assteType='{1}'", this.textBox1.Text,this.comboBox1.Text);
adapter = new SqlDataAdapter(sql.ToString(), db.Connection);
adapter.Fill(ds, "assets");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
db.CloseConnection();
}
}
private void Form3_Load(object sender, EventArgs e)
{
GetInfo();
}
private void button1_Click(object sender, EventArgs e)
{
if (this.dataGridView1.SelectedRows[0].Cells[0].Value.ToString().Equals(null))
{
MessageBox.Show("没有查询到结果", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
SearchInfo();
}
}
}
}
c#开发数据库考试题2
最新推荐文章于 2022-05-27 21:16:05 发布