form1.cs

来自「[Visual C# 2005程序设计基础教程] 全部的源码！非常经典」· CS 代码 · 共 89 行

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;
using System.Collections;

namespace DatabaseSample
{
    public partial class Form1 : Form
    {
        private SqlConnection con;
        private SqlCommand com;
        private string sql;
        public Form1()
        {
            InitializeComponent();
        }
        
        private void Form1_Load(object sender, EventArgs e)
        {
            string constr = System.Configuration.ConfigurationSettings.AppSettings["DB"];
            this.con = new SqlConnection(constr);
            con.Open();
            this.com = new SqlCommand();
            com.Connection = con;

           
           
        }

        private void button1_Click(object sender, EventArgs e)
        {
           
            this.com.CommandText = "select IP地址,下载日期 ,下载地点 from DownLog where DownID = 5";
           
            SqlDataReader dr = this.com.ExecuteReader();
            Book.CControl.AddListViewByDataReader(this.listView1, dr);
        }

        private void button2_Click(object sender, EventArgs e)
        {
            
            //构造SQL语句
            string sql = "select * from DownLog where DownID = 5";
            //创建DataAdatper
            SqlDataAdapter myda = new SqlDataAdapter(sql,this.con);
            //创建并填充DataSet
            DataSet ds = new DataSet();
            myda.Fill(ds, "DownLog");
            SqlCommandBuilder objcmdBuilder = new SqlCommandBuilder(myda);
            myda.UpdateCommand = objcmdBuilder.GetUpdateCommand();
            myda.InsertCommand = objcmdBuilder.GetInsertCommand();
            myda.DeleteCommand = objcmdBuilder.GetDeleteCommand(); 
            DataTable dt = ds.Tables["DownLog"];
            //对DataTable中的DataRow和DataColumn对象进行操作
            //添加一条新纪录
            DataRow drow =dt.NewRow();
            drow["DownID"] = 5;
            drow["IP地址"] = "Samp地址";
            drow["下载日期"] = "2005-9-29 0:37:00";
            drow["下载地点"] = "Samp地点";
            dt.Rows.Add(drow);
            
            /*修改记录操作
            DataRow drow = dt.Rows[0];
            drow["DownID"] = 5;
            drow["IP地址"] = "Samp地址";
            drow["下载日期"] = "2005-9-29 0:37:00";
            drow["下载地点"] = "Samp地点";
             */

            //最后将更新提交到数据库中
            myda.Update(ds, "DownLog");
 
        }

        private void button3_Click(object sender, EventArgs e)
        {
            sql = "delete from DownLog where 下载地点 = '湖南省'";
            com.CommandText = sql;
            com.ExecuteNonQuery();
            MessageBox.Show("删除成功！"); 
        }
    }
}