如何用VS2005对SQL数据库进行新增保存修改,用Visual C# Windows应用程序

Question

表名STU

本人小白，求教大神给出具体的步奏

Answer 1

`using System.Data.OleDb;
string connString, sqlString;
OleDbConnection conn = new OleDbConnection();
OleDbCommand comm = new OleDbCommand();
OleDbDataAdapter da = new OleDbDataAdapter();
DataTable dt = new DataTable();
connString = "Provider=Microsoft.JET.OLEDB.4.0;Data Source=|DataDirectory|STU.mdb";//数据库名称
conn.ConnectionString = connString;
comm.Connection = conn;
sqlString = "Insert into STU Values('"+ idtextBox.Text + "','" + nametextBox.Text +
"','" + cjtextBox.Text + "')";
comm.CommandText = sqlString;//添加语句
//sqlString = "delete from STU where id='" + idtextBox.Text + "'"; //删除语句
//string sqlString = "update STU set [cj]='" + cjtextBox.Text + "'where name = '" + namestring + "'";//修改语句
comm.CommandText = sqlString;
int countInteger;
try
{
conn.Open();
countInteger = comm.ExecuteNonQuery();
if (countInteger > 0)
{
MessageBox.Show("添加成功","Add ",MessageBoxButtons.OK,MessageBoxIcon.Information);
}

}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
conn.Close();
}
`
这是例子,还有把数据库中id那一项的名称改了,id属于关键字就像date,if之类的一样,用id做表头名称程序会出错.