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

C#对Access数据库做的添加、删除、查找、

修改的例子

usingSystem.Data;usingSystem;

usingSystem.Data;

usingSystem.Data.OleDb;

using

usingSystem.Collections;

///summaryusingSystem.Windows.Forms;namespaceRace

///summary

publicclassMyData////summary

publicclassMyData

privateOleDbConnectionconn;

privateOleDbCommandcomm;

privateOleDbCommandcomm;

publicMyData()//用函数实现一个数据库联接conn=new

OleDbConnection(@Provider=Microsoft.Jet.OLEDB.4.0;DataSource=

OleDbConnection(@Provider=Microsoft.Jet.OLEDB.4.0;DataSource=

+Application.StartupPath+@\data.mdb);

summary} ///

summary

///

/summary

/summary

///param

///param

name=peid一级项目ID/param

///

returns二级项目信息/returns

publicDataTableProject_GetInfo()//从数据库中读取数据到da

再在内存中建立ds 用fill来把da的数据填充到ds再返回ds中的首行

try

Project,conn);OleDbDataAdapterda=newOleDbDataAdapter(select*from

Project,conn);

DataSetds=

new

newDataSet();

returnda.Fill(ds);

return

ds.Tables[0];

catch}

catch

}

return

return

null;

null;

}

summary} ///

summary

///

/summary

/summary

///param

///param

name=info信息数组/parampublicvoidProject_InsertInfo(string[]

comm=

comm=new

OleDbCommand(insertinto

OleDbCommand(insertinto[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,stringid)publicvoidProject_UpdateInfo(string[]

info,stringid)

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]+

whereid=+id,conn);

conn.Open();

conn.Open();

comm.ExecuteNonQuery();

comm.ExecuteNonQuery();

finallyca