110,579
社区成员
发帖
与我相关
我的任务
分享
create table DataGridViewDemoTable
(
[ID] int identity(1,1) primary key,
[Name] varchar(20) unique,
[Department] varchar(20)
)
insert into DataGridViewDemoTable ([Name],[Department]) select '张三','市场部'
union all select '李四','研发部'
union all select '王二','策划部'
select * from DataGridViewDemoTable
namespace InformationTest
{
partial class DataGridViewDemo
{
/// <summary>
/// 必需的设计器变量。
/// </summary>
private System.ComponentModel.IContainer components = null;
/// <summary>
/// 清理所有正在使用的资源。
/// </summary>
/// <param name="disposing">如果应释放托管资源,为 true;否则为 false。</param>
protected override void Dispose(bool disposing)
{
if (disposing && (components != null))
{
components.Dispose();
}
base.Dispose(disposing);
}
#region Windows 窗体设计器生成的代码
/// <summary>
/// 设计器支持所需的方法 - 不要
/// 使用代码编辑器修改此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.dataGridView1 = new System.Windows.Forms.DataGridView();
this.btnSave = new System.Windows.Forms.Button();
((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit();
this.SuspendLayout();
//
// dataGridView1
//
this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.dataGridView1.Location = new System.Drawing.Point(12, 12);
this.dataGridView1.Name = "dataGridView1";
this.dataGridView1.RowTemplate.Height = 23;
this.dataGridView1.Size = new System.Drawing.Size(366, 150);
this.dataGridView1.TabIndex = 0;
//
// btnSave
//
this.btnSave.Location = new System.Drawing.Point(136, 203);
this.btnSave.Name = "btnSave";
this.btnSave.Size = new System.Drawing.Size(75, 23);
this.btnSave.TabIndex = 1;
this.btnSave.Text = "保存";
this.btnSave.UseVisualStyleBackColor = true;
this.btnSave.Click += new System.EventHandler(this.btnSave_Click);
//
// DataGridViewDemo
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(402, 273);
this.Controls.Add(this.btnSave);
this.Controls.Add(this.dataGridView1);
this.Name = "DataGridViewDemo";
this.Text = "DataGridViewDemo";
this.Load += new System.EventHandler(this.DataGridViewDemo_Load);
((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).EndInit();
this.ResumeLayout(false);
}
#endregion
private System.Windows.Forms.DataGridView dataGridView1;
private System.Windows.Forms.Button btnSave;
}
}
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 InformationTest
{
public partial class DataGridViewDemo : Form
{
public DataGridViewDemo()
{
InitializeComponent();
}
private void btnSave_Click(object sender, EventArgs e)
{
DataTable dt = dataGridView1.DataSource as DataTable;
if (dt != null)
{
try
{
using (SqlConnection con = new SqlConnection("server=.;uid=xxx;pwd=xxx;database=test"))
{
SqlDataAdapter da = new SqlDataAdapter("select * from [DataGridViewDemoTable]", con);
SqlCommandBuilder scb = new SqlCommandBuilder(da);
DataSet ds = new DataSet();
da.Fill(ds, "DataGridViewDemoTable");
da.Update(dt);
}
}
catch (DataException de)
{
con = null;
}
}
}
private void DataGridViewDemo_Load(object sender, EventArgs e)
{
using (SqlConnection con = new SqlConnection("server=.;uid=xxx;pwd=xxx;database=test"))
{
try
{
SqlDataAdapter da = new SqlDataAdapter("select * from [DataGridViewDemoTable]", con);
DataSet ds = new DataSet();
da.Fill(ds, "DataGridViewDemoTable");
if (ds.Tables.Contains("DataGridViewDemoTable"))
{
dataGridView1.DataSource = ds.Tables["DataGridViewDemoTable"];
}
}
catch (DataException de)
{
con = null;
}
}
}
}
}
public static DataTable stDT;
private void DataGridViewDemo_FormClosing(object sender, FormClosingEventArgs e)
{
stDT = dataGridView1.DataSource as DataTable;
}
private void toolStripButton4_Click(object sender, EventArgs e)
{
string sql = "server=(local);user id=sa;pwd=sa;database=test";
SqlConnection con = new SqlConnection(sql);
con.Open();
SqlCommand cmd = new SqlCommand("", con);
for (int i = 0; i < dataGridView2.RowCount - 1; i++)
{
cmd.CommandText = "insert into jilu values(@niuju,@zhuansu,@zhougonglv,@shurugonglv,@shuchugonglv,@gonglvyinshu,@bengzhanzaoyin,@caozuotaizaoyin,@madazaoyin,@madayouya,@shuibengyali,@tuijinyali,@madajinyou,@madahuiyou,@lengqueshui,@geijinli,@maoguli1,@maoguli2,@youye,@youbeng,@mada,@daqiwendu,@daqishidu,@xingcheng,@sudu,@zhengjixiaolv,@shijian)";
cmd.Parameters.Clear();
cmd.Parameters.Add("@niuju", SqlDbType.Char, 10);
cmd.Parameters.Add("@zhuansu", SqlDbType.Char, 10);
cmd.Parameters.Add("@zhougonglv", SqlDbType.Char, 10);
cmd.Parameters.Add("@shurugonglv", SqlDbType.Char, 10);
cmd.Parameters.Add("@shuchugonglv", SqlDbType.Char, 10);
cmd.Parameters.Add("@gonglvyinshu", SqlDbType.Char, 10);
cmd.Parameters.Add("@bengzhanzaoyin", SqlDbType.Char, 10);
cmd.Parameters.Add("@caozuotaizaoyin", SqlDbType.Char, 10);
cmd.Parameters.Add("@madazaoyin", SqlDbType.Char, 10);
cmd.Parameters.Add("@madayouya", SqlDbType.Char, 10);
cmd.Parameters.Add("@shuibengyali", SqlDbType.Char, 10);
cmd.Parameters.Add("@tuijinyali", SqlDbType.Char, 10);
cmd.Parameters.Add("@madajinyou", SqlDbType.Char, 10);
cmd.Parameters.Add("@madahuiyou", SqlDbType.Char, 10);
cmd.Parameters.Add("@lengqueshui", SqlDbType.Char, 10);
cmd.Parameters.Add("@geijinli", SqlDbType.Char, 10);
cmd.Parameters.Add("@maoguli1", SqlDbType.Char, 10);
cmd.Parameters.Add("@maoguli2", SqlDbType.Char, 10);
cmd.Parameters.Add("@youye", SqlDbType.Char, 10);
cmd.Parameters.Add("@youbeng", SqlDbType.Char, 10);
cmd.Parameters.Add("@mada", SqlDbType.Char, 10);
cmd.Parameters.Add("@daqiwendu", SqlDbType.Char, 10);
cmd.Parameters.Add("@daqishidu", SqlDbType.Char, 10);
cmd.Parameters.Add("@xingcheng", SqlDbType.Char, 10);
cmd.Parameters.Add("@sudu", SqlDbType.Char, 10);
cmd.Parameters.Add("@zhengjixiaolv", SqlDbType.Char, 10);
cmd.Parameters.Add("@shijian", SqlDbType.DateTime, 20);
cmd.Parameters[0].Value = dataGridView2.Rows[i].Cells[2].Value.ToString();
cmd.Parameters[1].Value = dataGridView2.Rows[i].Cells[3].Value.ToString();
cmd.Parameters[2].Value = dataGridView2.Rows[i].Cells[4].Value.ToString();
cmd.Parameters[3].Value = dataGridView2.Rows[i].Cells[5].Value.ToString();
cmd.Parameters[4].Value = dataGridView2.Rows[i].Cells[6].Value.ToString();
cmd.Parameters[5].Value = dataGridView2.Rows[i].Cells[7].Value.ToString();
cmd.Parameters[6].Value = dataGridView2.Rows[i].Cells[8].Value.ToString();
cmd.Parameters[7].Value = dataGridView2.Rows[i].Cells[9].Value.ToString();
cmd.Parameters[8].Value = dataGridView2.Rows[i].Cells[10].Value.ToString();
cmd.Parameters[9].Value = dataGridView2.Rows[i].Cells[11].Value.ToString();
cmd.Parameters[10].Value = dataGridView2.Rows[i].Cells[12].Value.ToString();
cmd.Parameters[11].Value = dataGridView2.Rows[i].Cells[13].Value.ToString();
cmd.Parameters[12].Value = dataGridView2.Rows[i].Cells[14].Value.ToString();
cmd.Parameters[13].Value = dataGridView2.Rows[i].Cells[15].Value.ToString();
cmd.Parameters[14].Value = dataGridView2.Rows[i].Cells[16].Value.ToString();
cmd.Parameters[15].Value = dataGridView2.Rows[i].Cells[17].Value.ToString();
cmd.Parameters[16].Value = dataGridView2.Rows[i].Cells[18].Value.ToString();
cmd.Parameters[17].Value = dataGridView2.Rows[i].Cells[19].Value.ToString();
cmd.Parameters[18].Value = dataGridView2.Rows[i].Cells[20].Value.ToString();
cmd.Parameters[19].Value = dataGridView2.Rows[i].Cells[21].Value.ToString();
cmd.Parameters[20].Value = dataGridView2.Rows[i].Cells[22].Value.ToString();
cmd.Parameters[21].Value = dataGridView2.Rows[i].Cells[23].Value.ToString();
cmd.Parameters[22].Value = dataGridView2.Rows[i].Cells[24].Value.ToString();
cmd.Parameters[23].Value = dataGridView2.Rows[i].Cells[25].Value.ToString();
cmd.Parameters[24].Value = dataGridView2.Rows[i].Cells[26].Value.ToString();
cmd.Parameters[25].Value = dataGridView2.Rows[i].Cells[27].Value.ToString();
cmd.Parameters[26].Value = textBox27.Text;
cmd.ExecuteNonQuery();
}
con.Close();
MessageBox.Show("保存成功");
}