protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("../../App_Data/tuohaichuanmei.mdb") + ";Persist Security Info=False";
OleDbConnection conn = new OleDbConnection(str);
conn.Open();
OleDbCommand cmd = new OleDbCommand("select * from News where ID="+Request["id"].ToString()+"",conn);
OleDbDataReader rad = cmd.ExecuteReader();
if (rad.Read())
{
BiaoTi.Text = rad["Title"].ToString();
NeiRong.Text = rad["Body"].ToString();
HiddenField1.Value = rad["Img"].ToString();
}
rad.Close();
conn.Close();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("../../App_Data/tuohaichuanmei.mdb") + ";Persist Security Info=False";
OleDbConnection conn = new OleDbConnection(str);
conn.Open();
string Img = string.Empty;
if (FileUpload1.HasFile == true)
{
string tif = Img.Substring(Img.LastIndexOf('.'));
string NewName = DateTime.Now.ToString();
string NewStr = NewName.Replace('-', '2').Replace(':', '2').Replace(' ', '2');
FileUpload1.SaveAs(Server.MapPath("~/Admin/Img/" + NewStr + tif));
File.Delete(Server.MapPath("~/Admin/Img/" + HiddenField1.Value));
OleDbCommand cmd = new OleDbCommand("update News set Title='"+BiaoTi.Text+"',Body='"+NeiRong.Text+"',Img='"+NewStr+tif+"' where ID="+Request["id"].ToString()+"", conn);
cmd.ExecuteNonQuery();
}
else
{
OleDbCommand cmd = new OleDbCommand("insert into News(Title,Body,Img)values('" + BiaoTi.Text + "','" + NeiRong.Text + "')", conn);
cmd.ExecuteNonQuery();
}
conn.Close();
}
请教高人指点 事成之后必有重谢
{
if (!IsPostBack)
{
string str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("../../App_Data/tuohaichuanmei.mdb") + ";Persist Security Info=False";
OleDbConnection conn = new OleDbConnection(str);
conn.Open();
OleDbCommand cmd = new OleDbCommand("select * from News where ID="+Request["id"].ToString()+"",conn);
OleDbDataReader rad = cmd.ExecuteReader();
if (rad.Read())
{
BiaoTi.Text = rad["Title"].ToString();
NeiRong.Text = rad["Body"].ToString();
HiddenField1.Value = rad["Img"].ToString();
}
rad.Close();
conn.Close();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("../../App_Data/tuohaichuanmei.mdb") + ";Persist Security Info=False";
OleDbConnection conn = new OleDbConnection(str);
conn.Open();
string Img = string.Empty;
if (FileUpload1.HasFile == true)
{
string tif = Img.Substring(Img.LastIndexOf('.'));
string NewName = DateTime.Now.ToString();
string NewStr = NewName.Replace('-', '2').Replace(':', '2').Replace(' ', '2');
FileUpload1.SaveAs(Server.MapPath("~/Admin/Img/" + NewStr + tif));
File.Delete(Server.MapPath("~/Admin/Img/" + HiddenField1.Value));
OleDbCommand cmd = new OleDbCommand("update News set Title='"+BiaoTi.Text+"',Body='"+NeiRong.Text+"',Img='"+NewStr+tif+"' where ID="+Request["id"].ToString()+"", conn);
cmd.ExecuteNonQuery();
}
else
{
OleDbCommand cmd = new OleDbCommand("insert into News(Title,Body,Img)values('" + BiaoTi.Text + "','" + NeiRong.Text + "')", conn);
cmd.ExecuteNonQuery();
}
conn.Close();
}
请教高人指点 事成之后必有重谢
解决方案 »
- 字符串替换问题
- VS2005昨天还好好的,今天一开就报错,高人谁知道怎么解决
- 调查一下:写个小小的程序,是新建一个什么样的解决方案好?进者皆有分
- 连接 ACCESS2003数据库在Web.config中的字符串应怎样写?
- 简单的页面样式问题
- 关于《ASP.NET 4高级编程——涵盖C#和VB.NET(第7版)》
- treeview模板列的赋值问题
- 求助:关于GridView的问题 谢谢!!
- 救命一问~~~有关SQL语句的一个问题(在线等) 当场揭帖
- 我把代码贴出来(不太难),大家帮我看看错哪里了(在我发生疑问的地方我做了标记,后面有说明)
- 求c#表单验证类或表单验证策略
- IIS7.5+ASP.Net配置的最小权限
if (FileUpload1.HasFile == true)
{
string tif = Img.Substring(Img.LastIndexOf('.'));
}这一句的问题吧?Img是空串,你获取的Img.LastIndexOf('.')为-1,然后你把-1给Substring(-1)方法作参数就会出现你这个问题