求助各位大神——C#做web的时候出现了问题
程序代码:
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; using System.Data; using System.Configuration; using System.Data.SqlTypes; public partial class Default2 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void Button1_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(); SqlCommand cmd = new SqlCommand(); con.ConnectionString = @"Data Source=EZCHPLXFN2SMP6I;Initial Catalog=C:\DOCUMENTS AND SETTINGS\ADMINISTRATOR\桌面\WEB技术\数据库\APP_DATA\STUDENT.MDF;Integrated Security=True"; con.Open(); cmd.Connection = con; = "insert into students values(@stuid,@name,@sex,@birthday,@department,@totalscore)"; SqlParameter stuid=new SqlParameter("@stuid",SqlDbType.NVarChar,10); cmd.Parameters.Add(stuid); SqlParameter name=new SqlParameter("@name",SqlDbType.NVarChar,20); cmd.Parameters.Add(name); SqlParameter sex=new SqlParameter("@sex",SqlDbType.Bit); cmd.Parameters.Add(sex); SqlParameter birthday = new SqlParameter("@birthday", SqlDbType.SmallDateTime); cmd.Parameters.Add(birthday); cmd.Parameters.Add(new SqlParameter("@department",SqlDbType.NVarChar,20)); cmd.Parameters.Add(new SqlParameter("@totalscore", SqlDbType.Int)); cmd.Parameters["@stuid"].Value=Request.Form["studentid"]; cmd.Parameters["@name"].Value=Request.Form["name"]; if (sex1.Checked = true) cmd.Parameters["@sex"].Value = true; else cmd.Parameters["@sex"].Value = false; cmd.Parameters["@birthday"].Value=Request.Form["@birthday"]; cmd.Parameters["@department"].Value=Request.Form["@department"]; cmd.Parameters["@totalscore"].Value=int.Parse(Request.Form["@totalscore"]); cmd.ExecuteNonQuery(); GridView1.DataBind(); con.Close(); } protected void Button2_Click(object sender, EventArgs e) { stuid.Text = ""; name.Text = ""; sex1.Checked =false; sex2.Checked = false; birthday.Text = ""; department.Text = ""; totalscore.Text = ""; } protected void Button3_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(); SqlCommand cmd=new SqlCommand(); con.ConnectionString=@"Data Source=EZCHPLXFN2SMP6I;Initial Catalog=C:\DOCUMENTS AND SETTINGS\ADMINISTRATOR\桌面\WEB技术\数据库\APP_DATA\STUDENT.MDF;Integrated Security=True"; con.Open(); cmd.Connection=con; "delete students where studentid='"+stuid.Text+"'"; cmd.ExecuteNonQuery(); GridView1.DataBind(); con.Close(); } }
[ 本帖最后由 好北 于 2013-6-24 21:38 编辑 ]