How to submit the value of a large number of form objects to the database with the simplest statement

How can I use the simplest statement to submit the values of a large number of form objects to the database? Said this problem may be often encountered, feel very headache, but there is no way, can only slowly write, the author to submit a candidate form submission as an example to introduce how to use the shortest sentence to achieve the goal
Scripts run through the environment:
iis5.0+sqlserver2000 (You can also access2000, of course)
If you have any questions or suggestions please send email:chenxingbai@21cn.com
Script to generate table structure
if exists (SELECT * from dbo.sysobjects WHERE id = object_id (N ' [dbo].[ Yingpin] and OBJECTPROPERTY (ID, N ' isusertable ') = 1)
drop table [dbo]. [Yingpin]
Go
CREATE TABLE [dbo]. [Yingpin] (
[ID] [int] IDENTITY (1, 1) not NULL,
[Yp_ name] [varchar] (m) COLLATE chinese_prc_ci_as NULL,
[Sex] [varchar] (4) COLLATE chinese_prc_ci_as NULL,
[Birthday] [varchar] (a) COLLATE chinese_prc_ci_as NULL,
[Health] [varchar] (a) COLLATE chinese_prc_ci_as NULL,
[Hunyin] [varchar] (a) COLLATE chinese_prc_ci_as NULL,
[Zhengzhi] [varchar] (a) COLLATE chinese_prc_ci_as NULL,
[Xueli] [varchar] (a) COLLATE chinese_prc_ci_as NULL,
[Zhicheng] [varchar] (a) COLLATE chinese_prc_ci_as NULL,
[中文版] [varchar] (a) COLLATE chinese_prc_ci_as NULL,
[Email] [varchar] (m) COLLATE chinese_prc_ci_as NULL,
[Phone] [varchar] (m) COLLATE chinese_prc_ci_as NULL,
[Yp_ Address] [varchar] (MB) COLLATE chinese_prc_ci_as NULL,
[Zip] [varchar] (a) COLLATE chinese_prc_ci_as NULL,
[Colledge] [varchar] (m) COLLATE chinese_prc_ci_as NULL,
[Zhuanye] [varchar] (m) COLLATE chinese_prc_ci_as NULL,
[Bumen] [varchar] (m) COLLATE chinese_prc_ci_as NULL,
[GANGWEI1] [varchar] (m) COLLATE chinese_prc_ci_as NULL,
[Gangwei2] [varchar] (m) COLLATE chinese_prc_ci_as NULL,
[X_shijian] [varchar] (m) COLLATE chinese_prc_ci_as NULL,
[X_address] [varchar] (m) COLLATE chinese_prc_ci_as NULL,
[X_zhiwu] [varchar] (m) COLLATE chinese_prc_ci_as NULL,
[G_shijian] [varchar] (m) COLLATE chinese_prc_ci_as NULL,