if you are using SQL Server, you can run the script in SQL Query Analyzer directly, other database systems have similar toolsor you can write a program in ADO.NET, SqlConnection conn = ...
SqlCommand cmd = new SqlCommand("insert into a (x,y,z) select x,y,z form a", conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close()
SqlCommand cmd = new SqlCommand("insert into a (x,y,z) select x,y,z form a", conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close()
"where prodname = '"+ddlPeifang.SelectedItem.Value+"' ";
帮忙看一下,这句是不是有哪里不对,总是说没有给参数值指定值。