c# datagridview 绑定mysql_c# 数据库数据与DataGridView表控件的绑定

usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;usingSystem.Data.Common;namespaceDateManagerTools

{public partial classForm1 : Form

{privateDataSet dsMain;privateSqlDataAdapter adapter;publicForm1()

{

InitializeComponent();

}privateSqlConnection getConnection()

{

SqlConnection connection= newSqlConnection();

connection.ConnectionString= "Data Source=IP;Initial Catalog=数据库名称;Persist Security Info=True;User ID=**; Password=";returnconnection;

}private void Form1_Load(objectsender, EventArgs e)

{

InitAdapter();

getData();

BindingControl();

}///

///初始化adapter变量///

private voidInitAdapter()

{

SqlConnection connection= this.getConnection();

adapter= new SqlDataAdapter("select * from steelname", connection);

adapter.FillLoadOption=LoadOption.OverwriteChanges;//新增

SqlCommand InsertCommand = newSqlCommand();

InsertCommand.Connection=connection;

InsertCommand.CommandText= "insert into steelname,Name) values(@ID,@Code,@Name)";

InsertCommand.Parameters.Add("@ID", SqlDbType.Int, 4, "ID");

InsertCommand.Parameters.Add("@Code", SqlDbType.Char, 20, "Code");

InsertCommand.Parameters.Add("@Name", SqlDbType.VarChar, 50, "Name");

adapter.InsertCommand=InsertCommand;//修改

SqlCommand UpdateCommand = newSqlCommand();

UpdateCommand.Connection=connection;

UpdateCommand.CommandText= "update steelname set Code=@Code,Name=@Name where ID=@ID";

UpdateCommand.Parameters.Add("@ID", SqlDbType.Int, 4, "ID");

UpdateCommand.Parameters.Add("@Code", SqlDbType.Char, 20, "Code");

UpdateCommand.Parameters.Add("@Name", SqlDbType.VarChar, 50, "Name");

adapter.UpdateCommand=UpdateCommand;//删除

SqlCommand DeleteCommand = newSqlCommand();

DeleteCommand.Connection=connection;

DeleteCommand.CommandText= "delete steelname where steelname_id=@steelname_id";

DeleteCommand.Parameters.Add("@steelname_id", SqlDbType.Int, 4, "steelname_id");

adapter.DeleteCommand=DeleteCommand;//添加表映射//DataTableMapping TableMapping = new DataTableMapping();//TableMapping = adapter.TableMappings.Add("Users", "Users");//TableMapping.ColumnMappings.Add("Code", "Code");//TableMapping.ColumnMappings.Add("Name", "Name");//TableMapping.DataSetTable = "SteelName";

}///

///把控件绑定到数据源///

private voidBindingControl()

{this.dataGridView1.DataSource =dsMain;this.dataGridView1.DataMember = "steelname";//this.dataGridView1.Columns[0].Width = 40;//this.txtID.DataBindings.Add("Text", dsMain, "Users.ID");//this.txtCode.DataBindings.Add("Text", dsMain, "Users.Code");//this.txtName.DataBindings.Add("Text", dsMain, "Users.Name");

}///

///从Sql Server中获取数据///

private voidgetData()

{if (dsMain == null)

{

dsMain= newDataSet();

}else{

dsMain.Clear();

}

adapter.Fill(dsMain,"steelname");

}//新增

private void button1_Click(objectsender, EventArgs e)

{this.BindingContext[dsMain, "steelname"].AddNew();this.BindingContext[dsMain, "steelname"].EndCurrentEdit();//结束编译//this.txtCode.Focus();

}//删除

private void button2_Click(objectsender, EventArgs e)

{if (this.BindingContext[dsMain, "steelname"].Position > -1)

{if (MessageBox.Show("是否要删除此记录？", "提示", MessageBoxButtons.YesNo) ==DialogResult.Yes)

{this.BindingContext[dsMain, "steelname"].RemoveAt(this.BindingContext[dsMain, "steelname"].Position);

Save();

}

}

}//保存

private void button3_Click(objectsender, EventArgs e)

{this.BindingContext[dsMain, "steelname"].EndCurrentEdit();

Save();

}//刷新

private void button4_Click(objectsender, EventArgs e)

{

getData();

}private voidSave()

{try{

adapter.Update(dsMain,"steelname");

}catch(Exception ex)

{

MessageBox.Show(ex.Message);

}

}

}

}