ASP.
NET作业 网站设计示意图
代码
设计部分
using System; using System.Data; using System.Data.SqlClient; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void Button1_Click(object sender, EventArgs e) {
if (FileUpload1.HasFile) { string fn = FileUpload1.FileName; string fpath = Server.MapPath("images/"); string fullname = fpath + fn; try { FileUpload1.PostedFile.SaveAs(fullname); } catch { Response.Write("上传文件失败"); } SqlConnection id=sa;password=sa"; SqlCommand SqlParameter SqlParameter SqlParameter cmd=new SqlCommand(); p1=new SqlParameter("@number",TextBox1.Text); p2=new SqlParameter("@bumen",TextBox2.Text); p3=new SqlParameter("@telephone",TextBox3.Text); cmd.Connection=conn; conn=new SqlConnection(); conn.ConnectionString = "server =127.0.0.1;initial catalog=stu-044;user
SqlParameter p4 = new SqlParameter("@pic", "images/" + fn); cmd.Parameters.Add(p1); cmd.Parameters.Add(p2); cmd.Parameters.Add(p3); cmd.Parameters.Add(p4); cmd.CommandText="insert conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); Showdata(); } else { Response.Write("没有要上传的文件"); } } void Showdata() { SqlConnection conn = new SqlConnection(); conn.ConnectionString = "server =127.0.0.1;initial catalog=stu-044;user id=sa;password=sa"; SqlCommand cmd = new SqlCommand(); into zhigong(number,bumen,telephone,pic) values(@number,@bumen,@telephone,@pic)";
cmd.Connection = conn; cmd.CommandText = "select * conn.Open(); GridView1.DataSource = cmd.ExecuteReader(); GridView1.DataBind(); conn.Close(); } protected void Button2_Click(object sender, EventArgs e) { string fn = FileUpload1.FileName; string fpath = Server.MapPath("images/"); string fullname = fpath + fn; from zhigong";
SqlConnection conn = new SqlConnection(); conn.ConnectionString = "server =127.0.0.1;initial catalog=stu-044;user id=sa;pass
word=sa"; SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; SqlParameter p1 = new SqlParameter("@number", TextBox1.Text); SqlParameter p2 = new SqlParameter("@bumen", TextBox2.Text); SqlParameter p3 = new SqlParameter("@telephone", TextBox3.Text); SqlParameter p4 = new SqlParameter("@pic", "images/" + fn); cmd.Parameters.Add(p1); cmd.Parameters.Add(p2); cmd.Parameters.Add(p3); cmd.Parameters.Add(p4); cmd.CommandText = "select * from zhigong conn.Open(); GridView1.DataSource = cmd.ExecuteReader(); GridView1.DataBind(); Response.Write("
"); conn.Close(); } protected void Button3_Click(object sender, EventArgs e) { string fn = FileUpload1.FileName; string fpath = Server.MapPath("images/"); string fullname = fpath + fn; SqlConnection conn = new SqlConnection(); conn.ConnectionString = "server =127.0.0.1;initial catalog=stu-044;user id=sa;password=sa"; SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; where number=@number";
SqlParameter p1 = new SqlParameter("@number", TextBox1.Text);
SqlParameter p2 = new SqlParameter("@bumen", TextBox2.Text);
SqlParameter p3