高手们，帮忙看看来，哪里错？

[阿妖]

void Onsubmit(object sender,EventArgs arg){
if(Page.IsPostBack){
string dbconn="Provider=MicroSoft.Jet.OLEDB.4.0;Data Source="+Request.PhysicalApplicationPath+"\\messages.mdb";//建立数据库连接字符串。
string sql="select * from leavemessages";
OleDbConnection conn=new OleDbConnection(dbconn);//连接数据库。
OleDbDataAdapter command=new OleDbDataAdapter(sql,conn);
DataSet rs=new DataSet();
command.Fill(rs,"leavemessages");

DataTable table;
DataRow newRow;

table=rs.Tables["leavemessages"];
newRow=table.NewRow();
newRow["name"]=name.Text;
newRow["sex"]=sex.SelectedItem.Value;
newRow["fromwhere"]=fromwhere.Text;
newRow["homepage"]=homepage.Text;
newRow["email"]=email.Text;
newRow["titles"]=title.Text;
newRow["contents"]=content.Text;
newRow["times"]=DateTime.Now.ToString();
table.Rows.Add(newRow);

}
}
...
<asp:Button id="submit" TEXT="提 交" runat="server" onclick="Onsubmit" />
不执行！

[biao88482005]

<asp:Button id="submit" TEXT="提 交" runat="server" onclick="Onsubmit" />
这样写是不对的，onclick是执行客户端的脚本语言
要运行服务器端的应该像这样写
void Button_Click(Object Src, EventArgs E)
{

}

[boytomato]

if(Page.IsPostBack)???
没有用吧...加上???

OleDbDataAdapter.updata(table)//加上它你才能更新表啊...

[boytomato]

你说说具体错误....是数据库没更新,还是其它 的....

[boytomato]

public static DataSet SelectOleDbSrvRows(string myConnection, string mySelectQuery, string myTableName)
{
OleDbConnection myConn = new OleDbConnection(myConnection);
OleDbDataAdapter myDataAdapter = new OleDbDataAdapter();
myDataAdapter.SelectCommand = new OleDbCommand(mySelectQuery, myConn);
OleDbCommandBuilder cb = new OleDbCommandBuilder(myDataAdapter);

myConn.Open();

DataSet ds = new DataSet();
myDataAdapter.Fill(ds, myTableName);

//code to modify data in DataSet here

//Without the OleDbCommandBuilder this line would fail
myDataAdapter.Update(ds, myTableName);

myConn.Close();

return ds;
}

你考虑用 OleDbCommandBuilder



table=rs.Tables["leavemessages"];
newRow=table.NewRow();
newRow["name"]=name.Text;
newRow["sex"]=sex.SelectedItem.Value;
newRow["fromwhere"]=fromwhere.Text;
newRow["homepage"]=homepage.Text;
newRow["email"]=email.Text;
newRow["titles"]=title.Text;
newRow["contents"]=content.Text;
newRow["times"]=DateTime.Now.ToString();
table.Rows.Add(newRow);
只更新了现在的表,并没有更新数据库..而且,你也没有更新语句....
只用 OleDbDataAdapter.updata(table) 是不行的.

你考虑用
OleDbCommandBuilder
用它自动生成更新语句....
去然后再 加上OleDbDataAdapter.updata(table)

[阿妖]

我改成这样：
string dbconn="Provider=MicroSoft.Jet.OLEDB.4.0;Data Source="+Request.PhysicalApplicationPath+"\\messages.mdb";//建立数据库连接字符串。
string sql="insert into leavemessages (name,sex,fromwhere,homepage,email,titles,contents,times) values ('"+name.Text+"','"+sex.SelectedItem.Value+"','"+fromwhere.Text+"','"+homepage.Text+"','"+email.Text+"','"+title.Text+"','"+content.Text+"','"+DateTime.Now.ToString()+"')";
OleDbConnection conn=new OleDbConnection(dbconn);//连接数据库。
OleDbDataAdapter command=new OleDbDataAdapter(sql,conn);
还缺少什么语句？

[boytomato]

你用OleDbCommand
的就行了..没有必要再用 OleDbDataAdapter
ExecuteNonQuery

[boytomato]

只用 OleDbCommand的 ExecuteNonQuery


public void CreateMyOleDbCommand(string myExecuteQuery, string myConnectionString)
{
OleDbConnection myConnection = new OleDbConnection(myConnectionString);
OleDbCommand myCommand = new OleDbCommand(myExecuteQuery, myConnection);
myCommand.Connection.Open();
myCommand.ExecuteNonQuery();
myConnection.Close();
}

[boytomato]

tring dbconn="Provider=MicroSoft.Jet.OLEDB.4.0;Data Source="+Request.PhysicalApplicationPath+"\\messages.mdb";//建立数据库连接字符串。
string sql="insert into leavemessages (name,sex,fromwhere,homepage,email,titles,contents,times) values ('"+name.Text+"','"+sex.SelectedItem.Value+"','"+fromwhere.Text+"','"+homepage.Text+"','"+email.Text+"','"+title.Text+"','"+content.Text+"','"+DateTime.Now.ToString()+"')";
OleDbConnection conn=new OleDbConnection(dbconn);//连接数据库。

OleDbCommand myCommand = new OleDbCommand(sql, conn);
myCommand.Connection.Open();
myCommand.ExecuteNonQuery();
conn.Close();

试试吧...