在C＃窗口应用程序中的访问数据库中插入删除更新值 [英] insert delete update value in access database in C# window application

问题描述

C＃窗口应用程序中的访问数据库中插入删除更新值的示例

example of insert delete update value in access database in C# window application

推荐答案

简单的ADO.NET数据库使用C＃读取，插入，更新和删除。 [ ^ ]



希望这个链接可以帮助你



以及更多谷歌搜索ADO.net

Simple ADO.NET Database Read, Insert, Update and Delete using C#.[^]

Hope this link to help you

AND more in google search for ADO.net

您好，

FOR SHOW数据库：



// ************** **************** FOR SHOW数据库：************************

OleDbConnection con1 = new OleDbConnection（）;

con1.ConnectionString =provider = microsoft.ace.oledb.12.0; data source = C：\\University.accdb;

con1.Open（）;





//创建数据库查询

OleDbDataAdapter da = new OleDbDataAdapter（select * from Student，con1）;

//数据表：我们数据的表格/>
DataTable dt = new DataTable（）;

da.Fill（dt）;



dataGridView1.DataSource = dt .DefaultView;

con1.Close（）;

//// ********************* ********* FOR插入数据库：************************

//连接到数据库

OleDbConnection con1 = new OleDbConnection（）;

con1.ConnectionString =provider = microsoft.ace.oledb.12.0; data source = C：\\ University.accdb;



OleDbCommand cmd = new OleDbCommand（）;

cmd.CommandType = CommandType.Text;

cmd.CommandText = @插入学生（StuNO，姓名，家庭，领域，年龄）VALUES（''+ textBox1.Text + ''，''+ textBox2.Text +''，''+ textBox3.Text +''，''+ textBox4.Text +''，''+ textBox5.Text +' '）;



///这个:( StuNO，姓名，家庭，领域，年龄）学生表中字段的名称

///

///

cmd.Connection = con1;

con1.Open（）;

cmd.ExecuteNonQuery（）;

System.Windows.Forms.MessageBox.Show（Recrod Succefully Created）;

con1.Close（）;

textBox1.Text =;

textBox2.Text =;

textBox3.Text =;

textBox4.Text =;

textBox5.Text =;



//你应该点击show按钮上的agin看看插入记录。

Hi,
FOR SHOW database:

//******************************FOR SHOW database:************************
OleDbConnection con1 = new OleDbConnection();
con1.ConnectionString = "provider = microsoft.ace.oledb.12.0;data source = C:\\University.accdb";
con1.Open();


//create the database query
OleDbDataAdapter da = new OleDbDataAdapter("select * from Student", con1);
// data Table : a table for our data
DataTable dt = new DataTable();
da.Fill(dt);

dataGridView1.DataSource = dt.DefaultView;
con1.Close();
////******************************FOR Insert into database:************************
// connect to data base
OleDbConnection con1 = new OleDbConnection();
con1.ConnectionString = "provider = microsoft.ace.oledb.12.0;data source = C:\\University.accdb";

OleDbCommand cmd = new OleDbCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = @"insert into Student (StuNO, Name,Family,Field,Age)VALUES(''" + textBox1.Text + "'',''" + textBox2.Text + "'',''" + textBox3.Text + "'',''" + textBox4.Text + "'',''" + textBox5.Text + "'')";

/// this :(StuNO, Name,Family,Field,Age) name of fields in "Student" table
///
///
cmd.Connection = con1;
con1.Open();
cmd.ExecuteNonQuery();
System.Windows.Forms.MessageBox.Show("Recrod Succefully Created");
con1.Close();
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox5.Text = "";

// you should click agin on the show button to see inserted record.

这篇关于在C＃窗口应用程序中的访问数据库中插入删除更新值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！