adapter.Update的问题？？？
小弟初学ASP.NET请各位高手帮忙？？
adapter.Updat怎么不上传数据？？adapter.Updat能像这样用吗？？如果不是该怎么用？？？

upconnection.ConnectionString = ConfigurationManager.ConnectionStrings[ "webConnectionString "].ConnectionString;

upcommand = new SqlCommand();
upcommand.CommandText = "UPDATE [number] SET [number] = 222 ";
upcommand.CommandType = CommandType.Text;
upcommand.Connection = upconnection;

myconnection.Open();

myadapter = new SqlDataAdapter();
myadapter.SelectCommand = mycommand;
myadapter.UpdateCommand = upcommand;
myadapter.Fill(mytable);
myadapter.Update(mytable);

[解决办法]
上传数据 不用整个记录都返回回来 只要知道操作成功的记录数就行了

myconnection.open();
upcommand = new SqlCommand();
";
upcommand.Connection = upconnection;??你是open的myconnection撒 怎么出来了个upconnection

upcommand.Connection=myconnection.Connection

int flag = upcommand.ExecuteNonQuery();//无记录时是 “-1”
try
{
upcommand.CommandText = "UPDATE [number] SET [number] = 222
int flag = myconnection.ExecuteNonQuery();
if(flag != -1)
{
return true;
}
else
{
return false;
}
}
catch(Exception ex)
{
return false;
}

[解决办法]
这里边SQL 语句不对
并没有SQL Parameter参数
这样就不能执行你的SQL语句
---------------------------
SqlConnection myConnection = new SqlConnection( "server=(local)\\SQLExpress;Integrated Security=SSPI;database=northwind ");
SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter( "Select * from Region ", myConnection);
SqlParameter workParam = null;

// Restore database to it 's original condition so sample will work correctly.
Cleanup();

// Build the insert Command
mySqlDataAdapter.InsertCommand = new SqlCommand( "Insert into Region (RegionID, RegionDescription) VALUES (@RegionID, @RegionDescription) ", myConnection);

workParam = mySqlDataAdapter.InsertCommand.Parameters.Add( "@RegionID ", SqlDbType.Int);
workParam.SourceColumn = "RegionID ";
workParam.SourceVersion = DataRowVersion.Current;

workParam = mySqlDataAdapter.InsertCommand.Parameters.Add( "@RegionDescription ", SqlDbType.NChar, 50);

workParam.SourceVersion = DataRowVersion.Current;
workParam.SourceColumn = "RegionDescription ";

// Build the update command
mySqlDataAdapter.UpdateCommand = new SqlCommand( "Update Region Set RegionDescription = @RegionDescription WHERE RegionID = @RegionID ", myConnection);

workParam = mySqlDataAdapter.UpdateCommand.Parameters.Add( "@RegionID ", SqlDbType.Int);
workParam.SourceColumn = "RegionID ";
workParam.SourceVersion = DataRowVersion.Original;

workParam = mySqlDataAdapter.UpdateCommand.Parameters.Add( "@RegionDescription ", SqlDbType.NChar, 50);
workParam.SourceVersion = DataRowVersion.Current;
workParam.SourceColumn = "RegionDescription ";

DataSet myDataSet = new DataSet();

// Set the MissingSchemaAction property to AddWithKey because Fill will not cause primary key & unique key information to be retrieved unless AddWithKey is specified.
mySqlDataAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
mySqlDataAdapter.Fill(myDataSet, "Region ");

DataRow myDataRow1 = myDataSet.Tables[ "Region "].Rows.Find(2);
myDataRow1[1] = "Changed this region desc ";

DataRow myDataRow2 = myDataSet.Tables[ "Region "].NewRow();
myDataRow2[0] = 901;
myDataRow2[1] = "A new region ";
myDataSet.Tables[ "Region "].Rows.Add(myDataRow2);

try
{
mySqlDataAdapter.Update(myDataSet, "Region ");
builder.Append( "Updating DataSet succeeded! </BR> ");
}
catch (Exception e)
{
builder.Append(e.ToString());
}