1.添加新记录
Insert into TableName(字段1,字段2,...) values(value1,value2,...)
例如:insert into Soft_info(SoftName) values('" + SoftNameTxtBox.Text + "')
2.修改任意一条记录(如要修改多条记录,可同时写多条语句)
Update Table_Name set Column_Name=** where ID=***
例如:Update table8 set aa=44 where ID=1
3.删除某条记录:
Delete from Table_Name where 条件
例如:Delete from table8 where ID=3
4.删除某一字段:
alter table Table_Name drop column Column_Name
例如:alter table table8 drop column cc