使用dataset修改数据

软件技术国家教学资源库建设项目软件开发素材之C源代码一、名称使用DATASET修改数据二、创建或搜集相关信息搜集单位重庆电子工程职业学院搜集时间20120805来源互联网三、适用对象学生、教师、C及ASPNET项目开发人员、相关技术人员等。四、功能简介使用DATASET修改数据。五、程序代码程序名称MODIFYDATABASECSUSINGSYSTEMUSINGSYSTEMDATAUSINGSYSTEMDATASQLCLIENTNAMESPACEMODIFYDATABASE/MODIFYDATABASE的摘要说明。/PUBLICCLASSMODIFYDATABASE/显示指定行的记录属性值PUBLICSTATICVOIDDISPLAYDATAROWDATAROWMYDATAROW,DATATABLEMYDATATABLECONSOLEWRITELINE“NINDISPLAYDATAROW“FOREACHDATACOLUMNMYDATACOLUMNINMYDATATABLECOLUMNSCONSOLEWRITELINEMYDATACOLUMN“MYDATAROWMYDATACOLUMNPUBLICSTATICVOIDADDDATAROWDATATABLEMYDATATABLE,SQLDATAADAPTERMYSQLDATAADAPTER,SQLCONNECTIONMYSQLCONNECTIONCONSOLEWRITELINE“NINADDDATAROW“/用DATATABLE中的NEWROW方法生成新的DATAROWCONSOLEWRITELINE“CALLINGMYDATATABLENEWROW“DATAROWMYNEWDATAROWMYDATATABLENEWROWCONSOLEWRITELINE“MYNEWDATAROWROWSTATE“MYNEWDATAROWROWSTATE/对新的DATAROW的DATACOLUMN对象设置数值MYNEWDATAROW“CUSTOMERID“JXCOM“MYNEWDATAROW“COMPANYNAME“JXCOMPANY“MYNEWDATAROW“ADDRESS“1MAINSTREET“/将新的DATAROW加进DATATABLE中CONSOLEWRITELINE“CALLINGMYDATATABLEROWSADD“MYDATATABLEROWSADDMYNEWDATAROWCONSOLEWRITELINE“MYNEWDATAROWROWSTATE“MYNEWDATAROWROWSTATE/将新行推进数据库中CONSOLEWRITELINE“CALLINGMYSQLDATAADAPTERUPDATE“MYSQLCONNECTIONOPENINTNUMOFROWSMYSQLDATAADAPTERUPDATEMYDATATABLEMYSQLCONNECTIONCLOSECONSOLEWRITELINE“NUMOFROWS“NUMOFROWSCONSOLEWRITELINE“MYNEWDATAROWROWSTATE“MYNEWDATAROWROWSTATEDISPLAYDATAROWMYNEWDATAROW,MYDATATABLEPUBLICSTATICVOIDMAINSQLCONNECTIONMYSQLCONNECTIONNEWSQLCONNECTION“SERVERLOCALHOSTDATABASENORTHWINDUIDSAPWDSA“/创建SELECT语句得SQLCOMMAND对象SQLCOMMANDMYSELECTCOMMANDMYSQLCONNECTIONCREATECOMMANDMYSELECTCOMMANDCOMMANDTEXT“SELECTCUSTOMERID,COMPANYNAME,ADDRESS“FROMCUSTOMERS“ORDERBYCUSTOMERID“/创建INSERT语句得SQLCOMMAND对象SQLCOMMANDMYINSERTCOMMANDMYSQLCONNECTIONCREATECOMMANDMYINSERTCOMMANDCOMMANDTEXT“INSERTINTOCUSTOMERS“CUSTOMERID,COMPANYNAME,ADDRESS“VALUES“CUSTOMERID,COMPANYNAME,ADDRESS“MYINSERTCOMMANDPARAMETERSADD“CUSTOMERID“,SQLDBTYPENCHAR,5,“CUSTOMERID“MYINSERTCOMMANDPARAMETERSADD“COMPANYNAME“,SQLDBTYPENVARCHAR,40,“COMPANYNAME“MYINSERTCOMMANDPARAMETERSADD“ADDRESS“,SQLDBTYPENVARCHAR,60,“ADDRESS“/创建SQLDATAADAPTER并设置相应属性SQLDATAADAPTERMYSQLDATAADAPTERNEWSQLDATAADAPTERMYSQLDATAADAPTERSELECTCOMMANDMYSELECTCOMMANDMYSQLDATAADAPTERINSERTCOMMANDMYINSERTCOMMAND/创建DATASET并调用MYSQLDATAADAPTER的FILL方法DATASETMYDATASETNEWDATASETCONSOLEWRITELINE“CALLINGMYSQLDATAADAPTERFILL“MYSQLCONNECTIONOPENINTNUMOFROWSMYSQLDATAADAPTERFILLMYDATASET,“CUSTOMERS“MYSQLCONNECTIONCLOSECONSOLEWRITELINE“NUMOFROWS“NUMOFROWS/从MYDATASET中获取CUSTOMERS表DATATABLECUSTOMERSDATATABLEMYD