我在VS2005中,想做三层的东西,SELECT语句的可以执行,但是其他编辑语句就执行报错,弹出个对话框,说不明错误,500。我在WEBMATRIX里面可以执行INSERT和DELETE,但是不能执行UPDATE,这是怎么回事呀!!?
解决方案 »
- dropDownList相关问题
- sql 表 导入到 access
- 第二帖:无刷新联动:我把无刷新二级联动做在了一个用户控件里:liandong.ascx 中,然后拖入 ab.aspx 页中,可是在这个aspx 页中却取不到
- 请问大家,如何测试自己所买的空间的速度的快慢啊
- 多页的情况下,如何得到DataGrid的记录总数?
- 讨一条SQL语句,大家帮帮忙
- echoString节点有误
- 请问那里有asp.net的论坛,要管理很方便的,哪个最好,20分都给他!
- 关于分页的问题!
- 如何取得在DataGrid中所选择的记录里的某字段的值
- [daaaxiang]简单问题:如何不区分大小写替换字符串中的内容,即"AV-girl".replace("v-G","vg")="Avgirl"
- 求ASP.NET连接VF-dbf数据库的方法和连接字符串。
{
protected string webpath;
protected string datapath;
protected DataBasic DB;
protected OleDbCommand comm; public CompanyEdit(string inwebpath)
{
webpath = inwebpath;
ReturnFilePath rfp = new ReturnFilePath(inwebpath);
datapath = rfp.ReturnPath();
DB = new DataBasic(datapath);
comm = new OleDbCommand();
} public string ReturnText()
{
string text;
comm.CommandText = "SELECT content FROM CompanyIntroduce WHERE id = '1'";
text = DB.DataReader(comm);
return text;
}
public void SaveData(string text)
{
//comm = new OleDbCommand();
comm.CommandText = "UPDATE CompanyIntroduce SET content = @content WHERE id = '1' ";
//comm.CommandText = "UPDATE CompanyIntroduce SET content = 1 WHERE id = '1' ";
comm.Parameters.AddWithValue("@content", text.ToString());
//comm.Parameters.AddWithValue("@id", "1");
DB.SQLExecute(comm);
}
using System.Collections.Generic;
using System.Text;
using System.IO;
using System.Data;
using System.Data.OleDb;
namespace DLL
{
public class DataBasic
{
private string webPath; protected OleDbConnection conn;
//protected OleDbCommand comm; public DataBasic(string strPath)
{
webPath = strPath; conn = new OleDbConnection();
conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" +
@"Data source= " +
webPath;
} public string DataReader(OleDbCommand comm)
{
string text="";
OleDbDataReader reader; comm.Connection = conn;
conn.Open();
reader = comm.ExecuteReader(); while(reader.Read())
{
text = reader["content"].ToString();
} return text;
} public void SQLExecute(OleDbCommand comm)
{
comm.Connection = conn;
conn.Open();
comm.ExecuteNonQuery();
}
/*public string PDataPath()
{
string RTdataPath = "";
if(File.Exists(webPath + @"\data\db.mdb"))
{
RTdataPath = webPath + @"\data\db.mdb";
}
else if (File.Exists(webPath + @"..\data\db.mdb"))
{
RTdataPath = webPath + @"..\data\db.mdb";
}
return RTdataPath;
}*/
}
}
这句使用了参数,改成
"@UPDATE [CompanyIntroduce] SET [content]={0} WHERE [id]='',content"
试试
有严重的问题所有的操作
conn.open以后
都没有即时的关闭.
改为
comm.CommandText = "UPDATE CompanyIntroduce SET content =" + @content +" WHERE id = '1' ";