1、农民户口号,姓名,身份证号,年龄,性别,民族,住址,是否家长,是否已婚等家庭成员的基本信息处理,这些操作跟microsoft sql server 2005 连接完成的。农民财产信息模块能添加、删除、修改和查询农民财产信息,这个模块儿我们能中我们能在动物选项和机械工具处理操作,能加,删除,修改 动物名和机械工具名,如 我们能添加,删除,修改,牛、羊、鸡农业机械工具2程序算法:1)系统功能结构图:注意:由于程序内容较多,流程图按模块画的。系统运行流程图2)代码: 连接数据库的代码如下:Using System;using System.Collections.Generic;using Syst
2、em.Text;using System.Data;using System.Data.Sql;using System.Windows.Forms;using System.Data.SqlClient;namespace 乡村农民财产信息管理系统 class CData public CData() public string conn_sql = Data Source=WIN-KMFBGMGGB45SQLEXPRESS;Initial Catalog=nc_info;Integrated Security=True; public int RUN_SQL(string sql) try
3、 SqlConnection conn = new SqlConnection(conn_sql); SqlCommand comm = new SqlCommand(sql, conn); if (conn.State = ConnectionState.Closed) conn.Open(); int i = comm.ExecuteNonQuery(); conn.Close(); return i; catch (Exception ex) MessageBox.Show(ex.Message); return -1; public DataTable get_data(string
4、sql) SqlDataAdapter da = new SqlDataAdapter(sql, conn); DataTable dt = new DataTable(); da.Fill(dt); return dt; catch(Exception ex) return null;农民家庭基本信息代码:using System;using System.ComponentModel;using System.Drawing;using System.IO; public partial class family : Form public family() InitializeCompo
5、nent(); CData data = new CData(); string images_path = iam.jpg public int bianliang() string sign_no = , sex = , hk_nom = , name = , adress = int age = 0, mz_id = 0; hk_nom = txthukouhao.Text.Trim(); sign_no = txtshenfenzheng.Text.Trim(); name = txtxingming.Text.Trim(); adress = txtzhuzhi.Text.Trim(
6、); age = Convert.ToInt32(combonianling.SelectedItem); sex = comboxingbie.SelectedItem.ToString(); mz_id = Convert.ToInt32(combominzu.SelectedValue); if (hk_nom.Length = 0 | hk_nom.Length != 6) MessageBox.Show(户口号必须是6位数字!); txthukouhao.Focus(); else if (name.Length = 0)姓名不能空! txtxingming.Focus(); els
7、e if (sign_no.Length = 0 & sign_no.Length != 18)身份证号必须是18位数字 txtshenfenzheng.Focus(); else if (adress.Length = 0)住址不能空。 txtzhuzhi.Focus(); else return 1; public void qingkong() txthukouhao.Clear(); txtshenfenzheng.Clear(); txtxingming.Clear(); txtzhuzhi.Clear(); checkhunyin.Checked = false; checkjia
8、zhang.Checked = false; private void chushihua() string sql = select mz_id,mz_name from minzu DataTable dt = data.get_data(sql); combominzu.DataSource = dt; combominzu.DisplayMember = mz_name.Trim(); combominzu.ValueMember = mz_id for (int i = 1; i -1) int i = data.RUN_SQL(sql); if (i 0)成功! qingkong(
9、);失败! 此人信息已存在,不能重复添加! public int shanchu(string s_no) DialogResult dr = MessageBox.Show(你真的要永久删除身份证号为 + s_no + 的信息吗?, 你好。, MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr = DialogResult.Yes)delete from main_info where sign_num= public DataTable GetAll()select * from view_family dt = data.g
10、et_data(sql); private void Fjibenxinxi_Load(object sender, EventArgs e) dGView1.DataSource = GetAll(); chushihua() private void bttianjia_Click(object sender, EventArgs e) tianjia(); private void bttuichu_Click(object sender, EventArgs e) this.Close(); private void dGView1_CellMouseClick(object send
11、er, DataGridViewCellMouseEventArgs e) if (e.RowIndex txthukouhao.Text = (dGView1.Rowse.RowIndex.Cells户口号.Value.ToString(); txtshenfenzheng.Text = (dGView1.Rowse.RowIndex.Cells身份证号.Value).ToString().Trim(); txtxingming.Text = (dGView1.Rowse.RowIndex.Cells姓名 txtzhuzhi.Text = (dGView1.Rowse.RowIndex.Ce
12、lls住址 combominzu.Text = (dGView1.Rowse.RowIndex.Cells民族 combonianling.Text = (dGView1.Rowse.RowIndex.Cells年龄 comboxingbie.Text = (dGView1.Rowse.RowIndex.Cells性别 hunyin = (dGView1.Rowse.RowIndex.Cells是否已婚 if (hunyin = ) checkhunyin.Checked = true; checkhunyin.Checked = false; jiazhang = dGView1.Rowse
13、.RowIndex.Cells是否家长.Value.ToString().Trim(); if (jiazhang = checkjiazhang.Checked = true; else checkjiazhang.Checked = false; string image1 = dGView1.Rowse.RowIndex.Cells图片.Value.ToString(); pictureBox1.Image = Image.FromFile(Application.StartupPath + img + image1);+ex.Message ); private void btshan
14、chu_Click(object sender, EventArgs e) string sfz = txtshenfenzheng.Text.Trim(); / MessageBox.Show(身份证=+sfz); if (sfz.Length != 0 | sfz.Length = 18) int i = shanchu(sfz); chushihua();请正确输入你要删除的人的身份证号。 private void btixiugai_Click(object sender, EventArgs e)update main_info set hk_id=+hk_nom+, nm_name
15、=+name+, sex=+sex+,jiazhang=+jiazhang+,hunyin=+hunyin+,age=+age+,mz_id=+mz_id+,address=+adress+,picture=+images_path + where sign_num=+sign_no+ int i=data.RUN_SQL(sql);修改成功! else MessageBox.Show(修改失败,请你检查信息再试。 private void btchaxun_Click(object sender, EventArgs e) string name = txtxingming.Text.Tri
16、m (); string sfz_no=txtshenfenzheng.Text.Trim (); string hk_no=txthukouhao.Text .Trim (); string sql_chaxun = if (name.Length != 0|sfz_no.Length !=0|hk_no.Length !=0 ) MessageBox.Show(name+sfz_no+hk_no ); sql_chaxun = sql_chaxun + where (姓名 like % or 身份证号 like + sfz_no + ) and 户口号 like + hk_no + dGV
17、iew1.DataSource = data .get_data(sql_chaxun);不能空或有误。 private void bttupian_Click(object sender, EventArgs e) OpenFileDialog fp = new OpenFileDialog(); DialogResult dr = fp.ShowDialog(); if (dr = DialogResult.OK) FileInfo info = new FileInfo(fp.FileName); images_path = info.Name; pictureBox1.Image = Image.FromFile(fp.FileName); private void 民族ToolStripMenuItem1_Click(object sender, EventArgs e) Fminzu minzu = new Fminzu(); minzu.Show(); private void 退出ToolStripMenuItem2_Click(object sender, EventArgs e)机械工具表的代码:usi
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1