我正在使用 asp.net 4.5 和 SQL Server 2008 Express。
我想将表单的数据插入到我的数据库中,连接字符串正常并且可以在另一个页面中工作,但在此页面中,插入按钮似乎只是刷新页面并且没有发生插入!
代码 :
protected void Button1_Click(object sender, EventArgs e)
{
var conn = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
var cmdd = "insert into poroje (Pname,Pmozu,Ppayan,StartDate,EndTime,makan,tozih) values(@Pname,@Pmozu,@Ppayan,@StartDate,@EndTime,@makan,@tozih)";
using (SqlConnection cnn = new SqlConnection(conn))
{
using (SqlCommand cmd = new SqlCommand(cmdd, cnn))
{
if (aksporoje.HasFile)
{
if (CheckFileType(aksporoje.FileName))
{
PersianCalendar Pe = new PersianCalendar();
string s = Pe.GetYear(System.DateTime.Now).ToString();
if (Directory.Exists("~/poroje/"+s))
{
Directory.CreateDirectory(Server.MapPath("~/poroje/" + s+pushePoroje(System.DateTime.Today)));
string filePath = "~/poroje/" + s + "/" + pushePoroje(System.DateTime.Today) + "/" + aksporoje.FileName;
aksporoje.SaveAs(MapPath(filePath));
cmd.Parameters.AddWithValue("@aks","poroje/"+ s + "/" + pushePoroje(System.DateTime.Today) + "/" + aksporoje.FileName);
}
else {
Directory.CreateDirectory(Server.MapPath("~/poroje/"+s));
Directory.CreateDirectory(Server.MapPath("~/poroje/"+s+ pushePoroje(System.DateTime.Today)));
string filePath = "~/poroje/" + s + "/" + pushePoroje(System.DateTime.Today) + "/" + aksporoje.FileName;
aksporoje.SaveAs(MapPath(filePath));
cmd.Parameters.AddWithValue("@aks", "poroje/" + s + "/" + pushePoroje(System.DateTime.Today) + "/" + aksporoje.FileName);
}
}
}
cmd.Parameters.AddWithValue("@Pname", txtnam.Text);
cmd.Parameters.AddWithValue("@Pmozu", txtmozu.Text);
cmd.Parameters.AddWithValue("@Ppayan",false);
cmd.Parameters.AddWithValue("@StartDate",PersianDateTextBox1.Text);
cmd.Parameters.AddWithValue("@EndTime",null);
cmd.Parameters.AddWithValue("@makan", txtmakan.Text);
cmd.Parameters.AddWithValue("@tozih", txttozih.Text);
try
{
cnn.Open();
int recordsAffected = cmd.ExecuteNonQuery();
}
catch (SqlException)
{
lblpeygham.Visible = true;
lblpeygham.Text = "error";
}
finally
{
cnn.Close();
lblpeygham.Visible = true;
lblpeygham.Text = "data inserted";
}
}
}
当我单击按钮时,页面刷新并向我显示“数据已插入”消息。但是当我检查数据库时没有插入任何内容!你能帮我吗?