最好是用一个SqlDataAdapterSqlConnection myConnection = new SqlConnection(strSQL); SqlCommand myCommand = new SqlCommand(strSql,myConnection); SqlDataAdapter myDA = new SqlDataAdapter(myCommand); SqlCommandBuilder myCB = new SqlCommandBuilder(myDA); myConnection.Open(); myDA.Update(DS.Tables[0]); myConnection.Close();to acewang(平平安安过一年) : 获取IIS各个站点绝对路径: DirectoryEntry root = new DirectoryEntry("IIS://localhost/W3SVC"); foreach(DirectoryEntry _e in root.Children) { if(_e.SchemaClassName == "IIsWebServer") { string Text; Text = "IIS://localhost/W3SVC/"+_e.Name.ToString()+"/ROOT"; DirectoryEntry rootfolder2 = new DirectoryEntry(Text); listBox1.Items.Add(rootfolder2.Properties["Path"][0].ToString()); MessageBox.Show(rootfolder2.Properties["Path"][0].ToString()); } }
参考: -------------------------- OleDbDataAdapter catDA = new OleDbDataAdapter("SELECT CategoryID, CategoryName FROM Categories", nwindConn); catDA.UpdateCommand = new OleDbCommand("UPDATE Categories SET CategoryName = ? " + "WHERE CategoryID = ?" , nwindConn);catDA.UpdateCommand.Parameters.Add("@CategoryName", OleDbType.VarChar, 15, "CategoryName");OleDbParameter workParm = catDA.UpdateCommand.Parameters.Add("@CategoryID", OleDbType.Integer); workParm.SourceColumn = "CategoryID"; workParm.SourceVersion = DataRowVersion.Original;DataSet catDS = new DataSet(); catDA.Fill(catDS, "Categories"); DataRow cRow = catDS.Tables["Categories"].Rows[0]; cRow["CategoryName"] = "New Category"; catDA.Update(catDS);
see: Updating the Database with a DataAdapter and the DataSethttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconupdatingdatabasewithdataadapterdataset.asp
Update 语法对Access数据库好像不支持!总是提示如下所示的错误!“UPDATE 语句的语法错误!”如果在把下面的代码注释掉,则出现如下所示的错误!//为数据适配器创建映射 /* daUserInfo.TableMappings.AddRange(new DataTableMapping[] { new DataTableMapping("Table","T_UserInfo",new DataColumnMapping[] { new DataColumnMapping("userName","userName"), new DataColumnMapping("password","password") }) }); */这时的错误信息如下: “UPDATE 无法找到 TableMapping['Table'] 或 DataTable 'Table'”
--->>>
daUserInfo.Update(dsUserInfo);
http://chs.gotdotnet.com/quickstart/howto/default.aspx
OleDbConnection cnUserInfo;
cnUserInfo = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + "\\myAddressList.mdb;" + "Password=;User ID=Admin;Persist Security Info=false");cnUserInfo.Open();
daUserInfo = new OleDbDataAdapter();
daUserInfo.SelectCommand = new OleDbCommand("Select userName,password From T_UserInfo Where userName = '" + tbUserName.Text.Trim() + "'",cnUserInfo);
//为数据适配器创建映射
daUserInfo.TableMappings.AddRange(new DataTableMapping[]
{
new DataTableMapping("Table","T_UserInfo",new DataColumnMapping[]
{
new DataColumnMapping("userName","userName"),
new DataColumnMapping("password","password")
})
});
dsUserInfo = new DataSet();
daUserInfo.Fill(dsUserInfo,"T_UserInfo");
DataRow dr;
dr = dsUserInfo.Tables["T_UserInfo"].Rows[0];
dr["password"] = tbNewPwdOk.Text.Trim();//把数据集中的修改保存到数据集中
dsUserInfo.AcceptChanges();
daUserInfo.Update(dsUserInfo);
cnUserInfo.Close();
语句的时候说是语法错误,我已经试过多次了,都是这样!
你用个COMMAND,然后执行一个UPDATE语句,一切不就OVER了。而且代码很少;简单
daUserInfo.Update(dsUserInfo);
-----------------------------------
去掉dsUserInfo.AcceptChanges();
SqlCommand myCommand = new SqlCommand(strSql,myConnection);
SqlDataAdapter myDA = new SqlDataAdapter(myCommand);
SqlCommandBuilder myCB = new SqlCommandBuilder(myDA);
myConnection.Open();
myDA.Update(DS.Tables[0]);
myConnection.Close();to acewang(平平安安过一年) :
获取IIS各个站点绝对路径:
DirectoryEntry root = new DirectoryEntry("IIS://localhost/W3SVC");
foreach(DirectoryEntry _e in root.Children)
{
if(_e.SchemaClassName == "IIsWebServer")
{
string Text;
Text = "IIS://localhost/W3SVC/"+_e.Name.ToString()+"/ROOT";
DirectoryEntry rootfolder2 = new DirectoryEntry(Text);
listBox1.Items.Add(rootfolder2.Properties["Path"][0].ToString());
MessageBox.Show(rootfolder2.Properties["Path"][0].ToString());
}
}
--------------------------
OleDbDataAdapter catDA = new OleDbDataAdapter("SELECT CategoryID, CategoryName FROM Categories", nwindConn); catDA.UpdateCommand = new OleDbCommand("UPDATE Categories SET CategoryName = ? " +
"WHERE CategoryID = ?" , nwindConn);catDA.UpdateCommand.Parameters.Add("@CategoryName", OleDbType.VarChar, 15, "CategoryName");OleDbParameter workParm = catDA.UpdateCommand.Parameters.Add("@CategoryID", OleDbType.Integer);
workParm.SourceColumn = "CategoryID";
workParm.SourceVersion = DataRowVersion.Original;DataSet catDS = new DataSet();
catDA.Fill(catDS, "Categories"); DataRow cRow = catDS.Tables["Categories"].Rows[0];
cRow["CategoryName"] = "New Category";
catDA.Update(catDS);
Updating the Database with a DataAdapter and the DataSethttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconupdatingdatabasewithdataadapterdataset.asp
/*
daUserInfo.TableMappings.AddRange(new DataTableMapping[]
{
new DataTableMapping("Table","T_UserInfo",new DataColumnMapping[]
{
new DataColumnMapping("userName","userName"),
new DataColumnMapping("password","password")
})
});
*/这时的错误信息如下:
“UPDATE 无法找到 TableMapping['Table'] 或 DataTable 'Table'”
SqlCommandBuilder cmdBuilder=new SqlCommandBuilde(catDS);
catDS.UpdateCommand=cmdBuilder.GetUpdateCommand();
catDA.Update(catDS,"表名");