面向对象程序设计(C#)第08章 数据库编程.pptVIP

3.2 查询数据 String SQL = String.Format(select * from tblstudent where {0} like %{1}%, fieldName, keyWords); OleDbDataAdapter da = new OleDbDataAdapter(); da.SelectCommand = new OleDbCommand(SQL, sqlConn); DataSet ds = new DataSet(); da.Fill(ds); if (ds.Tables.Count 0) { dgvStudents.DataSource = ds.Tables[0]; if (ds.Tables[0].Rows.Count 0) dgvStudents.ContextMenuStrip = popMenu; } sqlConn.Close(); 3.3新增记录 String SQL = insert into tblstudent values(:No, :Name, :Sex, :Department, :Class, :Credit, :Memo); sqlConn.Open(); OleDbCommand command = new OleDbCommand(); command.Connection = sqlConn; command.CommandText = SQL; command.Parameters.AddWithValue(No, student.No); command.Parameters.AddWithValue(Name, student.Name); command.Parameters.AddWithValue(Sex, student.Sex); command.Parameters.AddWithValue(Department, student.Department); command.Parameters.AddWithValue(Class, student.CurClass); command.Parameters.AddWithValue(Credit, student.Credit); command.Parameters.AddWithValue(Memo, student.Memo); command.ExecuteNonQuery(); sqlConn.Close(); 3.5修改记录 String SQL = String.Format(update tblstudent set [No] = :No, Name = :Name , Sex = :Sex , Department = :Department, Class = :Class, Credit = :Credit, [Memo] = :Memo where [No]={1},student.Memo, OldNo); OleDbCommand command = new OleDbCommand(); command.Connection = sqlConn; command.CommandText = SQL; command.Parameters.AddWithValue(No, student.No); command.Parameters.AddWithValue(Name, student.Name); command.Parameters.AddWithValue(Sex, student.Sex); command.Parameters.AddWithValue(Department, student.Department); comm