In fact, it is very simple, it is the Update method of SqlDataAdapter. The main code is shown, for example:
Private void update ()
{
String link = configurationSettings.appsettings ["link_local"]. TOSTRING ();
SqlConnection Conn = New SqlConnection (LINK);
SqlDataAdapter Da = New SqldataAdapter ("Select Order_ID, Contract from Linhai", CONN);
DataSet DS = New DataSet ();
Da.fill (DS, "Linhai");
Da.UpdateCommand = New Sqlcommand ("Update Linhai Set Contract = @Contract" "Where Order_ID = @Order_ID", CONN);
Da.UpdateCommand.Parameters.Add ("@ contract", sqldbtype.nvarchar, 15, "contract");
Da.UpdateCommand.Parameters.Add ("@ Order_ID", SqldbType.nvarchar, 15, "ORDER_ID");
DS.Tables ["Linhai"]. Rows [0] ["contract"] = "PPP";
Da.UPDATE (DS.Tables [0]);
}
