2023年8月3日发(作者：)

vbmysqlupdate,使⽤VB代码更新SQL数据库。Hello everyone,I want to get all records from the "Student" database table where StudentStatus = ''New'''' .Find a particular RegDate(2001/02/02) , StudNo ( 200144176) and update it''s StudentStatus to "?ld", by clicking a command button (UpdateDatabase). I''m using SQL2000( Windows Authentication).and please show me how to connect or retreive that information from the database .Hope I make sense.解决⽅案Hello everyone,I want to get all records from the "Student" database table where StudentStatus = ''New'''' .Find a particular RegDate(2001/02/02) , StudNo ( 200144176) and update it''s StudentStatus to "?ld", by clicking a command button (UpdateDatabase). I''m using SQL2000( Windows Authentication).and please show me how to connect or retreive that information from the database .Hope I make can Get it You can Get it Yes, but how do I do that. I want to design program that is going to update the database for me and change the Status fromnew to old. I need to know what I should write on the Update command button, can you please show me the code. I''m usingSQL2005 and vb6Hi. You will need a connection object and a sql update |Select|Wrap|Line Numbers⼤家好，我想从"学⽣"中获取所有记录。数据库表，其中StudentStatus =''新''''。查找特定的RegDate(2001/02/02)，StudNo(200144176)并通过单击命令按钮(UpdateDatabase)将其'StudentStatus更新为"？ld" )。我正在使⽤SQL2000(Windows⾝份验证)。请告诉我如何从数据库连接或检索这些信息。希望我有意义。解决⽅案⼤家好，我想要从"学⽣"中获取所有记录。数据库表，其中StudentStatus =''新''''。查找特定的RegDate(2001/02/02)，StudNo(200144176)并通过单击命令按钮(UpdateDatabase)将其'StudentStatus更新为"？ld" )。我正在使⽤SQL2000(Windows⾝份验证)。请告诉我如何从数据库连接或检索这些信息。希望我有道理。你可以通过qrys获得.....你可以通过qrys获得它.....是的，但是我该怎么做。我想设计⼀个程序来为我更新数据库，并将Status从new更改为old。我需要知道我应该在更新命令按钮上写什么，你能告诉我代码吗？我正在使⽤SQL2005和vb6嗨。您将需要⼀个连接对象和⼀个sql update语句。展开 | 选择 | Wrap | ⾏号

2023年8月3日发(作者：)

vbmysqlupdate,使⽤VB代码更新SQL数据库。Hello everyone,I want to get all records from the "Student" database table where StudentStatus = ''New'''' .Find a particular RegDate(2001/02/02) , StudNo ( 200144176) and update it''s StudentStatus to "?ld", by clicking a command button (UpdateDatabase). I''m using SQL2000( Windows Authentication).and please show me how to connect or retreive that information from the database .Hope I make sense.解决⽅案Hello everyone,I want to get all records from the "Student" database table where StudentStatus = ''New'''' .Find a particular RegDate(2001/02/02) , StudNo ( 200144176) and update it''s StudentStatus to "?ld", by clicking a command button (UpdateDatabase). I''m using SQL2000( Windows Authentication).and please show me how to connect or retreive that information from the database .Hope I make can Get it You can Get it Yes, but how do I do that. I want to design program that is going to update the database for me and change the Status fromnew to old. I need to know what I should write on the Update command button, can you please show me the code. I''m usingSQL2005 and vb6Hi. You will need a connection object and a sql update |Select|Wrap|Line Numbers⼤家好，我想从"学⽣"中获取所有记录。数据库表，其中StudentStatus =''新''''。查找特定的RegDate(2001/02/02)，StudNo(200144176)并通过单击命令按钮(UpdateDatabase)将其'StudentStatus更新为"？ld" )。我正在使⽤SQL2000(Windows⾝份验证)。请告诉我如何从数据库连接或检索这些信息。希望我有意义。解决⽅案⼤家好，我想要从"学⽣"中获取所有记录。数据库表，其中StudentStatus =''新''''。查找特定的RegDate(2001/02/02)，StudNo(200144176)并通过单击命令按钮(UpdateDatabase)将其'StudentStatus更新为"？ld" )。我正在使⽤SQL2000(Windows⾝份验证)。请告诉我如何从数据库连接或检索这些信息。希望我有道理。你可以通过qrys获得.....你可以通过qrys获得它.....是的，但是我该怎么做。我想设计⼀个程序来为我更新数据库，并将Status从new更改为old。我需要知道我应该在更新命令按钮上写什么，你能告诉我代码吗？我正在使⽤SQL2005和vb6嗨。您将需要⼀个连接对象和⼀个sql update语句。展开 | 选择 | Wrap | ⾏号