|
protected void Button1_Click(object sender, EventArgs e) { string link_name = this.link_name.Text; string link_url = this.link_url.Text; string link_logo = this.link_logo.Text; //建立连接,连接字符串从配置文件中获取SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DataConnString"].ConnectionString); //创建Sql命令SqlCommand cmd = new SqlCommand("insert_link", con); //命令类型为存储过程cmd.CommandType = CommandType.StoredProcedure; //为存储过程中的变量获取值cmd.Parameters.AddWithValue("@link_name", link_name); cmd.Parameters.AddWithValue("@link_url", link_url); cmd.Parameters.AddWithValue("@link_logo", link_logo); //打开数据库con.Open(); //执行命令cmd.ExecuteNonQuery(); //关闭con.Close(); //重定向到default.aspxResponse.Redirect("default.aspx"); }////////////ACCSEE不行,它不支持存储过程,只能Sql Server |
