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;
using _11._2第三章作业;
namespace _11._9
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
DataSet ds = null;
SqlDataAdapter ad = null;
DBHelper db = null;
private void Form1_Load(object sender, EventArgs e)
{
MoneyInfo();
}
double qq = 0;
/// <summary>
/// 输出表到dgv
/// </summary>
private void MoneyInfo()
{
db = new DBHelper();
db.OpenDB();
string sql = string.Format("select * from moneyInfo");
ad = new SqlDataAdapter(sql,db.conn);
ds = new DataSet();
ad.Fill(ds,"moneyInfo");
dataGridView1.DataSource = ds.Tables["moneyInfo"];
}
/// <summary>
/// 花费相加
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
db.OpenDB();
string sql = string.Format("select * from moneyInfo");
SqlCommand cmd = new SqlCommand(sql,db.conn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
qq = qq + Convert.ToDouble(dr["money"]);
}
textBox1.Text = qq.ToString();
}
/// <summary>
/// 退出
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button2_Click(object sender, EventArgs e)
{
this.Close();
}
/// <summary>
/// 保存修改按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button3_Click(object sender, EventArgs e)
{
updateDB();
}
/// <summary>
/// 保存修改
/// </summary>
private void updateDB()
{
try
{
SqlCommandBuilder cmd = new SqlCommandBuilder(ad);
ad.Update(ds, "moneyInfo");
MessageBox.Show("修改成功!","提示");
}catch(Exception ex)
{
MessageBox.Show("修改失败!"+ex.Message);
}
}
}
}