C#对Access数据库做的添加、删除、查找、修改的例子.docxVIP

C#对 Access 数据库做的添加、删除、查找、 修改的例子 using System.Data;using System; using System.Data; using System.Data.OleDb; using using System.Collections; /// summaryusing System.Windows.Forms; namespace Race /// summary public class MyData/// /summary public class MyData private OleDbConnection conn; private OleDbCommandcomm; private OleDbCommandcomm; public MyData()//用函数实现一个数据库联接conn = new OleDbConnection(@Provider=Microsoft.Jet.OLEDB.4.0;Data Source= OleDbConnection(@Provider=Microsoft.Jet.OLEDB.4.0;Data Source= + Application.StartupPath + @\data.mdb); summary} /// summary /// /summary /summary /// param /// param name=peid一级项目ID/param /// returns二级项目信息/returns public DataTableProject_GetInfo()//从数据库中读取数据到 da 再在内存中建立ds 用 fill 来把 da 的数据填充到ds 再返回ds 中的首行 try Project,conn);OleDbDataAdapter da = new OleDbDataAdapter(select * from Project,conn); DataSet ds = new new DataSet(); returnda.Fill(ds); return ds.Tables[0]; catch} catch } return return null; null; } summary} /// summary /// /summary /summary /// param /// param name=info信息数组/param public void Project_InsertInfo(string[] comm = comm = new OleDbCommand(insert into OleDbCommand(insert into [project] values([name],[multiple],[time],[delay],[loop],[music],[startmusic]) values (+info[0]+,+info[1]+,+info[2]+,+info[3]+,+info[4]+,+info[5]+,+info[6]+),con n); n); conn.Open(); comm.ExecuteNonQuery(); catch catch //MessageBox.Show( //MessageBox.Show(添加失败); finally conn.Close(); conn.Close(); } /// ///summary /// /summary /// param /// param name=info信息数组/param /// param name=idID/param name=idID/param info,string id)public void Project_UpdateInfo(string[] info,string id) try OleDbCommand(update [project] setcomm = new OleDbCommand(update [project] set [name]=+info[0]+,[multiple]=+info[1]+,[time]=+info[2]+,[delay]=+info[3]+,[loop]= +info[4]+,[music]=+info[5]+,[startmusic]=+info[6]+ +info[4]+,[music]=+info[5]+,[startmusic]=+info[6]+ where id=+id,conn); conn.Open(); conn.Open(); comm.ExecuteNonQuery(); comm.ExecuteNonQuery(); finallyca