程式搜集分享精靈

SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["schoolConnectionString"].ConnectionString);
conn.Open();
SqlCommand cmd = new SqlCommand("insert into test_result (student_id,test_id,test_result_second,test_result_date) values (" + Session["student_id"] + "," + ViewState["test_id"] + ",'" + Convert.ToInt32((Convert.ToDateTime(Session["end_time"]) - Convert.ToDateTime(Session["start_time"])).TotalSeconds) + "秒','" + DateTime.Now.ToShortDateString() + "') ; Select SCOPE_IDENTITY()", conn);
string a = cmd.ExecuteScalar().ToString();
cmd.Cancel();