资源描述:
《c#对access数据库做的添加、删除、查找、修改的例子》由会员上传分享,免费在线阅读,更多相关内容在应用文档-天天文库。
1、C#对Access数据库做的添加、删除、查找、修改的例子usingSystem;usingSystem.Data;usingSystem.Data.OleDb;usingSystem.Collections;usingSystem.Windows.Forms;namespaceRace//////publicclassMyData privateOleDbConnectionconn; privateOleDbCommandcomm; publicMyData()//用函数实现一个数据库联接 conn=newOleDbConnection(
2、@"Provider='Microsoft.Jet.OLEDB.4.0';DataSource='"+Application.StartupPath+@"data.mdb'"); } /// /// ///一级项目ID ///二级项目信息 publicDataTableProject_GetInfo()//从数据库中读取数据到da再在内存中建立ds 用fill来把da的数据填充到ds再返回ds中的首行 try OleDbDataAdapterda
3、=newOleDbDataAdapter("select*fromProject",conn); DataSetds=newDataSet(); da.Fill(ds); returnds.Tables[0]; } catch returnnull; } } /// /// ///信息数组 publicvoidProject_InsertInfo(string[]info) try comm=newOleDbCommand("insertinto[project]
4、([name],[multiple],[time],[delay],[loop],[music],[startmusic])values('"+info[0]+"','"+info[1]+"','"+info[2]+"','"+info[3]+"','"+info[4]+"','"+info[5]+"','"+info[6]+"')",conn); conn.Open(); comm.ExecuteNonQuery(); catch //MessageBox.Show("添加失败"); finally conn.Close(); } ///
5、/// ///信息数组 ///ID publicvoidProject_UpdateInfo(string[]info,stringid) try comm=newOleDbCommand("update[project]set[name]='"+info[0]+"',[multiple]='"+info[1]+"',[time]='"+info[2]+"',[delay]='"+info[3]+"',[loop]='"+info[4]+"',[music
6、]='"+info[5]+"',[startmusic]='"+info[6]+"'whereid="+id,conn); conn.Open(); comm.ExecuteNonQuery(); catch{} finally conn.Close(); } /// /// ///信息数组123 publicvoidProject_DeleteInfoByID(stringid) try comm=newOleDbCommand("deletefromprojectw
7、here[id]="+id,conn); conn.Open(); comm.ExecuteNonQuery(); } catch{} finally conn.Close(); }}